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 <[EMAIL PROTECTED]>
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"]))" ?
> 
> [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>
> >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
> >>[EMAIL PROTECTED]
> >>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
> >>
> >>
> >>    
> >>
> >
> >  
> >
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to