Re: [PHP-DB] Query was empty - Strange problem
I do not see where you are populating $Query --> therefore your query
would be empty --
On Mar 16, 2005, at 10:30 PM, Vinayakam Murugan wrote:
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 ";
return FALSE;
}
$Ret = mysql_query ($Query, $Conn) or $Error = "" .
mysql_errno() . "---" . mysql_error() . "";
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
*
Stephen Johnson
[EMAIL PROTECTED]
http://www.thelonecoder.com
--continuing the struggle against bad code--
*
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Query was empty - Strange problem
Here is the entire function
function Executequery($Query)
{
global $Error, $Hostname,$Loginname,$Passwd,$Dbname,$Conn;
$Conn = mysql_pconnect($Hostname,$Loginname,$Passwd);
$Ret = mysql_select_db ($Dbname, $Conn);
if (!$Ret)
{
$Error = "Error opening Database : $Dbname ";
return FALSE;
}
$Ret = mysql_query ($Query, $Conn) or $Error = "" .
mysql_errno() . "---" . mysql_error() . "";
if (!$Error)
{
$numfields = mysql_num_fields($Ret);
$numrows = mysql_num_rows($Ret);
if($numrows == 0)
{
$Error = "Query returned zero records";
return FALSE;
}
}
else
{
return FALSE;
}
}
On Wed, 16 Mar 2005 22:36:13 -0800, Stephen Johnson <[EMAIL PROTECTED]> wrote:
> I do not see where you are populating $Query --> therefore your query
> would be empty --
>
>
> On Mar 16, 2005, at 10:30 PM, Vinayakam Murugan wrote:
>
> > 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 ";
> > return FALSE;
> > }
> >
> > $Ret = mysql_query ($Query, $Conn) or $Error = "" .
> > mysql_errno() . "---" . mysql_error() . "";
> >
> > 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
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> *
> Stephen Johnson
> [EMAIL PROTECTED]
> http://www.thelonecoder.com
>
> --continuing the struggle against bad code--
> *
>
>
--
Warm Regards
Vinayak
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Query was empty - Strange problem
This is a common procedure. $Query is being passed to it. As I had
said before, i had tried echoing $Query before and after the
mysql_query statement and it displays a proper query.
That's what driving me nuts! :-(
On Wed, 16 Mar 2005 22:36:13 -0800, Stephen Johnson <[EMAIL PROTECTED]> wrote:
> I do not see where you are populating $Query --> therefore your query
> would be empty --
>
>
> On Mar 16, 2005, at 10:30 PM, Vinayakam Murugan wrote:
>
> > 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 ";
> > return FALSE;
> > }
> >
> > $Ret = mysql_query ($Query, $Conn) or $Error = "" .
> > mysql_errno() . "---" . mysql_error() . "";
> >
> > 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
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> *
> Stephen Johnson
> [EMAIL PROTECTED]
> http://www.thelonecoder.com
>
> --continuing the struggle against bad code--
> *
>
>
--
Warm Regards
Vinayak
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
