Php Programming Code Examples
Php > Database Related Code Examples
Single Query MySQL Functions
Single Query MySQL Functions
<?
/*
* These functions provide a simple API for returning one set of results.
* Syntax :
* mysql_one_data($query);
* mysql_one_array($query);
*
* Example :
* $fname = mysql_one_data("SELECT fname FROM users WHERE id = '2'");
*
* $user = mysql_one_array("SELECT * FROM users WHERE id = '2'");
*/
/*
* mysql_one_data([ string query ]);
*/
function mysql_one_data($stmt) {
$query=mysql_query($stmt);
$result=mysql_fetch_row($query);
return($result[0]);
}
/*
* mysql_one_array([ string query ]);
*/
function mysql_one_array($stmt) {
$query=mysql_query($stmt);
$result=mysql_fetch_array($query);
return($result);
}
?>
