Fetch_array Help and problem

[Andyr6381]

Hi All,

I have just chanegd to a new sever not sure if the php i newer or older but I am getting this error for a script I wrote some time back can any1 see anything obvious that it could be. New server rules

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/virtual/site8/fst/var/www/html/bb4b/html/subitdata.php on line 71

The script it

//check user is unique
$result = mysql_query ("SELECT * FROM registration WHERE tel = '$tel'");
function check_unique($result){
if ($row = mysql_fetch_array($result)) return FALSE;
else return TRUE;
}

It has always worked before, but I just can't see what it could be.

Kind regards
Andy

p.s I already tried Assoc for array = same error

[kevinsequeira]

couldnt u try if(mysql_num_rows($result)>0)
return false;
else
return true;

did u try running the query directly on the database ?

try this also

$result = mysql_query ("SELECT * FROM registration WHERE tel = '$tel'");
if(mysql_error())
echo mysql_error();

reg
kevin

[Andyr6381]

Ah no worries,

Solved the problem, I mixed up my database names when changing over to my new dedicated server. Script works fine now, thanks to

if(mysql_error())
echo mysql_error();

Thanks
Andy

Must remeber that 1