Det er så her jeg lister medlemmer, for at vælge en der skal redigeres:
<? if(is_array($_POST['valg']))
{
foreach( $_POST['valg'] as $_POST['key'] => $_POST['val'] )
{
if($_POST['val']=="ja")
{
$insertSQL = "update medlem set status = '1',sletdato=now() where id='".$_POST['key']."'";
mysql_query($insertSQL)or die (mysql_error());
}
}
}
?>
<form action="<? $php_self ?>" method="post">
<div align="left">
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td bgcolor="#cccccc">
<table border="0" cellpadding="3" cellspacing="1">
<tr bgcolor="#FFE4B5">
<td >Slet</td>
<td >Dato</td>
<td >Navn</td>
<td >Telefon</td>
<td >Træffetid</td>
<td >Brev.nr.</td>
<td >Notat</td>
</tr>
<? $q = "SELECT *,date_format(dato,'%d-%m-%y') as dto FROM medlem where brugerId='".$_POST['brugerId']."' and status != '1' order by `dato` DESC ";
$r = mysql_query( $q ) or die(mysql_error());
while( $row = mysql_fetch_array($r) )
{
if($row[Status]==2){
$bgcolor = $color++%2?"F5F5F5":"e9e9e9";
echo " <tr bgcolor=\"#$bgcolor\">\n";
echo " <td valign=\"top\"><INPUT TYPE=\"checkbox\" NAME=\"valg[$row[id]]\" VALUE=\"ja\"></td>\n";
echo " <td valign=\"top\"><font color=\"red\">$row[dato]</font></td>\n";
echo " <td valign=\"top\"><font color=\"red\"><a href =\"index.php?id=$row[id]&nx=medlemmer/editMedlem
\">$row[navn]</a></font></td>\n";
echo " <td valign=\"top\"><font color=\"red\">$row[tlf]</font></td>\n";
echo " <td valign=\"top\"><font color=\"red\">$row[data1]</font></td>\n";
echo " </tr>\n";
}
Herunder er koden der skulle hente medlemmerne ind i formen så jeg kan rette medlems data (formen er "klippet over på midten"):
<? if($_POST['task']=="ok") {
$insertSQL = "UPDATE medlem set navn='{$_POST['navn']}', efternavn='{$_POST['efternavn']}', tlf='{$_POST['tlf']}', mobil='{$_POST['mobil']}', email='{$_POST['email']}', data1='{$_POST['data1']}', data2='{$_POST['data2']}', postnr='{$_POST['postnr']}' where id='{$_GET['id']}'";
mysql_query($insertSQL) or die(mysql_error());
header("location: index.php?nx=system/listeMedlemmer");
}
$result = mysql_query("SELECT DATE_FORMAT(dato,'%d-%m-%Y')as dto,navn,efternavn,tlf,mobil,email,data1,data2,postnr FROM medlem where id='{$_GET['id']}' ")or die (mysql_error());
{
?>
<form action="<? $php_self ?>" method="post">
<div align="left">
<input type="hidden" name="task" value="ok">
<table width="64" border="0" cellspacing="0" cellpadding="1">
<tr>
<td bgcolor="silver">
<table width="274" border="0" cellspacing="1" cellpadding="2" bgcolor="#f5f5f5">
<tr>
<td colspan="3" bgcolor="black"><b>
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr height="16">
<td height="16"><b><font color="white">REDIGERE KUNDE EMNE</font></b></td>
</tr>
</table>
</b></td>
</tr>
<tr>
<td colspan="3"><img src="../../billeder/Spacer.gif" alt="" height="1" width="1" border="0"></td>
</tr>
<tr>
<td><img src="../../Spacer.gif" alt="" height="5" width="1" border="0"></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Navn:</td>
<td><font color="red">*</font></td>
<td><input type="text" name="navn" value="<? $row[navn] ?>" size="24" border="0"></td>
</tr>
<tr>
