How do i fetch a single field from a row in mysql?

ishwar

Hi evry1,

I want to know to fetch a single field from a row in mysql?

i don't want to use mysql_fetch_array() or something that returns an array.

Any suggestions?

Thanx a lot.

Ishwar

Houdini

SELECT columnname FROM tablename

laserlight

That which Houdini said, plus [man]mysql_result/man.

ishwar

Houdini wrote:
SELECT columnname FROM tablename

Hi,

perhaps i didn't explain it clearly.

i know you can do something like this:


$q = "SELECT samplecolumn FROM sample_table WHERE row=unique_id;";

$result = mysql_query($q);

 $arr = mysql_fetch_array($result); //see i don't want  to use this return as it returns an array. I want it to return only one column

Thanx, Ishwar

laserlight

Have you not read my post?

Blulagoon

You can alter it to this if you like:

$q = "SELECT samplecolumn FROM sample_table WHERE row=unique_id;"; 
$result = mysql_query($q); 
$arr = mysql_fetch_row($result); 

echo $arr['samplecolumn'];

Does this help ?

Blu

ishwar

So whatever column is you get from mysql is always returned in an array? Even if you wanted a single element?

Thats all i wanted to know,

Thanx, Ishwar

ishwar

Oh wait,

i just read laserlight's reply...

Thanx a lot.. that really helped...

Don't know i missed your reply.

Anyway Thanx,

Ishwar