mysql where statement not displaying proper results

Question

I have a database that has 2 records in it:

id |  message  |    date     |   user    | option
---+-----------+-------------+-----------+--------
1  |  Welcome  |  2015-03-01 |           |   0
2  |  message  |  2015-03-05 |  admin    |   0

What I'm trying to do is if the user field is blank, it shows the message to all users, if there is a username (such as admin in this example) listed, it shows the one for that user, and a the blank message if it exist.

Right now it will show both messages if the user is Pam (it should only show id 1).

If the user is admin, it shows both messages.

It seems like its ignoring the user = '$zuser'

What am I doing wrong?

<?php 

  ini_set('display_errors',1);  error_reporting(E_ALL);
  $zuser=$_COOKIE['aauser'];

  $result = mysqli_query($con,"SELECT * FROM message WHERE (user = '$zuser' OR run_date >= CURDATE() AND user='')");

  while($quick = mysqli_fetch_array($result))           
  {
    echo $quick['message'];
    echo '<script>alert("'.$quick['message'].'");</script>';
  }

?>

Run a var_dump on the cookie while making sure it's set/not empty. Also or die(mysqli_error($con)) to mysqli_query() — Funk Forty Niner
– Funk Forty Niner, Commented Mar 1, 2015 at 3:20
there is also a difference between null and '' (empty string) — Kevin
– Kevin, Commented Mar 1, 2015 at 3:24
Entered... meaning what? Plus, where is the cookie initially set? Remember, cookies only get set AFTER the second page load. — Funk Forty Niner
– Funk Forty Niner, Commented Mar 1, 2015 at 3:25
if(isset($_COOKIE['aauser'])){...} that will determine if it's set. Or if(!empty($_COOKIE['aauser'])){...} — Funk Forty Niner
– Funk Forty Niner, Commented Mar 1, 2015 at 3:33

Donavon · Accepted Answer · 2015-03-01 03:34:06Z

1

Found my problem @ Fred -ii- that was a bone head mistake i forgot that cookies were only set after the second page loaded!!!

Thank you for your help!

<?php 
        ini_set('display_errors',1);  error_reporting(E_ALL);
        echo $zuser=$_GET['usrname'];


    $result = mysqli_query($con,"SELECT * FROM message WHERE user = '$zuser' OR run_date >= CURDATE() AND user=''");

                while($quick = mysqli_fetch_array($result)) 

                {
                echo $quick['message'];
                echo '<script>alert("'.$quick['message'].'");</script>';
                }


        ?>

answered Mar 1, 2015 at 3:34

Donavon

511 gold badge2 silver badges12 bronze badges

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

1 Comment

Funk Forty Niner Over a year ago

Blowing on fingers ;-) you're welcome. Cheers!

Adrian Cid Almaguer · Accepted Answer · 2015-03-01 03:30:11Z

0

Change this line:

$result = mysqli_query($con,"SELECT * FROM message WHERE (user = '$zuser' OR run_date >= CURDATE() AND user='')");

to:

$result = mysqli_query($con,"SELECT * FROM message WHERE user = '$zuser' OR ( run_date >= CURDATE() AND user='')");

answered Mar 1, 2015 at 3:30

Adrian Cid Almaguer

7,79113 gold badges44 silver badges66 bronze badges

Collectives™ on Stack Overflow

mysql where statement not displaying proper results

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related