MySQL error - Warning: mysql_fetch_array(): supplied argument is not a valid MySQL re

[DigitHeads]

i cloned a piece of mysql code embedded into a php file.

the original works, the clone generates the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

what am i doing wrong ?

[lilleman]

Use [man]mysql_error[/man] to print the error message from the query:

<?php

$sql = "Your SQL query";
$result = mysql_query($sql) or die( mysql_error() );

?>

[DigitHeads]

the actual sql statement:

$SQL = "SELECT * FROM ProductInfo WHERE ProductName=$DataKey ORDER BY ProductName";
$result = mysql_query($SQL, $GLOBALS[link]);
while ($AP = mysql_fetch_array($result)) {
include('productinfoformdatatable.php');
}

[lilleman]

Use this code and see if you get any error messages. If you do, please post them here. It's easier to help you then...

$SQL = "SELECT * FROM ProductInfo WHERE ProductName=$DataKey ORDER BY ProductName";
$result = mysql_query($SQL, $GLOBALS[link]) or die( mysql_error() );
while ($AP = mysql_fetch_array($result)) {
include('productinfoformdatatable.php');
}

[mtimdog]

You could also try putting $DataKey in single quotes.