Checkbox for changig value of column value

flashmxfreak

I try to make a guestbook.
I need to change value of column "isAproved" in table guestbook from NO to YES.

I suppose I must:
1. Call records of table "guestbook" and add checkbox to every record.
The checkbox will have the value "unchecked".
Than I will check the entries, which I aprove and send values of the form to the dtb.

Thanks for any help.

Houdini

You would do better to use a radio button only on of the two may be selected. Then is $POST['yes'} is set it will perform the action. With checkboxes you can check none or one oras many as desired but with a readio button only one may be selected.

<input name = 'update' type = 'radio' value = 'yes'>Yes
<input name = 'update' type = 'radio' value= 'no'>No

That will show two buttons one that says Yes and one that says No if you check Yes and change your mind and click No then the tick in Yes wil disappear and the No will now be ticked. The value will be $_POST['update'] which would equal a value of no.

flashmxfreak

Thanks Houdini - good idea.
And what about get the recordset of my "guestbook" table of "isAproved" column.

Houdini

How does your query for that table go. If you were to post the query then maybe you could find someone with a solution. State just what you are trying to achieve with your query and any conditions that you might want along with the query.

flashmxfreak

I have this code:

$sql = "select isAproved,gflash from guestbook where isAproved like 'NO'";
 $r = mysql_query($sql);
 // loop condition
 if(!mysql_num_rows($r))
 break; // empty table
// loop all not aproved post 
 while($z = mysql_fetch_row($r))
{
 foreach ($z as $val)
 echo $val;
 // table with column of 2 radio btns with value of NO and YES, than column with gflash records here
 }

I don´t know how to generate table with 2 radio btns one with value YES and second is the record of column 'isAproved'. Than I need next column with record of column 'gflash'.

Than can user choose wich row will be aproved over the radio btn with value of YES and the data will be sent back to the dtb.

Thank you

flashmxfreak

I replaced the code and I can get the values:

<?php

$dbc = mysql_connect("localhost","xxx","xxx");
 mysql_select_db("xxx") or die(mysql_error("Couldn't select to DB"));
 $sql = "select isAproved,gflash from guestbook where isAproved like 'NO'";
 $r = mysql_query($sql);
 // loop condition
 if(!mysql_num_rows($r))
 {
 echo "No records found";
 // empty table
 }
 else
 {
// loop all not aproved post 
// while($z = mysql_fetch_row($r))
while($record = mysql_fetch_row($r))
	{
// foreach ($z as $val)
 echo $record[0];
 echo $record[1];
 //<div>$val</div>
 	}
 }


?>

Now I need only to create radio for each record to have possibility to change VALUE of record from column isAproved default NO -> YES.