Array putting out the wrong data ...
Posted: Sat Jan 15, 2011 1:51 am
I'm running a small voucher business for restaurants however I have a big problem:
Users can access their voucher that they via their account. They click on their voucher (voucher.php) which will then have their title of voucher ($vouchertitle in the MySQL database), Voucher validity ($Voucherstart and $Voucherend), which are stored in a products structure in the database. But here's when it goes funky, I also have a supplier structure, which has $supplierArray['VoucherAddress'], $supplierArray['address'] and $supplierArray['company'], which are called when voucher.php is opened: However, this crappy $supplierarray displays me the VoucherAddress, address and company only of the supplier of the latest voucher created, and NOT of their "real" respective supplier.
does anyone sense a solution for this as in where to look into? it actually worked fine but it seems like my mysql database is going bonkers with the heavy traffic load in the last days... thanks for any help in advance!
Users can access their voucher that they via their account. They click on their voucher (voucher.php) which will then have their title of voucher ($vouchertitle in the MySQL database), Voucher validity ($Voucherstart and $Voucherend), which are stored in a products structure in the database. But here's when it goes funky, I also have a supplier structure, which has $supplierArray['VoucherAddress'], $supplierArray['address'] and $supplierArray['company'], which are called when voucher.php is opened: However, this crappy $supplierarray displays me the VoucherAddress, address and company only of the supplier of the latest voucher created, and NOT of their "real" respective supplier.
does anyone sense a solution for this as in where to look into? it actually worked fine but it seems like my mysql database is going bonkers with the heavy traffic load in the last days... thanks for any help in advance!