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)){ } Quote Link to comment 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? Quote Link to comment 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. Quote Link to comment 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? Quote Link to comment 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. Quote Link to comment 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.