[thelist] SQL Query Review

[r937]

>> also, an index on entryID would be wise
>
> But entryID is a PK. Would I still want to do that?

no, do not declare indexes for PKs, just for FKs, as well as for any 
non-PK/FK columns used in a WHERE condition


> I have always used array positions. So in the example SQL,
> I would access it in PHP this way:
>
>   $entryTitle=$rs->fields[1];

i don't do php, but i think you're leaving yourself open for disaster if you 
ever change the sequence of the columns in the SELECT clause


>>      FROM entries AS e
>
> ....but that threw me for a loop. What will that do for me?

it will give the alias "e" to the entries table