beginning and end of field

[Garabaldi]

Hi,

My question is this:

In ASP I can check if the result of an sql query produces any records through an if statement ( ex: if object.BOF or object.EOF then
'do nothing
end if
)

Is there anyway to accomplish the results through PHP?

thanks

 

[danielhozac]

Sure, look up the page for your database server at

http://www.php.net/manual/en/.

//Daniel

 

[DRJ478]

It depends what backend server you use for the database.

Here's the answer for MySQL:

# get the resource identifier
$result = mysql_query("SELECT * FROM mytable WHERE 1") OR die(mysql_error());

# check how many rows and do something if none
if (mysql_num_rows($result)<1){
   # whatever happens if no result
} else {
   # other handling etc.