Re: Syntax for select statement
| From: | Christian Reiniger | Date: | Fri, 27 Apr 2001 18:10:09 +0000 |
| Subject: | Re: Syntax for select statement | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-50668@lists.php.net to get a copy of this message | ||
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 statement? If the answer is
> "Yes", can someone give me a more robust way of writing it using PHP?
Yes.
use addslashes()
--
Christian Reiniger
LGDC Webmaster (http://sunsite.dk/lgdc/)
Error 032: Recursion error - see error 032