[SOLVED] Using Try...Catch to eliminate an error

[elite_prodigy]

I'm using the following code to test if a "site" exists in the database.

 

<?php

//...

$sql = "SELECT * FROM `sites` WHERE `site`=$site;";
$result = mysql_query($sql,$conn);

$rows = mysql_num_rows($result);

if($rows > 0){


if($_SESSION['count'] < 1){

  $page = "home";
  $_SESSION['count'] = $_SESSION['count']++;

}

}
else{

$page = "sign";

}

//...

?>

 

The above code does a couple things. It queries the data I need from the database and uses mysql_num_rows() to see if at least one row exists (I'll add a clause later for when more than one row exists) because if there is a row then the site is there.

 

I'm getting the desired result, but a warning is generated when no site exists because mysql_num_rows() returns an error when there is nothing to query. I need to catch the warning so that it is not displayed to the screen.

 

I thinking a try/catch statement but cannot for the life of me think of how to write it.

 

Can anyone help?

[burnside]

sum it like :

 

if($rows == 0 ) { echo " No result ";} else { echo " result blahhhhhhhhhh ";}

 

i think that is what your after,

[trq]

<?php

$sql = "SELECT * FROM `sites` WHERE `site`=$site;";
if ($result = mysql_query($sql,$conn)) {
  if (mysql_num_rows($result)) {
    if ($_SESSION['count'] < 1){
      $page = "home";
      $_SESSION['count'] = $_SESSION['count']++;
    }
  }
} else {
  $page = "sign";
}

?>

[elite_prodigy]

Thank you! Why didn't I think of that? So simple! I really need to think more logically.