sql query

[ManikandanM]

Please guide me. Im begginer in Sql. Im working through task tracking system in php. I need know how to display particular username details using query? Since Im getting all userdetails by single username and password..

You use a WHERE clause. If you don't show your code, how on earth do you expect any help? Read the sticky about how to ask a suitable question: https://www.daniweb.com/web-development/php/threads/435023/read-this-before-posting-a-question.

Also my new tutorial:

https://www.daniweb.com/web-development/php/threads/499320/common-issues-with-mysql-and-php

That may be a temporary location - it should be moved to PHP > tutorials in the near future. It discusses how to authenticate using PHP / MySQL (section 11).

[rotten7]

I will give you an example to get you started thinking.

Select username, age, mobile_number from UsersTable
Where username = 'rotten7';

I hope this helps