Problem with identifying COLUMN NAME

[zeeshanhashmi]

Hi

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...

global $dbconn;

$qyery = "select * from user u, ads a where a.userno=1 and a.id=1221 and aduserno = u.userno";

$res= @mysql_query($query,$dbconn);

$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.....

pzl help

[Jelena]

$qyery = "SELECT *, u.reading as ureading, a.reading as areading FROM user AS u, ads AS a WHERE a.userno=1 AND a.id=1221 AND aduserno = u.userno";

$res= @mysql_query($query,$dbconn);

$resarray = @mysql_fetch_array($res);

$ad_reading = $resarray['areading'];
$user_reading = $resarray['areading']; 

How about this?

[zeeshanhashmi]

It seems good, and i m gonna use this. I want one more thing here. I want to get all fields from ADS and few Fields from USER. How to do that ????

like is it possible

select user.*, ads.reading, ads.writing, ads.speaking ads.etc from user, ads

is it ok ?

[Jelena]

Yes, it is ok, but be careful if some of the column names from two tables are the same. It so, make sure to use AS.

[zeeshanhashmi]

Hi i got the solution i can do that. like

select ads.*,user.email from ads,user where ads.userno = user.userno