SQL Update Function

[Unholy Prayer]

I once again need help with my forum software.  I am trying to make it so that everytime a user posts a reply or a new thread, it updates both the replies or threads table, and the forums table.  I can't figure out what is wrong with my code.  The page is functioning, but the table row is not updated.  This is my code:

    mysql_query("UPDATE vbb_forums SET $lastpost_auth = lastpost_auth, $laspost_datetime = lastpost_datetime, $lastpost_thread = lastpost_thread WHERE fid = $fid");

[per1os]

Try this and report the error:

 

<?php
mysql_query("UPDATE vbb_forums SET $lastpost_auth = lastpost_auth, $laspost_datetime = lastpost_datetime, $lastpost_thread = lastpost_thread WHERE fid = $fid") or DIE(mysql_error());
?>

 

--FrosT

[paul2463]

try this one

mysql_query("UPDATE vbb_forums SET lastpost_auth = '$lastpost_auth', laspost_datetime = '$lastpost_datetime', lastpost_thread = '$lastpost_thread' WHERE fid = '$fid'") or DIE(mysql_error());

 

for an update to work, you set the column to the variable, in your query you were trying to set the variable to the column name

[per1os]

Yep listen to Paul, that should work good. Sorry for not catching that, just missed it. Good catch Paul.

 

--FrosT