For Programmers: Free Programming Magazines  


Home > Archive > PHP DB > February 2007 > Re: SQL query error









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: SQL query error
Haydar Tuna

2007-02-21, 3:57 am

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-err...2.html#a7903857
> Sent from the Php - Database mailing list archive at Nabble.com.

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com