grahamb314 Posted September 26, 2008 Share Posted September 26, 2008 Hi all, I have a small error on my php page Query: Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM `grahamb_test`.`booking` WHERE `confirmcode` = 'riyolafapa '' at line 1 from else {$sql2 = mysqli_query($mysqli, "DELETE * FROM `grahamb_test`.`booking` WHERE `confirmcode` = '{$_POST["confirmcode"]}'") or die("Query:{$query} Error:".mysqli_error($mysqli)); { any ideas? Link to comment https://forums.phpfreaks.com/topic/125988-solved-small-error-sql/ Share on other sites More sharing options...
peranha Posted September 26, 2008 Share Posted September 26, 2008 On delete statements, you dont use the *, just DELETE FROM `grahamb_test`... Link to comment https://forums.phpfreaks.com/topic/125988-solved-small-error-sql/#findComment-651508 Share on other sites More sharing options...
grahamb314 Posted September 26, 2008 Author Share Posted September 26, 2008 oh silly me, Thank you so much Link to comment https://forums.phpfreaks.com/topic/125988-solved-small-error-sql/#findComment-651512 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.