I have this list of characters and I'm trying to figure out what I have to do to put the results of these functions into the table or what not. Keep in mine that these functions are included in a file that is with the bottom file.
Code: function getstatusname($statusid) { $query = "SELECT s.name as status FROM efed_list_status as s WHERE s.id = '$statusid'"; $result = mysql_query ($query); while ($row = mysql_fetch_assoc($result)) { $status=cleanquerydata($row['status']); return $status; }
}
function getstylename($styleid) { $query = "SELECT style.name as stylename FROM efed_list_styles as style WHERE style.id = '$styleid'"; $result = mysql_query ($query); while ($row = mysql_fetch_assoc($result)) { $style=cleanquerydata($row['stylename']); return $style; } }
function getalignmentname($alignmentid) { $query = "SELECT alignment.name as alignmentname FROM efed_list_alignment as alignment WHERE alignment.id = '$alignmentid'"; $result = mysql_query ($query); while ($row = mysql_fetch_assoc($result)) { $alignmentname=cleanquerydata($row['alignmentname']); return $alignmentname; } }
Code: <?php { print '<h1 class=backstage>Character Management</h1><br />'; print "<h2 class=backstage>Characters :: <a href="#" onclick="ajaxpage('addcharacter', 'content'); return false;">Add New</a></h2><br />"; { $query = "SELECT * FROM efed_bio ORDER BY `charactername`"; $result = mysql_query ( $query ); // Run The Query $rows = mysql_num_rows($result); if ($rows > 0) {
