Jump to content

Archived

This topic is now archived and is closed to further replies.

Guteman

MySQL Error Help

Recommended Posts

Hey All,

Can someone help me figure out what I did wrong in this mysql query?

[code]
$query = mysql_query("UPDATE projects SET name = '$name', domain = '$domain', designers = '$designer', developer = '$developer', deadline = '$deadline', webhosting = '$webhosting', projecturl = '$projecturl', phase = '$phase', status = '$status' WHERE name = '$name'") or die ("MySQL Error");[/code]

Thanks alot!

Share this post


Link to post
Share on other sites
Use mysql_error() function within your or die clause:
[code]$query = mysql_query("UPDATE projects SET name = '$name', domain = '$domain', designers = '$designer', developer = '$developer', deadline = '$deadline', webhosting = '$webhosting', projecturl = '$projecturl', phase = '$phase', status = '$status' WHERE name = '$name'") or die ("Unable to run query: " . mysql_errro());[/code]
This will now return an error from mysql itself which will help you why your query is failing.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.