php help please - set variable based on items on order

[philip937]

I was just about to post my poor attempt at the logic, yours look much neater! thank you :)

$restult1 = SELECT count(*) as count FROM `orders_products` WHERE `orders_id` = 14532;

if $result1 = 1 {  

$result2 = SELECT `products_quantity` FROM `orders_products` WHERE `orders_id` = 14532;

if $result2 = 1 { 

$oneItemOrder = true;

}

}