Archive for March 24th, 2005

the mystery of querying

March 24th, 2005

Filed under: at 10:28pm

if i know (or remember) more from my database class, i may have an answer for this. i was just coding my new board and was curious about which of the following query is faster:

SELECT m.regdate, m2.postnum FROM dmb_members m, dmb_members_post m2 WHERE m.uid=m2.uid AND m.uid = '".$userid."' LIMIT 1

or

SELECT m.regdate, m2.postnum FROM dmb_members m, dmb_members_post m2 WHERE m2.uid = '".$userid."' AND m.uid = '".$userid."' LIMIT 1

m.uid is a primary index while m2.uid is an index. what would be your guess?
(more…)

6 comments

pretty form with css

March 24th, 2005

Filed under: at 06:39pm

this is pretty cool :) tho it does take a bit more time to config your forms. maybe i will do it sometimes just for the hack of its cool trick.

awww just learned another trick.. all these nifty mozilla only css tricks :)

3 comments