help with PDO / select * from statement
Posted: Sun Dec 21, 2014 6:09 pm
please take a look at my code and help me figure out why im getting the following error:
something along the lines of "my_sql_fetch_array expects parameter 1 to be source"
///////begin code
/////////end code
something along the lines of "my_sql_fetch_array expects parameter 1 to be source"
///////begin code
Code: Select all
$ordernumber = $_POST['ordernumber'];
$dbname = "bob_orders";
$pdo = new PDO( "mysql:dbname=$dbname;host=$host" , $user , $password);
$sql= "SELECT * FROM invoices WHERE OrderNumber= $ordernumber";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':OrderNumber', $ordernumber, PDO::PARAM_INT);
$stmt->execute();
echo "<table align=\"center\"><tr><td>Order Number</td><td>First Name</td><td>Order Status</td></tr>";
if($pdo){
while($row = mysql_fetch_array($sql))
{
echo "<tr><td>";
echo $row['OrderNumber'];
echo "</td><td>";
echo $row['FirstMiddle'];
echo "</td><td>";
echo $row['Status'];
echo "</td></tr>";
}
echo "</table><br><br><br><br>";
}