|
Hi I am using below: [SQLPasswordAuth] Driver=MySQL Host=***.***.***.*** Port=1234 Database=dbname Username=username Password=secret Table=subscriber Query=SELECT password FROM subscriber
WHERE username = '%1' CacheTimeout=30 MinPoolSize=5 I would like to add an insert see below: [SQLPasswordAuth] Driver=MySQL Host=***.***.***.*** Port=1234 Database=dbname Username=username Password=secret Table=subscriber Query=SELECT password FROM subscriber
WHERE username = '%1' Query=INSERT INTO location (username)
VALUES ('%u') CacheTimeout=30 MinPoolSize=5 Does anyone have an idea how I can have an INSERT and SELECT
in this section. Theory is when the users password is checked I would like to
insert the details into a table called location. This would allow me to call
the details from the location table and display user online in a PHP page. |
