Weird Problem. Please Help Me!

GeekAzoid

Hi everybody!

I'm having promblems with PHP 4 on a RedHat Linux with Apache 1.3.26 and
mySQL.

All runs perfectly except the paramenters between pages:

for example, I have an HTML file with this code:

<a href="countries.php?idcountry=3">United States</a>

the code of countries.php

$sql = "select * from countries where idcountry=$idcountry";

echo $sql;

the result is:

select * from countries where idcountry=

I don't know what's the problem.

Please help me to solve this, is urgent!

THANKS IN ADVANCE

Roberto

piersk

Ive answered this question in your other posting...

lenchik

Check your php.ini file and set the value of 'register_globals" to ON

GeekAzoid

I'll try it tomorrow, I think that this is the problem.

THANKS A LOT!

N03L

registering globals is a potential security risk. There is a reason the php consortium decided to discontinue the convenience. I say get in the habit of using your superglobals:

$POST & $GET. Only grab the vars you need.

ex.
$var=$_POST['var'];

I recommend adopting this style for all your future scripts. For old scripts, I say if you don't want to bother fixing them, and I don't blame you, throw these lines at the top of each script:

extract($POST);
extract($GET);
$PHP_SELF=$_SERVER['PHP_SELF'];

The order of POST and GET in the above might matter if you like to submit forms with query strings in the action.

This will also make your scripts more portable if you have to move them to a server where you don't get to edit the php.ini file.

GeekAzoid

Very interesting. Thank you.

I'm a novice with PHP.

Regards