Re:Help with SELECT clause

2009-11-22 Thread shjunsin
Hi\I think you can achieve this using a single query like this: SELECT * FROM approvals WHERE adminname != 'admin2'and photo_uid in (select photo_uid from approvals where adminname='admin2'), of course, maybe it's not the best solution, just for your information.在2009-11-22,"Ashley M. Kirchner"

Re:help !

2002-07-10 Thread Oliver Six
"Brett Whittaker" <[EMAIL PROTECTED]> wrote on 10.07.2002 18:28:54: > >I was trying to connect into an MYSQL database, and I keep getting the error >message > >Can't connect to MySQL server on '10.10.10.250' (10054) > >but I know that the database is running and I can connect fine on the server >

Re:Help!

2001-10-03 Thread Heikki Tuuri
Alex, you are using MyISAM type tables which do not support rollback. Use BDB or InnoDB tables. Regards, Heikki http://www.innodb.com/ibman.html > My big problem is the rollback, every time when I try to use a rollback > command I get this error: > ERROR 1196: warning: some non-transaction cha