max() can't work

2010-02-06 Thread tech list
select * from table_name where movid = max(movid); why the sql above can't work? Shall I use a sub-select instead? select * from table_name where movid = (select max(movid) from table_name) ? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

connect VB to mysql over net

2001-09-05 Thread Moax Tech List
I want to build a VB application that connects to mysql (over the internet) running on linux. i have mysql currently running on LAMP system fine, but do i just need to install MyODBC for linux on the mysql server or what? also, are there any major security issues to this i should know about? any h

Re: ERROR 2002:

2001-05-25 Thread Moax Tech List
You most likely don't have your permissions set right on your socket, make sure it is readable / writeable by the php user (nobody?) and apache i had that same prob. -derick - Original Message - From: "Jeff Pace" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 25, 2001 5:39