Multiple queries in one call...

[Sleidia]

Hello,

What is the most elegant way to send multiple queries
to a mysql DB in one single call (without the need to
open/close a connection for each query)?

Thanks for helping!

 

[AnakinPt]

You can send multiple queries in one connection... you don't need to open and close the connection all the time

Usualy you only need to open the connection in beggining of the page, and you close it in the end, and between you do all the queries.

Anikin
Hugo Alexandre Dias
Web-Programmer
anikin_jedi@hotmail.com

 

[Sleidia]

Hello Anikin,

What you said can't work on my side and always produces errors. I guess the reason in explained here:

http://www.ashleyit.com/blogs/brentashley/archives/000342.html

What's your opinion?

 

[AnakinPt]

What in the hell?

You can always do this:

$conn=mysql_connect(server,login,password);
mysql_select_db(database);

$res1=mysql_query("SELECT count(1) from table"
$res2=mysql_query("INSERT INTO table VALUES (id,title)"

list($count)=mysql_fetch_row($res1);
mysql_disconnect($conn);

Anikin
Hugo Alexandre Dias
Web-Programmer
anikin_jedi@hotmail.com