mysql UPDATE

[Anon]

This block gives me the die() error.

$sql = "UPDATE review
SET
artist = '$artist',
album = '$album',
rec_comp = '$rec_comp',
picture = '$picture',
date_cd = '$date_cd',
date_rev = '$date_rev',
web_artist = '$web_artist',
web_rev = '$web_rev',
amazon = '$amazon',
review = '$review'
WHERE uniqueid = '$id'
";
$result = mysql_query($sql, $connection) or die("No way jose!");

Whenever I run the page "No way jose!" pops up.

PLEASE HELP! 🙂

[Anon]

I positive the connection is working fine.

[Anon]

Try:

$result = mysql_query($sql) or die("No way jose!");

Jon

[dstockto]

Also, try printing out the mysql_error()... ie

echo(mysql_error());

after your mysql_query() attempt. You should also make sure you are doing a mysql_select_db() or you will need to specify the database name in your UPDATE as well.

Dave

[chadt]

That is why I don't use mysql_query. In the above code you don't specify a database. If you are sure your connection is ok (maybe with a mysql_pconnect) then all you should need now is to specify the database. mysql_select_db will do the trick. Or you can use @mysql_db_query($db, $sql);

Hope that helps.
chadT

[Anon]

THANK YOU!!!!
I didn't know about the mysql_error() function and when I used it it showed I had a typo in my field definitions.

finally I'm through with that part!

THANKS!!

[dstockto]

Glad I could help.

Dave