listing each db entry in its own cell in a table

Gump

Hiya,

I have a sript running here that lists all results from a specified column in a table.

What the goal is to have each record displayed in its own cell of a table. Thoughts? Here is the current code:

// print the list of pages alphabetically with function to delete the record

$result = mysql_query("SELECT * FROM page_data ORDER BY page ASC",$dbh);

while ($myrow = mysql_fetch_array($result)) {

 	  printf("<a href=\"%s?id=%s\">%s </a> \n", $PHP_SELF, $myrow["id"], $myrow["page"]);

  echo "<a href=\"" . $_SERVER['PHP_SELF'] . "?id=" . $myrow["id"] . "&delete=yes\"><img src=\"../images/delete.gif\" width=\"57\" height=\"19\" border=\"0\"></a><br>";

}

Thanks all

😃

leetcrew



<html>
<head>
</head>
<body>


<table>
  <tr><td>Name<td>Address</tr>
  <tr><td>&nbsp;<td>&nbsp;</tr>

<?php

printf ("<tr><td>%s<td>%s</tr>", $row['name'], $row['address']);

?>


</table>


</body>
</html>

Weedpacket

printf() is overboard

<tr><td><?php echo $row['name']?></td><td><?php echo $row['address']?></td></tr>

And the HTML was bad, too

leetcrew

i frequently use printf()