Help with SQL Query String

From: Date: Thu, 31 Mar 2005 15:00:31 +0000
Subject: Help with SQL Query String
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-211960@lists.php.net to get a copy of this message
Ave, Simple problem.. Following is a statement I¹m inserting in my PHP Script... But it doesn¹t work because I¹m not able to figure out how to put the variables with the trim() function in the SQL insert statement: $sql = INSERT INTO tblname (USERID,FULLNAME,SSN,STARTDATE) VALUES (trim($row[USERID]),trim($row[FULLNAME]),trim($row[SSNO]),trim($row[STARTDAT E])); I can of course predefine a unique variables for each of the $row[] variables with the trim() function and then use those variables in my INSERT statement... But I¹m sure there is a way this statement can work, I¹m just not able to figure it out and would love if anyway made a suggestion. Thanks, Rahul S. Johari Coordinator, Internet & Administration Informed Marketing Services Inc. 251 River Street Troy, NY 12180 Tel: (518) 266-0909 x154 Fax: (518) 266-0909 Email: rahul@informed-sources.com http://www.informed-sources.com

« previous php.general (#211960) next »