[SOLVED] Check if database is empty

[tecmeister]

Hi Guys,

 

I'm trying to check the database to see if the user has inserted any images.

 

I've tried:

 

if(empty())

SELECT COUNT(userid) FROM personalImage WHERE userid='$id'.

 

Please will you be able to help me and tell me what I need to do.

 

Thanks,

 

tecmeister.

[trq]

$sql = "SELECT userid FROM personalImage WHERE userid='$id'";
if ($result = mysql_query($sql)) {
  if (mysql_num_rows($result)) {
    // The user has images
  } else {
    // The user has no images
  }
} else {
  // Query failed
}

 

[tecmeister]

Thank you so much for your help.