multiple MySQL SELECTS in same query

Question

Is it possible to retrieve elements from multiple SELECTS into PHP?

Take this one for example:

$query= mysql_query("SELECT ...; SELECT ...;")

If it is possible how can we organize the information ?

I don't think it's as simple as:

while($row = mysql_fetch_array($query))

does your select have the same columns retrieve? what are you trying to do? — John Woo
– John Woo, Commented Oct 24, 2012 at 1:17
it's hard to tell what you want to do. Is it a Union of two selects? — jlibert
– jlibert, Commented Oct 24, 2012 at 1:24
if they relate you can Inner, left, full outer join these data together. If they don't you can still join them together using a cross join which gives you all records from both joined tables. Understanding your table structures is imperative to provide a response though. — xQbert
– xQbert, Commented Oct 24, 2012 at 1:43

iHeff · Accepted Answer · 2012-10-24 01:46:18Z

1

$query = mysql_query("SELECT [blank] FROM [blank]
UNION
SELECT [blank] FROM [blank]");

(what the previous people suggested, just how it'd look)

answered Oct 24, 2012 at 1:46

iHeff

2591 gold badge4 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Saul Martínez · Accepted Answer · 2012-10-24 01:25:44Z

1

You should use Union as @JLibert suggested.

answered Oct 24, 2012 at 1:25

Saul Martínez

92014 silver badges29 bronze badges