Numbered database query list
Posted: Wed May 29, 2002 10:53 pm
Lets say I'm querying my database, and I get 3 results, and post it on my website, like normal. How would I add a numbered list?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<?
//MAKE $results AN ARRAY OF THE RESULTS..
$r_n = count($results);
echo "<ol type=1>";
for($i = 0; $i <= $r_n; $i++){
echo "<li>$resultsї$i]";
}
echo "</ol>";
?>
or something close :-)Code: Select all
<?php
$sql = mysql_query("SELECT * FROM table_name");
$row = mysql_fetch_array($sql);
for ($i = 0; $i < mysql_num_rows($sql); $i++) {
echo("<B>".$i.".</B>".$rowї$i]."<BR>");
}
?>Code: Select all
<?php
$sql = mysql_query("SELECT * FROM table_name");
$i = 1;
while ($row = mysql_fetch_array($sql)) {
print "<B>$i</B>$rowї'COUMN_NAME']<BR>");
$i++;
}
?>Code: Select all
<?php
$COLUMN_NAME = 'whatever';
$sql = mysql_query("SELECT $COLUMN_NAME FROM table_name") or die('query failed');
print('<ol>');
while ($row = mysql_fetch_row($sql))
print ("<li>{$rowї0]}</li>");
print('</ol>');
mysql_free_result($sql);
?>