Query was empty - Strange problem
| From: | Vinayakam Murugan | Date: | Thu, 17 Mar 2005 06:30:42 +0000 |
| Subject: | Query was empty - Strange problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-38939@lists.php.net to get a copy of this message | ||
Hi
I have an application in which i am connecting to three different
databases. I have three connect and query procedure. I am facing
problems with one of these databases.
-------------------------------------------------------------------------------------------------------------------------------
$Conn = mysql_pconnect($Hostname,$Loginname,$Passwd);
$Ret = mysql_select_db ($Dbname, $Conn);
if (!$Ret)
{
$Error = "Error opening Database : $Dbname <BR>";
return FALSE;
}
$Ret = mysql_query ($Query, $Conn) or $Error = "<BR><BR>" .
mysql_errno() . "---" . mysql_error() . "<BR><BR>";
echo $Error;
-------------------------------------------------------------------------------------------------------------------------------
I am getting an Error - Query was empty.
I have tried echoin $Query before and after the mysql_query. It shows
a proper query which if I copy and execute in phpmyadmin, i get the
required results. It is not workign through PHP only.
Any pointers would be very helpful.
--
Warm Regards
~~~~~~~~~~~~
Vinayak