Thanks, but not working: The error message: Error in query: SELECT Newsheadline, News, Contact FROM news WHERE Newsid = . You have an error in your SQL syntax near '' at line 1
Here are both lines: $query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid = {$_GET['id']}"; $result = mysql_query($query) or die ("Error in query: $query. " . mysql_error()); Regards, Frank ----- Original Message ----- From: "Danny Shepherd" <[EMAIL PROTECTED]> To: "Frank Keessen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, January 15, 2003 11:54 AM Subject: Re: [PHP] Question about $_GET > Try > > $query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid = > {$_GET['id']}"; > > HTH > > Danny. > ----- Original Message ----- > From: "Frank Keessen" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, January 15, 2003 10:50 AM > Subject: [PHP] Question about $_GET > > > Hi All, > > Can you please help me with the following problem? I've had code wich was > running fine with php till i've upgraded to PHP version 4.2.3. > > The original code line was: > > $query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid = > '$id'"; > > but it's not working when you have register_globals=Off > So i've read everywhere to use the $_Get: > > So the code looks like this: > > $query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid = > $_GET['id']"; > > But all i'm getting in my browser is: > > parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' > > > Can someone please help? > > Thanks and regards, > > Frank > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php