[PHP-DB] Re: SQL query error

2006-12-16 Thread Geoff Lane
On Saturday, December 16, 2006, Jeffrey wrote; > Have you tried... > echo " $query "; > ...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

Re: [PHP-DB] SQL query error

2006-12-16 Thread Jeffrey
Chris Carter wrote: What wrong with this syntax, its not giving any error on runtime but I am facing a blank page while paging. $query=" SELECT * FROM gurgaonmalls WHERE mallname = '$mallname' limit $eu, $limit "; Have you tried... echo " $query "; ...to unsure the variables have the values