Query was empty

[Anon]

Hi folks,

Having a small problem with an UPDATE. I'm doing something like:

$go = "UPDATE 4_Contacts SET ID = 5, FirstName='Dave', LastName='Boop', MiddleInitial='B', Address1='1111 Microsoft Way', Address2='Apt 1237', City='Dallas', ST='AR', ZipCode='75000', HomePhone='2225553333', WorkPhone='6547981234', CellPhone=NULL, Email='[e-mail]', ContactStatus='Hot', ContactType='client' WHERE ID = 5"

$query = mysql_db_query($DBNAME, $go, $dbConnect);

and it's erroring out with 1065:Query was empty.

Yes, I'm echo'ing my $go and everything looks fine. Yes, I've run the query directly into mysql and it works fine, just not through the PHP.

Any ideas?

[Anon]

What does your connection to mysql in PHP look like? Are you using mysql_pconnect? if you are, take out the link identifier (ie $dbConnect) in your mysql_db_query statement and see how that goes. It is nice to have it there but not always necessary unless you are hitting multiple DB connections which usually only happens when connecting to several different database servers.