Limiting String Print

justlukeyou

I have a database of 100 lines which have echoed onto the page so each line within the database is printed. I would like to limit it to ten. However, I have tried a whole range of different loops but none of them seek to work.

Some of them print the database ten times so I have 1000 lines on the page. Can anyone advise the best method of limiting how many lines within a database are printed on the page?

jeepin81

I'm guessing by lines you mean rows in your database. If you're using MySQL you can limit the results.

SELECT * FROM yourDB LIMIT 0,100;

//or db2
SELECT * FROM yourDB FETCH FIRST 100 ROWS ONLY;

or you can exit out of your loop after 100 iterations.

Not sure if that's what your looking for. maybe post the code you have.
j

justlukeyou

Hi, I have tried around 30 different variations of the limit option but cant get it to work.

while($row = mysql_fetch_array($result))
{
$id = $row['ID'];
$image = $row['awImage'];
$link = $row['link'];
$description = $row['description'];
$fulldescription = $row['fulldescription'];
$price = $row['price'];




?>



<?php

{



echo   "<div class=\"productdisplayshell\"> <div class=\"productdisplayoutline\"> <div class=\"productborder\"><center>  <a href=\"$link\"  target=\"_blank\" ><img src=\"$image\" /></a> </center> </div></div> <div class=\"productdescriptionoutline\"><div class=\"productdescriptionbox\">  <a href=\"$link\"  target=\"_blank\" >$description</a> </div><div class=\"productfulldescriptionbox\">  $fulldescription </div></div> <div class=\"productpriceoutline\">  <div class=\"productpricebox\"><center>&#163; $price</center></div>  <div class=\"productbuybutton\"><center><a href=\"$link\"  target=\"_blank\" ><img src=/images/buybutton.png /></a></center></div></div></div>" ;

SELECT 'id' FROM `productfeed` LIMIT 0, 5;

}
}

bradgrafelman

You can't throw a SQL query into the middle of some PHP code and expect PHP to know what to do with it... you have to use a function such as [man]mysql_query/man.