PHP - Help Get Details From Sql Database Please

I have created a button which when pressed should present the user with their details (whoever is logged in), here is the form code:

<form id="form1" name="form1" method="post" action="getdetails.php">
 
  <input type="submit" name="Get Details" value="Get Details" />
   </label>
   
  </p>
</form>

Here is the getdetails.php file

<?php
 mysql_connect("localhost","root","");
 mysql_select_db("test");
 $username = $_POST['textfield'];
  echo '</br>';
 $query = mysql_query("SELECT * FROM membersdetails WHERE name=`$username` ");

while($result = mysql_fetch_array($query)) {
//display
echo $result['firstname'];
echo $result['surname'];
}
?>

Its not workin at all I have attacthed the error i am getting

Any help please?

Hello everyone, I am trying to have a function on my website where the administrator can add a new member to the database. Their details are to be stored in the table memberdetails, I have posted the code below, the error i recieve is "Error: Column count doesn't match value count at row 1"

Can anybody help me please?

form code:

<form action="insert.php" method="post">
Username: <input type="text" name="username" /><br><br>
Firstname: <input type="text" name="firstname" /><br><br>
Surname : <input type="text" name="surname" /><br><br>
Date Birth: <input type="text" name="dob" /><br><br>
Total Wins: <input type="text" name="wins" />
Total Loses: <input type="text" name="loses" /><br><br>
Email Add: <input type="text" name="email" /><br><br>
Country : <input type="text" name="born" /><br><br>
Other Info: <input type="text" name="other" /><br><br>
<input type="submit" name="Submit" value="Create" align="right"></td>
</form>


insert.php

<?php
mysql_connect ("localhost","root","")
or die("Cannot connect to Database");
mysql_select_db ("test");

$sql="INSERT INTO memberdetails (username, firstname, surname, dob, totalwins, totalloses, email, country, info)
VALUES
('$_POST[username]''$_POST[firstname]','$_POST[surname]','$_POST[wins]''$_POST[loses]''$_POST[email]''$_POST[born]''$_POST[other]''$_POST[dob]')";

if (!mysql_query($sql))
  {
 die('Error: ' . mysql_error());
  }
echo "1 record added";

?>

hi
i had database with field of name,title,post,content

i want to fetch the post and content for a specific user from giving name of that user by form help me to get that

ps just give me idea to how to do that/

Code: [Select]
<form id="form1" name="form1" method="post" action="view.php">
  <label>Name
  <input type="text" name="textfield" />
  </label>
  <p>
    <label>
    <input type="submit" name="Submit" value="Submit" />
    </label>
  </p>
</form>

Hi,

I have a form that allows a user to enter details and also to upload a image. The form works great and inserts into the database if i dont include the file input.

What i would like happen is:

The user enters details and selects a file

The file then gets uploaded to ../images and the path is then written to bedroom1 variable

The addresses and the bedroom1 variable that now holds the uploaded file path e.g. images/test.jpg is written to the database

Form
Code: [Select]
<form action="admin.php" method="POST">
   <table>
     <tr><td>
     Address 1:
</td><td>
     <input type="text" name="address1" id="address1" onfocus="selected(this)" onblur="notselected(this)">
</td><td>
     <div id="dynamicText1">
             </div>
</td></tr>

<tr><td>
     Address 2:
</td><td>
     <input type="text" name="address2" id="address2" onfocus="selected(this)" onblur="notselected(this)">
</td><td>
     <div id="dynamicText1">
             </div>
</td></tr>

<tr><td>
     County:
</td><td>
     <input type="text" name="county" id="county" onfocus="selected(this)" onblur="notselected(this)">
</td><td>
     <div id="dynamicText1">
             </div>
</td></tr>

<tr><td>
     Bedroom 1:
</td><td>
     <input type="file" name="bedroom1" id="bedroom1" input name="uploadedfile">
</td><td>
     <div id="dynamicText1">
             </div>
</td></tr>



<tr><td>
     <input type="submit" name="submitaddapartment" value="Add" id="registerbutton">
</td></tr>

   </table
           
        </form>

And the php code to add it to the database


Code: [Select]
<?php
  //get variables
  $submitaddapartment = $_POST['submitaddapartment'];
  $address1 = strip_tags($_POST['address1']);
  $address2 =  strip_tags($_POST['address2']);
  $county = strip_tags($_POST['county']);
  $bedroom1 = strip_tags($_POST['bedroom1']);
   
  
  

  if ($submitaddapartment) //if submit button was pressed
  {
    if ($address1&&$address2&&$county&&$bedroom1&&) //if fields arn't blank
    {
  include 'dbase.php'; //connect to database
  
  if ((($_FILES["bedroom1"]["type"] == "image/gif")
  || ($_FILES["bedroom1"]["type"] == "image/jpg")
  || ($_FILES["bedroom1"]["type"] == "image/pjpeg"))
  && ($_FILES["bedroom1"]["size"] < 20000000))
  {

  if ($_FILES["bedroom1"]["error"] > 0)
  {
  echo "Return Code: " . $_FILES["bedroom1"]["error"] . "<br />";
  }
  else
  {
  echo "Upload: " . $_FILES["bedroom1"]["name"] . "<br />";
  echo "Type: " . $_FILES["bedroom1"]["type"] . "<br />";
  echo "Size: " . ($_FILES["bedroom1"]["size"] / 1024) . " Kb<br />";
  echo "Temp file: " . $_FILES["bedroom1"]["tmp_name"] . "<br />";
  
  if (file_exists("../images/" . $_FILES["bedroom1"]["name"]))
      {
      echo $_FILES["bedroom1"]["name"] . " already exists. ";
      }
  else
      {
      move_uploaded_file($_FILES["bedroom1"]["tmp_name"],
      "/" . $_FILES["bedroom1"]["name"]);
      echo "Stored in: " . "../images/" . $_FILES["bedroom1"]["name"];
  $bedroom1=".'images/.' $_FILES["bedroom1"]["name"]";  
  }
  }
  }
  
  else
  {
  echo "Invalid file";
  }
  
  
  mysql_query ("INSERT INTO user VALUES(NULL,'$address1','$address2','$county','$bedroom1')");
          
    }
    else
    {
    }
  }    
  
?>
Any help would be greatly appreciated.

Thanks

Fred

Hi All,

I've searched long and hard accross the web for an answer to this and finnally given in and requesting help. Here's what i have, i have a database setup and working fine. What i would like to do is for an administrator to be able to update my users details. It may sound odd, why don't you let your users update their own details? Well the administrators are dispatchers if you like, and my users are the 'dispatchees', for want of a better word. So i would like my administrators to be able to dispatch my users with routes and my users be able to see the routes that have been dispatched to them. I've setup a login area and a page that pulls there routes off the database, depending on their login details, i.e. jack will see his routes and jill will see her's independantly. This works by me editing the appropriate columns/rows of my database using phpmyadmin. What i'd like now is for administrators (who are directed to a seperate page, with more controls) to be able to do the same as me (updating the database) but by using a php form/script.

I'd like to be able to select the routes from a second table on the same database if possible, to try and keep everything tidy. So my dispatcher would select Route001 from a drop down list, this would fill in the text fields next to the route field with From To, so my dispatcher would know what route001 actually is from/ too, choose a username (now being driven from my other table) and hit dispatch. My user would login to their area, hit view dispatched routes and it would display Route 001 with the correct information.

The login area was a downloaded script i modified to suit and is called Login-Redirect_v1.31_FULL

Many thanks in advance, hope you can sort of understand what i want 

Josh

PHP/MySQL ability:Novice