Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.php > #3120

Re: query with empty resultset (but the same one, used in phpmyadmin, gives results!!)

From "Álvaro G. Vicario" <alvaro.NOSPAMTHANX@demogracia.com.invalid>
Newsgroups comp.lang.php
Subject Re: query with empty resultset (but the same one, used in phpmyadmin, gives results!!)
Date 2011-09-12 08:16 +0200
Organization http://alvaro.es/
Message-ID <j4k83t$toc$2@dont-email.me> (permalink)
References <14f2e3aa-e019-4c87-a87b-1329a63c1e37@u20g2000yqj.googlegroups.com> <5603e5a5-ed19-44f8-9bc2-4ba707a3a7d6@d18g2000yqm.googlegroups.com>

Show all headers | View raw


El 10/09/2011 13:34, SatBoy78 escribió/wrote:
> solved!
>
> the problem was $month=09;
>
> correct is $month=9;

It it wasn't true that it was the same query, was it? :)

Sorry if I'm stating the obvious but the MySQL server cannot see your 
PHP code. You use PHP to compose a string that contains a SQL query and 
that SQL code is all that MySQL care about. So next time start your 
debugging by inspecting the *generated* SQL code.


-- 
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

query with empty resultset (but the same one, used in phpmyadmin, gives results!!) SatBoy78 <bruno.matteo@gmail.com> - 2011-09-10 03:41 -0700
  Re: query with empty resultset (but the same one, used in phpmyadmin, gives results!!) SatBoy78 <bruno.matteo@gmail.com> - 2011-09-10 04:34 -0700
    Re: query with empty resultset (but the same one, used in phpmyadmin, gives results!!) Jerry Stuckle <jstucklex@attglobal.net> - 2011-09-10 08:32 -0400
    Re: query with empty resultset (but the same one, used in phpmyadmin, gives results!!) Denis McMahon <denis.m.f.mcmahon@gmail.com> - 2011-09-11 11:45 +0000
    Re: query with empty resultset (but the same one, used in phpmyadmin, gives results!!) "Álvaro G. Vicario" <alvaro.NOSPAMTHANX@demogracia.com.invalid> - 2011-09-12 08:16 +0200
  Re: query with empty resultset (but the same one, used in phpmyadmin, gives results!!) Norman Peelman <npeelmandog@cfl.rr.com> - 2011-09-10 09:00 -0400

csiph-web