Re: validation & inserts not working

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



PJ,

>     <snip>
> >     $sql1 = "INSERT INTO book ( title, sub_title, descr,
> >                comment, bk_cover, copyright, ISBN, language, sellers )
> >             VALUES ('$titleIN', '$sub_titleIN', '$descrIN', '$commentIN',
> >                '$bk_coverIN', '$copyrightIN', '$ISBNIN', '$languageIN',
> >                '$sellersIN')";
> >        $result1 = mysql_query($sql1, $db);
> >        $autoid = mysql_insert_id($result1);
>

You're actually sending mysql_insert_id() the wrong parameter. It should be:
$autoid = mysql_insert_id($db); // you send the resource of your MySQL
connection (http://ca3.php.net/manual/en/function.mysql-insert-id.php)
This should be corrected in everywhere you call mysql_insert_id()

-Lex

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux