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. 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? Link to comment https://forums.phpfreaks.com/topic/204603-mutiple-tables/#findComment-1071346 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.