Page 1 of 1

[SOLVED] Am I Blind?

Posted: Sat Jul 18, 2009 8:07 pm
by radium35
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\'>&nbsp;</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\'>&nbsp;</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>
 
';
   
      }
      
      
?>
 

Re: Am I Blind?

Posted: Sat Jul 18, 2009 8:17 pm
by jackpf
Well use the mysql_error() function then.

Re: Am I Blind?

Posted: Sat Jul 18, 2009 9:21 pm
by califdon
I would encourage you not to write mysql_query() statements like that. If you first assign the SQL statement to a variable, then use the variable in the mysql_query() function, it will be much easier to echo the variable during debugging and discover all sorts of problems immediately. And use the " or die(mysql_error()) " syntax to show your errors, as jackpf suggested.

Re: Am I Blind?

Posted: Sun Jul 19, 2009 10:10 am
by radium35
thanks guys! Yes i forgot mysql_query() funny how my debugger did not catch that spent 4 hours going over the order and the quotes lool