I'm probably an idiot to try this, but...

[KITTfan2K]

How do I count the number of results in a database with text in the field Email_Address that match what a user has entered?

And how should I make sure that the email address was valid, i.e. contained exactly one '@' symbol?

KITTfan2K

[aSa]

1)

<?
$sql_exec = mysql_query("SELECT * FROM your_table where email = $email");

$number_of_same_email_addr_in_table = mysql_num_rows($sql_exec);
?>

2)

<?
//Checking whether @ exists or not:
if(strstr($email,'@'))
print "$email is a real email addr."
?>

[KITTfan2K]

Originally posted by aSa

<?
$sql_exec = mysql_query("SELECT * FROM your_table where email = $email");

$number_of_same_email_addr_in_table = mysql_num_rows($sql_exec);
?>

This doesn't work for me.

I changed the table and field names and the variable. Then I added the following statement:

<?
echo "\"".$number_of_same_email_addr_in_table."\""
?>

And it just echo's "". It just skips that step and continues with the script.

I tried it with an email address that was in the table, and one that wasn't, and it didn't work either time.

KITTfan2K

[[deleted]]

hmm,
strings must be quoted,
SQL tends to be case-sensitive in string comaprisons,
and never ever select *if you just want to count:

<?
$result = mysql_query("SELECT count(1) AS number FROM your_table WHERE UPPER(email) = UPPER('".$email.'"));

$aRow = mysql_fetch_assoc($result);
echo $aRow['number']
?>

And this just checks for an @ sign, which has nothing at all to do with it being a real email adres:
<?
//Checking whether @ exists or not:
if(strstr($email,'@'))
print "$email is a real email addr."
?>

[KITTfan2K]

Originally posted by vincente

<?
$result = mysql_query("SELECT count(1) AS number FROM your_table WHERE UPPER(email) = UPPER('".$email.'"));

$aRow = mysql_fetch_assoc($result);
echo $aRow['number']
?>

The first few lines of my PHP file look like this:

<?php

 $result = mysql_query("SELECT count(1) AS number FROM posn_Member WHERE UPPER(Email) = UPPER('".$Email1.'"));
 $aRow = mysql_fetch_assoc($result); 
 echo $aRow['number'];

$Error = "False";

Unfortunately, I get this error returned:

Parse error: parse error in Register3.php on line 5

I've double-checked, and all the table/field names and variables are correct.

KITTfan2K

[mattr]

vincente's code has one little bug.

KITTfan2K:
Hint: look at the coloring in vB.

Hint #2: Consider learning PHP, in particular strings.