Re: SQL query error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux