Select And If Statement

[essexboyracer]

Hi ALl,

Im looking for a control structure to exie any other processing on comparison against mysql, I have gotten to the following but am stuck,

$query1="SELECT * FROM proposer WHERE proposer3='$item[2]' AND proposer6='$item[8]'";
$result1=mysql_query($query1);

if ($result1 === true) {
die();
} else {

do something else();

}

Any ideas?

[ChrisBoden]

I'm a little uncertain about what you're trying to achieve. Could you explain it a little better?

[Kardall]

ya I don't get it. Are you trying to have something report true/false if a certain comparrison actually has results? If so... just use mysql_num_rows(); on the query so that you can see if it got 0 or more results.

for example:

$sql = "SELECT * FROM proposer WHERE proposer3='$item[2]' AND proposer6='$item[8]'";

$query=mysql_query($sql);

if( mysql_num_rows($query) > 0 ) {
  // There is somem results returned
  // Put code here to handle what you want it to do
} else {
  // it's 0 so nothing was returned
}

if you want it to loop continuously through values... that's a while loop and you do the same thing, but put the while variables in the $sql query 🙂