Boxerman Posted March 18, 2008 Share Posted March 18, 2008 Hi guys, i've got a problem thats why im posting... On my page i want to grab information from two different tables in the same database... i used this: /* Select all pilots */ $query = "SELECT * FROM `pilots` `positions` ORDER BY pilot_num ASC, WHERE last_update > DATE_SUB( NOW() , INTERVAL 15 MINUTE ) ORDER BY IATA"; $result = mysql_query($query); /* Determine the number of pilots */ $number = mysql_numrows($result); i now have this error... Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/vipersim/public_html/jamesm/pilot_roster.php on line 36 to to help line 36 is $number = mysql_numrows($result); but before i added the code at the top it worked fine.. so how do i fix this? Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/96764-more-than-2-tables-surely/ Share on other sites More sharing options...
Barand Posted March 18, 2008 Share Posted March 18, 2008 how are `pilots` and `positions` tables related? Quote Link to comment https://forums.phpfreaks.com/topic/96764-more-than-2-tables-surely/#findComment-495241 Share on other sites More sharing options...
Boxerman Posted March 18, 2008 Author Share Posted March 18, 2008 there are both under the same database... so, vipersim_acars is the database, they are tables under it... Quote Link to comment https://forums.phpfreaks.com/topic/96764-more-than-2-tables-surely/#findComment-495273 Share on other sites More sharing options...
treehugger88 Posted March 18, 2008 Share Posted March 18, 2008 WHERE last_update > You gotta tell it which table that comes from, yeah? Like pilots.last_update or positions.last_update, right? Quote Link to comment https://forums.phpfreaks.com/topic/96764-more-than-2-tables-surely/#findComment-495357 Share on other sites More sharing options...
Boxerman Posted March 19, 2008 Author Share Posted March 19, 2008 i dont understand sorry Quote Link to comment https://forums.phpfreaks.com/topic/96764-more-than-2-tables-surely/#findComment-495714 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.