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

go to bug id or search bugs for

Bug #6405 SELECT in 1 row
Submitted: 2000-08-28 13:17 UTC Modified: 2000-08-28 13:58 UTC
From: hejna at inisoft dot cz Assigned:
Status: Closed Package: MySQL related
PHP Version: 4.0.1pl2 OS: Linux goodlife 2.3.99-pre8 #27 W
Private report: No CVE-ID: None
View Developer Edit
 [2000-08-28 13:17 UTC] hejna at inisoft dot cz 
Sorry if I did't say about realy bug.
I'm maybe out of reality...

My WebHoster(?) upgrades from PHP3 to PHP4 and finish work:

(PHP3)
$result = mysql_query("SELECT * FROM page WHERE p_FILENAME = "home.php3"
--- return 1 row about page "home.php3"

(PHP4)
$result = mysql_query("SELECT * FROM page WHERE p_FILENAME = "home.php3"
--- return nothing!!!

I must evade it:
$result = mysql_query("SELECT * FROM page WHERE p_FILENAME LIKE "%home.php3%");
--- return 1 row about page "home.php3"

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-08-28 13:55 UTC] sniper@php.net 
Write that line like this:

$result = mysql_query
("SELECT * FROM page WHERE p_FILENAME = 'home.php3'");

Note those single quotes around home.php3-string.

--Jani
 [2000-08-28 13:58 UTC] sniper@php.net 
Forgot to mention:

Always test your select clauses within mysql command line
sql shell!

--Jani
 
PHP Copyright © 2001-2026 The PHP Group
All rights reserved. 		Last updated: Tue Jul 07 12:00:02 2026 UTC