Help with SQL Query String

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxxxxx
http://www.informed-sources.com


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux