problem with mysqli access to mysql

problem with mysqli access to mysql, not possible to use DELETE (6 Replies, Read 15144 times)

mvvv	October 4, 2012, 11:01 am
Group: Member Post Group: Newbie Posts: 5 Status:	I can open a mysql DB table from php anbd run INSERT and SELECT queries on it with mysqli but somehow the damned library returns a syntax error on a DELETE query where as far as I can tell there is none. Very strange.... 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 'DETELE FROM ww1vars WHERE varname='lastName'' at line 1 Obviously I tried to reformat the query, ran even without the WHERE clause, nothing works. When I run this from the phpmyadmin or from the mysql prompt there is no problem. I also checked carefully if the user has DELETE permissions: it should have all permissions. This is also confirmed by logging into mysql as the user and doing the DELETE query succesfully. I am getting very frustrated,. Any suggestion would be very welcome.
IP: --

Users viewing this topic
	1 guests, 0 users.