Hi.
I am having another issue with my MySQL database. I dont seem to be able to get form data to update the database. The form passes php variables using GET to an external edit file (edit.php). This file seems to be able to read the GET variables, but unable to pass on the data to the database.
The form can be found here, and the edit page [URL=“http://www.nardoo.co.uk/justfloating/edit.php”]here.
The code from the edit page (without my server details and user + pass or connect functions) is below:
//Define data variables
$username = $_GET['username'];
$userid = $_GET['uid'];
$name = $_GET['name'];
$aboutyou = $_GET['aboutyou'];
$doingnow = $_GET['doingnow'];
$location = $_GET['location'];
//Define SQL Action
$sql = 'UPDATE `nardooco_users`.`members` SET `name` = "$name", `doingnow` = "$doingnow", `aboutyou` = "$aboutyou", `flag` = "$flag" WHERE `members`.`id` = "$userid" LIMIT 1;';
//The following is to check the variables are being read
echo $username;
echo $doingnow;
echo $userid;
//End of Script
Any help would be greatly appreciated
