Thread: Listing data from 2 tables of one MySQL Database

Hello,

I would like to write a PHP code to listing my users on a page and then able to export into CSV format.

The data are stored in two separate tables in one database.

The first table named 'users' contains only the email addresses.
The second one named 'data' contains the first name, last name and other data if any.

I would like to print on screen the above data like this:
Email First Name Last Name

And then I would like to export this table into CSV file.

Are there anybody can help me to start?

Thanks

you need to put a key in every table to associate an email to name. Example
Table ONE
id
1
email
some[at]email

Table TWO
id
1
First Name
Will
Last Name
Smith

in this case id is the key.

Fine, I did it.
But how can I list them in one php file?
I connected to db, create the query but I would like to display data on the screen.
I am stduying UNION at this time but I am not sure I am on the right way.

you have created the queries, now you have the values in some variables.
example
$resulquery1
$resulquery2
to display them just use "echo"
example
echo "My name is ".$resulquery2." and my email is ".$resulquery2;

Yes you're but because these are in separate tables I cannot render the data for the email.

For example:
I have the users tabel
ID email
1 [email protected]
2 [email protected]
etc.
The second table has:
UID first_name last_name
1 Joe Smith
2 Peter Peterson
etc.

Now I need two query to get the data but I would like to display the right name for the email addresses.
email1@domain com Joe Smith
[email protected] Peter Peterson
etc.

What is the query and the while that I need?

the query is
SELECT 'table1'.'email', 'table2'.'first_name', 'table2'.'last_name' FROM 'table1', 'table2' WHERE 'table1'.'id'=1 AND 'table1'.'id'='table2'.'uid'
in this case I used the id=1 so the results is email1[at]domain com Joe Smith