mysql - Updating a phpmyadmin table through Php using a url varible -
im having problem when trying implement edit page in php. getting items database doesent pose problem, yet trying update tells me have missed field , trying skip check leaves me unedited table. to explain more, there page directs 1 while passing on id (propertyid) veriable , use grab desired variables. can @ code , tell me have done wrong, have prevously got similar page working , getting quite flustered trying figure out why 1 isent. <?php // start sessions include('includes/security.inc.php'); authorise(); if (!isset($_get['propertyid']) || !is_numeric($_get['propertyid'])) { header('location:./houselist.php'); } else { // include connection file include('includes/connection.inc.php'); // details connect(); $propertyid = $_get['propertyid']; $sql = "select * properties propertyid='$propertyid' limit 1"; $result = @mysql_query($sql) or die('unable run query'); ...