Re: novice on SQL

2006-05-10 Thread tony yau
etc ps: a collegue said to me that DBs are not design to do what I wanted to do (in 1 sql query anyway). I'm beginning to accept that comment :( Thanks John Tony > > "John Hicks" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > tony yau

Re: novice on SQL

2006-05-09 Thread tony yau
said to me that DBs are not design to do what I wanted to do (in 1 sql query anyway). I'm beginning to accept that comment :( Thanks John Tony "John Hicks" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > tony yau wrote: > > Hi John, > > > >

Re: novice on SQL

2006-05-08 Thread tony yau
.3 1 12.212.2 2 31.031.0 3 1.021.02 3 4.94.9 thanks for your help anyway Tony "tony yau" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi John, > > I didn't know

Re: novice on SQL

2006-05-07 Thread tony yau
Hi John, I didn't know you can do that! (such a novice indeed!) Thank you for your reply, I will put it to the test first thing when i get back to the office tomo. Cheers "John Hicks" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > tony yau wrote: > &

novice on SQL

2006-05-07 Thread tony yau
Hello, I can get a select result like the following: (SELECT ID,Changes FROM mytable WHERE somecondition;) IDChanges - 1 10.0 1 10.3 1 12.2 2 31.0 3 1.02 3 4.9 how can I get the above result sets into the following for

Re: MySQL give up on a query after a certain length of time

2005-05-20 Thread Tony Yau
Hi Guys, you can always set a max time out for your php script (php.ini) Tony - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: Sent: Friday, May 20, 2005 12:45 PM Subject: Re: MySQL give up on a query after a certain length of time > Hello. > > I don't remember