Multiple (sql inserts)

[apw]

Hello, ive ran into a problem with sql insert.  My register.php file contains playername, password, email, empirename and title along with those when player submits the info the player provided gets pas sed to another php file called reguser.php in this file the info the player provided is checked and inserted into a table called pfile.  The insert into pfile works fine but when i tried placing a similar insert below the insert into pfile, after the ; at the end the information doesnt get inserted it doesnt generate an error and the pfile insert above the new insert also doesnt work.

 

my question is how do i go about adding multiple inserts within that php file

[apw]

Alas could the reason the second insert into isnt working because i do not have a line mysql_query($sql) similar to the line above that does have that following it?

[.josh]

php does not support multiple queries like that. You need to run each query string individually.

[Barand]

You can insert multiple records using this syntax (faster than multiple single inserts)

INSERT INTO table (x, y, z) 
VALUES
($a, $b, $c),
($d, $e, $f),
($g, $h, $i),
($j, $k, $l)

[dannyb785]

You can insert multiple records using this syntax (faster than multiple single inserts)

INSERT INTO table (x, y, z) 
VALUES
($a, $b, $c),
($d, $e, $f),
($g, $h, $i),
($j, $k, $l)

 

whooooooooooooooooooooooooaaa!! are you serious?? thats awesome!!

[.josh]

yeah i knew that. Good call Barand.  I was too focused on the whole multiple queries separated by a ; to think about it.