PHPBuilder - MYSQL query Simplified

RSS Twitter

MYSQL query Simplified

by: Leonard Burton
January 21, 2003

Version: 1.0

Type: Function

Category: Databases

License: GNU General Public License

Description: This script is used when you have more than one table where names are stored. I created it so that I could get names of accounts, vendors, or payment types for a ledger program that are associated to a number. You pass to it a number as $acct and what type of name you want (i.e. Vendor, Account, Payment Type) as $type.

This code comes from the PHP Function Junction at
Gets Account and Payment Type names
$acct is the $ that holds the refered #
$type is a choice account:

function fj_get_names($acct, $type)
	if ($type=="accounts")
$result= mysql_query("select * from ledger_accounts where auto=$acct");
	elseif ($type=="vendor")
$result= mysql_query("select * from ledger_vendors where auto=$acct");
	elseif ($type=="pmt")
$result= mysql_query("select * from ledger_pmttype where auto=$acct");
	if ($result)
		while ($row = mysql_fetch_array($result))
			return $row["name"];

Comment and Contribute

Your comment has been submitted and is pending approval.

Leonard Burton



(Maximum characters: 1200). You have characters left.