Go4Expert (http://www.go4expert.com/)
-   PHP (http://www.go4expert.com/forums/php/)
-   -   need help with sql data (http://www.go4expert.com/forums/help-sql-data-t22068/)

roma2509 11May2010 16:22

need help with sql data
1 Attachment(s)
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.

shabbir 11May2010 19:27

Re: need help with sql data
Just Add the Limit 10 at the end of your MySQL Query

All times are GMT +5.5. The time now is 07:10.