Re: Database problem?
| From: | William Stokes | Date: | Mon, 28 Nov 2005 19:04:09 +0000 |
| Subject: | Re: Database problem? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-226558@lists.php.net to get a copy of this message | ||
OK. Where can I change the register_globals setting?
Thanks for the fast replies.
-Will
"Jay Blanchard" <jay.blanchard@THERMON.com> kirjoitti
viestissä:0CEC8258A6E4D611BE5400306E1CC9270915AB40@smtmb.tmc.local...
> [snip]
> http://localhost/index.php?team=F10a
>
> I have this in my page and it doesn't work:
> $sql = "select jouk_nimi from x_jun_jouk where jouk_id='$team' ";
> $kysely = mysql_query($sql);
> $tulos = mysql_fetch_row($kysely);
> $jouk_nimi = $tulos[0];
>
> $jouk_nimi -variable will be empty.
>
> This works (replaced the $team with static entry "F10a")
> $sql = "select jouk_nimi from x_jun_jouk where jouk_id='F10a' ";
> $kysely = mysql_query($sql);
> $tulos = mysql_fetch_row($kysely);
> $jouk_nimi = $tulos[0];
>
> $jouk_nimi get's right value from database.
> [/snip]
>
> register_globals is 'on' on the other server. Try
>
> $sql = "select jouk_nimi from x_jun_jouk where jouk_id=$_GET['team'] ";