Thread: Multiple pages
View Single Post
  #1 (permalink)  
Old November 24th, 2004, 08:14 AM
usedcarsgbcom usedcarsgbcom is offline
Registered User
 
Join Date: Nov 2004
Location: , , United Kingdom.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Multiple pages

Hi Matt
Thanks for your help, I have successfully joined my tables! The error came from putting the LIMIT in single quotes rather than Double.

One further question if you dont mind:

I have used the following code

$start = $_GET['start'];
$end = 4 + $start;
$Query = "SELECT * FROM VehicleStock LEFT JOIN cpg11d_pictures ON VehicleStock.RegNo = cpg11d_pictures.title LIMIT $start,$end";

to LIMIT the number of pictures per page, starting the page as Display.php?start=0

The problem I have is that the 1st page is fine with 4 pictures, however page 2 now has 7 pictures and not 4, with page 3 having 3 pictures. This gives a total of 14 pictures when I only started with 11 !!!! How can I restrict each page to just 4 pictures?

website page should it help is:

http://www.usedcars.gb.com/Display.php?start=0

I really am appreciating your assitance

Regards

Bruce


Reply With Quote