Re: SoS

Hi, Jason and Shahmat: I figured it out! The register_globals is turned off. To parse the id with this parameter off, I just need to judge whether $_GET["id"] is set or not. The problem is that I wrote the SQL statement as: $SQLstr="SELECT * FROM employees WHERE id=$_GET["id"]"; That's a wrong one. To solve this, I do the following (a naive one): $tid=$_GET["id"]; $SQLstr="SELECT * FROM employees WHERE id=$tid"; And it's OK. Thank you very much for your helps! Zhan Xu EECS Department Case Western Reserve University ----- Original Message ----- From: Shahmat Dahlan <shahmatd@sains.com.my> Date: Monday, October 6, 2003 6:07 am Subject: Re: [PHP-DB] SoS > if the statement "if (isset($id)) doesn't probably it because > register_globals has been turned off maybe? > > How about "if (isset($_GET["id"]))" ? > > zxx10@cwru.edu wrote: > > >Hi, Jason: > > > >Thank you very much for your quick reply. I tried > >the if (isset($id)) but it doesn't work. Any > >thoughts? > > > >By the way, I'm using Php4.3.3 and MySQL4.0.15a. > >The tutorial I'm reading is about Php3. Will this > >be the problem? > > > >Many thanks. > > > >Zhan Xu > >EECS Department > >Case Western Reserve University > > > >----- Original Message ----- > >From: Jason Godesky <jason@tribaldawn.com> > >Date: Monday, October 6, 2003 5:52 am > >Subject: Re: [PHP-DB] SoS > > > > > > > >>Your if statement will only be TRUE if $id is set to FALSE, NULL > or > >>zero > >>(0)--I think you're looking for if the variable is set. That > would > >>be: if > >>(isset($id)) > >> > >>-- > >>Jason Godesky > >>jason@tribaldawn.com > >>http://www.tribaldawn.com/jason/ > >> > >> > >> > >> > >>>I'm a beginner of PHP. While trying the code from > >>>a tutorial, I encountered the following problem. > >>> > >>>The variable $id can not be transfered to my server. > >>>You can find the code at the end of this email. When > >>>I visit http://mydomain.com/test.php?id=1 > >>>it always shows the list of the database instead > >>>of a perticular record. > >>> > >>>I appreciate your kind helps! > >>> > >>>Zhan Xu > >>>EECS Department > >>>Case Western Reserve University > >>> > >>> > >>-- > >>PHP Database Mailing List (http://www.php.net/) > >>To unsubscribe, visit: http://www.php.net/unsub.php > >> > >> > >> > >> > > > > > > >