chasethemetal Posted December 13, 2011 Share Posted December 13, 2011 hey all! This might be one for the SQL forum, but maybe not. Anyways I'm selecting from two mysql tables information. mysql_query("SELECT * FROM tbl1 ORDER BY RAND() ", $db) and mysql_query("SELECT * FROM tbl2 ORDER BY RAND() ", $db) Is there anyway to make the random selection order the same on both queries?? Any tips would be appreciated!! Thanks Link to comment Share on other sites More sharing options...
justsomeguy Posted December 13, 2011 Share Posted December 13, 2011 Not if the queries are separate. You may be able to use a join to get all of the information at once, depending on your situation. Look into what joins are and what they do. Link to comment Share on other sites More sharing options...
chasethemetal Posted December 13, 2011 Author Share Posted December 13, 2011 Thank you! Will do Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.