how to get ONE value from a mysql db

[Anon]

hello, i'm trying to make a profiles page for a band so i made a database and a table with a row of the names

example:
+--------+----------+
| id | name |
+--------+----------+
| 0 | jairo |
+--------+----------+
| 1 | josh |
+--------+----------+
| 2 | ed |
+--------+----------+

...and i can't figure out how to get for example only josh's name printed on the page. the only thing i'm capable of doing because of my lack of knowledge of commands is (example of my code):

$d = SELECT * FROM table LIMIT 2;
while($c = mysql_fetch_object($d))
{
print $c->name
}

and that prints the whole 'name' row..

please help =P

[Anon]

hello,

try this

to get only Josh's name

$d = SELECT * FROM table where id=1;
while($c = mysql_fetch_array($d))
{
print $c[name];
}

[Anon]

thanks alot!!!! ::sigh:: couldn't figure it out after hours =(, but thanks to you it works now, now i only need to finish the page. thanks once again =) really appreciate it =P