Need help forming a query for a format table

Discussion in 'PHP' started by co.ador, Jun 3, 2009.

0
  1. #1
    I have a file called shoe.php and it contain the following.

    This file has several format tables. One of the format table which I have called "Format table 1" below has six <td> which I have floated it them to the left. I have assigned links to each of <td>'s. the <td> Number 1 has a link similar to this 
    <a href="shoemenu.php?caridad">
    HTML:
    . I want when user x click on <td> 1 eventually get linked to the other table below this one which I have called "Format table 2".

    Format table 1
     <table width="385"  border="0" bordercolor="#666666" bgcolor="#D83607" id="wheretogo">
<td width="39"><a href="shoemenu.php?caridad"><img src="../images/sneakers.gif" alt="menu" width="100%" height="22" /></a></td>
<td width="64"><a href="#"><img src="../images/Dressshoes.gif" alt="menu" width="100%" height="22" /></a></td>
<td width="43"><a href="#"><img src="../images/kidsshoes.gif" alt="menu" width="100%" height="22" /></a></td>
<td width="95"><a href="#"><img src="../images/womanshoes.gif" alt="menu" width="100%" height="22" /></a></td>
<td width="54"><a href="#"><img src="../images/Boots.gif" alt="menu" width="100%" height="22" /></a></td>
<td width="42"><a href="#"><img src="../images/teenagershoes.gif" alt="menu" width="100%" height="22" /></a></td>
</table>
    HTML:

    "Format table 2"
    "<table><tr><td>" . $row['shoes_name'] . "</td><td>" . $row['price'] . "</td><td>" . $row['moreinfo'] . "</td></tr></table>"

    as I said before, I want Format table 2 to appear only if users click on <td> number 1 on "Format table 1".

    But I don't want all the rows of the array to echo in Format table 2 only few of them that's why I was asking in a former post, how I could select just a few rows of a table fields.

    So far this has come up.

    [HIGHLIGHT="SQL"]$query = "SELECT shoes.shoes_name, shoes.price, shoes.moreinfo shoes.shoe_kind_id
    FROM shoes
    WHERE shoe_kind_id = 1 OR shoe_kind_id = 8 OR shoe_kind_id = 4 OR shoe_kind_id=5 OR shoe_kind_id=7 OR shoe_kind_id=3";

    Then I imagine Format table 2 would go somewhere down the query. But in the query there is not reference to the link on the <td> number one of "Format table 1"

    If you haven't understood guys let me know, if haven't understood would be because I haven't be somehow specific.
     
    co.ador, Jun 3, 2009 IP