how to update multiple records????

derksj

I have the next textboxes
the boxes get data from a database
I want to be able to update the data
bud how to update multiple records????

$sql = "UPDATE tblcoordinatoren SET naam='$naam',afdeling='$afdeling',telefoon='$telefoon',divisieID='$divisie' WHERE ID = $ID";
$result = mysql_Query($sql);

does anyone have a clue

anthill

yeah, what you've dones is fine:

$sql = "UPDATE tblcoordinatoren SET naam='$naam', afdeling='$afdeling', telefoon='$telef
oon', divisieID='$divisie' WHERE ID = '$ID'"; 
$result = mysql_Query($sql);

try outputting echo mysql_error(); to see where you are going wrong.

You may have just made a spelling mistake or something.

Ant

derksj

How should i update these data
should i use an array or something and how does that work

$result = mysql_query("SELECT divisie.divisie,
tblcoordinatoren.naam,
tblcoordinatoren.ID,
tblcoordinatoren.afdeling,
tblcoordinatoren.telefoon
FROM tblcoordinatoren
INNER JOIN divisie ON (tblcoordinatoren.divisieID = divisie.divisieID) Order by divisie");

while ($myrow = mysql_fetch_array($result))
{

}

echo "</td>\n";
echo "</tr>\n";

mogster

Hmmm... as far as I remember, you need an AND between each:

$sql = "UPDATE tblcoordinatoren SET naam='$naam' AND afdeling='$afdeling' AND telefoon='$telef
oon' AND divisieID='$divisie' WHERE ID = $ID";

But I've made functions to do this:

## Update field ##
function updateField ($id, $field, $value) {
$sqlObj = mysql_query("update field set $field = $value where id = $id");
}
## Call varchar/text ##
updateField($id, fieldname, "'".$data."'");
## Call int (number) ##
updateField($id, fieldname, $number);

knutm