Oops, I forgot the double quotes at the end of the example query from the last email. This is how it should be:
Example Query: $query = "SELECT * FROM items WHERE '$item[itemID]'"; > -----Original Message----- > From: @ Nilaab [mailto:[EMAIL PROTECTED]] > Sent: Saturday, February 01, 2003 1:00 PM > To: [EMAIL PROTECTED] > Subject: RE: [PHP] MySQL/PHP Associative Array Insert > > > Yes Chris, > > When you add the item to the database, make sure to leave out the single > quotes inside the brackets of the associative array. For example: > > Instead Of: > $item['itemID'] > > Do This: > $item[itemID] > > Example Query: > $query = "SELECT * FROM items WHERE '$item[itemID]'; > > Hope that helps. > > > -----Original Message----- > > From: CDitty [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, February 01, 2003 10:26 AM > > To: [EMAIL PROTECTED] > > Subject: [PHP] MySQL/PHP Associative Array Insert > > > > > > A co-worker is teaching me to move to the next level in php. I have > > started using associative arrays for my scripts, but I am > having a problem > > using them to do an insert into MySQL. Can someone give me an example of > > how to do an insert to the database using these arrays? My array is > > this...$item['itemID'] > > > > Thanks > > Chris > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
