Hello guys ,

I need sql query to get the first field values without specifying the name of that field, i also don't want to use fetch_array,fetch_row like mysql concepts over here.
Anybody please provide me ASAP

i need the result within today, atleast say it is possible or not.

Dear Seearam,
Write in detail about your prbolem. So that it will be easy for all to have atlest a sketch.

We WILL...
Best regards
Milind

Hi guys,

I will give the explanation regarding sql query :

assume a table (user) having fields :
user_name,pass_word,ranking.
i need sql query to get the values of the user_name, without specifying user_name in the sql query.
like "select user_name from user"; this one i dont want , i need is there any query to get user_name values without specifying field name.

hi,

is it possible for you to user something like below
$sql="select * from user";
$res=mysql_query($sql)
$row=mysql_fetch_array($res);

and now u can fetch your values
echo $row[0]

hope it help if i got you correctly.
Regards

i dont want php to retrive first feild, i need to specify it in query

SELECT column_name
FROM information_schema.columns
WHERE table_name = 'tablename'

select top(1) from table_name
returns one row