php mysql select column

[wannabe_god]

I use php with mysql.I'm new to mysql, but everything works fine (mostly)Now i searched a way to show all users in the database, and as the function mysql_fetch_column doesnt exists, I thought of making an extra table with all users. However, i think i will encounter a problem like this often, so...... could someone help?

[justsomeguy]

I'm not sure what the problem is. If you want to get one column from all rows, you can do something like this:SELECT column FROM tableBut I don't think that's your question. Clarify what you are wanting to do.

[reportingsjr]

Yes, I think that is what he wants. "SELECT `username` FROM `user_info`" then do anything like regular!

[jhecht]

Or you could use mysql_result... but i would advise staying away from that.the syntax however, would be something like :

$sql = "SELECT * FROM table";$ans= mysql_query($sql) or die(mysql_error());$res= mysql_result($ans,0,'column') or die(mysql_error());