1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

need help with sql data

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

  1. roma2509

    roma2509 New Member

    Joined:
    May 11, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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

    Joined:
    Jul 12, 2004
    Messages:
    15,287
    Likes Received:
    364
    Trophy Points:
    83
    Just Add the Limit 10 at the end of your MySQL Query
     

Share This Page