我有一个以s_id作为主键的表t_s_list。现在,如果相应的列已经插入,我想检索主值。如果相应的列是即时的,我可以使用mysql_insert_id函数轻松地获得这些值。但是,如果值已经存在,该怎么办呢?我的代码是..$result=mysql_query("select title from t_s_
= "SELECT COUNT(t.id), SUM(t.num_replies) FROM threads AS t WHERE t.forum_id=$forum_id";
list($num_threads, $num_posts) = mysql_fetch_assoc($result);Notice: Undefined offset:1 in C:\wamp\www\includes\functions.php on line 11
仅当table1中的更新成功时,我如何才能在以下代码中更新table2?$sql="update table1 set col1='abc' where col2='1'";if(that is success)
{$sql="update table2 set col1='cde' where col2='1