dan_c00per
04-10-2003, 02:28 PM
Hi,
I have written an online ordering system using PHP and MySQL, to deal with the problem of apostrophe's (') closing the SQL statement early, I used the addslashes() function, I am now writing an internal management system for the ordering system but cannot find an equivalent function, so if someone enters the name O'Brien for example, the ' closes the SQL statement early and the record is not saved properly.
Has anyone else come across this, how can I solve it?
I have written an online ordering system using PHP and MySQL, to deal with the problem of apostrophe's (') closing the SQL statement early, I used the addslashes() function, I am now writing an internal management system for the ordering system but cannot find an equivalent function, so if someone enters the name O'Brien for example, the ' closes the SQL statement early and the record is not saved properly.
Has anyone else come across this, how can I solve it?