Checking to see if conditions are met

[LanceT]

Lets say I have two fields on a table called "hello" and "world"

Now I want to check if there is an existing row where

"hello" = some value

and

"world" = some value

and then return a boolean true if the conditions are met.

Can I use a simple if statement for this?

something like

[code]if ($hello=sdsds && $world=83434) {

code inside here

}[/code]

[simcoweb]

Well, you'd have to run a query first to determine what's there. Something like:

[code]
$sql = "SELECT * FROM tablename WHERE hello='hello' ";
$results = mysql_query($sql) or die(mysql_error());
if (!results)
{
echo "nothing matches that entry";
} else {
echo $results;
[/code]

[fenway]

A COUNT() would be more efficient if don't actually care about the results.