[SOLVED] Need help with mysql/php script.
Posted: Tue Oct 05, 2004 4:18 pm
I am creating somewhat of a "downloads" system, where it records the information about each download on my site to a mysql database, ive added a couple of downloads, but only one will show up.
Here is the code:
If anyone would care to help i would be very grateful.
Here is the code:
Code: Select all
<?
$check=mysql_query("SELECT * FROM downloads");
$down=mysql_fetch_array($check);
?>
<table width="355" border="0" cellspacing="2">
<tr>
<td width="55" class="x"><center>Name</center></td>
<td width="203" class="x"><center>Description</center></td>
<td width="83" class="x"><center>Download</center></td>
</tr>
<?
echo "<tr><td width="55" class="y"><center>",$down['name'],"</center></td>";
echo "<td width="203" class="y"><center>",$down['desc'],"</center></td>";
echo "<td width="83" class="y"><center><a href="downloads/",$down['link'],"">Download</a></center></td></tr>";
?>
</table>