Retrieving Values from MySQL Database

[Anon]

I'm using an incredibly simple database for a voting poll (I'm more familiar with MySQL than with file interfacing) and I'm having some difficulty recalling values. The database is as follows:

id yes no
1 2 2

...with the yes and no values varying and the id (1) just being an index for me to call. Is there anyway to just retrieve the value for the "yes" column (in the only row there is) and output it into a PHP variable? I guess I'm not as talented in MySQL as I thought I was if I can't do this...

I realize that this is incredibly easy and I probably shouldn't be posting on a such an advanced forum, but I wasn't getting any responses elsewhere and figured that you people would know best. Thanks for the help!

[tubedogg]

Something like this...

<?php

$value = ("SELECT yes FROM table");
$yes = mysql_fetch_array($value);
echo 'There are' . $yes['yes'] . 'votes for Yes';

?>

[tubedogg]

I should add, if you ever add more polls you will need to add a WHERE clause to the query so you only select one row, as you will have a problem if you end up selecting more than one row in the code I gave you.