I am having a problem with a very simple mysql query, basically all i get as an output is resource id #2. I have spent ages on this trying to figure it out, and i would certainly appreciate any help you guys could give me.
When you mysql_query, you create a thing called a result resource.
To extract information from it, you need to use one of the mysql_fetch_array(), mysql_fetch_assoc(), or mysql_fetch_row(), functions. These return arrays with an element for each column specified in the query.