mysql_fetch_array not returning all fields

[RHolm]

Hello,

I have a very simple problem, but i have no idea what to do with it..

here's the code

$sql_ad_select = "SELECT * FROM $ad_type WHERE ad_id='$ad_id'";
				  $result_ad_select = mysql_query($sql_select_ad,$connection) or die ("Couldn't retrieve data. " . mysql_error());
				  $line_ad_select = mysql_fetch_array($result_ad_select);
				  print $line_ad_select['id'];

Ok.. that one works.. but when i change

print $line_ad_select['id'];

to any other field (including 'ad_id', which is what it uses in the WHERE clause) then it says:

Notice: Undefined index: ad_id in d:\nuvocreative\clients\wheelquip\listings.php on line 177

[RHolm]

ok.. i worked out what the problem was..

I didn't change $sql_select_ad to $sql_ad_select in the mysql_query() so it was getting the result from my previous sql query.