Xtremer360 Posted May 7, 2010 Share Posted May 7, 2010 I'm trying to figure out why these two pages are producing different results when it should be producing the same results: Page 1: http://www.kansasoutlawwrestling.com/backstage/content.php?p=roster $querya = "SELECT bio.posername as posername, bio.charactername as charactername, biosingles.hometown as singleshometown, biosingles.height as singlesheight, biosingles.weight as singlesweight FROM efed_bio as bio INNER JOIN efed_list_styles as style ON ( bio.style_id = style.id ) LEFT JOIN efed_bio_singles as biosingles ON ( bio.id = biosingles.bio_id ) WHERE style.name = 'singles' and bio.sortorder = '$sortorder' and bio.status_id = '1' ORDER BY bio.charactername"; $resulta = mysql_query ($querya); while ($rowa = mysql_fetch_assoc($resulta)) { $fieldarray=array('posername','charactername','singleshometown','singlesheight','singlesweight'); foreach ($fieldarray as $fieldlabel) { if (isset($rowa[$fieldlabel])) { $$fieldlabel=$rowa[$fieldlabel]; $$fieldlabel=cleanquerydata($$fieldlabel); } } And this page: http://kansasoutlawwrestling.com/roster/singles $querya = "SELECT bio.posername as posername, bio.charactername as charactername, biosingles.hometown as singleshometown, biosingles.height as singlesheight, biosingles.weight as singlesweight FROM efed_bio as bio INNER JOIN efed_list_styles as style ON ( bio.style_id = style.id ) LEFT JOIN efed_bio_singles as biosingles ON ( bio.id = biosingles.bio_id ) WHERE style.name = 'singles' and bio.sortorder = '$sortorder' and bio.status_id = '1' ORDER BY bio.charactername"; $resulta = mysql_query($querya) or die(mysql_error()); while ($rowa = mysql_fetch_assoc($resulta)) { $fieldarray = array('posername', 'charactername', 'singleshometown', 'singlesheight', 'singlesweight'); foreach ($fieldarray as $fieldlabel) { if (isset($rowa[$fieldlabel])) { $$fieldlabel = $rowa[$fieldlabel]; $$fieldlabel = cleanquerydata($$fieldlabel); } } Quote Link to comment Share on other sites More sharing options...
ialsoagree Posted May 7, 2010 Share Posted May 7, 2010 Since there doesn't appear to be any difference in the segment of code you've provided, the problem is somewhere else in the files. 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.