A loop of some sort - Minicart

chrislead

Hi,

I am aiming for a mini cart of some sort that simply shows the user what is in their cart at any one time.

I have successfully managed to get the quantity value and display it using the select count(*) query. Which counts the number of rows in my mysql database. Great stuff, although the page needs to be refreshed in order to display the latest value. (which i don't want)

So my common sense tells me I need a loop of some sort to constantly loop through the code.

So I was simply wondering what loop I would need, and an example would be great.

The code I have so far (using a while loop, but it still doesnt work as I am not sure what i need to put inside the brackets!):

		$result = mysql_query("select count(*) from cart where session_id = '".$_COOKIE[PHPSESSID]."'");

	while($row = mysql_fetch_row($result)){

	$numRows = $row[0];
	echo "$numRows";
	}

Thanks all.

melody

Do you mean that when a user adds a new item to their cart and goes back to it, the cart doesn't update until the user clicks refresh? If that's the case, its because the browser is caching the page. Say your shopping cart is called cart.php. Call it with "cart.php?t=" . time(). This will make each url unique(based on the time) and the browser will be forced to reload each time. Is this what you needed?

HTH,
Melody

chrislead

Sos, I probably diddnt explain myself.

Its not the actual cart. Its like a minicart, that is displayed all the time, wherever the user goes on the site. The cart itself is perfect. It is that; in the minicart section (always displayed) I display only the number of items currently in the cart, and the total price of all the items in the cart.

Which works (the quantity at the moment anyway) but as I displayed above, I try and use a loop to constantly have the qty updating when it does in the cart, but the code still is not working, maybe it is a problem with what I have inside the brackets? and that the select query is before the loop?

Hope this is more clear.