Trying to find is a null is True False

[anon1971]

I am trying to check to confirm that both memberid and recipeid is not null. That way if both have value it will allow the member to ad the ripe to there list if both have a value it will tell them the recipe they are adding is already in there list. Working on this for a while need help and trying to transition from asp classic to php ;-).

$check_fav = mysql_query("SELECT memberid, recipeid FROM favorites WHERE (memberid = '".$memberid."' AND recipeid = '".$id."')");

If ($check_fav == TRUE){.......

 

[vacunita]

Your query already does the checking for the existence of a recipe, all you need to do is verify whether your query returned a row or not. Checking for true or false will only tell you the query succeeded, but it can succeed even if it did not bring anything back. 0 results would mean the recipe does not exist. At least one result means it already does.

Try:

$rows = if(mysql_num_rows($check_fav) > 0)
{
[indent][COLOR=#4E9A06]//recipe exists[/color][/indent]
}
else
{
[indent][COLOR=#4E9A06]//recipe does not exist[/color][/indent]
}

PHP Online Manual: mysql_num_rows()



----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech

 

[gandalf458]

The mysql_* functions were deprecated some years ago and don't even exist in the latest version of PHP. It is better to use mysqli_* or PDO.


I'm not a number, I'm a free man

 

[ChrisHirst]

Just as a minor point of programming semantics;

Trying to find is a null is True False

A NULL is neither 'true' or 'false', it is simply NULL (equating to Nothing)

So your question should be something like "Testing for a NULL value"

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum