NYCPHP Meetup

[nycphp-talk] mysqli prepared statements

Daniel Convissor danielc at analysisandsolutions.com
Thu Jan 4 20:09:08 EST 2007


On Thu, Jan 04, 2007 at 04:38:46PM -0500, William Klein wrote:

> This statement is in a while loop, which is why I was using prepared
> statements to begin with.

You're preparing the statement before the loop, then only 
binding/executing on each loop, right?


In your reply I see there's a "?" after "select":

> $statement2 = $dbi->prepare("select? date, 
> date_format(date ,' %b %d %y') as
> dta from 1TrackUser where loginID = ? ORDER BY date");

Perhaps there's some messed up stuff in your query?

Also, the code you posted is a mess.  It looks like you wrote it in the 
email rather than copied it from a real test script.

To really debug an issue, especially if you're trying to get help 
debugging it, you need to boil down the issue to a few lines of code in an 
isolated test script that anyone can run.

--Dan

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409



More information about the talk mailing list