Hi, What SQL statements do I have to use to get the following results?
I have a preferences page that lists directories with check boxes. This is displaying by querying my database. It looks something like this: Preferences: (Click to omit directories from listing) [ ] dir1 [ ] dir2 [ ] dir3 [ ] dir4 [ ] dir5 [ UPDATE ] Preferences: (Click to add directories to listing) No directories selected. [ UPDATE ] So if the user checked on boxes dir2 and dir4 and clicks on the "update" I then want the screen to appear like: [ ] dir1 [ ] dir3 [ ] dir5 [ UPDATE ] Preferences: (Click to add directories to listing) [ ] dir2 [ ] dir4 [ UPDATE ] I'm not how to make this happen using my queries? --------------------------------------------------- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --------------------------------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php