Hi again.
I am now running the following: and it works fine.
my inc.php file
<?php
$server= "***********";
$user= "****";
$password= ""; / FTP-Password /
$database= "**"; / name of database /
$table= "******"; / Name of table, you can select that */
function clean($input, $maxlength)
{
$input = substr($input, 0, $maxlength);
$input = EscapeShellCmd($input);
return ($input);
}
?>
My-Your script
<html>
<head>
<title>AdultInfo4u.co.uk - escort listings - xxx galleries and more...</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="sites/newadultinfo/styles.css" type="text/css">
<script language="JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}}
}
//-->
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<script type='text/javascript'>
function Go(){return}
</script>
<script type='text/javascript' src='sites/newadultinfo/menu_var.js'></script>
<script type='text/javascript' src='sites/newadultinfo/menu_com.js'></script>
<noscript>Your browser does not support script</noscript>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="sites/newadultinfo/images/logo.gif" width="259" height="35"></td>
</tr>
<tr>
<td width="690" height="30" id="MenuPos" style="position:relative"></td>
</tr>
</table>
<table width="700" border="0" cellspacing="1" cellpadding="0" bgcolor="#000000">
<tr>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td align="center" valign="top">
<?
include 'inc.php';
include 'error.inc';
$link = mysql_connect($server, $user, $password);
mysql_select_db("db66511019", $link);
if (empty($page)) $page = "";
if ($page == "add") {
$query = "SELECT * FROM embassies WHERE country = 'finland'";
$result = mysql_query($query) or die("Query failed");
while ($i = mysql_fetch_array($result)) {
if ($user == $i[user]) {
echo "<font face=arial size=2>Username all ready in use</font>";
die;
}
}
echo "$result";
if (empty($user) || $user == "") {
echo "<font face=arial size=2>Bad Username</font>";
die;
}
if (empty($pass) || $pass == "") {
echo "<font face=arial size=2>Bad Password</font>";
die;
}
if (empty($email) || $email == "") {
echo "<font face=arial size=2>Bad E-Mail</font>";
die;
}
$time = time();
if ($file1_name != "") {
mkdir ("members/uploads/$time", 0777);
copy("$file1", "members/uploads/$time/$file1_name");
$pic = $url."/members/uploads/".$time."/".$file1_name;
}
}
$query = "INSERT INTO phpmeet (id, user, pass, name, email, country, location, city, rates, Description, height, stats, age, pic, imgname, imgtime) VALUES ('', '$user', '$pass', '$name', '$email', '$country', '$location', '$city', '$rates', $Description', '$height', '$stats', '$age', '$pic', '$file1_name', '$time')";
if (!mysql_query ($query, $connection) )
{
die (mysql_error());
}
echo "$result";
echo "<font face=arial size=2>Thank you for signing up<br><br><a href='search.php'>Search for that special someone.</a></font>";
echo "<form action=add.php?page=add method=post enctype=\"multipart/form-data\">";
echo "<table width=\"60%\" border=0 cellpadding=2 cellspacing=0 class=\"maintxt\"><tr>";
echo "<td width=\"36%\">Username:</td><td width=\"64%\">";
echo "<input type=text name=user value=\"$user\" maxlength=\"20\"></td></tr>";
echo "<tr><td>Password:</td><td><input type=password name=pass value=\"$pass\" maxlength=\"10\"></td></tr>";
echo "<tr><td>Name:</td><td><input type=text name=name value=\"$name\" maxlength=\"50\"></td></tr>";
echo "<tr><td>E-Mail:</td><td><input type=text name=email value=\"$email\" maxlength=\"70\"></td></tr>";
echo "<tr><td>Country</td><td><input type=text name=country value=\"$country\" maxlength=\"99\"></td></tr>";
echo "<tr><td>Location:</td><td><select name=\"location\"><option value=\"london\" selected>London</option>";
echo "<option value=\"north\">North</option><option value=\"northeast\">North East</option>";
echo "<option value=\"northwest\">North West</option><option value=\"eastmids\">East Midland</option>";
echo "<option value=\"westmids\">West Midlands</option><option value=\"south\">South</option>";
echo "<option value=\"southeast\">South East </option><option value=\"southwest\">South West</option>";
echo "<option value=\"scotland\">Scotland</option><option value=\"wales\">Wales</option>";
echo "<option value=\"ireland\">Ireland</option><option value=\"outside\">Outside UK</option></select></td></tr>";
echo "<tr><td>City:</td><td><input type=text name=city value=\"$city\" maxlength=\"99\"></td></tr>";
echo "<tr><td>Rates:</td><td><input type=text name=rates value=\"$rates\" maxlength=\"99\"></td></tr>";
echo "<tr><td>Description:</td><td><textarea cols=20 rows=4 name=Description value=\"$Description\"></textarea></td></tr>";
echo "<tr><td>Height:</td><td><input type=text name=height value=\"$height\" maxlength=\"20\"></td></tr>";
echo "<tr><td>Stats:</td><td><input type=text name=stats value=\"$stats\" maxlength=\"20\"></td></tr>";
echo "<tr><td>Age:</td><td><input type=text name=age value=\"$age\" maxlength=\"5\"></td></tr>";
echo "<tr><td>Picture:</td><td><input type=file name=file1 value=\"$file1\"></td></tr>";
echo "<tr colspan=2><td><input type=submit value=\"Make Your Page!\"></table></form>";
?></td>
</tr>
</table> </td>
</tr>
</table>
</body>
</html>
Dereck
