in reply to DBI Update Query Not Updating
First of all, if nothing is printed at all, you should check your server's error logs (Hope you used -w to catch warnings). Second, use CGI::Carp 'fatalsToBrowser'; to send the errors to the browser so that you can see them. Third: you have a spelling mistake (UPADTE?) and extra quotes in your statement:
Also, as the number of hits increase, how are you squeezing the ips and dates into the table? And do you really want these in the table? Just wondering.UPDATE urls SET hits = ?, unixdate = ?, ip1 = ? WHERE id = ?
Hope this helps,,,
Aziz,,,
|
|---|