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" <php-db@gremlins.biz> wrote in message 200302080333.30767.php-db@gremlins.biz">news:200302080333.30767.php-db@gremlins.biz... > 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
