[PHP-DB] How to eliminate bad fields from a mysql query?

2001-03-30 Thread Bob Stone
Dear PHP Helpers, Can you direct me to a solution for this problem: How can I eliminate bad (blank or incorrect) fields from a mysql query? In other words, if someone leaves a form field blank or enters a value that does not have a matching entry in the database, how can I eliminate that

RE: [PHP-DB] How to eliminate bad fields from a mysql query?

2001-03-30 Thread Oson, Chris M.
-Original Message- From: Bob Stone [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 2:56 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] How to eliminate bad fields from a mysql query? Dear PHP Helpers, Can you direct me to a solution for this problem: How can I eliminate bad

Re: [PHP-DB] How to eliminate bad fields from a mysql query?

2001-03-30 Thread Phil Jackson
If there are some fields that you absolutley require, or must be in a valid format, I'd use javascript to edit the form first - no reason to make a round trip to the server for something you can do server-side. **Or** - say the form is for selecting an automobile - make is required but color