Retrieving a datum from mySql

[admin]

Hi,

I've got a mySql database on the server, and need to structure some PHP to retrieve a single datum from the database.

So if I want to say something like/;
"select firstname from table1 where lastname = 'clinton'",
how would i get the answer 'bill' into a php variable?

thanks, James.