How to catch an Sql Error
Posted: Wed Feb 03, 2010 3:33 am
hello,
i have a website that runs a query on a database when you select a certain to and from date. sometimes if you try and bring back too much information in one go i get this error, Fatal error: Maximum execution time of 30 seconds.
the problem i have is that the form for setting the date appears below the call to the database so when this error occurs the form does not get printed and the user is left with this error and no way to key in a smaller time frame.
has anyone any ideas?
help much appreciated.
i have a website that runs a query on a database when you select a certain to and from date. sometimes if you try and bring back too much information in one go i get this error, Fatal error: Maximum execution time of 30 seconds.
the problem i have is that the form for setting the date appears below the call to the database so when this error occurs the form does not get printed and the user is left with this error and no way to key in a smaller time frame.
has anyone any ideas?
help much appreciated.