<?

function db_get_table_contents($table) {
	$db_query = "SELECT * FROM $table;";
	return mysql_query($db_query);
}

function db_admin_checkuser($username, $password) {
	return true;
}
function db_get_row_names($table) {
	global $db_database;

	$fields = mysql_list_fields($db_database, $table);
	$columns = mysql_num_fields($fields);
	
	for ($i = 0; $i < $columns; $i++) {
	    $rtn[$i][0] = mysql_field_name($fields, $i);
	    $rtn[$i][1] = mysql_field_len($fields, $i);
	}
	return $rtn;
}
function db_get_tables() {
	global $db_database;
	return mysql_list_tables($db_database);
}

function db_connect() {
	global $db_link;
	global $db_server, $db_username, $db_password, $db_database;
	
	$db_link = mysql_pconnect($db_server, $db_username,$db_password);

	if($db_link) {
		return mysql_select_db($db_database) or die("Could not select database");
	} else {
		echo "nailed";
		return $db_link;
	}
}

function db_get_row($table, $key, $value) {
	$db_query = "SELECT * FROM $table WHERE $key='$value'";
	$db_result = mysql_query($db_query) or die("Query failed : " . mysql_error());
	
	return mysql_fetch_assoc($db_result);	
}

function db_get_prod_data($prod_id, $type) {
	db_connect();
	$db_query = "SELECT * FROM prods WHERE prod_id='$prod_id'";
	$db_result = mysql_query($db_query);
	$prod = mysql_fetch_assoc($db_result);	
	return $prod[$type];
}

function db_get_rows($table) {
	$db_query = "SELECT * FROM $table";
	$db_result = mysql_query($db_query) or die("Query failed : " . mysql_error());
	
	return mysql_num_rows($db_result);	
}

function db_get_cat($cat_id) {
	db_connect();
	$db_query = "SELECT * FROM cats WHERE cat_id='$cat_id'";
	$db_result = mysql_query($db_query);
	$cat = mysql_fetch_assoc($db_result);	
	return $cat['cat_name'];
}
function db_get_cats_result() {
	db_connect();
	$db_query = "SELECT * FROM cats";
	$db_result = mysql_query($db_query);
	return $db_result;
}

function db_get_prodsbycat($cat_id, $page) {
	global $max_results;
	if(!$page){$page=1;}
	$start = ($page - 1) * $max_results;
	db_connect();
	$db_query = "SELECT * FROM prods WHERE prod_cat_id='$cat_id' LIMIT $start, $max_results";

	return mysql_query($db_query);
}

function db_get_prodsbyprice($price_min, $price_max, $page) {
	global $max_results;
	if(!$page){$page=1;}
	$start = ($page - 1) * $max_results;
	db_connect();
	$db_query = "SELECT * FROM prods WHERE prod_price BETWEEN $price_min AND $price_max LIMIT $start, $max_results";

	return mysql_query($db_query);
}

function db_search_prods($prod_str='', $cat_id=0, $price_min=0, $price_max=0) {
	db_connect();
	global $max_results;
	
	$start = $page * $max_results;
	db_connect();
	$db_query = "SELECT * FROM prods WHERE";
	
	$db_query = $db_query." MATCH (prod_name, prod_title, prod_desc) AGAINST ('$prod_str')";
	if ($price_max) { $db_query = $db_query." AND prod_price BETWEEN $price_min AND $price_max";}
	if ($cat_id) { $db_query = $db_query." AND prod_cat_id = $cat_id";}
	$db_query = $db_query." LIMIT $start, $max_results";
echo $db_query;
	return mysql_query($db_query);
}

?>