[thelist] MySQL/PHP Associative Array Insert

[CDitty]

Looks like you understood it correctly.  Your example is exactly what I
needed.  I didn't realize that with associative arrays
I would have to '" . $item['itemID'] . "'.  This will get me moving again.

Thank you
Chris

At 10:41 AM 2/1/2003, you wrote:
> > Can someone give me an example of how to do an insert to the
> > database using these arrays?  My array is this...$item['itemID']
>
>Maybe I'm not understanding the question clearly, but if I do you should
>be able to use the array values just as you would any variable.
>
>Here's a function I use to update announcement items in a calendar app
>that takes an array as you described, $data is the array (like your
>$item) and $update is a switch that tells the function whether to update
>or insert, defaulting to insert:
>
>// update announcement item
>function update_announcement($data, $update=0) {
>         $connect = dbconnect();
>         $query = "UPDATE cal_announcements
>                     SET
>                         user_id='".$data['user_id']."',
>                         s_date='".$data['s_date']."',
>                         e_date='".$data['e_date']."',
>                         title='".$data['title']."',
>                         content='".$data['content']."'
>                     WHERE annc_id='".$data['annc_id']."'";
>         if (empty($update)) {
>                 $query = "INSERT INTO cal_announcements
>                                 (user_id,s_date,e_date,title,content)
>                             VALUES
>                                 ('".$data['user_id']."',
>                                 '".$data['$s_date']."',
>                                 '".$data['e_date']."',
>                                 '".$data['title']."',
>                                 '".$data['content']."')";
>         }
>         $result = mysql_query($query) or die (mysql_error());
>}
>
>HTH.
>
>BH
>
>--
>* * Please support the community that supports you.  * *
>http://evolt.org/help_support_evolt/
>
>For unsubscribe and other options, including the Tip Harvester
>and archives of thelist go to: http://lists.evolt.org
>Workers of the Web, evolt !