FUDforum: comp.lang.php » Why does my PDO query with named parameters return a blank result?

Home » Imported messages » comp.lang.php » Why does my PDO query with named parameters return a blank result?

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

Re: Why does my PDO query with named parameters return a blank result? [message #179319 is a reply to message #179317]

Wed, 03 October 2012 19:13

tom.rankin51
Messages: 17
Registered: September 2012

Karma:

Junior Member

Apologies for the ORDER BY DESC further on in the code - I caught that and forgot to remove it.

I understand what I've done with the AND - it makes sense and explains things a lot. However...

....when I've been reading about PDO and named parameters, I always see examples typed as WHERE foo = :foo I struggle to see why it works in an example, and why it does not in one of my failed attempts? Do parameters have to be declared?

I've tried different permutations of the postdate and $mydate part, and I'm really not sure how I can make it say postdate > $mydate by using parameters. Is there an accepted way, or standard way of doing this?

Report message to a moderator

[Message index]

		Why does my PDO query with named parameters return a blank result? By: tom.rankin51 on Wed, 03 October 2012 17:56
		Re: Why does my PDO query with named parameters return a blank result? By: Jerry Stuckle on Wed, 03 October 2012 18:45
		Re: Why does my PDO query with named parameters return a blank result? By: tom.rankin51 on Wed, 03 October 2012 19:13
		Re: Why does my PDO query with named parameters return a blank result? By: Michael Fesser on Wed, 03 October 2012 21:26

Previous Topic:	Is Symfony 2 on-topic in this newsgroup?
Next Topic:	How to run a batch file using PHP?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 12 20:24:48 GMT 2024

Total time taken to generate the page: 0.05870 seconds