Unfortunately that has already been done and that exact method is what got
me this far. I can visually confirm that I am calling on the correct
names/variables.
array(1) { ["file"]=> array(5) { ["name"]=> string(14) "emailsTest.txt"
["type"]=> string(10) "text/plain" ["tmp_name"]=> string(14)
"/tmp/phpec4hX9" ["error"]=> int(0) ["size"]=> int(61) } } array(5) {
["name"]=> string(14) "emailsTest.txt" ["type"]=> string(10) "text/plain"
["tmp_name"]=> string(14) "/tmp/phpec4hX9" ["error"]=> int(0) ["size"]=>
int(61) } $sqlYou have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'ALTER TABLE `3` ADD Array VARCHAR(60); FIELDS TERMINATED BY ',' OPTIONALLY
EN' at line 2
Brad
-----Original Message-----
From: lists-php [mailto:replies-lists-d5y3-php@xxxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, July 25, 2012 7:55 PM
To: Brad
Subject: RE: Re: Stuck trying to upload and grab file name
------------ Original Message ------------
> Date: Wednesday, July 25, 2012 07:33:09 PM -0400
> From: Brad <nyctelecomm@xxxxxxxxx>
> To: 'Karl DeSaulniers' <karl@xxxxxxxxxxxxxxx>
> Cc: php-db@xxxxxxxxxxxxx
> Subject: RE: Re: Stuck trying to upload and grab file name
>
> Switching it to -> ALTER TABLE `{$memberID}` ADD {$tmp_name}
> VARCHAR(60); produces the same error.
> For the record $tmp_name is just gibberish and should not be the final
> column name.
>
> Brad
>
Echo the statement out (after the variable substitutions have taken place),
and then work with that at the mysql command line. You'll likely figure out
the issue much faster (it might even be obvious from what gets displayed).
- Richard
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
