combining several queries?

jstraa

Hi,

I've got an question, I hope someone can provide a code sniplet
for what I want;

Let's say I do 3 queries each containing 5 columns,
I want to combine the 3 queries, and print out;

Query 1 - row 1
Query 2 - row 1
Query 3 - row 1
Query 1 - row 2
Query 2 - row 2
Query 3 - row 2

ETC ... Can this be done with mysql_fetch_array?
Thanks for any help !

siwis

what are the three queries?

do the 3 queries relate to 3 distict rows in the same table or are they totally different queries each time??

jstraa

It are queries in the same table, only with different keywords.
So the thing is to mix the 3 or more results into 1 table.

Regards,

Jeroen

siwis

BUT are the queries the same except for the WHERE statements?

jstraa

Yes they are, the same colums.

siwis

SELECT column FROM table WHERE field = value1 OR field = value2 OR field = value3

This should return 3 specific rows which you may then use as you wish.

jstraa

They don't mix if you do that, it will do the first at first then the
2nd and last the 3rd. The idea that I got is to do 3 queries with
only 1 where 3 times each time with 1 keyword. If you merge
that 3 into one table you have the results mixed by different
keywords.

siwis

$result = mysql_query("$sql");
$row[] = mysql_fetch_array($result);

then echo them into a predifined template using the keys 0,1 and 2

$row['col1']['0']
$row['col1']['1']
$row['col1']['2']
$row['col2']['0']
$row['col2']['1']
$row['col2']['2']
$row['col3']['0']
$row['col3']['1']
$row['col3']['2']
$row['col4']['0']
$row['col4']['1']
$row['col4']['2']
$row['col5']['0']
$row['col5']['1']
$row['col5']['2']

This is pure guesswork so don't shoot me if it don't work 😉

Better explanation of your problem may help us to help you!