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? Quote Link to comment 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`... Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.