How to display MySQL data based on a column field

Question

I am trying to make an appointment maker for potential customers. The hours that are available will depend greatly on personal schedules, so I don't want a generic calendar type appointment maker. What I was trying was an SQL DB with 4 columns [ID, Made, Date, Time] with the following types [INT, BIT, VARCHAR, VARCHAR].

When SELECTing my data and displaying it, I am attempting to have an IF statement (PHP) determine if "Made" is "00" or "01" - 00 being "appointment available", 01 being "taken".

The output does display all the rows; however, it is showing all the rows as "appointment available". One of my rows has "01" in the "Made" column, and it is still showing as available.

PHP/SQL Script after connection:

$sql = "SELECT * FROM $tname";
$result = $conn->query($sql);
if ($result->num_rows > 0) {

while($row = $result->fetch_assoc()) {
if ($row["Made"] = '00') {
echo "<tr><td>" . $row["ID"] . "</td><td>" . 'Make An Appointment' . "</td><td>" . $row["Date"] . "</td><td>" . $row["Time"] . "</td></tr>";
}
elseif ($row["Made"] = '01') {
echo "<tr><td>" . $row["ID"] . "</td><td>" . 'Reserved' . "</td><td>" . $row["Date"] . "</td><td>" . $row["Time"] . "</td></tr>";
}
}
}

This is the link to the output on the website:

http://www.jpegchaos.com/appointment.php

I will continue to re-upload the .php with any attempts to see if new information displays.

Line 2 should show "Reserved" while 1 and 3 should be "Make an Appointment"

Thank you in advance

Chris Brendel · Accepted Answer · 2015-04-09 20:21:52Z

2

You need to use ==, not = when you're checking the $row["Made"]. As you have it now, the first if statement is always true, so it never gets to the elseif. Try this:

$sql = "SELECT * FROM $tname";
$result = $conn->query($sql);
if ($result->num_rows > 0) {

    while($row = $result->fetch_assoc()) {
        if ($row["Made"] == '00') {
            echo "<tr><td>" . $row["ID"] . "</td><td>" . 'Make An Appointment' . "</td><td>" . $row["Date"] . "</td><td>" . $row["Time"] . "</td></tr>";
        }
        elseif ($row["Made"] == '01') {
            echo "<tr><td>" . $row["ID"] . "</td><td>" . 'Reserved' . "</td><td>" . $row["Date"] . "</td><td>" . $row["Time"] . "</td></tr>";
        }
    }
}

edited Apr 9, 2015 at 20:21

answered Apr 9, 2015 at 20:05

Chris Brendel

7003 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

jpgerb Over a year ago

Of course it had to be something simple like that. Thank you so much.

Chris Brendel Over a year ago

No problem, happens to everyone. :)

jpgerb Over a year ago

i'll approve as soon as it lets me.

Collectives™ on Stack Overflow

How to display MySQL data based on a column field

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related