can anyone answer this????

[Rai_87]

if i have an sql table with some column such as userid, username, applicationid, companylogo etc..... the question is when any user login and change the info of the specify company. how should i write the select command.....

[_Aerospace_Eng_]

Well each user should have their own unique userid. I'm not sure what you would need the SELECT query for. Either way you would need to use the WHERE clause.
SELECT * FROM tablename WHERE userid = $id
Where $id can be a get variable in the url. Be sure the check and see if they are logged in and that the id in the url matches the id in the database with their username and password.
Or an update
UPDATE tablename SET whatever = '$whatever'
Where $whatever is a php post variable from a form or something.

[Rai_87]

what if i am using asp instead php, is it the same coding......

[abduraooft]

what if i am using asp instead php, is it the same coding......
The basic logic would be same, but may vary in syntax.

[Rai_87]

can anyone show me how to code using asp.net, pls help me..............cos i am a bit new to sql server!!!!

[Fumigator]

Do you not have access to Google?

p.s. this is the MySQL forum, not the SQL Server forum.