[mavoric]

ok, i have this small script, that updates my phpbb database, but it doesn't. I can't find anything worng with it, and all the password etc is correct, so please help. Here is the query

PHP Code:

<?



$db = mysql_connect("localhost", "username", "password");

mysql_select_db("database",$db);

$result = mysql_query("update phpbb_users set user_profcolour=blue, user_profbordcolour=pink where user_id=3",$db);



?>

and well it doesn't update it. Those rows and columns exsist, and im stumped please help

Thanks in advance

[Infinite_Hackers]

you don't really need the $db in the mysql_query

[NeverMind]

Originally Posted by Infinite_Hackers

you don't really need the $db in the mysql_query

the problem isn't in that!!

use this query to check if mysql will turn any error:

PHP Code:

$db = mysql_connect("localhost", "username", "password")or

die(mysql_error());



mysql_select_db("database",$db)or

die(mysql_error());



$result = mysql_query("update phpbb_users set user_profcolour=blue, user_profbordcolour=pink where user_id=3",$db)or

die(mysql_error()); 

if there is any problem in mysql this should tell you about it..

[mavoric]

nope, it still doesn't work

[mavoric]

actually, i sorted it out, never mind, thanks for your help though

[jrave]

oops... posted a bit too late... just erasing to save what ever embarrasment i can