mysql trouble

[[deleted]]

I am creating a newsletter and want to take the email address the user submitted and loop it through a search in the database and see if it matches. If it does, then I want to report an error saying email address already subscribed. if no match, then insert it into the db.

here is my code so far

$link = mysql_connect($host,$user,$pass);
mysql_select_db($db, $link);

// Check for existing email address
$match = false;
$i = 0;

$total = mysql_list_dbs($link);

while ($i < mysql_num_rows($total)) {

if ($email == ($dup_email[$i])
$match = true;
break;
}

$i++;
}

mysql_free_result($total);

if($match == true) {
echo "error";
exit;
}

please fill in the rest of the php/mysql code to make this work.

[raditha]

Hi,

First up i think it would be a good idea for you to read some of the sql related articles on PHP builder (if you haven't already done so)

Anyway the right way to do it is to create a database for your users (say dbuser). Then you need to have a table in that database that contains the user details (say tbuser).

This table might contain username, password, email etc.

then you could modify your code like this:

/ begin /
$link = mysql_connect($host,$user,$pass);
mysql_select_db("dbuser", $link);

// Check for existing email address
$match = false;

$email = addslashes($email);
$result = mysql_query("select * from tbuser where email ='$email',$link);

if($result)
if(mysql_num_rows($result)
$match=true;
/ end /

Of course there are neater ways of doing it but this should get you started.

[Anon]

maybe this will work

mysql_connect($host,$user,$pass);
mysql_select_db($db);

$sql = "SELECT <email_addie_field> from <TABLE_NAME> WHERE <email_addie_field> = '<WHATEVER THE USER ENTERED FOR THE EMAIL'";

if (mysql_query($sql)){
print "error...it already exist";
exit();
}else{
$sql = "INSERT INTO <TABLE_NAME> VALUE (whatver you need to pass in)";
mysql_query($sql);
<whatever else you want to happen if it doesn't exist>
}

[[deleted]]

i tried both examples and modified the code since i spotted some "'s errors and it still doesn't work.

[sepodati]

Can you show your code now?

Are you storing the email address as a database? I don't even see you issuing a select statement in your original code. How are your tables set up?

---John Holmes...