delete statement problem
am 07.06.2006 23:49:50 von Ian Davies
I am using a simple delete statement in my php script (below)
$q = "DELETE FROM commenttype WHERE TypeID=".$_POST['selectcat'];
the problem is it doesnt delete the whole row it only deletes the text in
one of the fields of the row. Has anyone else had a similar problem?
It works when I run the sql directly from a program such as mysqlphp
ian
Re: delete statement problem
am 07.06.2006 23:55:05 von Ian Davies
please ignore
Ive sorted it
ian
"Ian Davies" wrote in message
news:2SHhg.15450$x53.7020@newsfe1-win.ntli.net...
> I am using a simple delete statement in my php script (below)
>
> $q = "DELETE FROM commenttype WHERE TypeID=".$_POST['selectcat'];
>
> the problem is it doesnt delete the whole row it only deletes the text in
> one of the fields of the row. Has anyone else had a similar problem?
> It works when I run the sql directly from a program such as mysqlphp
>
> ian
>
>
Re: delete statement problem
am 07.06.2006 23:55:05 von Ian Davies
please ignore
Ive sorted it
ian
"Ian Davies" wrote in message
news:2SHhg.15450$x53.7020@newsfe1-win.ntli.net...
> I am using a simple delete statement in my php script (below)
>
> $q = "DELETE FROM commenttype WHERE TypeID=".$_POST['selectcat'];
>
> the problem is it doesnt delete the whole row it only deletes the text in
> one of the fields of the row. Has anyone else had a similar problem?
> It works when I run the sql directly from a program such as mysqlphp
>
> ian
>
>
Re: delete statement problem
am 07.06.2006 23:55:05 von Ian Davies
please ignore
Ive sorted it
ian
"Ian Davies" wrote in message
news:2SHhg.15450$x53.7020@newsfe1-win.ntli.net...
> I am using a simple delete statement in my php script (below)
>
> $q = "DELETE FROM commenttype WHERE TypeID=".$_POST['selectcat'];
>
> the problem is it doesnt delete the whole row it only deletes the text in
> one of the fields of the row. Has anyone else had a similar problem?
> It works when I run the sql directly from a program such as mysqlphp
>
> ian
>
>
Re: delete statement problem
am 07.06.2006 23:55:05 von Ian Davies
please ignore
Ive sorted it
ian
"Ian Davies" wrote in message
news:2SHhg.15450$x53.7020@newsfe1-win.ntli.net...
> I am using a simple delete statement in my php script (below)
>
> $q = "DELETE FROM commenttype WHERE TypeID=".$_POST['selectcat'];
>
> the problem is it doesnt delete the whole row it only deletes the text in
> one of the fields of the row. Has anyone else had a similar problem?
> It works when I run the sql directly from a program such as mysqlphp
>
> ian
>
>