need help with sql data

roma2509's Avatar, Join Date: May 2010
Newbie Member
Hello I have tehe code:
PHP Code:
$qry = "SELECT brand_name, brand_logo, site_link, video_link FROM tableName where catagory = 'Taxi'";
$result = mysql_query($qry) or die (mysql_error());
while ($row = mysql_fetch_assoc($result)){
<div id="categ">
    <div id="inside"><?php echo $row['brand_name']; ?></div>
    <div id="inside1"><a href="#"><img src="<?php echo $row['brand_logo']; ?>" /></a></div>
    <div id="inside2"><?php echo $row['short_desc']; ?> <a href="<?php echo $row['site_link']; ?>">continuare</a> </div>
    <div id="inside3"><a rel="shadowbox;width=405;height=340" title="Restaurant Daniel - New York, NY"   href="<?php echo $row['video_link']; ?>"><img src="img/tur_act.jpg" /></a></div>
<?php ?>
This cod select from table all rows from a category and put it on a div how it is show in the attach.problem is that it shows all the rows for this category (Taxi) but I want to show for exeample 10 results per page and generate a numeric list that will create a link to next page that will show me next result for this category.
Attached Images
File Type: jpg for-forum.jpg (143.0 KB, 2 views)
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Just Add the Limit 10 at the end of your MySQL Query