i have a script called database.php that is inclued into every file that uses database functions.
<?php
$DB[host] = "localhost";
$DB[user] = "username";
$DB[pass] = "password";
$DB[name] = "database_name";
$DB[prefix] = "prefix_";
$DB[pconnect] = 0;
if ($DB[pconnect] == 1){
$DB[connect] = mysql_pconnect($DB[host], $DB[user], $DB[pass]) or die ("Critical database error");
}else{
$DB[connect] = mysql_connect($DB[host], $DB[user], $DB[pass]) or die ("Critical database error");
}
mysql_select_db($DB[name], $DB[connect]) or die ("Critical database error");
function DATABASE_query($query){
$result = mysql_query($query, $DB[connect]);
return $result;
}
function DATABASE_fetch($query){
$result = mysql_fetch_array($query, $DB[connect]);
return $result;
}
?>
if, for example i include the file and then run this..
$result = DATABASE_query("SELECT * FROM users");
if(DATABASE_fetch($result)){
echo("it worked");
}else{
echo("didnt work");
}
it would always print 'didnt work'
I know that all my db info is correct. Please tell me whats wrong with the code, im stumped
Thanks in advance,
Mike