[Resolved] multiple insertions

TCovert

Is it possible to insert data into two tables at the same time? If so, how?

laserlight

What do you mean by inserting into 2 tables at the same time?
Why cant you do them consecutively?

TCovert

I mean insert data into table one and then do another sql statement which inserts different data into table2.

laserlight

well, of course you can.

TCovert

How? It won't work for me. It doesn't give any errors, it just doesn't work.

laserlight

Well, nice to hear that you're coming here for help, but unfortunately the majority of users around here arent psychic, so you'll have to post the relevant code that gives you the problem.

TCovert

$errors = "";

contact the database and stuff in the new, eh....stuff

if($errors == "") {

    db_connect();

    ### First update the table that holds all the information


    $sql = "update orderentry SET teamid='$teamid',proofneedby='$proofneedby',atexid='$atexid',acctid='$acctid',adtypeid='$adtypeid',adcaption='$adcaption',ponumber='$ponumber',inches='$inches',modularsize='$modularsize',adlocid='$adlocid',fullcolor='$fullcolor',color1='$color1',color2='$color2',coloroverriderate='$coloroverriderate',coloroverrideapprove='$coloroverrideapprove',layoutherewith='$layoutherewith',copytocome='$copytocome',pickupwithcorrections='$pickupwithcorrections',pickupwithchangenumber='$pickupwithchangenumber',adsend='$adsend',disc='$disc',email='$email',web='$web',other='$other',otherinfo='$otherinfo',emailaddress='$emailaddress',specposreq='$specposreq',coupon='$coupon',dbltruck='$dbltruck',coop='$coop',tears='$tears',tearsno='$tearsno',overrideapprove='$overrideapprove',notes='$notes',overrideadrate='$overrideadrate',color1type='$color1type',color2type='$color2type',adcolumns='$adcolumns' where orderid='$orderidnumber'";



    $sql = "insert into insertions
            (pubid,pubdate,orderno)

values('$pubid','$pubdate','$orderno')";

}

laserlight

Well, you could format it to see it properly, and so try:

$errors = ""; 

### contact the database and stuff in the new, eh....stuff 

if($errors == "") { 
	db_connect(); 

### First update the table that holds all the information 
$sql = "UPDATE orderentry SET
	teamid='$teamid',
	proofneedby='$proofneedby',
	atexid='$atexid',
	acctid='$acctid',
	adtypeid='$adtypeid',
	adcaption='$adcaption',
	ponumber='$ponumber',
	inches='$inches',
	modularsize='$modularsize',
	adlocid='$adlocid',
	fullcolor='$fullcolor',
	color1='$color1',
	color2='$color2',
	coloroverriderate='$coloroverriderate',
	coloroverrideapprove='$coloroverrideapprove',
	layoutherewith='$layoutherewith',
	copytocome='$copytocome',
	pickupwithcorrections='$pickupwithcorrections',
	pickupwithchangenumber='$pickupwithchangenumber',
	adsend='$adsend',
	disc='$disc',
	email='$email',
	web='$web',
	other='$other',
	otherinfo='$otherinfo',
	emailaddress='$emailaddress',
	specposreq='$specposreq',
	coupon='$coupon',
	dbltruck='$dbltruck',
	coop='$coop',
	tears='$tears',
	tearsno='$tearsno',
	overrideapprove='$overrideapprove',
	notes='$notes',
	overrideadrate='$overrideadrate',
	color1type='$color1type',
	color2type='$color2type',
	adcolumns='$adcolumns'
	WHERE orderid='$orderidnumber'"; 
if (db_query($sql)) {
	$sql = "INSERT INTO insertions (pubid,pubdate,orderno) VALUES('$pubid','$pubdate','$orderno')";
	if (db_query($sql)) {
		echo 'queries executed ok';
	} 
	else {
		exit(db_error());
	}
}
else {
	exit(db_error());
}
}

Where db_error() would be the function that outputs whatever error is returned (e.g. mysql_error() for mysql) and db_query() the database query function in PHP (e.g. mysql_query() for mysql)

TCovert

Fatal error: Call to undefined function: db_query() in /projects/admouse/htdocs/dbupload.php on line 21

Line 21 is:

if (db_query($sql)) {

laserlight

well, do you have a db_query() function?

I noticed you had a db_connect() function which presumably connects to the db server and selects the right database, so I assumed your db function library also has a db_query() and db_error() function.

What DBMS are you using?

TCovert

No, I don't. I have never used that function before....

laserlight

well, what is your database management system?

martincrumlish

try this:

$errors = ""; 


### contact the database and stuff in the new, eh....stuff 

if($errors == "") { 

db_connect(); 

### First update the table that holds all the information 


$sql = "UPDATE orderentry SET teamid='$teamid',proofneedby='$proofneedby',atexid
='$atexid',acctid='$acctid',adtypeid='$adtypeid',a
dcaption='$adcaption',ponumber='$ponumber',inches=
'$inches',modularsize='$modularsize',adlocid='$adl
ocid',fullcolor='$fullcolor',color1='$color1',colo
r2='$color2',coloroverriderate='$coloroverriderate
',coloroverrideapprove='$coloroverrideapprove',lay
outherewith='$layoutherewith',copytocome='$copytoc
ome',pickupwithcorrections='$pickupwithcorrections
',pickupwithchangenumber='$pickupwithchangenumber'
,adsend='$adsend',disc='$disc',email='$email',web=
'$web',other='$other',otherinfo='$otherinfo',email
address='$emailaddress',specposreq='$specposreq',c
oupon='$coupon',dbltruck='$dbltruck',coop='$coop',
tears='$tears',tearsno='$tearsno',overrideapprove=
'$overrideapprove',notes='$notes',overrideadrate='
$overrideadrate',color1type='$color1type',color2ty
pe='$color2type',adcolumns='$adcolumns' WHERE orderid='$orderidnumber'"; 

$result = mysql_query($sql);

$sql1 = "INSERT INTO insertions 
(pubid,pubdate,orderno) 
VALUES('$pubid','$pubdate','$orderno')"; 

$result1 = mysql_query($sql1);
}

You just had a variable called $sql with the update query. You didnt execute the query. Then you set the value of $sql tothe insert query. I changed it so the queries have a different variable name and they are executed using mysql_query (I presumed you are using mysql D😎

Martin

laserlight

well, that is pretty much my code, except that I included error checking a bit.

Are you really using mysql?

martincrumlish

Its just the original code with the code to differentiate between the 2 queries and to execute them

the best bet for you would be to use the error checking and stuff in laserlights code and also the DB queries in mine.

its pretty simple really

TCovert

Sorry, it was late and I wasn't thinking straight, I have used these functions before. Anyway, it has been resolved thanks to you.

Thanks again.