can anyone help got a few question

1. what the purpose of index in sql also why would i put a index on a password coloume.

2.is there a way in sql to send email to all my users email address.

3.is there a way to find out how many times that user has loged on to my website.

i think that it for now but if anyone could help

Originally Posted by W3Schools.com

Indices are created in an existing table to locate rows more quickly and efficiently. It is possible to create an index on one or more columns of a table, and each index is given a name. The users cannot see the indexes, they are just used to speed up queries.

http://tincan.co.uk/phplist
http://www.google.co.uk/search?hl=en...e+Search&meta=

You could create yourself a field in your SQL table that gets update and increased by one every time the user logins in.

as for the mail part, sql is for storing and retrieving data only, it is not a programming language. It is a data querying language. so the answer is no

is there a way to send email to all my users without having to type there email address or would i need to make a php script that say somthink like get email from sql database then send email to them

yes you need to write a php script that gets the email addresses from the database and sends them

The first link I supplied was for a PHP/MySQL mailing list ....

So, here it is again ....

http://tincan.co.uk/phplist

LOL THANKS ENIGMATIC

lol sory

another question i some how have put 2 index on some my coloums how i get rid one

ALTER tablename DROP INDEX indexname

i write ALTER users DROP INDEX first_name; and it said do you really want to i said yes then i got a error

hmm... right ok try
DROP INDEX index_name ON tbl_name;

DROP INDEX table_name.index_name

sorted is there like alink where it tell you all the sql code and explins it all as i cab never remember it

http://www.mysqlfreaks.com/forums
http://www.mysql.com

what was it?

what was what