List() function error?

Anon

Hi,

I've downloaded this catalog-application and it works fine. I inserted a couple of extra fields in the database. But when i want to edit an item i get this error:

Warning: Supplied argument is not a valid MySQL result resource in C:\apache\htdocs\snipegallery\inc\photo.functions.php on line 324

Here's the script:

if ($action=="edit") {
$sql = "SELECT id, title, filename, details, author, location, date, bouwjaar, kleur, price, kmstand, keywords, publish FROM snipe_gallery_data where id='$photo_id'";

$getpic = mysql_query($sql);

list($photo_id, $photo_title, $photo_filename, $photo_details, $photo_author, $photo_location, $photo_date, $photo_bouwjaar, $photo_kleur, $photo_price, $photo_kmstand, $photo_keywords, $photo_publish) =
mysql_fetch_row($getpic);
}

end script.

Line 234 is where the function List() begins.

[deleted]

"Line 234 is where the function List() begins."

yes, but it is also the line where you first try to read database results, and "Supplied argument is not a valid MySQL result resource" means that SQL was not able to execute your query becaue it query was invalid.

replace this:

$getpic = mysql_query($sql);

with this:

if (!$getpic = mysql_query($sql))
{
echo 'SQL ERROR:'.mysql_error().'<BR>'.$sql.'<BR>;
}

this will tell you where the error was.

Most likely you should remove the quotes around the ID field, numbers are never quoted.

A forum, a FAQ, what else do you need?