Query columns

How do I query a column in a table that is in a database and then print out all the strings that are in that column of the table? I tried, and all it printed out was resource id#4.

Probably you had some misrtake in syntax, trythis:

$conn=mysql_connect("localhost","username", "password");

mysql_select_db("your_db");

$res=mysql_query("Select column1 from my_table") or die(mysql_error());

if (mysql_num_rows($res)>0)
{
while ($result = mysql_fetch_array($res))
{
echo $result['column1 ']."<br>";
}
}