Addressed to: johndmiller <[EMAIL PROTECTED]>
              [EMAIL PROTECTED]

** Reply to note from johndmiller <[EMAIL PROTECTED]> Mon, 23 Apr 2001 20:37:49 
-0500 (CDT)
> I am new a database stuff.  I am using mysql 4.0.1 with php on RH7.0.
> I am setting up a db with three fields with no-one field being unique. Do
> I have to have a unique field?
> The purpose of this db is to store a word, name of a file, and path to the
> file.  My plan is to use a where clause, but I am not sure if it would be
> more efficent to do
> WHERE field1="word" and field2="filename" and field3="path";
> or
> WHERE field1 = "word"
> and then read through the rows using something like a for each and check
> the other two fields.

When in doubt, code it both ways and time them.

In general, the more you can do in the database the better.

Rick Widmer
Internet Marketing Specialists

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to