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 itself!

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