Creating A Discount Code

[newbie_kerry]

I am wanting to have a code "discount10" to give 10% off all purchases

 

I have created the tables, but unsure what code to do next. Here is my basket, where I want the code to be:

[Larry]

Would probably help to know how the table is set up. But I'm fairly sure you don't want to select everything from the discount_codes table.

[newbie_kerry]

It is a fairly basic table as per the other tables in your book. It is containing:

discount_id: int(11)

discount_code: varchar(25)

discount_amount

 

I just selected select all from table so I was not missing something.

 

I am unsure how to script the voucher discount to read the discount entered by the customer in the form.

[margaux]

You can use the variable you created from $_GET, although you might want to do some validation on it first.

 SELECT discount_amount FROM discount_codes WHERE discount_code = '$vouchercode';

[newbie_kerry]

SELECT

[margaux]

This is a bit confusing. What is the tablename? Your select statement should be in the format of

SELECT columnname FROM tablename WHERE columnname = '$variable' 

Assuming your table is named discount_codes and the column is named vouchercode...

SELECT discount_amount FROM discount_codes WHERE vouchercode = '$vouchercode'

Run your mysql statements in something like phpmyadmin and if it doesn't work it will give you a message to indicate where the error is. Then in your posts you can be more specific rather than just stating it doesn't work, which doesn't actually give any information.

 

I would recommend reading chap 5 and chap 8.

[newbie_kerry]

$q = "SELECT discount_amount FROM discount_codes WHERE vouchercode = '$vouchercode'";