Hello Every One,
I have a problem of fetching database from a huge table of allmot 3500 lines, the query was't exicuted and not getting any values. Any Suggestions please tell for me.
Thanking u
Regards,
Murali
Problem with fetching data
Moderator: General Moderators
-
B.Murali Krishna
- Forum Commoner
- Posts: 28
- Joined: Fri May 12, 2006 2:05 am
- Location: Hyderabad,India
- Contact:
- visonardo
- Forum Contributor
- Posts: 136
- Joined: Mon Oct 02, 2006 7:49 pm
- Location: Argentina, South America´s Sun.
i dont know what exactly you need but here i show you a way to fetch the row´s ammount of your table.
(with mysql)
it would show you the row´s ammount that has your table. hope it be useful to you 
(with mysql)
Code: Select all
$data=mysql_query('SELECT count(*) as cant FROM table',$link);
$show=mysql_fetch_assoc($data);
echo $show['cant'];- aaronhall
- DevNet Resident
- Posts: 1040
- Joined: Tue Aug 13, 2002 5:10 pm
- Location: Back in Phoenix, missing the microbrews
- Contact:
A good way to troubleshoot database bugs/errors is to add mysql_error() to your queries, like such:
Code: Select all
$data=mysql_query('SELECT count(*) as cant FROM table',$link) or die(mysql_error());