Re: Need help creating query statement

2007-11-07 Thread Néstor
Guys, just wanted to thank you again for helping me with the sql statement that I needed. I was able to sorted using php and I was able to display the correct result. Thanks again!!1 Nestor :-) On Nov 6, 2007 7:37 AM, Néstor <[EMAIL PROTECTED]> wrote: > You guys are correct, that is exactly wh

Re: Need help creating query statement

2007-11-06 Thread Néstor
You guys are correct, that is exactly what happened. I must thing of this in the future. At this moment I have a lot of other projects to take care, that it is eaiser for me to read the information into an associative array with the columns and the values and sort the array and then print the top

Re: Need help creating query statement

2007-11-06 Thread Enrique Sanchez Vela
--- [EMAIL PROTECTED] wrote: > Néstor wrote: > > I think you'd best begin by normalising your > database. Something along > these lines: > very true indeed, that would save you major headaches when right after finishing the demo, someone would say, "can we add a 18 gallon pledge? what about

Re: Need help creating query statement

2007-11-05 Thread mysql
Néstor wrote: I can do simple select statements but I need your brains to create query statment. I am using mysql 4.0 in my 1and1 site. I have a table that has 8 fields, one is the "agency" field and the other 7 are *tip* values on saving water and the value of this field is either 0 or an amoun

Re: Need help creating query statement

2007-11-05 Thread Néstor
Enrique that is pretty good and close to what I need. On top of what you have generously provide, I guess I can just put each gallon field into an array an then sort the array to display the first 5 gallon fields per agency. Is there an easier way? Thanks, Nestor :-) On 11/5/07, Enrique Sanche

Fwd: Re: Need help creating query statement

2007-11-05 Thread Enrique Sanchez Vela
--- Enrique Sanchez Vela <[EMAIL PROTECTED]> wrote: > Date: Mon, 5 Nov 2007 15:01:59 -0800 (PST) > From: Enrique Sanchez Vela <[EMAIL PROTECTED]> > Subject: Re: Need help creating query statement > To: Néstor <[EMAIL PROTECTED]> > > > --- Néstor <

Need help creating query statement

2007-11-05 Thread Néstor
I can do simple select statements but I need your brains to create query statment. I am using mysql 4.0 in my 1and1 site. I have a table that has 8 fields, one is the "agency" field and the other 7 are *tip* values on saving water and the value of this field is either 0 or an amount. -