Hi ... I´m writing a code in order to update daily activities, these activities are going to be saved in 3 daily records (depending of the schedule of workers and their session id´s). I´ve already got records registered in my DB ,but the problem comes when i´m trying to edit these records to add a new activity, it displays all records ok but when i choose one in order to edit it ,it displays and edit only the last one.
Can somebody help me?? Thanks ... This is the script i´m trying for : <html> <body> <?PHP $db = @mysql_connect("localhost", "root", "****"); mysql_select_db("bitacora",$db); if ($nombrebit) { if ($submit) { $sql = "UPDATE bitacora SET actividades='$actividades' WHERE nombrebit like '$nombrebit'"; $result = mysql_query($sql); echo " Informacion actualizada.\n"; } else { // query the DB $sql = "SELECT * FROM bitacora "; $result = mysql_query($sql); $myrow = mysql_fetch_array($result); ?> <table border = 0> <tr><td> <form method="post" action="<?php echo $PHP_SELF?>"> Usuario:</td><td><input type="Text" name="usuario" value="<?php echo $myrow["usuario"] ?>"></td></tr> <tr><td>Fecha:</td><td><input type="Text" name="fecha" value="<?php echo $myrow["fecha"] ?>"></td><tr> <tr><td> Actividades:</td><td> <textarea rows="12" cols="80" style="width:100%" name="actividades" class="postform"> <?php echo $myrow["actividades"] ?> </textarea> </td> </tr> <tr><td> Bitacora:</td><td><input type="Text" name="nombrebit" value="<?php echo $myrow["nombrebit"] ?>"></td></tr></table> <input type="Submit" name="submit" value="Agregar informacion"> </form> <?php } } else { // Despliega bitacoras $result = mysql_query("SELECT * FROM bitacora ",$db); while ($myrow = mysql_fetch_array($result)) { printf("<a href=\"%s?nombrebit=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["nombrebit"], $myrow["usuario"], $myrow["nombrebit"]); } } ?> </body> </html> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]