MySQL Update Command

Trid3nt

I'm using the code below to update my SQL database with the new caption of the given image. For some reason, it is returning the error as though the query was not going through. The values that I am passing appear to come out exactly as they went in when I echo the $query variable. Is the SQL command not correct? Any ideas?

<?php
	if ($HTTP_POST_VARS['submit']){
		$caption = $HTTP_POST_VARS['description'];
		$query = "UPDATE " . $username . "_galleries SET Caption='" . $caption . "' WHERE ID=" . $id . "";
		echo $query;
		if (mysql_query($query)){
			echo "Query submitted.<BR>";
		}
		else{
			echo "Ooops, I screwed up.<BR>";
		}
	}
?>

sglane

Try this:

mysql_query($query) or die (mysql_error() . "<br />$query")

That will have mysql tell you where the problem lies.

cgraz

Another helpful thing to do along with using mysql_error is to print the query.

print $query;

That will show you what the query looks like before it gets executed. This is extremely helpful if you have variables without values. Very easy to spot.

Cgraz

Trid3nt

Originally posted by cgraz
Another helpful thing to do along with using mysql_error is to print the query.

print $query;

That will show you what the query looks like before it gets executed. This is extremely helpful if you have variables without values. Very easy to spot.

Cgraz

I echoed the query on line 5 of the code that I posted.

Sglane, how do I use: mysql_query($query) or die (mysql_error() . "<br />$query")

I'm not sure what it does or where it should go in my code. Thanks.

xblue

I echoed the query on line 5 of the code that I posted.

and what does it look like? Not the echo command, but the output it gives?

One way to use mysql_error:


    if (mysql_query($query)){
        echo "Query submitted.<BR>";
    }
    else{
        echo "Mysql error: ".mysql_error()."<BR>";
    }

another one: replace the above with

        mysql_query($query) or die("Mysql error: ".mysql_error());
        echo "Query submitted.<BR>";

which basically would have the same effect.

Cheers,
xblue

Trid3nt

Well, I might have figured out what has been causing these REALLY weird errors in my code. I had a previous problem that cgraz helped me out with that somehow worked itself out on its own. Both problems had similar properties - they didn't seem to follow any pattern whatsoever. I might have figured it out though.

When I copy the code from the website that someone posts and paste it into notepad, I get strange parse errors. I think that it was coming from some kind of hidden character or something because when I re-type the exact same code, it comes out fine. It is the copy and paste that messes me up. Anyway, I finally got the error code that you guys told me to put in and it resolved to "Query was submitted." Perhaps all that retyping did the trick for the UPDATE command as well (although, I did type it myself in the first place... strange). Anyway, everything is copacetic now... thanks for all your help guys!!