I recently dived into PHP coding so my question may seem a bit 'simple',
so be gentle with the n00b here plz.
Anyway, my project is up and running and works like a jiffy, the only thing that
remains is to sort the query results from the mysql_query.
My query looks as follows:
$data = mysql_query("SELECT * FROM $dbtable JOIN genera_table ON $dbtable.genus = genera_table.genera_id") or die(mysql_error());
Which works fine, but if I want to sort my results by adding 'ORDER BY genus ASC' I get an error saying:
"Column 'genus' in order clause is ambiguous".
Anyone willing to help me out ?
Thanks in Advance,
Sven