php insert help

[snake310]

What is the problem in this source , is it even possible to do something like this :

$recordset="INSERT INTO `$table`";
        $recordset .=" WHERE ";
$recordset .=" `$table`.serial = '$serial'";
$recordset .=" (OutTime, buyer) ";
$recordset .=" VALUES('$OutTime','$Buyer') ";
mysql_query($recordset);

[dcro2]

Well, you can't put WHERE clause in an INSERT, but I don't know what you're trying to do...

[code]INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
    [INTO] tbl_name [(col_name,...)]
    VALUES ({expr | DEFAULT},...),(...),...
    [ ON DUPLICATE KEY UPDATE col_name=expr, ... ][/code]

Are you trying to find which table has that value? If so, you should search for it beforehand.