[Resolved] mySQL query getting info from two tables

[arsenalfan14]

What's the proper coding for this?

$query = "SELECT * FROM ratings,players ORDER BY ratings.match_id DESC LIMIT 0, 1"; 

Once I get that how do I display info from the different tables?

<tr> 
<td><? echo $row->players.player_lname; ?> <? echo $row->players.player_fname; ?></td>
<td><? echo $row->ratings.total_rating; ?></td>
</tr>

You can do math in the query right?

$query = "SELECT total_votes, total_rating, (total_rating / total_votes) AS rating_avg FROM ratings ORDER BY rating_avg DESC LIMIT 0, 1"; 

[bastien]

1. Try using alias' for the field names and limiting the select to just the fields you need

   $query = "SELECT p.first_name AS fname,
                                p.last_name AS lname,
                                r.total_rating AS rating     
   
                    FROM 
                                ratings r,
                                players p
                    ORDER BY 
                               ratings.match_id DESC LIMIT 0, 1";
   

   Then access by

<tr> 
<td><? echo $row->lname; ?> <? echo $row->fname; ?></td> 
<td><? echo $row->rating; ?></td> 
</tr> 

2. yes, math is possible, might wanna check the docs on proper syntax

[arsenalfan14]

thank you very much!