Hey,

Whilst you can't perform statements like this, there are alternatives.  If
you only have one field in your table, you can use:

"INSERT INTO com VALUES ('pentium'), ('amd')"; // Continue the comma
separated values list

Or, if you need to specify which fields the data is to go in:

"INSERT INTO com (column1, column2) VALUES ('something', 'something else'),
('something again', 'something else again')";

James

"VM ֿN" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello
>
> I want to know how to implement these several sql statements in one time.
>
> For example, I have 2 sql statements like :
>
> INSERT INTO com VALUES ('pentium');
> INSERT INTO com VALUES ('amd');
>
> Then, I want to excute these 2 sql statements in one time with PHP.
>
> I tried to implement like this :
>
> $query = "
> INSERT INTO com VALUES ('pentium');
> INSERT INTO com VALUES ('amd');
> ";
> mysql_query($query, $dbconnect);
>
> But as you know, it didn't work.
>
> Does any one know how to run this job?
>
> _________________________________________________________________
> MSN ExplorerƢ AOAe Hotmail ceAI EIA iRC AyIU. AoY
> http://explorer.msn.co.kr/  졤aI UiIaCIa.
>



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to