Re: SQL query error
| From: | Geoff Lane | Date: | Sat, 16 Dec 2006 09:43:00 +0000 |
| Subject: | Re: SQL query error | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42824@lists.php.net to get a copy of this message | ||
On Saturday, December 16, 2006, Jeffrey wrote;
> Have you tried...
> echo "<p> $query </p>";
> ...to unsure the variables have the values you expect them to have?
---
Another thing to try (particularly with SELECT statements) is to cut
and paste the echoed query from your browser to the DBMS prompt (e.g.
MySQL prompt or MSSQL Query Analyser), attempt to run it, and then
follow up any errors the DBMS reports.
HTH,
--
Geoff