mysql where statement in select

[Maureen E Fischer]

Hello,
Is there a way of varying the key fields in a where statement?  I don't
mean putting
a variable in as the VALUE of the key.  I know you can using a ?.
What I want to do
is allow the user to see all of a particular set of records (primary key
being client) if the date is equal to the current date and allowing her
to select a subset of the client records if she enters a date other then
the current date (date being an idex).  I know I can do this in two
separate select statements -- but I just wondered if there was a better
way?
Thanks,
Maureen



-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: mysql where statement in select

[fliptop]

Maureen E Fischer wrote:

 Hello,
 Is there a way of varying the key fields in a where statement?  I don't


i would suggest posting your questions on a more appropriate mailing list.

http://www.perl.com/pub/a/language/info/mailing-lists.html


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]