delte(), update() and "where" variable

tru · #1 (**permalink**) 08-06-2008, 10:06 AM

Hi,
I've got a script which edits and deletes data in database. To select row for edit/del, I want to use $id variable.
To perform a sql qeury "SELECT" I use following code

PHP Code:


			
$id = $this->getRequest()->getParam('id');

(...)

$db->fetchAll('SELECT * FROM table WHERE id = ?', $id)

Could you please tell me how can I insert $id variable into update() and delete() function? Using those functions I'd like to perform query like this

Code:

DELETE FROM table WHERE id = $id

I'd like to add that '$id = ?', $id doesn't work.

Regards,
Tru

Tekerson · #2 (**permalink**) 08-11-2008, 03:35 AM

The delete and update functions both take a standard where clause as the final argument, but don't do variable insertion. The adapter has a separate quoteInto() function that can handle that though.

Your example delete would look like

Code:

$adapter->delete('table', $adapter->quoteInto('id = ?', $id));

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode