SQL query error
am 16.12.2006 07:50:16 von Chris Carter
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 ";
--
View this message in context: http://www.nabble.com/SQL-query-error-tf2831052.html#a790385 7
Sent from the Php - Database mailing list archive at Nabble.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: SQL query error
am 16.12.2006 09:47:53 von jeffreyb
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 you expect them to have?
Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: SQL query error
am 16.12.2006 10:43:00 von 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.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
Re: SQL query error
am 21.02.2007 08:36:09 von Haydar TUNA
Hello,
Do you check the how many rows return. You can display rows count
with following PHP code. If rows count is zero, you can see the blank page.
:)
$num_rows = mysql_num_rows($result);
echo ($num_rows);
--
Haydar TUNA
Republic Of Turkey - Ministry of National Education
Education Technology Department Ankara / TURKEY
Web: http://www.haydartuna.net
"Chris Carter" wrote in message
news:7903857.post@talk.nabble.com...
>
> 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 ";
> --
> View this message in context:
> http://www.nabble.com/SQL-query-error-tf2831052.html#a790385 7
> Sent from the Php - Database mailing list archive at Nabble.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php