Xtremer360 Posted May 2, 2010 Share Posted May 2, 2010 I have this page: http://kansasoutlawwrestling.com/champions that is supposed to be showing my champions and contenders and its giving me all these errors. Here's my code and don't know why its showing all of this. <div id='champions'> <h1 class=backstage>KOW Champions</h1> <table cellspacing='0px' cellpadding='5px' style='border: 0px;'><tr> <?php $query = "SELECT title.name AS title, title.shortname AS shortname, title.champ_id AS championid, title.con1_id AS con1id, title.con2_id AS con2id, title.con3_id AS con3id, title.con4_id AS con4id, title.con5_id AS con5id, biochamp.posername AS posername, biochamp.username AS championusername, biochamp.charactername AS champion, biocon1.username AS con1username, biocon1.charactername AS con1, biocon2.username AS con2username, biocon2.charactername AS con2, biocon3.username AS con3username, biocon3.charactername AS con3, biocon4.username AS con4username, biocon4.charactername AS con4, biocon5.username AS con5username, biocon5.charactername AS con5 FROM <code>efed_list_titles</code> AS title LEFT JOIN <code>efed_bio</code> AS biochamp ON title.champ_id = biochamp.id LEFT JOIN <code>efed_bio</code> AS biocon1 ON title.con1_id = biocon1.id LEFT JOIN <code>efed_bio</code> AS biocon2 ON title.con2_id = biocon2.id LEFT JOIN <code>efed_bio</code> AS biocon3 ON title.con3_id = biocon3.id LEFT JOIN <code>efed_bio</code> AS biocon4 ON title.con4_id = biocon4.id LEFT JOIN <code>efed_bio</code> AS biocon5 ON title.con5_id = biocon5.id WHERE title.status_id = '1' ORDER BY title.sortorder"; if(!$result = mysql_query ($query)){ debug($query); } while ($row = mysql_fetch_assoc($result)) { $fieldarray=array('title','shortname','championid','championusername','champion','con1id','con1','con1username','con2id','con2','con2username','con3id','con3','con3username','con4id','con4','con4username','con5id','con5','con5username','posername'); foreach ($fieldarray as $fieldlabel) { if (isset($row[$fieldlabel])) { $$fieldlabel=$row[$fieldlabel]; $$fieldlabel=cleanquerydata($$fieldlabel); } } print "<td><span class='large'>".$title."</span>\n"; if (file_exists($dirpath.'/images/titles/'.$shortname.'.jpg')) { print "<img style='width: 240px; height: 75px;' class='champion' src='/backstage/images/titles/".$shortname.".jpg'></img>\n"; } else{ print "<img style='width: 240px; height: 75px;' class='champion' src='/backstage/images/titles/default.jpg'></img>\n"; } if (strlen ($champion) < 1) { print "<span class='medium'>Vacant</span><br />"; } else { print "<span class='medium'><a href='bio.php?username=".$championusername."'>".$champion."</a></span><br />\n"; } print "<span class='contender'>Contenders</span><ul>\n"; if (strlen ($con1) < 1) { print "<li><span class='medium'>TBD</span></li><br />"; } else { print "<li><a href='backstage/bio.php?username=".$con1username."'>".$con1."</a></li>\n"; } if (strlen ($con2) < 1) { print "<li><span class='medium'>TBD</span></li><br />"; } else { print "<li><a href='backstage/bio.php?username=".$con2username."'>".$con2."</a></li>\n"; } if (strlen ($con3) < 1) { print "<li><span class='medium'>TBD</span></li><br />"; } else { print "<li><a href='backstage/bio.php?username=".$con3username."'>".$con3."</a></li>\n"; } if (strlen ($con4) < 1) { print "<li><span class='medium'>TBD</span></li><br />"; } else { print "<li><a href='backstage/bio.php?username=".$con4username."'>".$con4."</a></li>\n"; } if (strlen ($con5) < 1) { print "<li><span class='medium'>TBD</span></li><br />"; } else { print "<li><a href='backstage/bio.php?username=".$con5username."'>".$con5."</a></li>\n"; } print "</ul></td>\n"; unset ($champion); unset ($championusername); unset ($con1); unset ($con1username); unset ($con2); unset ($con2username); unset ($con3); unset ($con3username); unset ($con4); unset ($con4username); unset ($con5); unset ($con5username); } print "</tr></table>"; ?> I'm trying to transfer things over from a custom cms because I like WP better and it should end up looking like this: http://kansasoutlawwrestling.com/backstage/content.php?p=champions Quote Link to comment https://forums.phpfreaks.com/topic/200467-wordpress-page-php-notice-issue/ 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.