$MYSQL_HOST = "localhost"; $MYSQL_LOGIN = "loginname"; $MYSQL_PASS = "password"; $MYSQL_DB = "databasename"; $db = mysql_connect($MYSQL_HOST,$MYSQL_LOGIN,$MYSQL_PASS); if(!$db){ echo('Unable to connect to db' . mysql_error()); exit; } mysql_select_db($MYSQL_DB); function q($q, $debug = 0){ $r = mysql_query($q); if(mysql_error()){ echo mysql_error(); echo "$q
"; } if($debug == 1) echo "
$q
"; if(stristr(substr($q,0,8),"delete") || stristr(substr($q,0,8),"insert") || stristr(substr($q,0,8),"update")){ if(mysql_affected_rows() > 0) return true; else return false; } if(mysql_num_rows($r) > 1){ while($row = mysql_fetch_array($r)){ $results[] = $row; } } else if(mysql_num_rows($r) == 1){ $results = array(); $results[] = mysql_fetch_array($r); } else $results = array(); return $results; } function q1($q, $debug = 0){ $r = mysql_query($q); if(mysql_error()){ echo mysql_error(); echo "
$q
"; } if($debug == 1) echo "
$q
"; $row = @mysql_fetch_array($r); if(count($row) == 2) return $row[0]; else return $row; } function qr($q, $debug = 0){ $r = mysql_query($q); if(mysql_error()){ echo mysql_error(); echo "
$q
"; } if($debug == 1) echo "
$q
"; if(stristr(substr($q,0,8),"delete") || stristr(substr($q,0,8),"insert") || stristr(substr($q,0,8),"update")){ if(mysql_affected_rows() > 0) return true; else return false; } $results = array(); $results[] = mysql_fetch_array($r); $results = $results[0]; return $results; }