1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

need help with sql data

Discussion in 'PHP' started by roma2509, May 11, 2010.

  1. roma2509

    roma2509 New Member

    Hello I have tehe code:
    PHP:
    $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>
        </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 Files:

  2. shabbir

    shabbir Administrator Staff Member

    Just Add the Limit 10 at the end of your MySQL Query
     

Share This Page