SQL Update problem...

Worker Joined: Jul 07, 2004 Posts: 192

I've got a table called _user_temp... And In it I've only got one Column, it's called tpid... I would like it to be just a temp table so I don't want any new records in it, just this one field...

Why isn't this queery working... Any suggestions might help...

Code:




$db->sql_query("update ".$prefix."_user_temp set tpid='29'");

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

When you run the query in phpmyadmin's SQL window, what does phpMyAdmin tell you? That's the fastest way to find errors. Or, add this statement right after that one.

Code:

die('MySQL said: '.mysql_error());

That will print out an error, if there is one, and stop your script. On the surface it looks ok, but you may be trying to set a value that conflicts with the auto_increment value, assuming there is one.

Posted: Sun Aug 08, 2004 8:51 am

OK... Thanks for help... I fixed it... And now it's working... But still I can't figure out why the variables aren't passed onto my function... Sad

I know you can't help... So I must find a way to figure it out my self... Thanks for all the patience and help, you gave me... Wink

You are THE BEST... !!!!!!!!!