confused big time
| From: | Andy B | Date: | Tue, 06 Apr 2004 23:51:00 +0000 |
| Subject: | confused big time | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-182567@lists.php.net to get a copy of this message | ||
hi...
i have 2 mysql queries....
first one:
//the extra { at the beginning and the extra , at the end of
//each variable should be an '...
"insert into $EventsTable values(NULL, '{$_SESSION[add][type]}',
'{$_SESSION[add][start_date]}', '{$_SESSION[add][end_date]}',
'{$_SESSION[add][name]}', '{$_SESSION[add][county]}',
'{$_SESSION[add][discription]}', '{$_SESSION[add][StartingDay]}',
'{$_SESSION[add][StartingMonth]}', '{$_SESSION[add][StartingYear]}',
'{$_SESSION[add][EndingDay]}', '{$_SESSION[add][EndingMonth]}',
'{$_SESSION[add][EndingYear]}'";
and the other one:
"insert into $GuestbookTable values(NULL, '{$_SESSION[add][date]}',
'{$_SESSION[add][name]}', '{$_SESSION[add][email]}',
'{$_SESSION[add][website]}', '{$_SESSION[add][referred]}',
'{$_SESSION[add][comments]}')";
they both use the same identical format to insert the arrays. there is an interesting problem
though: the first one complains about use of undefined constant add - assumed 'add' in the
second query...the first one doesnt do that??
everything is set up exactly the same for both queries except the relevant variable/array names...