How to extract emails from table?

[edhan]

Hi

How can I write in php to extract emails corresponding to a database table from the usernames?

Example:

Table name as records

Fields are: userid, username, password, emails, description, height, weight

Let says a few usernames like peter, william, charles are selected as array from the table. How do I extract their emails from the same table? The usernames selected are random and are displayed. Now I want to select the corresponding emails with these usernames, how can I accomplish this?

Any help will be appreciated. Thanks!

[edhan]

Is there any easier way to just submit names and retrieve emails result?

Say a person keys in peter, william and then submit

The result will extract the emails based on the names key in as peter, william and displaying the emails.

Is there a way to do this? Or it is not possible?

[Dubbya]

This seems like a pretty basic query.

This page should help you get started:

PHP SQL Select Query and Getting rows

[edhan]

Thanks for pointing me the direction, Dubbya. I am checking it out and test to see if it works for me. Will let you know the result.

Thanks again!

[edhan]

Hi Dubbya

Well, I have been experimenting with the link you have provided but still can't figure out how to do it. Hope someone can point to an example where I can get started.

Thanks anyway Dubbya.

[computergenius]

It's not really as simple as it first looks.

The SQL command that you want is
SELECT emails
FROM records
WHERE username in ("peter", "william" )

You need quotes around the usernames, which you will have to add in via some code.

Exactly how you acheive this, depends on what you are using to accept input from the user.