[RESOLVED] just to select 1 bit of data from one row

I've always used

while($row = mysql_fetch_array($res)){ etc

to get the data from a mysql resource but i was wondering if there's a simpler way if i just want the name of a product with a specific id

something like this :

$res = mysql_query("SELECT prod_name FROM products WHERE prod_id='1'");
echo $res;

this obviously doesn't work - but is there a way of doing that ?

thanks

VisionsOfCody wrote:
this obviously doesn't work - but is there a way of doing that ?

No is not working because $res is the mysql resourse result, so u need to fetch the result.
This will work if the u got only one result

$row = mysql_fetch_array($res);

U are using while to parse all the results from your resourse result, but u dont need it if your query returns only one result ..

ok - that works - and it removes the while() which is good
thanks

Np, but u should mark this thread as RESOLVED.