[RESOLVED] Retrieve data from more than one table

[dr_overload]

I'm currently run the following script

<?php
mysql_connect("", "", "") or die(mysql_error());
mysql_select_db("") or die(mysql_error());
$data = mysql_query("SELECT * FROM world_cup WHERE username ='$username'")
or die(mysql_error());
while($info = mysql_fetch_array( $data ))
if ( $info['a'].$info['b'] == $info['c'].$info['d'] ) {
echo $info['e'];
}
?>

What do I need to change if 'a' and 'b' were on another table ie world_cup_scores?

Any help is most appreciated

Many thanks

[pppppp]

<?php
mysql_connect("", "", "**") or die(mysql_error());

mysql_select_db("**") or die(mysql_error());

$data = mysql_query("SELECT * FROM world_cup, world_cup_scores WHERE username ='$username'")
or die(mysql_error());

while($info = mysql_fetch_array( $data ))
if ( $info['a'].$info['b'] == $info['c'].$info['d'] ) {
echo $info['e'];
}
?>

only the query will change

[pppppp]

mark the thread resolved if it is resolved