From:             [EMAIL PROTECTED]
Operating system: Redhat 7.2
PHP version:      4.2.0
PHP Bug Type:     MySQL related
Bug description:  no work with "where" clause in quey 

I upgrade my webserver hardware, then migrate all Mysql database and entire
web site content to new server.

I have tested Mysql from mysql databases server, every thing is OK, I can
use command line like this:
select * from content where id=2230

can get the data output correctly.

but:
when I test to get data by  http://192.168.0.4/reader/content.php?id=2230

get error: no data found

the content.php code contain: 
"select * from content where id=$id"
-------------
if the code only contain "select id, title from content" then it works
fine, (without where clause)


in brife: the "where" clause no work in new php version 4.2


in the old server, I setup it with mysql 3.23.22, php 4.1, apache 1.3.19,
redhat 7.0, all the programm is coded and tested, of couse worked on this
platform

the new server, I setup it with mysql 3.23.49a, php 4.2.0, apache 1.3.20,
(still no work with where clause)


the configure line is:
 './configure' '--with-mysql' '--with-xml' '--enable-track-vars'
'--with-apache=../apache_1.3.20'

****** I think I should change back to old php version

please let me know if this is realy a php bug.

thanks a lot

have good day

Anna Zhao




-- 
Edit bug report at http://bugs.php.net/?id=17009&edit=1
-- 
Fixed in CVS:        http://bugs.php.net/fix.php?id=17009&r=fixedcvs
Fixed in release:    http://bugs.php.net/fix.php?id=17009&r=alreadyfixed
Need backtrace:      http://bugs.php.net/fix.php?id=17009&r=needtrace
Try newer version:   http://bugs.php.net/fix.php?id=17009&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=17009&r=support
Expected behavior:   http://bugs.php.net/fix.php?id=17009&r=notwrong
Not enough info:     http://bugs.php.net/fix.php?id=17009&r=notenoughinfo
Submitted twice:     http://bugs.php.net/fix.php?id=17009&r=submittedtwice
register_globals:    http://bugs.php.net/fix.php?id=17009&r=globals

Reply via email to