Mark Hensler — Tue, 17 Apr 2001 04:06:18 +0000

BTW, welcome to TWF!

Mark Hensler — Sun, 15 Apr 2001 04:29:52 +0000

userID being the Primary key
I would recommend agains this. I always use ID as the primary key, and I never make a table withouth ID.

To check to see if something exists, and create if not, you will need two queries.

$query = "SELECT * FROM table_name WHERE field_name=value";
$result = mysql_query($query);
if (!$result) {
  $query = "INSERT INTO table_name (field_names) VALUES(values)";
  mysql_query($query)
}

No, IP would not make a good UNIQUE field. I am behind a router... the internet only see's 1 IP, but there are actually 3 PCs on the network, all online. Again, I would advise using ID as a UNIQUE field.