Here is the code itself:

<?php // Соединиться с сервером БД mysql_connect("localhost", "root", "") or die (mysql_error ()); // Выбрать БД mysql_select_db("poliklinika") or die(mysql_error()); // Получить данные из БД, в зависимости от значения id в URL $strSQL = "SELECT * FROM `cms_patients` WHERE `PatientID` LIKE 1"; $rs = mysql_query($strSQL); while($row = mysql_fetch_array($rs)) { // Записать данные человека echo "<form name='forma' method='POST' action=".$_PHP_SELF."> <div> <input type='text' name='LastName' placeholder='Фамилия' value='$row[LastName]'> <input type='text' name='FirstName' placeholder='Имя' value='$row[FirstName]'> <input name='update' type='submit' id='update' value='Update'> </div> </form>"; } ?> <?php if(isset($_POST['update'])) { $link = mysql_connect("localhost", "root", "", "poliklinika"); $sql = mysql_query("UPDATE cms_patients SET FirstName = '$row[FirstName]', LastName = '$row[LastName]' WHERE PatientID = 1"); $retval = mysql_query( $sql, $link); if(! $retval ) { die('Could not update data: ' . mysql_error()); } echo "Updated data successfully\n"; } ?>

Displays error:

Could not update data: Query was empty

Not strong, help I do not know how to be.

    2 answers 2

     <?php $connection = mysql_connect("localhost","root",""); if (!$connection) { die('Не подключился : ' . mysql_error()); } else{ $db_name = "poliklinika"; mysql_select_db($db_name, $connection); if(isset($_POST['submit'])){ if($_POST['LastName']!="" && $_POST['FirstName']!="" && $_POST['MidName']!=""){ $update_sql = "UPDATE cms_patients SET LastName='".$_POST['LastName']."', FirstName='".$_POST['FirstName']."', MidName='".$_POST['MidName']."' WHERE PatientID=1;"; mysql_query($update_sql, $connection); echo "Данные пациента обновлены"; } } } ?>

    So solved my problem

       $sql = mysql_query("UPDATE cms_patients SET FirstName = '$firstname', LastName = '$lastname' WHERE PatientID = 1");

      Ps. mysql_query is an obsolete function, read about mysqli and PDO

      • The error disappeared, but now another error, updated the record. As I understand it, he cannot find what to update - reddyk