[SOLVED] Order form

[MrBillybob]

when ever i have an order form if someone presses add cart then presses refresh it will add 2...how do i fix this?

[nathanmaxsonadil]

you check to see if it's in the database

[Fadion]

U could give some more details. Im assuming u have an input and submit in a form. If yes then when hitting refresh, if used post then it will ask to resend the information again and with get it will just run the same url. One idea may be to redirect to the same page just to clear post or get data.

[MrBillybob]

its a get and i dont want to have to redirect how do i clear the get?

[nathanmaxsonadil]

here is where you would check if there is already a entry

$doublecheck = "SELECT * FROM table WHERE name = "{$_POST['name']}";
if(mysql_num_rows($doublecheck) == 0){
// put your code to enter into the database here
}
}

[MrBillybob]

thx

 

[nathanmaxsonadil]

lol this won't work

change this

$doublecheck = "SELECT * FROM table WHERE name = "{$_POST['name']}";
if(mysql_num_rows($doublecheck) == 0){
// put your code to enter into the database here
}
}

 

to

$doublecheck = mysql_query("SELECT * FROM table WHERE name = "{$_POST['name']}");
if(mysql_num_rows($doublecheck) == 0){
// put your code to enter into the database here
}
}