[PHP-DB] Help needed on point system

2002-02-01 Thread Jerry Leonard
Hi all, I am relatively new to php and mysql and would appreciate any help you can provide. Here is the task: I need to have a point system added to my site. What I would like is when a user logs in they will get 1000 points. But they only get it once per day. I am running: Xitami on WinME,

[PHP-DB] How do I know when to

2002-01-11 Thread Jerry Leonard
Hi, I am really new to MySQL and am wondering this: I understand how to make a database and tables but what I don't understand is when to make a row an int with auto_increment or just a plain int. Or why would you use varchar(50) instead of char(50). Could someone please explain what is

[PHP-DB] How do I know when to

2002-01-11 Thread Jerry Leonard
Okay this is the way I understand the statement below. The uid will be a number from 1 to 10, max length of ten digits say starting at 1 then as the next user registers it will automatically make that user number 2. Am I correct? CREATE TABLE users ( uid int(10) unsigned NOT NULL