Re: SQL: Limit 1 usage?
| From: | 1LT John W. Holmes | Date: | Thu, 30 Jan 2003 20:51:34 +0000 |
| Subject: | Re: SQL: Limit 1 usage? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25271@lists.php.net to get a copy of this message | ||
> $sql = "SELECT * FROM accessnums WHERE areacode=$_POST[areacode]' and
city='$_POST[cityselected]' ORDER BY network LIMIT 1";
>
> It can't execute the query. Any suggestions?
Unless it's a typo, you're missing a single quote around $_POST[areacode]...
---John Holmes...