Re: MySQL query problem in conjunction with PHP

2004-05-08 Thread Michael Stassen
Thomas Nyman wrote: Hi I found an instruction on the net concerning "Date Arithmetic" and which seems to be exactly what I need to hel me get going..however there seems to be either a mistake on my behalf or on the writers behalf. Can anyone say whats wrong with this query $query2="UPDATE KK_

Re: MySQL query problem in conjunction with PHP

2004-05-08 Thread Ludwig Pummer
Thomas Nyman wrote: I found an instruction on the net concerning "Date Arithmetic" and which seems to be exactly what I need to hel me get going..however there seems to be either a mistake on my behalf or on the writers behalf. Can anyone say whats wrong with this query $query2="UPDATE KK_Fatal

RE: MySQL Query Problem

2002-05-04 Thread Roger Baklund
* Kory Wheatley [...] > I'm seeing some discrepancy in the operation of the SEC_TO_TIME > function, however. Let's say my Duration is a value of 9.25. When I > multiply 9.25 by 3600, I get 33300.00. When I use > SEC_TO_TIME(33300.00), it returns 09:15:00, the correct value. But when > > I try

Re: MySQL query problem...

2001-03-29 Thread Simon Windsor
Hi What happens if you use search_users.Age between 30 and 40 search_users.Age between 35 and 35 search_users.Age = 35 I would be interested in know these results before speculating and answer. Simon On Thursday 29 March 2001 03:05, you wrote: > I am having problems with a MySQL query. I