[nycphp-talk] mysqli prepared statements
willie at pdfsystems.com
Thu Jan 4 16:38:46 EST 2007
Well I figured this out but I can't explain why it works.
This statement is in a while loop, which is why I was using prepared
statements to begin with. I have another prepared statement which should
only have 1 record in the result, I'm searching on a unique primary key.
However when I do a $statement1->fetch() the second statement doesn't work.
When I put the first result into a while loop
Echo"showroom is $showroom<BR>";
The second statement executes fine.
Now would anyone know why this would be?
From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On
Behalf Of willie klein
Sent: Thursday, January 04, 2007 11:28 AM
To: talk at lists.nyphp.org
Subject: [nycphp-talk] mysqli prepared statements
I just started using prepared statements. So far I have been very impressed
by how much of a performance enhancement there is when using them. I have a
query that isnt working now though and Im not sure how to troubleshoot
it. I used to just echo out the query and I could see where the problem
was. I keep getting an empty result set from a query I know should have
data in it. Is there a way to see the prepared query as the server sees
it? I keep echoing out mysqli_error($dbi) but there is nothing in it.
$statement2 = $dbi->prepare("select date, date_format(date ,' %b %d %y') as
dta from 1TrackUser where loginID = ? ORDER BY date");// if
echo "ERROR: ".mysqli_error($dbi)."<BR>"; } echo "ShowroomLoginID
= $ShowroomloginID<br>"; // something valid is here
$TotalLogin = $statement2->num_rows ; // always 0 when I run query manually
More information about the talk