Version: 1.0
Type: Function
Category: Databases
License: GNU General Public License
Description: Small but handy function to emulate an Access-style DLookup function.
function DLookup($fld, $tab, $whr)
{
$q = "Select $fld from $tab where $whr";
$rst = mysql_query($q);
if ($row = mysql_fetch_object($rst))
return $row->$fld;
else
return NULL;
}
// ex: lookup a customer name based on $customerid
$name = DLookup("Name", "Customer", "Id=$customerid");
