a href in sql table<

This sql table:
<!-- m --><a class="postlink" href="http://members.lycos.nl/bexys/club_wijzigen_go.php">http://members.lycos.nl/bexys/club_wijzigen_go.php</a><!-- m -->
is created to do a online update.
Click on a ID to change the content.
But.... the Meer_info stays empty after Update.
Thought is was the link in the td, but Fragment has a link to.

If i use the Lycos My_admin no problem to update.

How to solve this problem?

:cool:

///edit
this
<!-- m --><a class="postlink" href="http://members.lycos.nl/bexys/club.php">http://members.lycos.nl/bexys/club.php</a><!-- m -->
is the file to be used in the sitehow are you inserting/updating the table? what is the code?The code

<h3>Pas de gegevens aan, of verwijder het record.</h3>
<br><br>
<?php
require("base.php");
import_request_variables("g","my_");
$id=$my_id;
$dbh=mysql_connect("$dbhost","$dbuser","$dbpass");
if (!$dbh) {
echo "<br><br>";
echo "<font color=\"#FF0000\"> ERROR ! Ik kan geen verbinding maken met de $db database.</font><br>\n";
echo "</body></html>";
exit;
}
$res=mysql_db_query("$db","select * from club where id='$id';",$dbh);
$fout=mysql_errno($dbh);
if ($fout != 0) {
$fout=mysql_error($dbh);
echo "<font color=\#FF0000\">$fout</font>";
mysql_close($dbh);
echo "</body></html>";
exit;
}
$aantal_lijnen=mysql_num_rows($res);
for($i=0;$i<$aantal_lijnen;$i++) {
$row=mysql_fetch_row($res);
}
?>
<form action="club-update-of-weg.php" method="POST">
<table>
<tr><td valign=top><b>Id</b></td><td><font size="4" color="#FA0D31"><b><?php echo $id ?></b></font></td></tr>
<tr><td valign=top><b>Label</b></td><td><input type="text" name="Label" value="<?php echo $row[1]; ?>"></td></tr>
<tr><td valign=top><b>Artiest</b></td><td><input type="text" name="Artiest" value="<?php echo $row[2] ?>"></td></tr>
<tr><td valign=top><b>Titel</b></td><td><input type="text" name="Titel" value="<?php echo $row[3] ?>"></td></tr>
<tr><td valign=top><b>Prijs</b></td><td><input type="text" name="Prijs" value="<?php echo $row[4] ?>"></td></tr>
<tr><td valign=top><b>Fragment</b></td><td><input type="text" name="Fragment" value="<?php echo $row[5] ?>"></td></tr>
<tr><td valign=top><b>Meer_info</b></td><td><input type="text" name="meer_info" value="<?php echo $row[6] ?>"></td></tr>
<tr><td valign=top><b>Informatie</b></td><td><input type="text" name="Informatie" value="<?php echo $row[7] ?>"></td></tr>
<tr><td><input type="hidden" name="id" value="<?php echo $row[0] ?>"></td><td> </td></tr>
<tr><td> </td><td> </td></tr>
<tr><td><input name="update" value="Update" type="submit"></td><td><input name="wissen" value="Verwijderen" type="submit"></td></tr>
</form>
<br>



:cool:It was a typo on this line:
<input type="text" name="meer_info" value="<?php echo $row[6] ?>">

changed in
<input type="text" name="Meer_info" value="<?php echo $row[6] ?>">

Think i will skip the Uppercase in the future ;)

thx

:cool:
 
Back
Top