Codezwiz >> Forums >> General PHP Nuke Help >> More PHP syntax

Register

I am trying to make a main page for my module that pulls a motd from my roster_main table. It should be rather simple but I can't get this to work.

$sql = "SELECT motd FROM roster_main";
$result = $db->sql_query($sql);
$info = $result["$motd"];

echo "<table border=0><tr><td width=600%>";
echo "<font class=\"mainroster\"><big><center><b>MILPACS</b></center></big></font><hr width=600 align=\"center\">";
echo "</td></tr></table>";
echo "<table border=0><tr><td width=600%>";
echo "<big><center><b>$info</b></center></big></td></tr></table>";
CloseTable();
echo "<br>";
include("footer.php");
?>

Register

$sql = "SELECT motd FROM roster_main";
$result = $db->sql_query($sql);
$row = mysql_fetch_array($result);
$info = $row["$motd"];

echo "<table border=0><tr><td width=600%>";
echo "<font class=\"mainroster\"><big><center><b>MILPACS</b></center></big></font><hr width=600 align=\"center\">";
echo "</td></tr></table>";
echo "<table border=0><tr><td width=600%>";
echo "<big><center><b>$info</b></center></big></td></tr></table>";
CloseTable();
echo "<br>";
include("footer.php");
?>

Thanks for the quick reply, but it still isn't pulling anything from the roster_main. I made the motd field a blob since it has a paragraph of text in it.

You can see the result here.
[ Register or login to view links on this board. ]

Nothing is displayed.

Edit... Nevermind

I found I had to take out the "" surrounding motd. Now it works.

$sql = "SELECT motd FROM roster_main";
$result = $db->sql_query($sql);
$row = mysql_fetch_array($result);
$info = $row["motd"];

Register

YW, Didnt really know it was quick, just came online and saw a PHP question, i like answering PHP questions lol

Gareth

Well then stick around, I'll have a million of them.

Register

lol, i check here every day dont worry

Here is one for you.

With the following code I am able to pull records from an award_lkup table. The award_lkup is because I had a many to many relationship between roster_awards and roster_members.

The thing that is in error is that I am pulling all records in the award_lkup table. Even the ones that a member doesn't have.
[ Register or login to view links on this board. ]

Here is my code.

$result3 = $db->sql_query("SELECT * FROM roster_awards a JOIN award_lkup b JOIN roster_members c WHERE b.uniqueid = c.uniqueid AND a.award_id = b.award_id");
while ( $row = $db->sql_fetchrow($result3) ) {
$aname = $row["award_name"];
$adetail = $row["award_decription"];
$adate = $row["award_dt"];
if (!$result3) {
echo("<p>Error performing query: " . mysql_error() . "</p>");
exit(); }

echo"<tr>";
echo"<td align=\"left\" bgcolor=\"#999999\">";
echo"<table border=\"1\" cellpadding=\"2\" cellspacing=\"1\" style=\"border-collapse: collapse\" ";
echo"width=\"100%\" id=\"AutoNumber2\" bordercolor=\"#111111\">";
echo"<tr>";
echo"<td width=\"11%\" valign=\"top\" align=\"left\">$adate";
echo"</td>";
echo"<td width=\"89%\" valign=\"top\" align=\"left\">$aname $adetail</td>";
echo"</table>";
echo"</td>";
echo"</tr>";
}
echo"</table>";
echo"</body>";
echo"</html>";
CloseTable();
include("footer.php");
?>