[Resolved] Dynamic checkboxes

[philippeguerind]

Hi from France,
I'm a beginer and I use the following code to dynamically create a table :
html code :
<table border="1" align="center" cellpadding="2" cellspacing="4" bgcolor="#FFFFFF" bordercolor="#808000" background="images/back.gif" rules="...............more

<?php
more code ...

$result = mysql_query($query)	or die("Impossible d'exécuter la requête : " . mysql_error());
$num_results = mysql_num_rows($result); 	
$typedate = mysql_field_name($result, 7);

}

while ($cols=mysql_fetch_array($result, MYSQL_ASSOC)) 
{ 
	print "<tr bgcolor='#FFFF99'>\n"; 
	foreach($cols as $value) 
    { 
 		print "\t<td nowrap style='font-size:10pt'>" . $value . "</td>\n"; 
	} 

	 print "</tr>\n"; 
} 

print "</table>"; 

I would like to dynamicaly create a checkbox into a cell to permit edition of a record in another page if it is checked. A field "numero" is used into the request and is the primary key (auto-incremented) of the table.

I searched into the forum for help but I didn't find the right code.
Any help would be apreciate.
If my english is not smart enough, perhaps there will be somewhere a french speeking member to help me.
Thank's
Philippe

[bad76]

Hi,
You can do just a little change:

 
while ($cols=mysql_fetch_array($result, MYSQL_ASSOC)) 
{ 
print "<tr bgcolor='#FFFF99'>\n"; 
foreach($cols as $value) 
{ 
print "\t<td nowrap style='font-size:10pt'><a href='edit.php?id=$value>'" . $value . "</a></td>\n"; 
} 

print "</tr>\n"; 
} 

Where edit.php is your page to edit.

This will work better if you access row value with $cols["name of filed"] instead of foreach()...

see you

[philippeguerind]

Thank's a lot, it works.
Philippe
😉