Checkbox and mysql!

Anon

OK, i'm trying to list rows from a database and have checkboxes with each of the name thats in the database..so i can check the name to delete or change or whatever!
ok, the name of the checkbox must be the ID number from the database query right?
so..where is that id?...do i have to make a column for the id?...
isn't this the best way of doing this?

suggestions are appreciated!

Thanx!

Anon

You should create your database tables with a primary key (usually an auto increment field in mysql) this field will hold your unique identifier for each of your rows in that table.

If you don't already have one in your table you can create it and update the entire table setting that field = 0. Your data won't be in any particular order, but they will all get unique id's.

Once you have the ID's you can do whatever you want to make the page work. You could use simple <a href> tags sending the id and the action as a get, or use a form holding the actions you want to perform. I'd recommend that you don't use check boxes for update/delete since they are mutually exclusive operations, radio buttons would be better.

arnihr

Well... íslenskur? 🙂

Tell what you're doing with the checkboxes, mark them so things can be deleted or what?

If so...
I'm guessing you got an ID for each row, auto_increment column for that ID,...

Let us talk better when I got more detail on this checkbox thingy of yours 🙂

Anon

Here is what i do:

// On the first page...
// Query database
$sQuery = "select id, namn from product";
$hResult = mysql_query( $sQuery, $dbhMysql );

// Generate checkboxes
while( list($sID, $sNamn) = mysql_fetch_array($hResult) )
{
echo "<input type='checkbox' name='DeleteProducts[]' value='$sID'>$sNamn <br>";
}

// On the receiveing page:

// Construct a commaseparated list of ids
$csvID = "'" . implode( "','", $DeleteProducts ) . "'";

$sQuery = "delete from products where id IN($csvID)";
mysql_query( $csvID, $dbhMysql );

Anon

ok..i think that i want to know now is ....
do i have to add a column to my table that holds the id information?!? and have a primary key on that column?...
then what kind of a column is the id column supposed to be?!

Thanx!!
Pall