XP is just a number | |
PerlMonks |
Re: Message storing problem.by nate (Monk) |
on Jan 21, 2001 at 00:00 UTC ( [id://53243]=note: print w/replies, xml ) | Need Help?? |
In case you care, here's the table structure that the Everything Chatterbox
system uses:
This basically breaks down to: For chat, your sql query looks something like:
then for viewing a user's specific messages:
It's really a pretty simple system, but it does depend on having numeric IDs that you can look up your users with. And don't worry too much about running out of INT -- 32-bits gives you lots of room to talk. -nate
In Section
Seekers of Perl Wisdom
|
|