Big Problem! Please Help!

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

You need to put single quotes around the variable. ie:

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

instead of your

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

GeekAzoid

It doesn't solve my problem.

The problem is that any page pass the paramenters of the form by GET or by POST.

I don't know why.

piersk

Try:

$sql = "select * from countries where idcountry='$_GET[idcountry]'";

bladx

What about:

$_POST[idcountry]

$_GET[idcountry] ?

dogdac

I don't think it's a Post vs. Get problem. That seems to be more form related then a hyper link.

Have you tried putting quotes around the 3 in your HTML?

I'm doing it now but with a text field:

Here I get all the States found in a data base (Rowitem[5] is the state) and display it

while($Rowitem = mysql_fetch_row($sql_result))
{
echo "<a href=\"showstate.php?state=$Rowitem[5]\">$Rowitem[5]</a> <BR>";

Then the HTML linked code looks like:

//make an sql statment and execute it
$sql = "SELECT * FROM courses where St='$state' Order by Name";

This is a working peice of code....

Because PHP is so loosely typed (ie don't care what the var is, int vs char) If you quote the passed var of 3 (ie "3") I wonder if the Char of 3 will make it in to the sql text line any better...

would love to know if that worked for you.

GeekAzoid

The problem is solved.

there was a problem with the version of PHP, I have 4.2.2 but since 4.2.0 there is a variable in php.ini called register_globals that is set to off instead of ON. Just change off to ON and all is ok.

Thanks to everybody!