I'm trying to makes a webpage that will get all it's information from a table in mysql. Seemed like I was doing pretty well but now i'm stuck. The table does have 27 rows but they are like a pixel high and I can't see any reason for this. could be cause it's 3am and I'm new at this stuff.
Thanx for any help
<?
@ $db = mysql_pconnect("localhost", "modsrw", "br364xfr");
if (!$db)
{
echo "Sorry the server could not process your request at this time. Please try again later.";
}
mysql_select_db("celicaweb");
?>
<center>
<table border=0 width=90%>
<tr><td>
<table border=0 width=100%>
<tr>
<td><IMG SRC="images/celicaweb3.jpg"></td>
<td> </td>
<td align=right><FONT SIZE="+3" face=arial><U>Mods</U></FONT></td>
</tr>
<tr>
<td colspan=3><HR SIZE=2></td>
</tr>
</table>
<BR>
<CENTER>
<FONT FACE="Arial" size=+1><B>Celica Mods</B></FONT><BR><I>click <A HREF="mod_submit.html">HERE</A> to submit a mod</I>
<BR><BR>
<table border=0 width=100% cellpadding=4 cellspacing=2>
<tr bgcolor=#000080>
<th><FONT COLOR="#FFFFFF">Model</FONT></th>
<th><FONT COLOR="#FFFFFF">Year</FONT></th>
<th><FONT COLOR="#FFFFFF">Engine</FONT></th>
<th><FONT COLOR="#FFFFFF">Mod(s)</FONT></th>
<th><FONT COLOR="#FFFFFF">Cost</FONT></th>
<th><FONT COLOR="#FFFFFF">Results</FONT></th>
<th><FONT COLOR="#FFFFFF">Posted By</FONT></th>
</tr>
<?
$query = "select * from mods";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
for ($i=0; $i <$num_results; $i++)
{
echo "<tr bgcolor=#C6C6C6><td>".$row[model]."</td><td>".$row[year]."</td><td>".$row[engine]."</td><td>".$row[mod]."</td><td>".$row[cost]."</td>
<td>".$row[results]."</td><td>".$row[name]."</td></tr>" ;
}
?>
