Re: [PHP] Syntax for select statement

2001-04-30 Thread Jason Stechschulte
On Fri, Apr 27, 2001 at 11:56:08AM -0400, Don Pro wrote: > $queryID = mysql_query("SELECT Country, Agent FROM Ports > WHERE Portname = '$portname'"); > > My question is, if the variable $portname has the ' character within in, > will this cause an error in

Re: [PHP] Syntax for select statement

2001-04-27 Thread Philip Olson
also note that if magic_quotes_gpc setting (in php.ini) is on, these quotes will automagically be escaped. phpinfo() will tell you your setting, as will get_magic_quotes_gpc(). http://www.php.net/manual/en/configuration.php#ini.magic-quotes-gpc run around the manual for more information. re

Re: [PHP] Syntax for select statement

2001-04-27 Thread Christian Reiniger
On Friday 27 April 2001 17:56, Don Pro wrote: > $queryID = mysql_query("SELECT Country, Agent FROM Ports > WHERE Portname = '$portname'"); > > My question is, if the variable $portname has the ' character within > in, will this cause an error in my select s

[PHP] Syntax for select statement

2001-04-27 Thread Don Pro
Hi, I've written PHP routines to work on MySQL and so far so good. However, I have one question. I have a select routine that has the following syntax (which works fine thus far): $queryID = mysql_query("SELECT Country, Agent FROM Ports WHERE Portname =