[SOLVED] multiple records with one sql statement

[samona]

is there a way to insert more than one record into the database without have to have a loop as I have below?

 

for ($i = 1; $i <= 4; $i++)
{
$index = "info_{$i}";


	$query = "Update table SET column = '{$_POST[$index]}' WHERE column_ID = $i";

	if (!($result = @mysql_query($query, $connection)))
	{
		die ('Could not query the databases: ' . mysql_error());
	}

[trq]

Not via php no. mysql_query will only except one query at a time.

[fenway]

First, that's updating, not insert... you can definitely insert multiple at a time

[teng84]

@thorpe

i think what he means is that to have one huge query..

 

this is update statement with a where clause so i guess you cant do it all at one query unlike insert

[samona]

how can i insert multiple records with one query?  Maybe this way i can just add records and request the latest one.

[trq]

You can't. mysql_query() won't let you. This is a php thing. You can execute mutiple queries seperated by colons in mysql directly, but not through php's mysql_query().

[fenway]

But INSERT can have multiple VALUES() clauses....

[trq]

Indeed, but I think the op is asking how to insert more than one record.

[fenway]

Indeed, but I think the op is asking how to insert more than one record.

You mean into different tables, thn.