[RESOLVED] Newest Record not appearing

[Maharg105]

Hey Guys,

I have a database of products on my site and a product gallery that shows these products. But at the moment the most recently added product does not appear in the gallery.

If I then add a new product, the previous one will show up but that one will not.

The code to display the records is:

$q = mysql_query("SELECT product_id, product_name, price, product_description, product_collection, product_category, product_thumbnail FROM 		products WHERE product_category='$product_category' ORDER BY product_id DESC LIMIT $page, $limit");

Here is the code from the CMS that inserts the records into the database:

$sql="INSERT INTO products (product_name, price, product_description, product_collection, product_category, product_picture, product_thumbnail) 
	 		VALUES
			('$name','$price','$description','$collection','$category','$file','$file_thumb')";

It's perplexing me and I wondered if you guys had seen something like this before?

Any help would, as always, be gratefully received.

Thanks,

[Weedpacket]

Perhaps there's something wrong with how you're displaying the results?

[bradgrafelman]

How are $page and $limit generated? Perhaps $page starts at 1 instead of 0?

[Maharg105]

Thanks bradgrafelman, your comments made me look a little more closely at that element of my code. It turned out I should have been using a $set_limit variable instead of $page. Now it works like a dream.

Thanks again for all your help guys,