[RESOLVED] list records from DB into table using mysql_fetch_array

garrickp

I am trying to list records from the database into a table. I am not getting any errors when I load the page, but the records from the DB are not showing up.

<?php
include_once ('conn.php');
$tbl_name='lottery';
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
// Retrieve data from database
$list_selectinfo="SELECT * FROM $tbl_name";
$list_res=mysql_query($list_selectinfo);

$rows=mysql_fetch_array($list_res);
?>
<table width="40%" border="1" cellpadding="0" cellspacing="0">
  <tr>
    <td colspan="3">List of Lottery Numbers</td>
  </tr>
  <tr>
    <td align="center" width="33%">Lottery Number</td>
    <td align="center" width="33%">Prize</td>
    <td align="center" width="33%">Update</td>
  </tr>
  <?php 
  while($rows=mysql_fetch_array($list_res)){
	?>
  <tr>
    <td><? echo $rows['lottonumber']; ?></td>
    <td><? echo $rows['prize']; ?></td>
    <td align="center"><a href="update.php?id=<? echo $rows['id']; ?>">Update</a></td>
  </tr>
  <?php
  }
  ?>
</table>
<?php 
mysql_close();
?>
</body>
</html>

Any help would be much appreciated.

Derokorian

This may not be the problem but you're two echo's are with short open tags, which may not be on. You could try:

    <td><?php echo $rows['lottonumber']; ?></td>
    <td><?php echo $rows['prize']; ?></td>

PS: Please use [php [/code] tags instead of [html [/code] tags when posting PHP code such as this.

garrickp

Thanks for the help again that worked and I will make sure to use the correct code blocks from now on. I do have another question though. It's only returning one record when there are more in the database. Any idea why it would do that based on the previous code I gave.

Derokorian

<?php
// Retrieve data from database
$list_selectinfo = "SELECT * FROM $tbl_name";
$list_res = mysql_query($list_selectinfo);

$rows = mysql_fetch_array($list_res);// See comment:

This pulls the first row from the result set out but then you later:

  <?php 
  while($rows=mysql_fetch_array($list_res)){

Which attempts to loop over the remaining results. So if you have two results I would expect to see only one. However if you had more than 2 I would expect to see that amount minus 1.

garrickp

Yeah I actually just figured it out, hey thanks again. This forum is great.