Hello Noah,
On 23-Jun-01 14:29:58, you wrote:
>Yeah the keys would be part of the first condition of the where clause...
>this table is like this:
>username | siteid | bannerid | clicks | someotherstat
>an update would be like: update tbl set clicks=clicks+1 where
>username='something' and siteid='something' and bannerid='something'
>a select would be: select clicks from tbl where username='something' and
>siteid='something' and bannerid='something'
>so knowing this, does it make sense to make primary keys out of
>username,siteid,bannerid?
Yes, you should make a single primary key with all the three fields:
username, siteid and bannerid.
Regards,
Manuel Lemos
Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED]
--
E-mail: [EMAIL PROTECTED]
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
