Re: [PHP-DB] foreach problem
On Saturday 08 February 2003 06:16, Sam Folk-Williams wrote: > I don't get any MySQL error... It adds the first entry_id and date exactly > as it should... it seems to be acting like entry_date is not an array, but > when I use the same foreach loop to echo the contents of entry_date it > echoes the multiple values (2003-05-01, 2003-05-02, etc)... I use the same > code to insert checkbox data in a different form, so... I'm kinda stumped. > > > $sql2 = "INSERT INTO cal_date_map (entry_id, date) VALUES echo $sql2 and plug each of them into the mysql commandline to see what happens. > > > $event_date is an array with several dates separated by commas. > > > (2003-10-02, 2003-10-03). The code above successfuly inserts the first Could you explain what exactly $event_date contains? The output of print_r($event_date) would suffice. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* Art is anything you can get away with. -- Marshall McLuhan. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] foreach problem
I don't get any MySQL error... It adds the first entry_id and date exactly
as it should... it seems to be acting like entry_date is not an array, but
when I use the same foreach loop to echo the contents of entry_date it
echoes the multiple values (2003-05-01, 2003-05-02, etc)... I use the same
code to insert checkbox data in a different form, so... I'm kinda stumped.
Sam
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> On Friday 07 February 2003 11:22, Sam Folk-Williams wrote:
> > Hi,
> >
> > I can't figure out why this won't work:
> >
> > foreach($event_date as $val) {
> >
> > $sql2 = "INSERT INTO cal_date_map (entry_id, date) VALUES
(\"$entry_id\",
> > \"$val\")";
> > $result = @mysql_query($sql2,$connection) or die
> > ("Problem executing foreach database query.");
> > }
> >
> > $event_date is an array with several dates separated by commas.
> > (2003-10-02, 2003-10-03). The code above successfuly inserts the first
dae
> > in the array, but none of the others... am I missing something?
>
> Any error messages? If so what does mysql_error() say?
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.biz
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
> --
> Search the list archives before you post
> http://marc.theaimsgroup.com/?l=php-db
> --
> /*
> WHERE CAN THE MATTER BE
> Oh, dear, where can the matter be
> When it's converted to energy?
> There is a slight loss of parity.
> Johnny's so long at the fair.
> */
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] foreach problem
On Friday 07 February 2003 11:22, Sam Folk-Williams wrote:
> Hi,
>
> I can't figure out why this won't work:
>
> foreach($event_date as $val) {
>
> $sql2 = "INSERT INTO cal_date_map (entry_id, date) VALUES (\"$entry_id\",
> \"$val\")";
> $result = @mysql_query($sql2,$connection) or die
> ("Problem executing foreach database query.");
> }
>
> $event_date is an array with several dates separated by commas.
> (2003-10-02, 2003-10-03). The code above successfuly inserts the first dae
> in the array, but none of the others... am I missing something?
Any error messages? If so what does mysql_error() say?
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
--
/*
WHERE CAN THE MATTER BE
Oh, dear, where can the matter be
When it's converted to energy?
There is a slight loss of parity.
Johnny's so long at the fair.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] foreach problem
Hi,
I can't figure out why this won't work:
foreach($event_date as $val) {
$sql2 = "INSERT INTO cal_date_map (entry_id, date) VALUES (\"$entry_id\",
\"$val\")";
$result = @mysql_query($sql2,$connection) or die
("Problem executing foreach database query.");
}
$event_date is an array with several dates separated by commas. (2003-10-02,
2003-10-03). The code above successfuly inserts the first dae in the array,
but none of the others... am I missing something?
Thank you.
Sam
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
