Help with queries

[esapo]

Hi!!
I have instaled Abyss Web Sever, PHP and SQL and Mysql. Everything works fine.

I made a copy of my site to the Abyss directory and the site also works, except when some page tries to run a query. I always receive errors like:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Archivos de programa\Abyss Web Server\htdocs\bio.php on line 9

The line 9 is

$row = mysql_fetch_array($response);

The previuos sentences are:

$db = mysql_connect("localhost", user , pass);
mysql_select_db(historia,$db);
$response = mysql_query("select * from bio_his where indice=$id", $db);

I supposed that it seems to be a problem with the variables sent by the previuos page, but in the Internet (not locally) I do not receive that errors.

It is something that I have to set anywhere in my computer??

Thanks to anyone for your help.

Ezequiel

[aprelium]

esapo,

If $id is a variable that comes from a POST or a GET request, you have to change ot to $_REQUEST['id'] or to set register_globals to on in php.ini .

Search for "Undefined variable" in this section of the forum for more information about the new PHP variable naming convention.
_________________
Support Team
Aprelium - http://www.aprelium.com