Selected items delete

2003-04-02 Thread Pag
Hi, I am kinda new to this mysql thing, so please forgive the basic question. What i need to do is, list my records on a table with a checkbox for each. After we choose several of the records, we click a button and i want to be able to delete the ones selected. Is there a simple mysql

Re: Selected items delete

2003-04-02 Thread Philipp Specht
Hi! Pag wrote: If i was too confusing, maybe this helps: How can i delete the records whose num field is 4,78,34 and 23, all in one command? Something along delete * in 'table' where num=1 and num=13 and num=34 etc. DELETE FROM table WHERE num=1 OR num=13 OR num=34 or better:

Re: Selected items delete

2003-04-02 Thread gerald_clark
Delete from table where num in ( 1,13,34) ; Pag wrote: Hi, I am kinda new to this mysql thing, so please forgive the basic question. What i need to do is, list my records on a table with a checkbox for each. After we choose several of the records, we click a button and i want to

RE: Selected items delete

2003-04-02 Thread Don Read
On 02-Apr-2003 Pag wrote: Hi, I am kinda new to this mysql thing, so please forgive the basic question. What i need to do is, list my records on a table with a checkbox for each. After we choose several of the records, we click a button and i want to be able to