Charles Hogan cd_satl at futuretechsolutions.com
Tue Feb 8 14:36:40 CST 2011

What I do when I run into similar problems, is echo the sql statement 
that is to be run onto the screen as well.  This gives me the 
opportunity to examine the statement for errors.

On 02/08/2011 02:24 PM, Richard Suberg wrote:
> Hash: SHA256
> I need some help on a php script. I am actually looking for an IDE for
> PHP that will allow me to step through the script to find out exactly
> what is going wrong. This script is connecting to an MS SQL server
> database to pull data and redisplay it. If I were to run the SQL
> statement in Access, I get the data I want, but if I put the same SQL
> statement straight into the PHP script it fails (I assume the entire
> statement is too long) so I decided to break it up into separate SQL
> statements. The first one runs ok, store results in several arrays,
> (as proven with an echo $array[] loop) and then free the sql result
> (mssql_free_result) but any further sql queries I run with the data
> from the array as a part of the where clause in SQL comes up empty. Is
> anyone familiar with this or has an IDE for php that will allow
> stepping through the script to find out what is going on? The fun part
> is the server that is hosting the php site is Ubuntu, but developing
> the php file on WinXP, so an IDE for either environment would be good.
> I've tried Eclipse, but it says it can't find the php binary on the
> windows machine (likely because the php would never install correctly
> on this computer)
> - --
> Thunderbird Portable...it goes with me!
> Version: GnuPG v1.4.10 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
> Wz0YiCj/QUwFqjwpft0A/j4ztBFAgmTeTIJ/iNznul4JF4ypMYPIRSyl+YrlBvfa
> =r3NU

More information about the SATLUG mailing list