getting data twice in array

[murli800]

My aim is to make an enquiry form and its database name is ashish and table name is mydata...everytime i am inserting data and then displaying it on the browser with the use of print_r getting each input data twice...attacthing my code ..help me..thanx in advance

 

this file is form.php

<?php include("dbconnect.php");

        include("cwfunction.php")?>

 

<form name="form1" action="#" method="post">

      Name<input name="stuname" type="text" value=""><br/>

    Address<input name="address" type="text" value=""><br/>

    Contact<input name="contact" type="text" value=""><br/>

    Email<input name="email" type="text" value=""><br/>

    Internet<input name="how" type="radio" value="internet"><br/>

    Friend<input name="how" type="radio" value="friend"><br/>

    Other<input name="how" type="radio" value="other"><br/>

 

    <input name="submit" type="submit" value="ENTER"><br/>

</form>

<?php

/*

* To change this template, choose Tools | Templates

* and open the template in the editor.

*/

$stuname=$_POST['stuname'];

$address=$_POST['address'];

$contact=$_POST['contact'];

$email=$_POST['email'];

$how=$_POST['how'];

 

insert_data($stuname,$address,$contact,$email,$how,$connect);

display_data();

 

 

 

 

echo "<table border=1>";

    echo "<tr>";

        echo "<td>Sr.No</td>";

        echo "<td>Student Name</td>";

        echo "<td>Address</td>";

        echo "<td>Contact no</td>";

        echo "<td>email</td>";

        echo "<td>how</td>";

        echo "<td>edit</td>";

        echo "<td>delete</td>";

    echo "</tr>";

 

 

   

    echo "</table>";

 

?>

 

this file is dbconnect.php

<?php

/*

* To change this template, choose Tools | Templates

* and open the template in the editor.

*/

$connect=  mysql_connect("localhost","root","") or die("Connection Error".  mysql_error());

        //echo "connection established";

        if(mysql_select_db("ashish",$connect))

        {

            //echo "<br/>database selected";

        }

       

 

?>

 

 

this file is cwfunction.php

<?php

/*

* To change this template, choose Tools | Templates

* and open the template in the editor.

*/

function insert_data($stuname,$address,$contact,$email,$how,$connect)

{

  global $stuname;

    global $address;

    global $contact;

    global $email;

  global $how;

    global $connect;

 

    $query="INSERT INTO mydata(student_name,address,contact,email,how) VALUES('$stuname','$address','$contact','$email','$how')";

    $result=mysql_query($query,$connect);

}

 

function display_data()

{

    echo "i m in display data";

    $query="SELECT * FROM mydata";

    $result=mysql_query($query);

    $row = mysql_fetch_array($result);

    print_r($row);

//    if($result)

//    {

//        $arr = array();

//        while($row = mysql_fetch_array($result))

//        {

//            array_push($arr,$row);

//        }

//

//

//

//    }

 

    //return $arr;

}

 

 

[attachment deleted by admin]

[requinix]

Take a look at the manual page for mysql_fetch_array. Read the Return Values section very carefully.

 

Then pick a different mysql_fetch_* function, or deal with the array you have now differently.