lalnfl Posted February 16, 2011 Share Posted February 16, 2011 $sql_form_union = mysql_query("SELECT id, base FROM Match_1v1 WHERE show_id='$show_id' ORDER BY ordered UNION SELECT id, base FROM Segment_1 WHERE show_id='$show_id' ORDER BY ordered"); while ($form_union = mysql_fetch_array($sql_form_union)){ } Link to comment https://forums.phpfreaks.com/topic/227822-what-is-wrong-with-this-query/ Share on other sites More sharing options...
lastkarrde Posted February 16, 2011 Share Posted February 16, 2011 Whats the table schema? Whats the expected output? What does it return? Link to comment https://forums.phpfreaks.com/topic/227822-what-is-wrong-with-this-query/#findComment-1174811 Share on other sites More sharing options...
lalnfl Posted February 16, 2011 Author Share Posted February 16, 2011 This is the error message: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a4284466/public_html/fed_events.php on line 4467 The expected output is $id and $base, not too sure what table schema is. Link to comment https://forums.phpfreaks.com/topic/227822-what-is-wrong-with-this-query/#findComment-1174812 Share on other sites More sharing options...
lastkarrde Posted February 16, 2011 Share Posted February 16, 2011 How are you supposed to write a query if you don't know what the schema is? Link to comment https://forums.phpfreaks.com/topic/227822-what-is-wrong-with-this-query/#findComment-1174813 Share on other sites More sharing options...
lalnfl Posted February 16, 2011 Author Share Posted February 16, 2011 Well if you can tell what the schema has to do with this question, then I can probably figure it out. Link to comment https://forums.phpfreaks.com/topic/227822-what-is-wrong-with-this-query/#findComment-1174814 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.