|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
July 9th, 2004, 10:05 AM
|
|||
|
|||
|
Solving the mystery of NULL
I am trying to query my database using the following code.
$result = mysql_query( "SELECT CASENUM,CLIENTNUM,CLNAME,CFNAME,SNUM,OFFICENUM,FUN DSNUM,PCODE,COPEN,DCLOSED FROM _clientsw_cases where (SNUM = $SNUM) AND (DOPEN IS NULL) ORDER BY COPEN ASC") My problem is the it will not select null values for DOPEN. I have been staring at this thing for hours. Can anyone please help me figure out what the heck is wrong!!! Why won't it pull the DOPEN fields from my MySQL database that are null! Foreever Thankful if you can help me solve this!!!!!!!!!!!
|
|
#3
July 9th, 2004, 11:05 PM
|
|||
|
|||
|
It is always good when you catch your own mistakes.
__________________
__________________________________________________ _ Wil Moore III, MCP | Integrations Specialist | Senior Consultant Are You Listed...? | DigitallySmooth Inc.
|
|
| Viewing: Dev Articles Community Forums > Programming > PHP Development > Solving the mystery of NULL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
