need to list result of sizes of products from recordset

[cody44]

Hi Guys,

Ive just done a recordset in dreamweaver linking 3 tables, one shows items of product and the other two are for colours and sizes. I have displayed all records and done a repeat region and it looks fine, however in the recordset I need it to display all the sizes I have linked into. At the moment it will only show the first item size.

Have attached code below:

Any help will be greatly appreciated.

<?php do { ?>
  <tr>
    <td><span class="style1"><?php echo $row_Recordset2['item_title']; ?></span></td>
  </tr>
  <tr>
    <td><span class="style4"><?php echo $row_Recordset2['item_desc']; ?></span></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><span class="style4">Colours Available: <?php echo $row_Recordset2['item_colour']; ?></span></td>
  </tr>
  <tr>
    <td><span class="style4">Sizes: <?php echo $row_Recordset2['item_size']; ?></span></td>
  </tr>
  <tr>
    <td><span class="style4">Price &pound; <?php echo $row_Recordset2['item_price']; ?></span></td>
  </tr>
  <tr>
    <td><div align="center">.........................................................................................................................</div></td>
  </tr>
  <?php } while ($row_Recordset2 = mysql_fetch_assoc($Recordset2)); ?>

[jeremyphphaven]

hey cody, need more information on the tables I think.

[PradeepKr]

If you can change do while loop to simple while lop ...any harm?
It would become more readable.

Copy paste the table columns and the query you are executing here.

[cody44]

Hi Guys here is the record set below. It shows as it should be on the page but where it displays the colour or size it only shows the first return (or result), same with the size, I need it to loop or something and show a list of all sizes available.

<?php
mysql_select_db($database_shop, $shop);
$query_Recordset1 = "SELECT item_title,item_desc,item_price,item_colour FROM store_items, store_colour WHERE store_items.col_id = store_colour.item_id ";
$Recordset1 = mysql_query($query_Recordset1, $shop) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

$maxRows_Recordset2 = 10;
$pageNum_Recordset2 = 0;
if (isset($_GET['pageNum_Recordset2'])) {
  $pageNum_Recordset2 = $_GET['pageNum_Recordset2'];
}
$startRow_Recordset2 = $pageNum_Recordset2 * $maxRows_Recordset2;

mysql_select_db($database_shop, $shop);
$query_Recordset2 = "SELECT item_title,item_desc,item_price,item_colour,item_size FROM store_items, store_colour,store_size WHERE store_items.col_id = store_colour.item_id AND store_items.size_id = store_size.item_id ORDER BY item_title ASC";
$query_limit_Recordset2 = sprintf("%s LIMIT %d, %d", $query_Recordset2, $startRow_Recordset2, $maxRows_Recordset2);
$Recordset2 = mysql_query($query_limit_Recordset2, $shop) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);

if (isset($_GET['totalRows_Recordset2'])) {
  $totalRows_Recordset2 = $_GET['totalRows_Recordset2'];
} else {
  $all_Recordset2 = mysql_query($query_Recordset2);
  $totalRows_Recordset2 = mysql_num_rows($all_Recordset2);
}
$totalPages_Recordset2 = ceil($totalRows_Recordset2/$maxRows_Recordset2)-1;

mysql_select_db($database_shop, $shop);
$query_Recordset3 = "SELECT item_colour FROM store_colour ORDER BY item_colour ASC";
$Recordset3 = mysql_query($query_Recordset3, $shop) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysql_num_rows($Recordset3);
?>

[cody44]

I think im looking into this issue too deep.

The result below does show colours, sizes and the price. The 'item_size' and 'iterm_colour' results are called from the database and there is more than one result, ie i have more than one size. How would I manipulate the code below to display all colours and sizes available as alist from the database?

<td><span class="style4">Colours Available: <?php echo $row_Recordset2['item_colour']; ?></span></td>
</tr>
<tr>
<td><span class="style4">Sizes Available: <?php echo $row_Recordset2['item_size']; ?></span></td>
</tr>
<tr>
<td><span class="style4">Price &pound; <?php echo $row_Recordset2['item_price']; ?></span></td>