View Single Post
  #5 (permalink)  
Old August 28th, 2006, 11:06 PM
pritz pritz is offline
Authorized User
 
Join Date: Mar 2005
Location: , , India.
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to pritz Send a message via Yahoo to pritz
Default

Quote:
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 With Quote