php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #17009 no work with "where" clause in quey
Submitted: 2002-05-05 00:03 UTC Modified: 2002-05-05 03:58 UTC
From: z29anna at yahoo dot com Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.2.0 OS: Redhat 7.2
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: z29anna at yahoo dot com
New email:
PHP Version: OS:

 

 [2002-05-05 00:03 UTC] z29anna at yahoo dot com 
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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-05-05 00:08 UTC] z29anna at yahoo dot com 
if so, how can I solve it?
 [2002-05-05 00:18 UTC] rasmus@php.net 
Turn on register_globals in your php.ini file
 [2002-05-05 03:58 UTC] z29anna at yahoo dot com 
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
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed Jul 16 23:01:33 2025 UTC