insert (database)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



the objective of the script below is to first search if a subscriber is already in a list before subscribing his email (so as to prevent double subscription). the select part works fine....but the insert doesnt. know why?
 
if ($v = strtolower($_POST['email'])) {
$db = mysql_connect(mysql, "usser", "pw");
$con = mysql_select_db("ng",$db);
$sql = "SELECT * FROM mytable WHERE email='$v'";
$res = mysql_query( $sql ) ; 
if ($row = mysql_fetch_array($res)) {
  echo "<b>Your email: <u>$v</u> already in the list<br>";
}
  else {
   $sql_in = "INSERT INTO arcadia ('email') VALUES ('$v')";
  $result_in = mysql_query($sql_in);
   echo "<b>Your email: <u>$v</u> subscribed!<br>";
}
  }
else {
include("index.php");
exit;
}



---------------------------------

A passion till tomorrow,
Opeyemi Obembe | ng.clawz.com





		
---------------------------------
Do you Yahoo!?
 Yahoo! Search presents - Jib Jab's 'Second Term'

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux