Re: Deleting a Record.
From: Rob (talon2lm_at_yahoo.com)
Date: 11/24/03
- Next message: Jochen Daum: "Re: Deleting a Record."
- Previous message: Jochen Daum: "Re: Deleting a Record."
- In reply to: Jochen Daum: "Re: Deleting a Record."
- Next in thread: Jochen Daum: "Re: Deleting a Record."
- Reply: Jochen Daum: "Re: Deleting a Record."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sun, 23 Nov 2003 20:03:46 -0700
Still nothing....
Not even an error message...
Thanks,
Rob
"Jochen Daum" <jochen.daum@cans.co.nz> wrote in message
news:86q2sv8ld0302f1rq9tj59ivsuf20po5m7@4ax.com...
> Hi Rob!
>
> On Sun, 23 Nov 2003 19:06:41 -0700, "Rob" <talon2lm@yahoo.com> wrote:
>
> >Thanks for the Help on the other problems...all resolved.
> >One last (hopefullly) problem I can't seem to get around for this
> >program...why isn't this deleting the row i want? It does nothing. Now
error
> >messages either. HELP!
> >
> >$link = mysql_connect("localhost");
> >if(! $link)
> > die("Could not connect to MySQL");
> >
> >$database = "PC_Store";
> >mysql_select_db($database)
> > or die ("could not open $database: ".mysql_error() );
> >
> >$result = mysql_query("DELETE FROM inventorydata VALUES('$ProductID')");
> >
> >The $ProductID variable is brought in from a menu choice on a diffrent
page,
> >it is also the primary of the table...so it should delete the whole row
> >right?
>
> Try
>
> "delete from inventorydata where field = '".$ProductID."'"
>
> Have a look at www.mysql.com for sql syntax
>
> HTH, Jochen
> --
> Jochen Daum - CANS Ltd.
> PHP DB Edit Toolkit -- PHP scripts for building
> database editing interfaces.
> http://sourceforge.net/projects/phpdbedittk/
- Next message: Jochen Daum: "Re: Deleting a Record."
- Previous message: Jochen Daum: "Re: Deleting a Record."
- In reply to: Jochen Daum: "Re: Deleting a Record."
- Next in thread: Jochen Daum: "Re: Deleting a Record."
- Reply: Jochen Daum: "Re: Deleting a Record."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
