RE: [PHP] Re: deleting a record.

2002-11-26 Thread Peter Houchin
Thanks Kyle, got it working like a treat :) for some reason it wasn't selecting the DB but it is now :D > -Original Message- > From: Kyle Gibson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 27 November 2002 10:05 AM > To: [EMAIL PROTECTED] > Subject: [PHP] R

[PHP] Re: deleting a record.

2002-11-26 Thread Kyle Gibson
".$myrow['id']."  ".$myrow['company'].""; printf("(DELETE)", $PHP_SELF, $myrow["id"]); }?> There's an easier way to display this. It should make your life easier...made mine. Take a look: // get the list of resellers from the db $res = mysql_query("SELECT * FROM resellers ORDER BY id"); //

[PHP] RE: Deleting a Record

2002-03-06 Thread Chuck \"PUP\" Payne
Thanks I have now five ways to try. | Chuck Payne | | Magi Design and Support | | [EMAIL PROTECTED] | -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 10:43 AM To

[PHP] Re: Deleting a Record

2002-03-06 Thread Paul DuBois
At 7:46 -0500 3/6/02, Chuck \"PUP\" Payne wrote: >Hi, > >I a seting up a php page that will let me delete a record from my mysql >database, but I want it be able to match to fields before it will let a user >delete that record. I know the basic sql command is > >DELETE FROM $table WHERE field

[PHP] Re: Deleting a Record

2002-03-06 Thread Julio Nobrega Trabalhando
First of all, make a copy of your database to test things. Never test code on production enviroment. Then, the delete syntax most of the time is: DELETE FROM table_name WHERE column = 'value'; Let's see: There isn't a space between field and 1, at least I don't think SQL compliant

[PHP] Re: Deleting a Record

2002-03-06 Thread Henrik Hansen
[EMAIL PROTECTED] (Chuck \"Pup\" Payne) wrote: > Hi, > > I a seting up a php page that will let me delete a record from my mysql > database, but I want it be able to match to fields before it will let a user > delete that record. I know the basic sql command is > > DELETE FROM $table WHE