SQL Query -> HTML Table

[Anon]

I'm aware of the limit command in sql queries, but how can I use this to return a table of values from a sql query, say, 5 rows per table? I saw a script like this somewhere before but I haven't been able to find it since. It had little "next " and "back " buttons. Dang I loved that script.

-Oliver

[Anon]

Try this . This should help u

$offset = 0;
$showrec = 6;

$query1 = "select fields from table";
}
$result1 = mysql_db_query($database,$query1,$connection);
$totrec=mysql_num_rows($result1);
$query1 .= " LIMIT $offset , $showrec";
$result01=mysql_db_query($database,$query1,$connection);
while ($fields= mysql_fetch_row($result01))
{

print records

}

if ($totrec>0)
{
/ For Previous Page /
if($offset != 0)
{
echo "<a href='$PHP_SELF?offset=".($offset-$showrec)."&field=$field_id'>";
echo "<IMG SRC='../images/previous.jpg' WIDTH='74' HEIGHT='22' ALIGN='Middle' BORDER='0' VSPACE='0' HSPACE='0' ALT='Previous News'></a>";
}
else
{
echo "<IMG SRC='../images/previous.jpg' WIDTH='74' HEIGHT='22' ALIGN='Middle' BORDER='0' VSPACE='0' HSPACE='0' ALT='Previous News'></a>";
}
echo " ";
// For Next Page
if( ($offset + $showrec) < $totrec ) {
echo "<a href='$PHP_SELF?offset=".($offset+$showrec)."&fieldid=$field_id'>";
echo "<IMG SRC='../images/next.jpg' WIDTH='74' HEIGHT='22' ALIGN='Middle' BORDER='0' VSPACE='0' HSPACE='0' ALT='Next News'></a>";
}
else {
echo "<IMG SRC='../images/next.jpg' WIDTH='74' HEIGHT='22' ALIGN='Middle' BORDER='0' VSPACE='0' HSPACE='0' ALT='Next News'></a>";
}

[Anon]

please how to used sql with html

Oliver wrote:

I'm aware of the limit command in sql queries, but how can I use this to return a table of values from a sql query, say, 5 rows per table? I saw a script like this somewhere before but I haven't been able to find it since. It had little "next " and "back " buttons. Dang I loved that script.

-Oliver

[Anon]

Tell me what exactly u r looking for..