"Set" data witha where clasue

[seanpaulcail]

I have the following query where I overwrite data matching the where clause

$query = "UPDATE Eli SET bckgrnd_image='$bckgrnd_image' , 
page_name='$page_name' ,
 num_of_sm_images='$num_of_sm_images' , 
big_image_name= '$big_image_name' , 
title_name='$title_name', 
page_text='$page_text' where page_number='$page_number'";

the problem is that it doesn't work.

to view this database application, visit the following url: http://www.caillouette.com/eli/admin19/searchpage.html
Can anyone tell me what I'm doing wrong?

Thanks

[LordShryku]

have you tried using mysql_error() to narrow it down?

[seanpaulcail]

the code following the query tells me whether or not the data was loaded.

here's the folow-up code

$result = mysql_query($query);

if (!$result)
echo "no data enetered into database";

if ($result)
echo mysql_affected_rows(). "data entries entered into database.";

I'm not getting any error messages.

How do I implement SQL error checking?

Thanks

[LordShryku]

Try using

$result = mysql_query($query) or die(mysql_error());

[seanpaulcail]

the error is that no datbase was selected.

Thanks again