Pulling a single line of data from a MySQL DB

[bassplaya4string]

This may sound uber n00b, BUT here it goes....

 

I get how to set a loop to pull ALL of the data in a table, but how would I pull just one field of data? All of the tuts I am seeing online only show how to loop through everything. Any help would be greatly appreciated! Thanks in advance!

[corbin]

http://dev.mysql.com/doc/refman/5.0/en/select.html

 

 

 

 

If by 1 field you mean one column:

 

SELECT column1 FROM table;

 

 

If you mean one row:

 

SELECT * FROM table LIMIT 1;