Snowman Posted September 25, 2010 Share Posted September 25, 2010 I know in the admin clientsummary template that {$clientsdetails.userid} returns the client id variable to smarty but within the template i need to use the client ID in a sql statement what is the non smarty variable name to identify the current clients ID? i was looking for a solution to provide the ID in the following sql statement: $result = mysql_query("SELECT tblsslorders.*,tblclients.companyname,tblclients.firstname,tblclients.lastname FROM `tblsslorders`,`tblclients` WHERE tblsslorders.status = 'Completed' AND tblsslorders.userid = $clientsdetails.userid AND tblclients.id = $clientsdetails.userid ORDER BY tblsslorders.completiondate ASC"); any suggestions? 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.