display data in html tables

[dragonflymd]

Can anyone help me with the php code to display 3 different rows of data in three <TD> per <TR> and then repeat with another row until there is no more data? I appreciate your help.

[dcooper]

im assuming your pulling your data from a database.

$conn = mysql_pconnect("host", "uname", "pword");
mysql_select_db("dbname");

$query = "select * from tblname";
$results = mysql_query($query);

$num_results = mysql_num_rows($results);

for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($results);

echo '</strong><br />field: ';
echo stripslashes($row['field']);
echo '<br />field: ';
echo stripslashes($row['field']);
echo '<br />field: ';
echo stripslashes($row['field']);
echo '<br />field ';
echo stripslashes($row['field']);
echo '<br />field: ';
echo stripslashes($row['field']);
echo '</p>';

}

again i was also assuming that you addslashes before putting the data in2 the database

hope this helps

[dragonflymd]

Thanks for your help. But I need the data to display in table, then 3 rows of mysql data in 3 different <TD>s per html row.

Here's what I was able to do with a table:

while ($r = mysql_fetch_array($result))
{
$image = $r["image"];
$subcategory = $r["subcategory"];
$itemnumber = $r["itemnumber"];
$description = $r["description"];
$wds = $r["wds"];
$ticketcount = $r["ticketcount"];
$ticketvalue = $r["ticketvalue"];
$tickettype = $r["tickettype"];
$sealvalue = $r["sealvalue"];
echo "<tr>\n";
echo "<td><img src=\"tickets/$image.jpg\" align=left width=$array[width] height=$array[height]><BR>$description<BR><a href=\"display3.php?itemnumber=$itemnumber\">Click for details.</a></td>\n";
echo "<td><img src=\"tickets/$image.jpg\" align=left width=$array[width] height=$array[height]><BR>$description<BR><a href=\"display3.php?itemnumber=$itemnumber\">Click for details.</a></td>\n";
echo "<td><img src=\"tickets/$image.jpg\" align=left width=$array[width] height=$array[height]><BR>$description<BR><a href=\"display3.php?itemnumber=$itemnumber\">Click for details.</a></td>\n";
echo "</tr>\n";
}

But this just repeats the same data 3 times. Then creates a new html row with the next results. Any ideas?