Help with SQL Query String
| From: | Rahul S. Johari | 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