firefly, can i ask you to explain to me why i cannot index twice the same field (on 2 different tables) in database? i tried to add inforum to session and used also INDEX (inforum) but i get a database error.
i saw that you cannot LEFT JOIN session. let me know where i go wrong. if i have a inforum field in session, i could do a LEFT JOIN session and include also the guests that browse the specific forum (in theory?)...
i would like to understand a little more the mystery of LEFT JOINs to other tables. it's clear to me the mechanism of associating 2 tables info.. let me know if i should start a thread related to this in General Hacking Discussion. thanks.
|