FUDforum: comp.lang.php » query with empty resultset (but the same one, used in phpmyadmin, gives results!!)

Home » Imported messages » comp.lang.php » query with empty resultset (but the same one, used in phpmyadmin, gives results!!)

Show: Today's Messages :: Polls :: Message Navigator

Re: query with empty resultset (but the same one, used in phpmyadmin, gives results!!) [message #175365 is a reply to message #175350]

Mon, 12 September 2011 06:16

alvaro.NOSPAMTHANX
Messages: 277
Registered: September 2010

Karma:

Senior Member

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
--

Report message to a moderator

[Message index]

		query with empty resultset (but the same one, used in phpmyadmin, gives results!!) By: SatBoy78 on Sat, 10 September 2011 10:41
		Re: query with empty resultset (but the same one, used in phpmyadmin, gives results!!) By: SatBoy78 on Sat, 10 September 2011 11:34
		Re: query with empty resultset (but the same one, used in phpmyadmin, gives results!!) By: Jerry Stuckle on Sat, 10 September 2011 12:32
		Re: query with empty resultset (but the same one, used in phpmyadmin, gives results!!) By: Denis McMahon on Sun, 11 September 2011 11:45
		Re: query with empty resultset (but the same one, used in phpmyadmin, gives results!!) By: alvaro.NOSPAMTHANX on Mon, 12 September 2011 06:16
		Re: query with empty resultset (but the same one, used in phpmyadmin, gives results!!) By: Norman Peelman on Sat, 10 September 2011 13:00

Previous Topic:	HOW TO: Spice up Your Site With Simple PHP
Next Topic:	Stats comp.lang.php (last 7 days)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 11:40:55 GMT 2024

Total time taken to generate the page: 0.03508 seconds