Posted By

shawntysco on 09/22/10

Tagged

mysql
php
query

Versions (?)

Last Edited at 09/22/10 09:57pm

Statistics

Viewed 783 times

Favorited by 0 user(s)

Related snippets

Query the database PHP

/ Published in: PHP

To use:
$update_sql = querys($sql);
or
$select_sql = getresult($sql);

Used simplify selecting rows from a database. You'll need to pass in the SQL statement.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

/*FUNCTION: querys
 *PURPOSE:  querys the database
 *RETURNS: $rs - result set 
 */
function querys($sql){
	$rs=mysql_query($sql);
	return $rs;
}
/*FUNCTION: get result
 *PURPOSE:  querys the database, adds to assicoative array
 *REUTRNS: $data - assocative array
 */
function getresult($sql){
	$rs=mysql_query($sql);
	$data=@mysql_fetch_array($rs);
	return $data;
}