delete statement problem

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
>
>