If you use paypal standard, you will need to create an IPN page to store the order information in the database. The IPN Page is a page that paypal will post to once the transaction is processed with the bank. it will contain the transaction results, success or failure.
see the following thread for details on IPN:
showthread.php?t=7723