Jump to content

[SOLVED] Error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL resu

DeepakJ

By DeepakJ
in PHP Coding Help

Recommended Posts

DeepakJ Member

DeepakJ

Posted
Posted

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

dbair Newbie

dbair

Posted
Posted

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.

DeepakJ Member

DeepakJ

Posted
  • Author
Posted

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 ^

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.