|
Subject:
|
sql query i need
|
|
Posted By:
|
seearam
|
Post Date:
|
7/28/2006 12:23:39 AM
|
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
|
|
Reply By:
|
seearam
|
Reply Date:
|
7/28/2006 12:25:36 AM
|
i need the result within today, atleast say it is possible or not.
|
|
Reply By:
|
milind.paralkar
|
Reply Date:
|
7/29/2006 2:27:58 AM
|
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
|
|
Reply By:
|
seearam
|
Reply Date:
|
7/29/2006 8:57:08 AM
|
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.
|
|
Reply By:
|
pritz
|
Reply Date:
|
8/28/2006 11:06:31 PM
|
quote:
Originally posted by seearam
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
|
|
Reply By:
|
seearam
|
Reply Date:
|
7/6/2007 5:37:06 AM
|
i dont want php to retrive first feild, i need to specify it in query
|
|
Reply By:
|
seearam
|
Reply Date:
|
11/20/2008 2:11:02 AM
|
SELECT column_name
FROM information_schema.columns
WHERE table_name = 'tablename'
|
|
Reply By:
|
ms_kout
|
Reply Date:
|
11/30/2008 2:14:29 AM
|
select top(1) from table_name
returns one row
|
