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! 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? 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... 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? 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 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
Archived
This topic is now archived and is closed to further replies.