Bug #17009 Updated: no work with "where" clause in quey
ID: 17009 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Bogus Bug Type: MySQL related Operating System: Redhat 7.2 PHP Version: 4.2.0 New Comment: I have tried php4.1.2, nothing change for my programm, but everything is OK. by the way, thanks for your answer, I'll try it out. thanks Anna Zhao Previous Comments: [2002-05-05 00:18:23] [EMAIL PROTECTED] Turn on register_globals in your php.ini file [2002-05-05 00:08:46] [EMAIL PROTECTED] if so, how can I solve it? [2002-05-05 00:03:39] [EMAIL PROTECTED] 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 this bug report at http://bugs.php.net/?id=17009&edit=1
Bug #17009 Updated: no work with "where" clause in quey
ID: 17009 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: MySQL related Operating System: Redhat 7.2 PHP Version: 4.2.0 New Comment: if so, how can I solve it? Previous Comments: [2002-05-05 00:03:39] [EMAIL PROTECTED] 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 this bug report at http://bugs.php.net/?id=17009&edit=1
Bug #17009: no work with "where" clause in quey
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
