DaniWeb IT Discussion Community - updating records using php and mysql

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- PHP (http://www.daniweb.com/forums/forum17.html)

- - updating records using php and mysql (http://www.daniweb.com/forums/thread73172.html)

updating records using php and mysql

hi,

I am creating a form for user to update their details which is saved in the database. So far i can show their details in the form where i have a submit button but the updating part doesnt work(it doesnt update at all). here is the code:

<html>

<?php



session_start();



$host="localhost"; // Host name

$username="user"; // Mysql username

$password="123456"; // Mysql password

$db_name="db"; // Database name

$tbl_name="member"; // Table name



// Connect to server and select databse.

mysql_connect("$host", "$username", "$password")or die("cannot connect");

mysql_select_db("$db_name")or die("cannot select DB");  

    

    

$username = $_SESSION['myusername'];



if(!isset($_SESSION['myusername']))

        {

   header("location: main_login.php");

}

  else

{

        $query=" SELECT * FROM $tbl_name WHERE LoginName='$username'";

        $result=mysql_query($query);

        $num=mysql_numrows($result);

        mysql_close();



$i=0;

while ($i < $num) {

$phone=mysql_result($result,$i,"telephone");

$add=mysql_result($result,$i,"address");

$town=mysql_result($result,$i,"town");

$email=mysql_result($result,$i,"email");

$city=mysql_result($result,$i,"city");

$postcode=mysql_result($result,$i,"postcode");

++$i;

}

$u_phone=$_POST['phone'];

$u_add=$_POST['add'];

$u_town=$_POST['town'];

$u_city=$_POST['city'];

$u_postcode=$_POST['postcode'];

$u_email=$_POST['email'];





$query1="UPDATE $tbl_name SET memberNo = NULL, LoginName=NULL, title=NULL, firstName=NULL, lastName=NULL, gender= NULL, address='$u_add', town='$u_town', city='$u_city', postcode='$u_postcode', telephone='$u_phone',  email='$u_email', mshipType = NULL";

mysql_query($query1);

echo "Record Updated";

mysql_close();

}

?>

<form action="changedetails.php" method="post">

<table>

<tr>

        <td>Phone Number :</td>

        <td><input type="text" name="phone" size="30" value="<?php echo $phone; ?>"></td>

</tr>

<tr>

        <td>Address :</td>

        <td><input type="text" name="add" size="30" value="<?php echo $add; ?>"></td>

</tr>

<tr>

        <td>Town :</td>

        <td><input type="text" name="town" size="30" value="<?php echo $town; ?>"></td>

</tr>

<tr>

        <td>City :</td>

        <td><input type="text" name="city" size="30" value="<?php echo $city; ?>"></td>

</tr>

<tr>

        <td>Post Code :</td>

        <td><input type="text" name="postcode" size="30" value="<?php echo $postcode; ?>"></td>

</tr>

<tr>

        <td>E-mail Address :</td>

        <td><input type="text" name="email" size="30" value="<?php echo $email; ?>" ></td>

</tr>

</table>



 <p>



<input type="Submit" value="Update">

<input type="Submit" value="Cancel">

</form>

</html>

here is the table:

CREATE TABLE Member(

 memberNo       INT(8) UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE,

 LoginName         VARCHAR(6)  NOT NULL UNIQUE,

 title          VARCHAR(5),

 firstName      VARCHAR(20) NOT NULL,

 lastName       VARCHAR(20) NOT NULL,

 gender         VARCHAR(6)  NOT NULL

                             CHECK(gender IN('MALE','FEMALE')),

 address        VARCHAR(30), 

 town           VARCHAR(20),

 city           VARCHAR(20),

 postcode       VARCHAR(8)  NOT NULL,

 telephone      INT(11),

 email          VARCHAR(50) NOT NULL,

 mshipType      VARCHAR(15) NOT NULL 

                             CHECK(mshipType IN('STUDENT','STAFF','ALUMNI')),

 password       VARCHAR(20) NOT NULL,

 PRIMARY KEY(memberNo)

);