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

Recommended Answers

All 2 Replies

Member Avatar

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:

Also my new tutorial:

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, learning, and sharing knowledge.