I have 2 tables one for user and 1 for his ADs. He has his SKILLS in the user table. But he also has skills for the ADs. and the column names for the skills are same in both the table. like READING , WRITING, KICKING, SWIMMING available in both the tables. (its a requirement) and unfortunately there column names are same in both the tables.
Now i have a SQL like...
$qyery = "select * from user u, ads a where a.userno=1 and a.id=1221 and aduserno = u.userno";
$resarray = @mysql_fetch_array($res);
now if i want to echo the value of u.reading and a.reading how can i access them using
$ad_reading = $resarray['a.reading'];
$user_reading = $resarray['u.reading'];
it gives error for using a. or u. in $resarray.....