migrating

[Misticx]

i moved from one host to another... first thing hapened was that my domain name never moved, then i have a problem with a mysql command

the command is

$sql = ' SELECT * FROM dbname WHERE ip=\'$REMOTE_ADDR\'';
$sql = mysql_query($sql);
(line X) $test = mysqli_num_rows($sql);

the return line is:
Fatal error: Call to undefined function: mysqli_num_rows() in /home/thequest/public_html/filename.php on line X

ideeas ?

[Misticx]

w8 ... sorry

my bad made a change ...

anyway there is a error...
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/thequest/public_html/filename.php on line x

[SargeZT]

On your

$sql = mysql_query($sql);

line, change it to

$sql = mysql_query($sql) or die(mysql_error());

and see if it spits out an error.

By the by, use the PHP tags around your code, makes it easier to read.

[Roger_Ramjet]

Check your string quotes; if this is a copy/paste then you have used single quotes to start the query but double quotes to end it - which they will not so your query is all screwed.

Try this construction when developing

 $result = mysql_query($sql) or die($sql . '<br />' . mysql_error()); 

This will display both the query string and the error message it generated.

Your problem may be that you are using the same var name, $sql, for both the qiery sytring and the resultset. Try changing one or the other.