Database Abstraction Layer for PHP

User Tools

Site Tools




This is a global variable that determines what the getOne() method returns if the SQL statement fails to match any records in a recordset. The value can be set or reset at any point in a script.

If the value that is being retrieved can return an empty or 0 value, it is important to do an exact comparison on the returned value to distinguish between queries where the value of the record found is empty and queries where no record is found


$test = $db->getOne('select character_field from table where integer_field=1');  
if ($test === null)
    * We did not find any records that matched the value of integer_field=1
if ($test == false)
    * We did not find any records OR the first record found that matched 
    * integer_field=1 had a character_field value of null
v5/reference/adodb_getone_eof.txt · Last modified: 2023/06/19 15:27 by dregad