Help with an update query

[nielsplus]

Hi everybody i need your help .....again.

I have a table of users.
i type a number of a user in a text field and the data of the users apears in different textfields. (this is no problem)

Now i want to be able to change the data in the textfield.
But i have tried and tried but my update query wont work.

See the code...

thnx

<?

echo"
<form method='post' action='Leden_wijzig.php'>
<input name='Zoek' type='text' id='Zoek' value='' size='10' maxlength='10'>
<input type='Submit' name='submit' value='Zoek'>
</form>"
?>
<?
$conn = mysql_connect("localhost", "mim", "mim123")
or die("Kan geen verbinding maken.");
/ Database selecteren /
$selected = mysql_select_db("mim", $conn)
or die("Fout, geen database gevonden.");

if ($POST[Zoek])
{

$Zoek = addslashes ($POST[Zoek]);
$sql_weerg = mysql_query("SELECT * FROM Leden WHERE Lid_id = '$Zoek'");
if(empty($sql_weerg))
{
echo 'Geen geldig lid nummer, probeer het nog een keer ';

}
else
{ $num = mysql_num_rows($sql_weerg);

				for ($j=0; $j < $num; $j++) 

{
$r = mysql_fetch_array($sql_weerg);
$db_Lid_id = $r['Lid_id'];
$db_Achternaam = $r['Achternaam'];
$db_Tussenvoegsel = $r['Tussenvoegsel'];
$db_Voornaam = $r['Voornaam'];
$db_Adres = $r['Adres'];
$db_Postcode = $r['Postcode'];
$db_Woonplaats = $r['Woonplaats'];
$db_Geslacht = $r['Geslacht'];
$db_Geboorte_datum = $r['Geboorte_datum'];
$db_Telefoonnummer = $r['Telefoonnummer'];
$db_Emailadresuit = $r['Emailadresuit'];
$db_Password = $r['Password']

?>
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr class="text">
<td width="20%">Lid nummer:</td>
<td width="83%">
<input name="Lidnummer" type="text" id="Lidnummer" value=" <?=$db_Lid_id;?>" size="5" readonly="true">
<tr class="text">
<td width="17%">Achternaam:</td>
<td width="83%">
<input name="Achternaam" type="text" id="Achternaam" value="<?=$db_Achternaam;?>" size="50" maxlength="50">
</td>
</tr>
<tr class="text">
<td width="17%">Tussenvoegsel:</td>
<td> <input name="Tussenvoegsel" type="text" id="Tussenvoegsel" value="<?=$db_Tussenvoegsel;?>" size="20" maxlength="20">
</td>
</tr>
<tr class="text">
<td width="17%">Voornaam:</td>
<td> <input name="Voornaam" type="text" id="Voornaam" value="<?=$db_Voornaam;?>" size="50" maxlength="50">
</td>
</tr>
<tr class="text">
<td width="17%">Adres:</td>
<td> <input name="Adres" type="text" id="Adres" value="<?=$db_Adres;?>" size="50" maxlength="50">
</td>
</tr>
<tr class="text">
<td width="17%">Postcode:</td>
<td> <input name="Postcode" type="text" id="Postcode" value="<?=$db_Postcode;?>" size="6" maxlength="6">
</td>
</tr>
<tr class="text">
<td width="17%" height="18">Woonplaats:</td>
<td> <input name="Woonplaats" type="text" id="Woonplaats" value="<?=$db_Woonplaats;?>" size="50" maxlength="50">
</td>
</tr>
<tr class="text">
<td width="17%" height="20">Geslacht:</td>
<td> <input name="Geslacht" type="text" id="Geslacht" value="<?=$db_Geslacht;?>" size="1" maxlength="1">
</td>
</tr>
<tr class="text">
<td width="17%" height="19">Geboortedatum:</td>
<td> <input name="Geboortedatum" type="text" id="Geboortedatum" value="<?=$db_Geboorte_datum;?>" size="12" maxlength="10">
</td>
</tr>
<tr class="text">
<?
}
}
}
?>

[scoppc]

I dunno whether I have mistakenly read your code but I just cant see any FORM tag on your edit table. It should be enclosed by FORM.

The input will be submitted to a file to be processed.

[bad76]

Hi,
I think you must insert the table of data in a new form, with an action like "updatedb.php". The updatedb.php is a page that receive all field and make an sql like this:

"UPDATE tavola SET fieldname1='fieldvalue1', fieldname1='fieldvalue1', ... WHERE Lid_id='idvalue'"

see you

[nielsplus]

oke bad 76

but how do is send the updated data to another.php.
?

thnx

[bad76]

Just do it:

<form method=post action="update.php">
<input name=field1> <-- it's important the name...
<input name=field2>

and other form tag. (Put your <table> code here.)
<input type="submit">
</form>

When you "submit" this form call "update.php" that can access to variables called $field1, $field2 as you write in name tag.

Then work on it.

[nielsplus]

I see wat u mean but wat i dont get is this

Here is wat i used to fill the field

---

<input name="zipcode" type="text" id="zipcode"

value="<?=$db_Postcode;?>" >

if i use form method can i use it like this
(changed the (") into (')
wont that send the old value?

---

<form method=post action='update.php'>
<input name='zipcode' type='text' id='zipcode'

value='<?=$db_Postcode;?>' >

thnx

[bad76]

😕
sorry, don't understand these words
"if i use form method can i use it like this
(changed the (") into (')
wont that send the old value?" ...

But look this:

"updform.php"

//make connection, get row, then:
<form method=post action='updateit.php'> 
<input name='zipcode' type='text' id='zipcode' 
value='<?=$db_Postcode;?>' > 
<input type=submit>
</form>

"updateit.php"

<? //make connection, then:
mysql_query("
UPDATE mytable SET zipcode='$zipcode'");
?>
<h1> Yes Joe, you've updated </h1>
<small><a href="index.hmtl">back to home</a></small>

I hope this help you

[scoppc]

You can still use double quotes with FORM tag coz whether or not the value will be there is dependant on the field itself. Is it blank or not.

[nielsplus]

thnx bad76 and scoppc (php psycho LOL)

IT WORKEd YEEEEEEEEEEEEEEEHAAAA

thnx again!!!