steveangelis Posted June 12, 2010 Share Posted June 12, 2010 I am attempting a query to gather data from two tables that are almost identical. My goal with the script is to get random entries from the database from both tables till s et amount. My current script is this: $q_test = mysql_query("select * from q2,q3 where bta='$course_test' order by rand() limit 2") or die(mysql_error()); Obviously this is failing. Does anyone know how I can get this to work? The field 'bta' is in both tables and I want it to draw entries from both tables as such. Quote Link to comment https://forums.phpfreaks.com/topic/204603-mutiple-tables/ Share on other sites More sharing options...
steveangelis Posted June 13, 2010 Author Share Posted June 13, 2010 Does anyone have any idea if this is possible or how to make this work? Quote Link to comment https://forums.phpfreaks.com/topic/204603-mutiple-tables/#findComment-1071346 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.