Re: Select ALL rows with WHERE statement

2005-09-18 Thread Peter Brawley
;Pooly" <[EMAIL PROTECTED]> To: Sent: Saturday, September 17, 2005 3:53 PM Subject: Re: Select ALL rows with WHERE statement 2005/9/17, Alvaro Cobo <[EMAIL PROTECTED]>: Hi all: I've searched into the MySQL manual but I can't find the solution to this

Re: Select ALL rows with WHERE statement

2005-09-18 Thread Pooly
2005/9/18, Jasper Bryant-Greene <[EMAIL PROTECTED]>: > Alvaro Cobo wrote: > > Thanks Pooly and Peter: > > > > The problem is that in the same php page I would like to choose either the > > calculation from an especific year or the calculation from the whole table > > using URL. > > The same page c

Re: Select ALL rows with WHERE statement

2005-09-17 Thread Jasper Bryant-Greene
Alvaro Cobo wrote: Thanks Pooly and Peter: The problem is that in the same php page I would like to choose either the calculation from an especific year or the calculation from the whole table using URL. The same page can easily handle both. If year is passed as a GET variable then it will

Re: Select ALL rows with WHERE statement

2005-09-17 Thread Alvaro Cobo
great help from you. Very best regards, Alvaro. PD: Sorry, but my English is not very good this time. - Original Message - From: "Pooly" <[EMAIL PROTECTED]> To: Sent: Saturday, September 17, 2005 3:53 PM Subject: Re: Select ALL rows with WHERE statement 2005/9

Re: Select ALL rows with WHERE statement

2005-09-17 Thread Peter Brawley
Alvaro, >I have a select query where I need to filter the data using the WHERE >statement. But also need to have an option to show all the data in the >table. You cannot send the query engine an "option". When the program determines that all rows are to be retrieved, you could set the WHER

Re: Select ALL rows with WHERE statement

2005-09-17 Thread Pooly
2005/9/17, Alvaro Cobo <[EMAIL PROTECTED]>: > Hi all: > > I've searched into the MySQL manual but I can't find the solution to this > very silly question. > > I have a select query where I need to filter the data using the WHERE > statement. But also need to have an option to show all the data

Select ALL rows with WHERE statement

2005-09-17 Thread Alvaro Cobo
Hi all: I've searched into the MySQL manual but I can't find the solution to this very silly question. I have a select query where I need to filter the data using the WHERE statement. But also need to have an option to show all the data in the table. For example (something like...): SELEC