questions related to MySQL

Hello, first question : If I retrieved an entire tuple in a variable like select *.... is there a way to display the fields I want using only the query select * (a kind of read_next _field or something )or I really have to store every field I need fetching the information using a specific query select th_field from ... second question : can I just display the result of a query. exemple I'm just trying to display a specific field $var=mysql_query("select field from...) wich is a char type, then just echo $var and all it displays is " Resource id #2 "!!! -- Isabelle Roussy Bell Canada IS/IT - Billing Requirements 700 de La Gauchetiere W B8W2 Montreal Qc H3B 4L1 Mailto:isabelle.roussy@bell.ca Office (514) 391-7939 Fax (514) 393-8162