Jump to content

insert ignore into two tables (mysql 5.0) php.


sayedsohail

Recommended Posts

Hi everyone,

 

I am just wondering how to insert values in two tables at same time.

 

Here is single insert code, which works perfectly fine.  I am just wondering to insert into two tables and ignoring if values are exists.

 

i.e, insert ignore, not sure how to achieve this in mysql 5.0.

 

$q1 = "insert into fmodels (member_id, make_id, model, model_date, description) VALUES ('$memid', '$fm', '$fmod','$today', '$fdes')";

$result= mysql_query($q1);

 

Any help is highly appreciated.

 

Thanks

Just run two mysql queries.

 

mysql_query("INSERT INTO `fmodels` (`member_id`, `make_id`, `model`, `model_date`, `description`) VALUES ('$memid', '$fm', '$fmod','$today', '$fdes')");

mysql_query("INSERT INTO `table2` (`member_id`, `make_id`, `model`, `model_date`, `description`) VALUES ('$memid', '$fm', '$fmod','$today', '$fdes')");

or

mysql_query("INSERT INTO `fmodels` (`member_id`, `make_id`, `model`, `model_date`, `description`) VALUES ('$memid', '$fm', '$fmod','$today', '$fdes');
INSERT INTO `table2` (`member_id`, `make_id`, `model`, `model_date`, `description`) VALUES ('$memid', '$fm', '$fmod','$today', '$fdes')");

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.