Working with Multi-Select & Dropdowns and SQL

Working with Multi-Select & Dropdowns and SQL

El Forum
Unregistered

#20

07-01-2010, 04:12 AM

[eluser]Bionicjoe[/eluser]
This is the update statement sent to the DB.

Code:
UPDATE `outage` SET 

`outageid` = '2', 

`ticketnumber` = 'INC000000000002', 

`servicename` = Array,      <-- Problem 

`location` = Array,       <-- Problem

`impact` = '5000', 

`starttime` = '', 

`endtime` = '', 

`summary` = 'Sample Ticket 2', 

`details` = 'Some details ...' 

WHERE `outageid` = '2'

That WHERE at the end is not needed.

Messages In This Thread

Working with Multi-Select & Dropdowns and SQL - by El Forum - 06-30-2010, 04:31 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 06-30-2010, 04:42 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 06-30-2010, 10:28 PM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 12:14 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 01:59 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 02:13 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 02:22 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 02:35 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 02:50 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 02:55 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 03:01 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 03:17 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 03:21 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 03:28 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 03:31 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 03:44 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 03:49 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 03:53 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 03:59 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 04:12 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 04:21 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 05:19 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-01-2010, 05:26 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-02-2010, 12:37 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-02-2010, 01:28 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-02-2010, 01:42 AM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-14-2010, 05:43 PM

Working with Multi-Select & Dropdowns and SQL - by El Forum - 07-14-2010, 10:44 PM