DeepakJ Posted July 27, 2007 Share Posted July 27, 2007 The error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\verification.php on line 28 The code: <html><head><title>AlibreCam Verification System</title></head> <center><h3>AlibreCam Verification System</h3></center> <center><TABLE border=0 cellpadding=3><form name="input" action="verification.php" method="get"> <tr><td><center>Customer ID:</center></td> <td><input type="text" name="user"></td></tr> <tr><td colspan=2><center><input type="submit" value="Submit"></center></td></tr> </form><br></table><br> <?php $hostname = "localhost"; $username = "root"; $password = "98989lol"; $dbname = "licensinginformation"; $value=0; $customer = $_GET['user']; mysql_connect($hostname, $username, $password) or DIE("Unable to connect to MySQL server $hostname"); $selected = mysql_select_db($dbname) or DIE("Could not select requested db $dbname"); $query= sprintf("SELECT * FROM invoiceid WHERE customerid=%s",$customer); //$query= "SELECT * FROM invoiceid WHERE //customerid==".$customer.""; $query= mysql_real_escape_string($query); $cResult= mysql_query($query); while($row=mysql_fetch_array($cResult)){ $value=$value+$row['numoflicenses']; } echo "Total number of licenses purchased: ".$value; ?> </html> Help would be greatly appreciated Quote Link to comment Share on other sites More sharing options...
dbair Posted July 27, 2007 Share Posted July 27, 2007 change your query to be something like: $query= "SELECT * FROM invoiceid WHERE customerid=$customer"; Quote Link to comment Share on other sites More sharing options...
DeepakJ Posted July 27, 2007 Author Share Posted July 27, 2007 Doesn't work Quote Link to comment Share on other sites More sharing options...
dbair Posted July 27, 2007 Share Posted July 27, 2007 k...try this: $query= "SELECT * FROM invoiceid WHERE customerid=$customer"; remove this line: $query= mysql_real_escape_string($query); $cResult= mysql_query($query); Quote Link to comment Share on other sites More sharing options...
DeepakJ Posted July 27, 2007 Author Share Posted July 27, 2007 Doesn't work Quote Link to comment Share on other sites More sharing options...
dbair Posted July 27, 2007 Share Posted July 27, 2007 What happens when you try it? What error messages, etc? Quote Link to comment Share on other sites More sharing options...
DeepakJ Posted July 27, 2007 Author Share Posted July 27, 2007 The error message stated in post. Apparently my query didn't go through or something. Quote Link to comment Share on other sites More sharing options...
dbair Posted July 27, 2007 Share Posted July 27, 2007 k...try this: do not use the sprintf stuff. single quote $customer, double quote entire select statement. $query = "SELECT * FROM invoiceid WHERE customerid='$customer'"; remove this line: $query= mysql_real_escape_string($query); $cResult = mysql_query($query) or die ("<p>Cannot select from invoiceid: query = " . $query . " mysql_error = " . mysql_error() . "</p>); This will give you more of an error message. copy, paste and post the results please. Quote Link to comment Share on other sites More sharing options...
DeepakJ Posted July 27, 2007 Author Share Posted July 27, 2007 Same exact error message Quote Link to comment Share on other sites More sharing options...
DeepakJ Posted July 27, 2007 Author Share Posted July 27, 2007 Cannot select from invoiceid: query = SELECT * FROM invoiceid WHERE customerid= mysql_error = You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 New error message ^ Quote Link to comment Share on other sites More sharing options...
dbair Posted July 27, 2007 Share Posted July 27, 2007 There is not value for $customer. Quote Link to comment Share on other sites More sharing options...
DeepakJ Posted July 27, 2007 Author Share Posted July 27, 2007 YOU FIXED IT DUDE I LOVE YOU ::D:D:D:::D Quote Link to comment Share on other sites More sharing options...
dbair Posted July 27, 2007 Share Posted July 27, 2007 Welcome! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.