Search String with radio button

Worker Joined: Sep 09, 2003 Posts: 165

I am trying to set up a search box that allows me to search records according to criteria.
I want to set the criteria with a radio button that will allow me to search that row only then when the criteria is met is shows all the data associated with that record.

I dont know if this could be done but have searched the web and found a couple of things but nothing that works.

Thanks
Rick

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Well, you would set the value of the radio button to what your 'WHERE' clause would be. Let's say the radio buttons are named 'criteria'. Then the value of button 1 might be 'scores > '10' . Then, as you are assembling your SQL clause, you might have this:

$sql = "Select * FROM some_table where $criteria";

Make sense?

Posted: Thu Nov 18, 2004 3:36 pm

Perfect Sense lets see if I can put it together tonight and will let you know

Thanks Raven

Thanks
Rick