Problem With Select

[jowatkins]

Hi,

I think I'm probably overlooking something really simple here but anyway.

I have a database that acts as a bug tracker. When a fix for a bug is found, it's details are added to the database. This fix then has to be either accepted or rejected by the manager. If a bug has had a previous fix that has been rejected then in order to make sure I am updating the correct fix (i.e. the last one added) I need to search for the fix where the accepted field is empty. Sounds simple right?

I have the following query, but it doesn't work.

SELECT * FROM HWBugfixes WHERE probno='$bugno' AND accepted=''

I've also tried

SELECT * FROM HWBugfixes WHERE probno='$bugno' AND accepted=NULL

If I just run SELECT * FROM HWBugfixes WHERE probno='$bugno' I get all the records, no problem. Can anyone see what's wrong?

Thanks in advance, Jo

[planetsim]

please say you have got mysql_query there

and a variable from it

into a while loop with mysql_fetch_array(variable_name)

ok if you do.

Now from there you have this AND accepted=''

You firstly are looking for through the table.. look into a particular field with information. SO that is narrowing your search. Then you look through another feild. Which it must equal the first then equal your Second.

Now im thinking that accepted doesnt have anything blank..

Do a mysql_num_rows

To see if there is any rows.
Most likely will output 0.

If so you must have something that signifies not being accepted or being excepted maybe no, 0

[the_Igel]

what type is "accepted"?
And you should check for null as "accepted is null", not "accepted = null"

[jowatkins]

Thanks,

changing the query to

SELECT * FROM HWBugfixes WHERE probno='$bugno' AND ISNULL(accepted)

worked