[SOLVED] What's wrong with this query?

[Moron]

If I use this (Look at the EmailAddress part) :

 

$RESULTMEMBER=mssql_query("select distinct * from MemberInfo MI where BoardName='Traffic Safety Advisory Board' and EmailAddress != '' order by MI.[LName]");
$RESULTBPE=mssql_fetch_assoc($RESULTMEMBER);
$RESULTMEMBERCOUNT=mssql_num_rows($RESULTMEMBER);

 

... it acts like it should. But if I use this:

 

$RESULTMEMBER=mssql_query("select distinct * from MemberInfo MI where BoardName='Traffic Safety Advisory Board' and EmailAddress = '' order by MI.[LName]");
$RESULTBPE=mssql_fetch_assoc($RESULTMEMBER);
$RESULTMEMBERCOUNT=mssql_num_rows($RESULTMEMBER);

 

...it crashes.

 

The first query is where EmailAddress is NOT EQUAL to '' (null or blank). The second query is where EmailAddress IS blank.

 

So what's wrong here?

 

 

[cooldude832]

= is not the comparisons you need here its ==

= really isn't a comparisons its more of saying x=6 or z=123 or f="sam I am"

== is a comparisons of values

=== checks value and type

 

[Moron]

= is not the comparisons you need here its ==

= really isn't a comparisons its more of saying x=6 or z=123 or f="sam I am"

== is a comparisons of values

=== checks value and type

 

 

But when I use ==, it crashes and gives me:

 

Warning: mssql_query() [function.mssql-query]: message: Line 1: Incorrect syntax near '='. (severity 15) in C:\user\WWWRoot\boards\TSAB\TSAB.php on line 15

 

Warning: mssql_query() [function.mssql-query]: Query failed in C:\user\WWWRoot\boards\TSAB\TSAB.php on line 15

 

Warning: mssql_fetch_assoc(): supplied argument is not a valid MS SQL-result resource in C:\user\WWWRoot\boards\TSAB\TSAB.php on line 16

 

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\user\WWWRoot\boards\TSAB\TSAB.php on line 17

 

Warning: mssql_data_seek(): supplied argument is not a valid MS SQL-result resource in C:\user\WWWRoot\boards\TSAB\TSAB.php on line 19

 

[Barand]

~cooldude

 

[pre]

                      +-----------+------------+

                      |    PHP    |  MYSQL    |

+----------------------+-----------+------------+   

|                      |          |            |

| Comparison operator  |    ==    |    =      |

|                      |          |            |

+----------------------+-----------+------------+

 

[Moron]

~cooldude

 

[pre]

                       +-----------+------------+

                       |    PHP    |   MYSQL    |

+----------------------+-----------+------------+   

|                      |           |            |

| Comparison operator  |    ==     |     =      |

|                      |           |            |

+----------------------+-----------+------------+

 

 

But look at the query. It works fine with a single = sign and crashes with ==. My question is, why does it work where EmailAddress != and crashes when it DOES equal something?

 

[Barand]

What error message do you get when it crashes (your original query, not the one with the erroneous ==)

[redarrow]

becouse you said the email is not equel to nothink

[Barand]

 

 

But look at the query. It works fine with a single = sign and crashes with ==. My question is, why does it work where EmailAddress != and crashes when it DOES equal something?

 

 

Can we have some clarification here?

 

Your original post said it crashed with "=", now you say it worked.

 

Which is it?

 

(And of course it failed with "==", as my last post stated for cooldude's benefit, that's the PHP comparison operator, not MySQL's)

[Moron]

 

 

But look at the query. It works fine with a single = sign and crashes with ==. My question is, why does it work where EmailAddress != and crashes when it DOES equal something?

 

 

Can we have some clarification here?

 

Your original post said it crashed with "=", now you say it worked.

 

Which is it?

 

(And of course it failed with "==", as my last post stated for cooldude's benefit, that's the PHP comparison operator, not MySQL's)

 

Sorry about the confusion. If I only use....

 

where BoardName='Traffic Safety Advisory Board'

 

...it works fine. If I use....

 

where BoardName='Traffic Safety Advisory Board' and EmailAddress != ''

 

...it also works fine. But, I need it to use where EmailAddress DOES equal '' (blank).

 

[redarrow]

read this please.

 

http://dev.mysql.com/doc/refman/4.1/en/comparison-operators.html

 

BETWEEN ... AND ...  Check whether a value is within a range of values 
COALESCE() Return the first non-NULL argument 
<=> NULL-safe equal to operator 
= Equal operator 
>= Greater than or equal operator 
> Greater than operator 
GREATEST() Return the largest argument 
IN Check whether a value is within a set of values 
INTERVAL() Return the index of the argument that is less than the first argument 
IS NULL NULL value test 
ISNULL() Test whether the argument is NULL 
LEAST() Return the smallest argument 
<= Less than or equal operator 
< Less than operator 
LIKE Simple pattern matching 
NOT BETWEEN ... AND ... Check whether a value is not within a range of values 
!=, <> Not equal operator 
NOT IN Check whether a value is not within a set of values 
NOT LIKE Negation of simple pattern matching 
SOUNDS LIKE(v4.1.0) Compare sounds 

[redarrow]

where BoardName='Traffic Safety Advisory Board' and EmailAddress = ISNULL

 

or

 

where BoardName='Traffic Safety Advisory Board' and EmailAddress = NULL

[Moron]

Thanks, folks. "IS NULL" did the trick! I swear I tried that earlier. Maybe I had the syntax wrong.