mysqli giving “Commands out of sync” error - why?

bowzer2

New Member
I am trying to run the following.\[code\]<?php$db = mysqli_connect("localhost","user","pw") or die("Database error");mysqli_select_db($db, "database");$agtid = $_POST['level'];$sql = sprintf("call agent_hier(%d)", $agtid);$result = mysqli_query($db, $sql) or exit(mysqli_error($db));if ($result) { echo "<table border='1'> <tr><th>id</th> <th>name</th> <th>parent_id</th> <th>parent_name</th> <th>level</th> <th>email</th></tr>"; while ($row = mysqli_fetch_assoc($result)) { $aid = $row["id"]; $sql2 = "SELECT * FROM members WHERE MEMNO = '$aid'"; $result2 = mysqli_query($db,$sql2) or exit(mysqli_error($db)); while ($newArray = mysqli_fetch_array($result2)) { $fname = $newArray['FNAME']; $lname = $newArray['LNAME']; $mi = $newArray['MI']; $address = $newArray['ADDRESS']; $city = $newArray['CITY']; $state = $newArray['STATE']; $zip = $newArray['ZIP']; $kdate = $newArray['KDATE']; $date = abs(strtotime(date('m/d/Y')) - strtotime(date($kdate))) / (60 * 60 * 24); } echo sprintf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>", $row["id"],$row["name"], $row["parent_id"],$row["parent_name"], $row["level"],$row["email"]); } echo "</table>";}mysqli_free_result($result);mysqli_close($db);?>\[/code\]If I remove lines from:$aid = $row["agent_id"];to....$date = abs(strtotime(date('m/d/Y')) - strtotime(date($kdate))) / (60 * 60 * 24);}everything will work fine. If not, I get the following error:Commands out of sync; you can't run this command nowIn researching, I think it could be due to multiple mysqli queries run at the same time, in which using mysqli_multi_query but for all the samples and general data in the guide does not seem to be applicable. Any ideas?
 
Back
Top