DISTINCT AND NON DISTINCT #2

2001-06-26 Thread anna soobrattee
Hi All, I've been reading up on how to do joins on the mysql site. Is there not an inverse function for DISTINCT, so that I can pull out duplicate data as opposed to DISTINCT data...or will I have to get this information by using joins? Thanks very much for your help. Anna

DISTINCT AND NON DISTINCT

2001-06-25 Thread anna soobrattee
Hi All, I've been reading up on how to do joins on the mysql site. Is there not an inverse function for DISTINCT, so that I can pull out duplicate data as opposed to DISTINCT data...or will I have to get this information by using joins? Thanks very much for your help. Anna

table locking and priorities

2001-06-13 Thread anna soobrattee
Hi All, Can anyone help me... My registration form looks up the last username in the members table (select distinct username from members order by uid desc limit 1), and increments this username (e.g. from abc2 abc3) which will be used as the username for the next user to sign up...

Re: where do i get an authcode from ? - PLEASE GET ME UNSUBSCRIBED OFF THIS LIST....

2001-03-26 Thread anna soobrattee
nothing at all i'm afraid.. i think this requires a little shouting ... PLEASE GET ME UNSUBSCRIBED OFF THIS LIST thanks anna - Original Message - From: "Brian McDonough" [EMAIL PROTECTED] To: "anna soobrattee" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wedne

http://lists.mysql.com/php/unsubscribe.php

2001-03-26 Thread anna soobrattee
I can't unsubscribe either - I do not receive an auth code from this page http://lists.mysql.com/php/unsubscribe.php after I've entered my email address, so I cannot unsubscribe myself. If someone can fix this page, then perhaps, people will stop sending "unsubscribe me" emails to this

how do i store complex data in the most efficient way?

2001-01-29 Thread anna soobrattee
hi, i have a query that i hope someone can help me with. i have a monitoring system that tracks the number of times that person clicks on a particular adbanner on our site or in one of our newsletters. i member can choose have a maximum of 16 interests selected. so for example, i can say

large tables?

2001-01-25 Thread anna soobrattee
hi, i've been asked to design a for a new web-based system which stores lots of data on it's members. There are currently about 500,000 member records. the problem is that i have to store at least 248 pieces of information on each user. i've made the system as relational as possible so that