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..

Member Avatar for diafol

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).

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.