Gossamer Forum: General: Databases and SQL: mysql & php: cannot update field

Oct 29, 2003, 7:00 AM

Beck

User (185 posts)

Oct 29, 2003, 7:00 AM

Post #1 of 3

Shortcut

mysql & php: cannot update field

Hi,

My code in php:

$query = "update $BOOKS set UserID = '$userid' where ID = $bid";

$result = mysql_query($query,$DB) or die ("Error in executing $query. Reason:". mysql_error($DB));

If I echo the query I can execute via phpmyadmin, but I cannot execute in the php code.

Please tell me how to solve this.

Thanks in advance,

Beck

Oct 29, 2003, 7:19 PM

Stealth

Veteran (17240 posts)

Oct 29, 2003, 7:19 PM

Post #2 of 3

Shortcut

Re: [Beck] mysql & php: cannot update field In reply to

If you UserID is an Integer field, then you don't need to use single quotes.

Try the following:

Code:
$query = "update $BOOKS set UserID = $userid where ID = $bid";

========================================
Buh Bye!

Cheers,
Me

Nov 1, 2003, 3:21 AM

Andy

Veteran / Moderator (18441 posts)

Nov 1, 2003, 3:21 AM

Post #3 of 3

Shortcut

Re: [Beck] mysql & php: cannot update field In reply to

Didn't the error catching stuff give you anything? I would have used a different approach for error checking too...

Code:
$result = mysql_query($query,$DB); 
$error = mysql_error(); 
if ($error) {  
    echo "SQL Error: Query \"$query\" gave the following error from MySQL: \n\n$error"; 
    exit;  
}

Cheers

Andy (mod)
andy@ultranerds.co.uk