need a liitle help with this form and database

ok i have a form with 7 fields and a database with 8 fields
what i want to do is instead of peeps entering data in a 8th field on form
i want it to be a fixed text entry eg "pic0.jpeg" and then that will go to last field in database
hope you can understand what i am trying to do
this is the form

<form action="add.php" method="post">
<div id="info" style="width:360px;">

    <div align="left">
      <input type="text" name="name"> 
      <strong>Name:</strong>    <br>
      <br />
      <input type="text" name="username"> 
      <strong>Username:</strong>    <br>
      <br />
      <input type="text" name="password"> 
      <strong>Password:</strong>    <br> 
      <br />
      <input type="text" name = "email"> 
      <strong>Email      </strong><br>
      <br />
      <input type="text" name="parkname"> 
      <strong>Park Name:</strong>    <br>
      <br />
      <input type="text" name="parklocation"> 
      <strong>Park Location</strong>:
    <br>
      <br />
      <input type="text" name="caravandetails"> 
      <strong>Caravan Details</strong>:
    <p><strong>
    <br/>
      <input type="submit" value="submit"/> 
    </div>
</form>

HTML:

<?php 

//This gets all the other information from the form 
$name=$_POST['name'];
$username=$_POST['username'];
$password=$_POST['password'];
$email=$_POST['email']; 
$parkname=$_POST['parkname'];
$parklocation=$_POST['parklocation'];
$caravandetails=$_POST['caravandetails']; 
$pname=$_POST['pname'];
// Connects to your Database 
mysql_connect("s", "d", "s") or die(mysql_error()); 
mysql_select_db("u") or die(mysql_error()); 

//Writes the information to the database 
mysql_query("INSERT INTO `members` VALUES ('$name', '$username', '$password', '$email', '$parkname', '$parklocation', '$caravandetails', '$pname')"); 
 
		
?> 

PHP:

 

I think i know what you mean if i understand correctly you could simply just add a hidden input field e.g.

<form action="add.php" method="post">
<div id="info" style="width:360px;">

    <div align="left">
      <input type="hidden" name="pname" value="pic0.jpeg">
      <input type="text" name="name">
      <strong>Name:</strong>    <br>
      <br />
      <input type="text" name="username">
      <strong>Username:</strong>    <br>
      <br />
      <input type="text" name="password">
      <strong>Password:</strong>    <br>
      <br />
      <input type="text" name = "email">
      <strong>Email      </strong><br>
      <br />
      <input type="text" name="parkname">
      <strong>Park Name:</strong>    <br>
      <br />
      <input type="text" name="parklocation">
      <strong>Park Location</strong>:
    <br>
      <br />
      <input type="text" name="caravandetails">
      <strong>Caravan Details</strong>:
    <p><strong>
    <br/>
      <input type="submit" value="submit"/>
    </div>
</form>

Code (markup):

That would add pic0.jpeg in the last field of the table.

 

You need to look into securing that as well.

 

a big thanks worked a treat
when i have all running will then look at security
cheers
Doug