WilliamMute
Programmer
- Jan 4, 2006
- 117
Hi Again,
I beleive this will be my last question.
Am obviously having trouble again.
Could anyone please look at the code below to see if they can spot why I my echo statement is not showing anything despite the fact that there are information in both tables in my db?
$query_Recordset1 = "SELECT * FROM springrisecart, products WHERE (springrisecart.session) = '$cart_id' AND (springrisecart.product_id = 'products.id')";
$Recordset1 = mysql_query($query_Recordset1, $Connection) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
Then my echo statement is this:
<td><span class="LoopRowsQuery2"><span class="LoopRowsQuery"><?php echo $row_Recordset1['product_price']; ?></span></span></td>
<td><img src="<?php echo "products/". $row_Recordset1['image']; ?>.jpg" alt="Your Product" height="25" width="28"></td>
Thanks again!
(ps: I dont know how you put your codes in those nice format when pasting it here so its easy to read. may be a tip bout that 2! fanks)
I beleive this will be my last question.
Am obviously having trouble again.
Could anyone please look at the code below to see if they can spot why I my echo statement is not showing anything despite the fact that there are information in both tables in my db?
$query_Recordset1 = "SELECT * FROM springrisecart, products WHERE (springrisecart.session) = '$cart_id' AND (springrisecart.product_id = 'products.id')";
$Recordset1 = mysql_query($query_Recordset1, $Connection) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
Then my echo statement is this:
<td><span class="LoopRowsQuery2"><span class="LoopRowsQuery"><?php echo $row_Recordset1['product_price']; ?></span></span></td>
<td><img src="<?php echo "products/". $row_Recordset1['image']; ?>.jpg" alt="Your Product" height="25" width="28"></td>
Thanks again!
(ps: I dont know how you put your codes in those nice format when pasting it here so its easy to read. may be a tip bout that 2! fanks)