Re: [PHP-DB] mysqli auto rollback on script termination

2006-10-10 Thread Hodicska Gergely
Reason I'm asking is, I've seen some deadlock issues in a script (using FOR UPDATE and LOCK IN SHARE MODE), that looks like they are caused by transactions not being rolled back (releasing locks) correctly. Do you use pconnect? If I right remember there was a bug in some version of mysql that

Re: [PHP-DB] SELECT date query

2006-10-07 Thread Hodicska Gergely
Hi! You can make this easier with date('w'). $correction = array(3, 2, 1, 7, 6, 5, 4); list($year, $month, $day, $dayOfWeek) = explode('|', date('Y|m|d|w')); echo date (Y.m.d, mktime (0,0,0,$month,$day+$correction[$dayOfWeek],$year)); Regards, Felhő Niel Archer wrote: Hi Ron I've