Forum Moderators: coopster
Basically when a customer clicks add to cart the next page displays that product information from the database.
Now if they click another product that again is displayed under the first product.
Now I want both of them products ids to be outputted to a text field but the problem is what ever product is put in last is taking over the varible.
the code starts like this.
$sql = 'SELECT * FROM products WHERE id = '.$id;
$result = $db->query($sql);
$row = $result->fetch();
$ig = '$image';
extract($row);
While simple and yet somewhat practical, I would throw in:
$row = "";
$result = "";
Put them in before the $sql statement. Thus clearing the variable used to contain the array.
try $row[] instead of $row - that might should do it...I think
I looked at this again i was not putting it before opening bracket.
That just stops outputting the whole varible. just shows 1st product in varible.
--------
trying out the row[] stops any data going through what so ever.
I looked at this again i was not putting it before opening bracket.
That just stops outputting the whole varible. just shows 1st product in varible.
--------
trying out the row[] stops any data going through what so ever.
There is also foreach ($contents as $id=>$qty) if that makes any difference.
The problem im having is that when the order are coming through all I can see is how much the total is which is no good.
print_r($title);
print_r($qty);
thats out puts the following:
6" pen229" pencil2
that tells me the foloowing order
6" pen x 22
9" pencil x 2
But how can I format that a little better?
pen x 2
pencil x 2
print_r($title); echo" x ";
print_r($qty); echo" = ";
$tot = ($price * $qty);
$num1 = number_format ($tot, 2);
echo ($num1);
echo "<br>";
How would you suggest it best to save that into a varible so I can echo it in to a text field?
You want the values of each or all into one text field? Or do you want the text field to have this:
pen x 2
