How do you use substitutes in the queries?
I'm trying to do login auditing, by just inserting a record into a table whenever anyone logs in. I don't know how to do this, though.
INSERT INTO jos_login_audit (user_id, ip,timestamp)
VALUES (**user_id?**, **ip?**,DATETIME())
If I have the above query, what do I put for the user_id and IP so that it uses the actual current value for it.
Is there a table with these or somewhere I can have them for future reference? I can find no documentation on it.
Thanks!