Richard Suberg rsuberg at satx.rr.com
Tue Feb 8 15:14:55 CST 2011

Hash: SHA256
I have done that also, and I don't see a problem with the sql
statement. Also, the sql search is not returning false, so I see it is
succeeding but not returning any results....strange because I am
searching on the primary key value.

On 2/8/2011 2:36 PM, Charles Hogan wrote:
> 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:
> 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/

More information about the SATLUG mailing list