MySQL Head Banger :@ !!! (1 Viewer)

[BlueIshDan]

Hello Follow Nerdlings

I'm about to bash my head :banghead: off of every surface in sight if I don't figure out what I'm missing...

This query:

$query = 'SELECT comments.id, comments.comment, users.first_name, users.last_name ' . 
         'FROM comments left join users on users.id = comments.user_id ' . 
         'WHERE comments.post_id = ' . $post_id . ' [COLOR="Red"]AND comments.date_deleted IS NULL[/COLOR] ' .
         'ORDER BY comments.post_id DESC';

Is still returning records with date_deleted fields that have values in them... WHY!? NO ERRORS AND CORRECT SYNTAX!!!

I'm going to cry here soon lol... the little things in life they say

 

[stopher]

What data type is comments.date_deleted? What values are you getting that you would expect to be Null?

 

[gemma-the-husky]

out of interest I don't understand the periods either side of $post_id

. $post_id .

they should be ampersands

& $post_id &

 

[BlueIshDan]

What data type is comments.date_deleted? What values are you getting that you would expect to be Null?

The data type is datetime. The result is returning all comments respective to the post. But it is not filtering for the date_deleted condition.


To Dave:

Sorry, I forgot to mention that this code snippet is written in PHP.

 

[stopher]

What happens when you include comments.date_deleted in the Select. What values are you seeing?

Are you also seeing Null values?

 

[BlueIshDan]

Seeing both null and valued.

 

[BlueIshDan]

 

[Gasman]

What do you get if you output $query ?

 

[BlueIshDan]

"SELECT comments.id, comments.comment, users.first_name, users.last_name FROM comments left join users on users.id = comments.user_id WHERE comments.post_id = 34 AND comments.date_deleted IS NULL ORDER BY comments.post_id DESC"

 

[BlueIshDan]

All good people!
It miraculously worked lmao!

I've never seen PHP results cache before... weird.

Thanks for the help!