Trying this query
$result= mysql_query("select d.docket_id, m.mag_name, d.pub_date, d.article_name from dockets d, magazines m where d.magazine_id = m.mag_id and where owner_id = '$username'") ;
Anything wrong with the syntax?
what table is owner_id from ???? shouldnt it be d.owner_id ? and what error are u getting ?
reg kevin
Does your SQL statement have two WHERE statements in it? If it does, that will cause an error, along with what Kevin put. If you use table reference names, you should do so throughout the entire query. If owner_id is in both tables, you will get an error because it does not know which one to use.
