Easy for those who know what theyre doin

[Anon]

Ho can I tell this query to only pull out the first 6 records?

And then how do I tell it to pull out records 6 to 12 etc?

Help much appreciated.

        <?
	 	include "../../variables.php";
		$query = "SELECT * FROM tblNews";
		$result = mysql_db_query ($dbname, $query);
		while ($row = mysql_fetch_array ($result)) 
			{
			$title = $row["Title"];
			$news = $row["News"];
			$date = $row["Date"];				
			$sitelink = $row["SiteLink"];
			print ("<font face='Tahoma' size='2'><b>$title - $date</b></font><br>");
			print ("<font face='Tahoma' size='2'>$news</font><br>");
			print ("<a href=http://www.virgintravelstore.com><font face='Tahoma' size='2'>$sitelink</font><br><br></a>");
			}
		?>

[kailien]

You need to edit your MySQL query with limit and offset.

I.E.

$limit = 6;

if (!isset($offset))
{
$offset = 0;
};

$sql = "select * from tblNews limit $offset,$limit order by date asc";

then, add next / previous logic to $offset variable. Make sure you carry the $offset variable on all the navigational links.

There is an article on the Articles section of this site with example. Check it out.

Kai

[Anon]

Sorry, but I'm getting an error on the SQL line. Is this typed correctly?

[Anon]

Ignor that, different error.