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 p $query /p; ...to unsure the variables have the values

[PHP-DB] Re: SQL query error

2006-12-16 Thread Geoff Lane
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