MySQL query in a query

[Rail racer]

Sponsored Links

Hi,

I want to know if we can pass multiple query in a single query?
I am updating a php form on web page with multiple values. I want to know if I can join or make a single query for those update.

Thanks in advance.

[amadeo]

What do you mean by MySQL query in a query?
I don't think its a good idea to marge multiple queries. What you can do is just use joiner or tolls present in Mysql for your help according to the scenario.
Personally I don't combine multiple MySQL queries. Its better if you keep them separate. SO it wont get messy & you can always troubleshoot or work on your code at later time with less pain.

[Mentos]

Technically speaking its not supported in current MySQL environment to sent multiple queries in a single query. You can create procedures & triggers if you wish?
According to MySQL & PHP what you want to do is not supported.

Anyway I have a question about nested query.
I have this code.

SELECT column_1, column_2, column_1
FROM table1 a, table2 b
WHERE a.playerid = b.playerid AND b.matchid
IN (

SELECT matchid
FROM matches
WHERE season =2000
)
GROUP BY nickname
ORDER BY avg( score ) DESC

Can anyone help?

[Vincenzo]

You need to learn the Update statement in SQL.
I think this tutorial will help you.
http://www.tizag.com/mysqlTutorial/mysqlupdate.php