Trying to add functions to table

Posted on 16th Feb 2014 07:03 pm by admin

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)
{

print '<table width="100%" class="table1">';
print '<tr class="rowheading">';
print '<td>&nbsp;</td>';
print '<td>&nbsp;</td>';
print '<td>Character Name</td>';
print '<td align=center width=100>Poser Name</td>';
print '<td align=center width=60>Style</td>';
print '<td align=center width=60>Alignment</td>';
print '<td align=center width=60>Status</td>';
print '</tr>';
// Fetch and print all records.
$i = 0;
$current_row = 0;
while ( $row = mysql_fetch_array ( $result, MYSQL_ASSOC ) ) {
$sClass = 'row2';
if ($i ++ & 1) {
$sClass = 'row1';
}
printf ( "<tr class="%s">", $sClass );
print "<td valign="top" align=center width=35><a href="#" onclick="ajaxpage('editcharacter', 'content'); return false;">Edit</a></td>";
print "<td valign="top" align=center width=25><a href="#" onclick="ajaxpage('bio', 'content'); return false;">Bio</a></td>";
printf ( "<td valign="top">%s</td>", $row [charactername] );
printf ( "<td align="center" valign="top">%s</td>", $row [posername] );
printf ( "<td align="center" valign="top">%s</td>", $row [style] );
printf ( "<td align="center" valign="top">%s</td>", $row [name] );
printf ( "<td align="center" valign="top">%s</td>", $row [name] );
print '</tr>';
}
print '</table>';
}
else
{
print '<span>There are characters.</span><br />';
}
print '<br />';
returnmain();
}
}
?>

Your Answer:

Login to answer

Other forums

Nested (echoed) php running wrong script
Got a problem with a php website I'm creating.

In a nutshell, the first page is entirely html

gettext translates ALWAYS?
I'm using gettext with the new version of XAMPP (5.3.0) on Windows Seven RTM (build 7600)
gettext

PHP error on MySQL insert
I'm sure it's the simplest of issues, but I can't recall why this isn't working.

Code: [Selec

Customizing message/behavior
Hi,I'm using the ASP.NET membership/authorization controls in my application. Some parts of my appli

preg-match with a string and numbers
Hi, I can't get the expression to work for my preg_match, what I'd like is for it to match the strin

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

Query failed issue with php script but works fine in mssql manager!
hi i have the script below which copies data from one table to another but will only insert new data

using variables in another page
I have a test database set up on localhost. I have a form that I can type a name into, hit the butto

Cron Job and Output
I have php codes running under a cron job.
But everytime i output (echo) , it comes out as comple

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I