IF statement problem?

jamesunited

hi all,
i have a bit of a problem, wondering if anyone can lend a hand here,
Ive created an e-commerce site and if a user buys something it updates the stock field in the database that works fine but if the stock is less than what the user wants to purchase i want it to display an error message saying something like "Sorry item not in stock"
I know im going to need some sort of IF statement but not sure how to retrieve the information from the database and then display the message.

dagon

hard without seeing code. But what i would do -when you retrieve the product details retrieve the stock level, if its 0 display some out of stock notice and no option to buy; if there is stock, and they buy more than the stock level, give them a warning.

jamesunited

what sort of code would you suggest to do that? Also if there was only one left in stock and the user only wanted one then that would be fine, more than one wouldn't is there no way i could do it the original way i thought of with a pop up error message?

dagon

if ($stock < $requested){
//bad
}else{
//good
}

jamesunited

what is the code that would generate a pop up error message box? And if the stock levels were fine how would i get it just to continue what it was doing?

dagon

what is the code that would generate a pop up error message box?

You can echo any js you like

And if the stock levels were fine how would i get it just to continue what it was doing?

That's the //good bit