How to Store Session Variable(UserName) in a table with MySQL....
-
Hi, I want to save the session UserName in a table using mysql. I have the history of my base table(auction) update, delete, create information will get stored in a backup table(auction_log). I want to save username(who currently loged in and modifies the record in a table) in too the auction_log table. reg, Subbu
-
Hi, I want to save the session UserName in a table using mysql. I have the history of my base table(auction) update, delete, create information will get stored in a backup table(auction_log). I want to save username(who currently loged in and modifies the record in a table) in too the auction_log table. reg, Subbu
And what part are you having difficulties with?
I know the language. I've read a book. - _Madmatt
-
Hi, I want to save the session UserName in a table using mysql. I have the history of my base table(auction) update, delete, create information will get stored in a backup table(auction_log). I want to save username(who currently loged in and modifies the record in a table) in too the auction_log table. reg, Subbu
Create a connection to mysql db and run an insert or update on the table.
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
Hi, I want to save the session UserName in a table using mysql. I have the history of my base table(auction) update, delete, create information will get stored in a backup table(auction_log). I want to save username(who currently loged in and modifies the record in a table) in too the auction_log table. reg, Subbu
Pass the username as a parameter to a stored procedure and insert the new record as: insert into auction_log (field1, field2, ..., UserName) values (@Field1, @Field2, ..., @UserName) or similar should do it. It's been a while since I used MySql but I think that should work.