I use this this query to find something;
result=mysql_query("SELECT m.subject, m.content, m.createdate, m.sentdate, m.listid, m.mailtype, m.id, l.id, l.listname FROM letters AS m, list AS l WHERE $field LIKE '%". $keywords ."%' AND m.listid = l.id ORDER BY $order", $db);
This one works fine, but what if I have 1 field in each table with the same name..How can I reach $row['id'] from the first table (m) when using mysql_fetch_array.
I thought I could use $row['m.id'] but then it didn't find anything. Do I have to rename the fields or is there a working solution.
Thanks / Henrik
result=mysql_query("SELECT m.subject, m.content, m.createdate, m.sentdate, m.listid, m.mailtype, m.id, l.id, l.listname FROM letters AS m, list AS l WHERE $field LIKE '%". $keywords ."%' AND m.listid = l.id ORDER BY $order", $db);
This one works fine, but what if I have 1 field in each table with the same name..How can I reach $row['id'] from the first table (m) when using mysql_fetch_array.
I thought I could use $row['m.id'] but then it didn't find anything. Do I have to rename the fields or is there a working solution.
Thanks / Henrik