Retrieving info from database into form

[Anon]

Hi folks,

like many others i'm also a newbie to PHP. I've got a question which I hope someone can answer or refer to a tutorial of some kind.

1) I've made an SMS Service. Every member gets a login (made this in ASP (.mdb)) Now I want my members to be able to insert phonenumbers in their phonebook. So each time they login they can use this phonebook. How do i do that?

2) i want my users be able to fill out the SMS-form (HTML) and send it to one of the numbers in their own phonebook (choosing the phonenumber with a dropdownmenu from their phonebook.)

My server doesn't work with MySQL...

Maybe it is too much to ask of you, but maybe someone out there will reach a helping hand...

Thanx, ZjieB

[badman]

hello

for 1)

make a table of 2 cols (in whichever database software you are using) and insert login names and phone numbers in pairs.

when retrieving them, fire a query (i dont know how in Access!!) like "select * from phone_table where login="login_name"

this will retrurn all phone numbers for a particular login

2)make another table with phone number as primary key and have columns as per the data you want to store,

now you can link both tables on basis of phone numbers(assuming that 2 people do not have same numbers). you can now know to which a phone number belongs. and once you have the number you can get all details

sample tables
phone_table

login phone
q 12345
q 667778
a 66666

phone_details

phone name city b'day (and so on)
12345 asdf llll 23-4-76

do you get it?
cheers!