leonidassavvides
11-06-2009, 11:30 PM
MySQL
$query1 ="INSERT INTO $CanceledCustomersTable (SELECT * FROM $CustomersTable WHERE status='deleted' AND email='$email2' AND password='$password2');";
Is any error with this query if $CanceledCustomersTable & $CustomersTable are identical of exactly BUT first field is AUTOINCREMENT in $CustomersTable something non-true in $CanceledCustomersTable ...? Always gives false(=>$result1 = @mysql_query($query1,$linkid);)...
to use in a MySQL Transaction...
$query1 ="INSERT INTO $CanceledCustomersTable (SELECT * FROM $CustomersTable WHERE status='deleted' AND email='$email2' AND password='$password2');";
Is any error with this query if $CanceledCustomersTable & $CustomersTable are identical of exactly BUT first field is AUTOINCREMENT in $CustomersTable something non-true in $CanceledCustomersTable ...? Always gives false(=>$result1 = @mysql_query($query1,$linkid);)...
to use in a MySQL Transaction...