www.webdeveloper.com
Results 1 to 2 of 2

Thread: SQL Database

  1. #1
    Join Date
    Feb 2013
    Posts
    2

    SQL Database

    Hi, I have a problem. When im wrting the code in php I put it like this:
    <table>

    ....

    <?php
    $sql = "SELECT wines.id, regions.name AS region, wines.name, color, year, price FROM wines, regions WHERE regions.id = wines.region_id ORDER BY year"
    $query = mysql_query($sql);

    while ($row = mysql_fetch_assoc($query)) {

    ?>
    <tr>
    <td> <?php echo $row['id'];?> </td>
    <td> <?php echo $row['name'];?> </td>
    <td> <?php echo $row['region'];?> </td>
    <td> <?php echo $row['color'];?> </td>
    <td> <?php echo $row['year'];?> </td>
    </tr>
    <?php
    }
    ?>

    </table>



    In the browser It appears everything right like the table is with the : Id, name, color, year, price and regions. But Can you tell me How can I choose a Particular color in the $sql part of the code so that I am able to display only that color items in the table?
    I already tried to set it "..., color=1,..." but it doesn't work very well.
    The color are in type "enum('Red','White','Rose') So 1, 2 and 3.

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,176
    You mean something like this?
    Code:
    . . . WHERE regions.id = wines.region_id AND color = 'red' . . .
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles