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


Groups > comp.lang.php > #3108

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

From Jerry Stuckle <jstucklex@attglobal.net>
Newsgroups comp.lang.php
Subject Re: query with empty resultset (but the same one, used in phpmyadmin, gives results!!)
Date 2011-09-10 08:32 -0400
Organization A noiseless patient Spider
Message-ID <j4fldd$85b$1@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


On 9/10/2011 7:34 AM, SatBoy78 wrote:
> solved!
>
> the problem was $month=09;
>
> correct is $month=9;

When you have problems with a database query, you should echo the query 
you are issuing.  Then if the problem is not obvious, you should almost 
always ask in a database newsgroup.

The solution may end up being in PHP - but PHP knows nothing about SQL 
and that's where your diagnosis should start.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

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