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
".$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");
//
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
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
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
[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
6 matches
Mail list logo