MYSQL Display
Posted: Wed Jul 11, 2007 12:21 pm
I want to only display only 10 MYSQL rows instead of all of the rows in the table, what's the code?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
mysql_select_db("news", $con);
$result = mysql_query("SELECT * FROM news");
while($row = mysql_fetch_array($result))
{
if ( $row['cat'] == News){
echo " <table bgcolor=\"#FFF7CA\" width=\"500\" height=\"100\" cellpadding=\"0\" cellspacing=\"0\" style=\"border: 1px solid #FFD460; margin: 10px; padding: 0;\" >
<tr>
<td valign=\"top\" height=\"15\" style=\"padding: 3px 3px 3px 5px ; border-bottom: 1px solid #FFD460\">
<d1head> News: " . $row['title'] . "</d1head>
</td>
</tr>
<tr>
<td valign=\"top\" height=\"20\" style=\"padding: 10px\"
<t2>" . $row['news'] . "</t2><t2><br />
<br /> " . $row['name'] . "</t2>
</td>
</tr>
<tr>
<td valign=\"top\" height=\"20\" style=\"border-top: 1px solid #FFD460\">
<t2>" . $row['date'] . "</t2>
</td>
</tr>
</table>
";
}
else{
echo " <table bgcolor=\"#FAF0FF\" width=\"500\" height=\"100\" cellpadding=\"0\" cellspacing=\"0\" style=\"border: 1px solid #EC9EFF; margin: 10px; padding: 0;\" >
<tr>
<td valign=\"top\" height=\"15\" style=\"padding: 3px 3px 3px 5px ; border-bottom: 1px solid #EC9EFF\">
<d1head> Blog: " . $row['title'] . "</d1head>
</td>
</tr>
<tr>
<td valign=\"top\" height=\"20\" style=\"padding: 10px\"
<t2>" . $row['news'] . "</t2><t2><br />
<br /> " . $row['name'] . "</t2>
</td>
</tr>
<tr>
<td valign=\"top\" height=\"20\" style=\"border-top: 1px solid #EC9EFF\">
<t2>" . $row['date'] . "</t2>
</td>
</tr>
</table>
";
}
}
mysql_close($con);