from sql query

[merican]

hi all,
I need to know how to select data from 2 different table in sql. below is the code i use to select data from 1 table:-

$ffdb->DivideData("SELECT FROM ffdb_files ORDER BY file_name",$page,$CONFIG['files_per_page']);
$ffdb->MakePages("<a href=\"admin.php?page={eachpage}&action=edit_file\">{eachpage}</a>&nbsp;","<b>({page})</b>&nbsp;","<a href=\"admin.php?page=1&action=edit_file\">« First Page</a>&nbsp;","<a href=\"admin.php?page={eachpage}&action=edit_file\">Last Page »</a>",$page,$ffdb->num_pages);
$tpl->LoadTemplate("file_list","Admin/templates/$admin_skin/file_list.tpl");
$mysql->Query("SELECT FROM ffdb_files ORDER BY file_name LIMIT $ffdb->data_bottom,$ffdb->data_top");
while ($show_file=mysql_fetch_array($mysql->result_id)) {
$has_files=1;
$file_list_array = array(
'file_filename'=> $show_file[file_filename],
'category'=> $show_file[category],
'file_description'=> $show_file[file_description],
'author'=> $show_file[username],
'author_email'=> $show_file[author_email],
'version'=> $show_file[version],
'file_id'=>$show_file[file_id]
);

let say i want to selet username from the filedb_users table. can anyone help me? thank you in advance.

Regards,
Alfy Merican

[eves]

Try this:
SELECT ffdb_files.*, filedb_users.username FROM ffdb_files, filedb_users WHERE ffdb_files.user_id = filedb_users.user_id

where
ffdb_files.user_id is a foreign key pointing to filedb_users.user_id
you should change this to a field that links the two tables.
And also, append your addional conditions in the where clause.

Hope that helps.