[SOLVED] Am I Blind?
Posted: Sat Jul 18, 2009 8:07 pm
its not inserting into the F** Table
Code: Select all
<?
mysql_connect("---", "---", "---") or die(mysql_error());
mysql_select_db("modelsite") or die(mysql_error());;
$username = $_POST['username'];
$dbunames = mysql_query("SELECT * FROM members WHERE username='$username'");
if ($uname != $dbunames)
if(mysql_num_rows($dbunames) > 0 ) { //check if there is already an entry for that username
echo "<div class = sendmessage>Username $username is already taken, hit back to enter another one.</div>";
} else {
echo $first = $_POST['first']; echo "<br/>";
echo $last = $_POST['last']; echo "<br/>";
echo $age = $_POST['age']; echo "<br/>";
echo $gender = $_POST['gender']; echo "<br/>";
echo $exp = $_POST['exp']; echo "<br/>";
echo $compensation = $_POST['compensation']; echo "<br/>";
// Photographer Stuff
echo $studio = $_POST['studio']; echo "<br/>";
echo $Fashion = $_POST['Fashion']; echo "<br/>";
echo $Runway = $_POST['Runway']; echo "<br/>";
echo $Sport = $_POST['Sport']; echo "<br/>";
echo $Casual = $_POST['Casual']; echo "<br/>";
echo $Editorial = $_POST['Editorial']; echo "<br/>";
echo $Swimwear = $_POST['Swimwear']; echo "<br/>";
echo $Lingerie = $_POST['Lingerie']; echo "<br/>";
echo $Nude = $_POST['Nude']; echo "<br/>";
echo $Art = $_POST['Art']; echo "<br/>";
echo $Glamour = $_POST['Glamour']; echo "<br/>";
echo $Artistic_Nude = $_POST['Artistic_Nude']; echo "<br/>";
echo $Erotic = $_POST['Erotic']; echo "<br/>";
echo $published = $_POST['published']; echo "<br/>";
echo $cambrand = $_POST['cambrand']; echo "<br/>";
echo $cammodel = $_POST['cammodel']; echo "<br/>";
echo $photoshop = $_POST['photoshop']; echo "<br/>";
// Date Signed Up
$today = date("F j, Y g:i a");
echo $bio = "This member has not made their biography yet."; echo "<br/>";
echo $city = $_POST['city']; echo "<br/>";
echo $state = $_POST['state']; echo "<br/>";
echo $country = $_POST['country']; echo "<br/>";
echo $zip = $_POST['zip']; echo "<br/>";
echo $username = $_POST['username']; echo "<br/>";
echo $password = $_POST['password']; echo "<br/>";
echo $email = $_POST['email']; echo "<br/>";
echo $profession = $_POST['profession']; echo "<br/>";
echo $today = date("F j, Y g:i a");
mysql_query("INSERT INTO members (
status,
m_type,
first,
last,
age ,
genre,
exp,
compensation,
city,
state,
country,
zip,
username,
password,
email,
uploads,
date_sign_up,
studio,
Fashion,
Runway,
Sport,
Casual,
PrintEditorial,
Swimwear,
Lingerie,
Art,
Glamour,
Artistic ,
Nude,
Erotic,
photoshop,
p_cambrand,
p_cammodel,
p_published
)
VALUES
(
'Free',
'$profession',
'$first',
'$last',
'$age',
'$gender',
'$exp',
'$compensation',
'$city',
'$state',
'$country',
'$zip',
'$username',
'$password',
'$email',
'no_avi.jpg',
'$today',
'$studio',
'$Fashion' ,
'$Runway' ,
'$Sport' ,
'$Casual' ,
'$Editorial' ,
'$Swimwear' ,
'$Lingerie' ,
'$Art' ,
'$Glamour' ,
'$Artistic_Nude',
'$Nude',
'$Erotic',
'$photoshop',
'$cambrand',
'$cammodel',
'$published'
)");
echo '
<table width=\'539\' border=\'0\' cellspacing=\'3\' cellpadding=\'3\'>
<tr>
<td width=\'77\' class=\'locationnomarginbiiger\' scope=\'row\'> </td>
<td width=\'216\' bgcolor=\'#006699\' class=\'locationnomarginbiiger\' scope=\'row\'><span class=\'modelnumber\'>Basic</span></td>
<td width=\'216\' bgcolor=\'#006699\' class=\'locationnomarginbiiger\' scope=\'row\'><span class=\'modelnumber\'>Pro Member</span></td>
</tr>
<tr>
<th class=\'locationnomargin\' scope=\'row\'><div align=\'right\'>Photographs</div></th>
<td width=\'216\' class=\'regcomments\' scope=\'row\'><div align=\'right\'>8 Photographs</div></td>
<td width=\'216\' class=\'regcomments\' scope=\'row\'><div align=\'right\'>100 Photographs</div></td>
</tr>
<tr>
<th class=\'locationnomargin\' scope=\'row\'><div align=\'right\'>Messages</div></th>
<td width=\'216\' bgcolor=\'#333333\' class=\'regcomments\' scope=\'row\'><div align=\'right\'>No</div></td>
<td width=\'216\' bgcolor=\'#333333\' class=\'regcomments\' scope=\'row\'><div align=\'right\'>100 a Day</div></td>
</tr>
<tr>
<th class=\'locationnomargin\' scope=\'row\'><div align=\'right\'>Site Updates</div></th>
<td width=\'216\' class=\'regcomments\' scope=\'row\'><div align=\'right\'>No</div></td>
<td width=\'216\' class=\'regcomments\' scope=\'row\'><div align=\'right\'>Yes</div></td>
</tr>
<tr>
<th class=\'locationnomargin\' scope=\'row\'><div align=\'right\'>Forum Access</div></th>
<td width=\'216\' bgcolor=\'#333333\' class=\'regcomments\' scope=\'row\'><div align=\'right\'>Yes</div></td>
<td width=\'216\' bgcolor=\'#333333\' class=\'regcomments\' scope=\'row\'><div align=\'right\'>Yes</div></td>
</tr>
<tr>
<th class=\'locationnomargin\' scope=\'row\'><div align=\'right\'>Favorites</div></th>
<td width=\'216\' class=\'regcomments\' scope=\'row\'><div align=\'right\'>Yes</div></td>
<td width=\'216\' class=\'regcomments\' scope=\'row\'><div align=\'right\'>Yes</div></td>
</tr>
<tr>
<th class=\'locationnomargin\' scope=\'row\'><div align=\'right\'>Friends</div></th>
<td width=\'216\' bgcolor=\'#333333\' class=\'regcomments\' scope=\'row\'><div align=\'right\'>Yes</div></td>
<td width=\'216\' bgcolor=\'#333333\' class=\'regcomments\' scope=\'row\'><div align=\'right\'>Yes</div></td>
</tr>
<tr>
<th class=\'locationnomargin\' scope=\'row\'><div align="right">Fans</div></th>
<td class=\'regcomments\' scope=\'row\'><div align="right">Yes</div></td>
<td class=\'regcomments\' scope=\'row\'><div align="right">Yes</div></td>
</tr>
<tr>
<th class=\'locationnomargin\' scope=\'row\'><div align=\'right\'>Advertisements</div></th>
<td width=\'216\' bgcolor="#333333" class=\'regcomments\' scope=\'row\'><div align=\'right\'>Yes</div></td>
<td width=\'216\' bgcolor="#333333" class=\'regcomments\' scope=\'row\'><div align=\'right\'>Yes</div></td>
</tr>
<tr>
<th class=\'locationnomargin\' scope=\'row\'><div align=\'right\'>Cost</div></th>
<td width=\'216\' class=\'locationnomarginblue\' scope=\'row\'><div align=\'right\'>Free</div></td>
<td width=\'216\' class=\'locationnomarginblue\' scope=\'row\'><div align=\'right\'>$8 Month</div></td>
</tr>
<tr>
<th class=\'locationnomargin\' scope=\'row\'> </th>
<td class=\'locationnomarginblue\' scope=\'row\'><form name=\'form1\' method=\'post\' action=\'member_cp.php?status=registerd\'>
<div align=\'right\'>
<input type=\'submit\' name=\'button\' id=\'button\' value=\'Submit\'>
</div>
</form></td>
<td class=\'locationnomarginblue\' scope=\'row\'><form name=\'form3\' method=\'post\' action=\'\'>
<div align=\'right\'>
<input type=\'submit\' name=\'button3\' id=\'button3\' value=\'Submit\'>
</div>
</form></td>
</tr>
</table>
';
}
?>