[nycphp-talk] mysqli prepared statements
willie at pdfsystems.com
Thu Jan 4 11:27:37 EST 2007
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 isn't working now though and I'm 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 it works.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the talk