Re: [PHP] Help with SQL Query String

On 3/31/05 12:45 PM, "Joseph Connolly" <[EMAIL PROTECTED]> wrote: > well...i would have told him to go pound sand...the php manual is great > and so is the MySQL manual. People are just lazy. Ave, "Pound sand" .. Interesting. And yes, both the manuals are great, and people are extremely lazy

Re: [PHP] Help with SQL Query String

well...i would have told him to go pound sand...the php manual is great and so is the MySQL manual. People are just lazy. [/snip] Ya'll bitch when I make them RTFM, ya'll bitch when I do codewhat's a guy to do? j/k Actually http://dev.mysql.com/doc/mysql/en/string-functions.html shows that My

Re: [PHP] Help with SQL Query String

Ave, Thanks a lot folks. I did actually mention that doing something like $userid = trim($row['USERID']); And then using those variables in my SQL statement would work... The only reason I chose to make this post however and not do that was because I wanted to know if it can be done the other

Re: [PHP] Help with SQL Query String

Jay Blanchard wrote: Ya'll bitch when I make them RTFM, ya'll bitch when I do codewhat's a guy to do? j/k Don't get married? ;) -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/uns

RE: [PHP] Help with SQL Query String

[snip] You should not just give him the code but rather tell him why. 1. trim() is a php function. MySQL does not know what to do with it. You need to place it 'outside' of the sql. You can also do something like this: $userid = trim($row['USERID']); Then use $userid in your sql. 2. Items in a

Re: [PHP] Help with SQL Query String

You should not just give him the code but rather tell him why. 1. trim() is a php function. MySQL does not know what to do with it. You need to place it 'outside' of the sql. You can also do something like this: $userid = trim($row['USERID']); Then use $userid in your sql. 2. Items in arrays must

RE: [PHP] Help with SQL Query String

[snip] $sql = INSERT INTO tblname (USERID,FULLNAME,SSN,STARTDATE) VALUES (trim($row[USERID]),trim($row[FULLNAME]),trim($row[SSNO]),trim($row[STAR TDAT E])); [/snip] Time to quote and concatenate and make pretty... $sql = "INSERT INTO tblname (USERID,FULLNAME,SSN,STARTDATE) "; $sql .= "VALUES ( ";