Using More Than One $results

[CRO8]

Hey all

 

I have a page that uses a similar query.

 

>$result = mysql_query ("SELECT aaa,bbb,ccc,ddd
                     FROM eee,fff,gggg
                     WHERE xxx = xxxxxx
                     AND yyyyy = yyyyyyyyyy
                     AND zzzzz = zzzzzzzzz
                     ORDER BY gggggggg");

 

How do I do more than one query on the same page? Can I use $result again? or use $result[1] or something similar. I think I can handle it from there- just need a little direction.

 

Thanks!

[Lonelydreamer]

I personally just make a new variable called like $result1 so I can use the data from both results further on in the code. Good Luck!

[CRO8]

nice thanks- let me dig in and re-post my progress.

 

thanks!