Two SQL queries using single mysql_query

[sasito]

Hi there,
I am qurious is there any who knows if it is possible to execute two queries to a MySQL database using a single mysql_query() function.
For example:
mysql_query("select from table1;select from table2")

Thanks for your support.

SaS.

[terje-s]

No, this is not possible.

However, read the mysql manual on JOIN. You can join two (or more) tables into one select, and return a number of records with columns from both tables.

[jc94062]

You can do both,

SELECT * from table1,table2 WHERE table1.value='something' and table2.value='somethingelse' ORDER by table1.ordering

[sasito]

OK
I know it very well but was cutious if I can put two query strings in a single query.
It would be easier if MySQL supported VIEWs but unfortunately it does not support them.

SaS.

[jc94062]

well as long as you define which table your trying to get it value from I don't see any problems arising 🙂

[Anon]

I don't believe mysql_query will parse beyond the first semi-colon, and for good reason. If it allowed you to stack queries into a single call, we'd all spend lots of time parsing every query which contained any kind of user input (well, even more time than we already do).

For example, let's say you have a form field that assigns it's value to "name". Naughty users might do this:

Name: brian;DROP TABLE user;

so name would now contain the above string. when you ran a query like: SELECT * from user WHERE name='$name'; You'd get an ugly surprise.

Beyond that, there are also problems handling result sets, etc.

[jc94062]

I never used a semicolon in my post...

SELECT * from table1,table2 WHERE table1.value='something' and table2.value='somethingelse' ORDER by table1.ordering

commas...

the only thing wrong with the above statement it that it might be more clear to put the and as AND, and the by and BY. But I didn't do table1;table2 or WHERE table1.value='something'; table2.value='somethingelse' because I know I'd get a parse error.