Hi,

Although this query is in reference to BEGINNING PHP 5 (2004 edition) Chapter 9 An Introduction to Databases and SQL it more of conceptual query.

Your explanation of KEY/INDEX is that they are synonymous keywords that specify field to be used as indexes. If an DB admin specified multiple fields as indexed, then index sorts first on "field1" and then any duplicate values in "field1" are sorted on "field2" and so on.

Can u pls explain the above with an example...

regrds,
rseni.

I think no one should even look at the question, if they cannot provide an answer......Probably the lazziest of forums i have come across.