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); } } Link to comment https://forums.phpfreaks.com/topic/201020-two-pages-producing-differen-results/ 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. Link to comment https://forums.phpfreaks.com/topic/201020-two-pages-producing-differen-results/#findComment-1054823 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.