Showing mysql in table

[d-machine]

Hi,

I have 2 tables;
1) name, last name.
2) last name, shirt-color.

I want to print (as html) a table that shows:
name | last name | shirt-color (asuming each name has other last name)

I just don't know how to print a table which combines 2 tables.

Any ideas?

[Jas]

Try something like:

SELECT
    table1.name,
    table1.lastname,
    table2.shirtcolor
FROM 
    table1,
    table2
WHERE 
    table1.lastname = table2.lastname;

Take a look at this, as well. You may find it helpful. It starts with basic queries, which I am sure you already know, and goes up to more complex ones.

[lord22]

Hi Jas and d-machine I've tried to do it too (for practice),

That's what I've tried to do:

$result = mysql_query("SELECT mytable1.name, mytable1.lastname, mytable2.shirtcolor FROM mytable1, mytable2
WHERE mytable1.lastname = mytable2.lastname;");

echo "<table border='1'>";
echo "<tr>  <th>name</th> <th>lastname</th> <th>shirtcolor</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo "<tr><td>"; 
    echo $row['mytable1.name'];
    echo "</td><td>"; 
    echo $row['mytable1.lastname'];
    echo "</td><td>"; 
    echo $row['mytable2.shirtcolor'];
    echo "</td></tr>"; 
} 

echo "</table>"; 

for some reason it printed me an empty table (with the correct size of rows and columns).

[d-machine]

Thank you lord22 and Jas,
I've tried your both Ideas and actually got stuck exactly in the same problem as lord22..

[allahverdi]

Change this:

$result = mysql_query("SELECT mytable1.name, mytable1.lastname, mytable2.shirtcolor FROM mytable1, mytable2
WHERE mytable1.lastname = mytable2.lastname;");

To this:

$result = mysql_query("SELECT mytable1.name, mytable1.lastname, mytable2.shirtcolor FROM mytable1, mytable2
WHERE mytable1.lastname = mytable2.lastname;") or die(mysql_error());

And look at the error.

[Nightfire]

Also try removing the semi-colon at the end of the query

mytable2.lastname;");

[d-machine]

Thank you, I've fixed my errors, and now it works fine!