Re: SQL query error
| From: | Haydar Tuna | Date: | Wed, 21 Feb 2007 07:36:09 +0000 |
| Subject: | Re: SQL query error | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43107@lists.php.net to get a copy of this message | ||
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" <chandan9sharma@yahoo.com> 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#a7903857
> Sent from the Php - Database mailing list archive at Nabble.com.