Community-
I am a first time databaser and am having trouble pulling information from a
database to display on a site. Not every entry is supposed to show up on
the web page, but does so. I have tried IF statements without any help.
Here is what I have so far:
?
$r1=SELECT * FROM $main_tbl;
$rsql=mysql_query($r1,$db);
?
body text=#66 link=#66 vlink=#66 alink=#66
table width=600
tr
td
font size=5ZMP Rosters/fontfont size=5 - font
size=2a
href=http://www.vatusa.org/html/modules.php?op=modloadname=PN_Contentfile
=indexreq=visitartid=26VATUSA listing/a/font/font/td
/tr
/table
br/br
table width=600
tr
td
font size=5Active Controllers/font/td
/tr
/table
table width=600
tr bgcolor=#99
td width=180div align=centerfont
size=3strongCONTROLLER/strong/font/div/td
td width=60div align=centerfont
size=3strongCID/strong/font/div/td
td width=100div align=centerfont
size=3strongRATING/strong/font/div/td
td width=130div align=centerfont
size=3strongPOSITION/strong/font/div/td
td width=130div align=centerfont
size=3strongDATE JOINED/strong/font/div/td
/tr
?
while ($a_row=mysql_fetch_array($rsql))
{
?
tr bgcolor=#CC
td width=180 align=leftfont size=2? echo
$a_row[LNAME], $a_row[FNAME];?/font/td
td width=60 align=centerfont size=2? echo
$a_row[CID];?/font/td
td width=100 align=centerfont size=2?
echo $a_row[RATING];?/font/td
td width=130 align=centerfont size=2?
echo $a_row[POSITION];?/font/td
td width=130 align=centerfont size=2?
echo $a_row[JDATE];?/font/td
/tr
?}
?
/table
/body
I would like to only show people who are active within our roster and within
the database I have identified those people by putting a A, I or L
depending on their status with our organization. I guess I am looking for a
way for the code to see how that person is labeled and then put them in the
proper roster.
www.zmpartcc.com/roster/roster.php
--
Jason T. Davidson