[PHP] Re: deleting a record.

? // get the list of resellers from the db $res = mysql_query(SELECT * FROM resellers ORDER BY id); // print all records in the DB while ($myrow = mysql_fetch_array($res)){ echo trtddiv align='center'font class=\content\.$myrow['id']./font/div /tdtdnbsp;/tdtddiv align='justify'font

RE: [PHP] Re: deleting a record.

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] Re: deleting a record

[PHP] Re: Deleting a Record

[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 WHERE field

[PHP] Re: Deleting a Record

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: ?php $table = 'table_name'; $value = '15'; $sql = DELETE FROM $table WHERE

[PHP] Re: Deleting a Record

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

[PHP] RE: Deleting a Record

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