10,946 Topics
 | |
| | This is my SQL statement.. SQL Statement: SELECT tbl_subjectsenrolled.SubjectID, tbl_subject.SubjectDesc, studentsubjectgrade.Finals FROM tbl_subject INNER JOIN tbl_subjectsenrolled ON tbl_subject.SubjectID=tbl_subjectsenrolled.SubjectID INNER JOIN studentsubjectgrade ON tbl_subjectsenrolled.SubjectID=studentsubjectgrade.subjectID WHERE studentsubjectgrade.StudentID='04-0044' But the OUTPUT is this: SubjectID1 SubjectDesc1 Finals1 SubjectID1 SubjectDesc1 Finals1 SubjectID2 SubjectDesc2 Finals2 SubjectID2 SubjectDesc2 Finals2 Instead of this: SubjectID1 SubjectDesc1 Finals1 SubjectID2 SubjectDesc2 … |
| | Hi I finally screwed up.In order to get rid of a minor problem I uninstalled Wamp Server and reinstalled it.Now when I try to start it it will not accept my old password.What can I do? Do I have to uninstall everything mySql, Workbench,Wamp server and maybe php? Another thing, … |
| | Hi.. I want call data from table in mysql database using javascript How to do it? [EDIT: Moved from Java to JavaScript] |
 | i had make php file into it function [getLink()] make connection with mysqli_connect and return link of connection to use it in another php file to get result from database with mysqli_query() connection.php ` <?php $userName="root"; $serverName="localhost"; $userPassword="*****"; $nameOfDataBase="ITI_System"; function getLink(){ $link=@mysqli_connect($serverName,$userName,$userPassword,$nameOfDataBase); if(!$link){ echo "connection Error".mysqli_connect_errno(); } return $link; } … |
| | |
 | Hi There, Ive been searching everywhere in google but i got nothing. What i need is to be able display user datail after he login on a certain textbox Login.php page code: <?php session_start(); ob_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> </head> <body> <?php … |
| | Just a quick question. I am using Workbench to export a database stored on my hoting providers server, will the server experience any downtime whilst I am exporting the data? The only reason I ask is because when I back up my local SQL database my server needs to be …  |
| | Hi everyone, i am designing database for books application. I have main table **Books** and its child table is **Chapters**, chapters child table is **Sections**, So here is the problem, that some chapters has also divided into 3 steps **chapter Name -> Part 1 -> Divisions 1** and each chapter … |
| | Hi guys I need some explanation from you experts on php.I succeeded in installing MySql vers.5.5, workbench, myPhpAdmin and Wamp Server.I gave up installing Apache, too complicated, I use IIS7 anyway and works fine.All these tools work fine, I can create databases, tables, update them etc.and I am doing all … |
| | I was just curious if this is just me or what but it's extremely annoying. I have installed Apache2 and PHP on my Linux Mint 14.1 Cinnamon machine fine, but when I use `apt-get install mysql-server` (as super user), this happens. Reading package lists... Done Building dependency tree Reading state … |
| | Hey guys I'm new to this I bought this script yesterday and on my site I keep getting this Warning need help!!! Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\Hosting\6967501\html\config.php on line 13 [CODE]<?php // Provide Values for Database $dbhost="MYHOST"; $dbname="DB_NAME"; $dbuser="DB_USER"; $dbpass="DB_PASSWORD"; //Don't change … |
 | Hi, I'm using this SQL statement to retrieve Value and Date which will then be plotted on a graph: SELECT DISTINCT assets.SEDOL,assets.Quantity,stock_names.value,stock_names.Fileid,date_header.dateid FROM assets,stock_names,date_header WHERE assets.Client_ref = '$clientref' AND stock_names.SEDOL = assets.SEDOL AND date_header.fileid = stock_names.fileid I'm also selecting Quantity. Instead of having to multiply out the arrays, how can …  |
| | I am working on a PHP project in which a mysql table needs to be updated with lots of rows in a single update. A set of parameters will be assigned for a product. Please find my present steps below: 1. **Delete** all rows with the product_id in the table … |
| | Hello, I have a Mysql table, where i want that after i execute the update query in the JSP form, an automated mail is send to the email id in the record.Can anyone tell me how to do this?  |
| | I have problem updating my MySQL database. The user can edit a form in my page and once they press 'send', the php script should be able to update all the information. However the database doesn't seem to be updated after pressing the 'send' button in the form but only …  |
| | Hi guys, I have been racking my brain for a while now trying to sort out a problem I have been having with my mysql query and thought this would be the best place to get some help and learn how to edit my query! So, users are able to … |
 | I'm having a problem with a MYSQL Join accross three tables. I'm new to MYSQL Join functions, and can't quite figure out how to write the code. My current code is horribly innefficient and does not implement explicit joins, which I believe is much of the problem. Here it is(in …  |
 | Hi, In my ubuntu 11.10 system Mysql Workbench not opening, but while using mysql-workbench --verbose command in terminal it opens. Please I need it to opened by clicking the button for Mysqlworkbench. Thanks in Advance. Velhassan. |
| | I'm using this PDO query to fetch all the data I need from Value and dateid: $pdo = new PDO('mysql:host=localhost;dbname=contisec_portal', 'root', ''); $date = date("o-m-d"); $stmt = $pdo->query("SELECT stock_names.Value,stock_names.Fileid,date_header.dateid FROM stock_names,date_header WHERE SEDOL = '$stocksel' AND date_header.fileid = stock_names.FileID"); Does anybody know how I can sort the two columns into … |
 | Hello. I have two tables, the itinerary table and location table. The itinerary table consists of all the itinerary: * A - B * B - A * B - C * C - B * C - A * A - C The user will select from the itinerary … |
| | Hi I am having an issue trying to run an sql query from a php script. I have checked the query through phpmyadmin and it runs fine but whenever I run it through php i get an error. The error is "Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean … |
| | I am trying to update multiple rows in my database using php and mysql. Here is my php mysql statment: $sql = "UPDATE book_store SET". "title = '$_POST[title]', isbn = '$_POST[isbn]', price = '$_POST[price]', quantity = '$_POST[quantity]' ". "WHERE ID = '$_POST[id]' "; Here is my Error: Error: You have … |
| | Hello All! This question probably has a really simple answer but I am fairly new to PHP and I'm not very farmiliar with generating numbers yet. This is what I'm having trouble with: * Check MySQL to make sure that this UNIQUE number is not already stored. If it is, … |
| | I am building a web for ordering stock for a small company. I wanted to add data into a table for user to view before confirm the order. Tried to use excel but can only display data and not add data on the website. I'm currently using Dreamweaver to develop … |
| | Hello guys, For my final year project I decide to develop an app for android. I have done some research and stuff for first semester and have to present the working app at the end of second semester. To be honest I'm not that great developer however I'm still interested …  |
 | i would like to be able to upload a pdf to a database then later be able to download the book and view it. i want the names of the books to appear as links which when clicked will open the book. the uploading is being done but the downloading … |
| | hi, i am very new in php programming. Pls help me how to store session variable into my sql database. Below is my code <?php function userIsLoggedIn() { if (isset($_POST['action']) and $_POST['action'] == 'login') { if (!isset($_POST['loginid']) or $_POST['loginid'] == '' or !isset($_POST['password']) or $_POST['password'] == '') { $GLOBALS['loginError'] = … |
 | I am new to the datebase concepts.. I am having a DataBase Management course in my engineering program now a days and i have to submit a small database project in 2 weeks which should be based on the core and complete fundamentals Database... I m using mysQL can any …  |
| | I m working on project in which i have to store member automatically in binary tree form like 1 is root 2 is child of 1 3 is child of 1 Then 4 is child of 2 5 is child of 2 6 is child of 3 7 is child … |
| | Hello all, I'm fairly new to using PHP, and for my assignment I've coded it all but I'm trying to go the extra step, and code something that if the item amount = 0 it doesn't print it out on the order form The items are $LAPTOP $MONITOR $KEYBOARD $PRINTER … |
| | Dear all i have created a small windows form application, which connect to mysql database, and the database is installed on a remote pc( virtual machine), i am using visual studio 2010 in winxp 32 bit , and i have build this application using .NET2.0, so that it can work … |
| | I created a stored Proc: Create PRocedure InsertTBL_Supplier ( @SupplierNumber nvarchar(50), @SupplierName nvarchar(50), @Address nvarchar(50), @ContactNumber nvarchar(50), @ContactPerson nvarchar(50) ) AS BEGIN INSERT INTO TBL_Supplier (SupplierNumber, SupplierName , Address, ContactNumber , ContactPerson ) VALUES ('10000','JenRoses Shop','Pasig City','09159675567','Dara Lim'), ('20000','Lawren FlowerFave','Makati City','5564818','Aiden Lee'), ('30000','FLowers&Scents','Marikina City','7280823','Dennis Park'), ('40000','Pretty Flower Spot','Pasay City','09276543789','Joshua Tan'), … |
| | Hi Hope someone can help with this as I dont really know where to start. I am trying to automate a quite large txt feed I get from an external url to import into database. I currently do it manually through database software, but it takes too long each day. … |
 | |
 | So Heres The problem code i get a Parse error: syntax error, unexpected $end in /home/crysta21/public_html/4dM1n1STr4+10nB4nk.php on line 149 from <?php /* MCCodes FREE cyberbank.php Rev 1.1.0c Copyright (C) 2005-2012 Dabomstew This program is free software; you can redistribute it and/or modify it under the terms of the GNU General …  |
 | Hello there, today I noticed there are two operation in PhpMyAdmin, Replication and Synchronization. and now I want to use these operation as the following scenario. I have local db, I want to copy its content to remotly db so when I connect to any db I see the same … |
| | I am trying to make a movie list for myself, I got everything working like add and delete but the edit gives me some headace. I get all the values fine, id, movie title, director and year are all filled in, well not what category I added using radio buttons … |
| | I am having trouble with a registration script that I am trying to implement. When I click the "Register" button, I get this error: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens This is my coding for the register function: `public function register() { …  |
 | I am first time using like in mysql .but it is giving error.my query with like is $user_query="SELECT * FROM rt_user WHERE rt_user_username LIKE %".$_GET['term']."% OR rt_user_name LIKE %".$_GET['term']."% OR rt_user_description LIKE %".$_GET['term']."% LIMIT 10"; it is giving syntax error. |
 | Hello, I have made an Employee Time clock application. I have been working on connecting my application to a MySQL database, I have a textbox wich is used to add an employee name to my database (this is working perfectly.), but I also a combobox where I want the list … |
 | My while keeps looping and i dont know why: code <?php $result = mysql_query("SELECT * FROM tag WHERE point='$pagename'"); while($row = mysql_fetch_array($result)) { $result = mysql_query("SELECT * FROM tag WHERE point='$pagename'"); //username echo $row["user"] . " ||"; //alias check $result = mysql_query("SELECT * FROM tag WHERE (user='$my_name' && point='$pagename')"); if … |
| | Hi guys, I am a little new to this stuff but have done a few research regarding PHP. Currently, I am trying to learn PHP to allow a web portal to interact with data stored on MySQL database. In other words, lets say I have a website that displays information … |
 | how to insert data in multi dimension array into mysql database in php. |
 | Hello everyone, i need small help since im stuck, and im not that good with php and vB.net connections... So here is the problem, i manage to get connected to db and php script shows me if im connected or not, grab if user/pw is correct everything works fine, but … |
| | Hi i have a query that i want to display the pulser1 pulser2 pulser3 pulser4 from table but only when the input type for each pulser=2 when i run the query not working as i want it please check my query $netw is a variable it can be any value … |
| | Dear Friends, Help me to fix this.. Error Message : **mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in** Code is, <?php $database=$diocese; $table=$category; //capture search term and remove spaces at its both ends if the is any $searchTerm = trim($_GET['query']); //check whether the name parsed is empty if($searchTerm … |
| | i want to compare dates stored in database in the format yyyy-mm-dd by changing it in unixtimestamp in the mysql query.for this my query is $bquery="SELECT * FROM rt_booking WHERE rt_unit_id='".$_POST['unit_id']."' AND (SELECT UNIX_TIMESTAMP(str_to_date(rt_start_date,'%Y-%m-%d'))>=".$my11." OR SELECT UNIX_TIMESTAMP(str_to_date(rt_end_date,'%Y-%m-%d'))<=".$my22.")"; but it is giving syntax error. |
| | Hi, I want users on my website to upload their company logo (if they have one) while filling out my form. Right now i only have one row designated for the company logo called 'images' with the type set to BLOB. Is this adequate for both uploading images and displaying … |
 | Hello, How to create a crystal report in vb.net 2008? |
| | I am new in using MySQL database and need some help. The scenario is pretty much like this: I collect data from some sensor which come with their own software. The software builds a .db file as it takes data from the sensors and saves it locally in the computer. … |
The End.