help (please) with arrays and queries

brianstorm

Hi,

If anyone can help me it would me much apprecciated. I am trying to add a section to an email subscription page which will check to see whether the email address already exists in the database and display an appropriate message. I have tried various different methods but I don't seem to be able to generate a list of the email addresses (although I can print it using a while loop). When I use the following code ($Email is from the form input) it will only match on the last row of the email table instead of searching through all the email address's

$Duplicate= mysql_query( "SELECT * FROM email" );
$myArray = mysql_fetch_array($Duplicate);

if (preg_match("/$Email/i", "/$myArray/")) {print "$Email is already subscribed. Please close this window"; }else {$Query="INSERT into $table values ('0','$FirstName','$LastName','$Email','1')";
print("<br><The query is:<br>$Query\n");
}

I know the answer is obvious if you know how but I don't and would much apprecciate guidance.

Thanks in Advance
😕

tomhath

The obvious problem is that you are only fetching one ROW from the query (mysql_fetch_array() puts each COLUMN from a single row into an array). So any other rows returned by the query are ignored.

But this whole thing is backwards. Let mysql search for the email address, then check if it returns any rows; rather than selecting every row and using php to see if one of them matches.

http://www.mysql.com/doc/en/Regexp.html

brianstorm

thanks....🙂

ps: if i wanted to get all the rows returned, how would I do that?

lunar

$inscribecheck =mysql_query("SELECT count(id) as total FROM email where emails like \"%$usersemail%\"");

if (mysql_result($inscribecheck,0,0)==0)
{
// email NOT found
}
else
{
// email found!
}

Hope this helps 🙂

tomhath

This should give you the idea. It sounds like reading through a couple of articles or tutorials would give you a lot of valuable background information.

$Duplicate= mysql_query( "SELECT * FROM email" ) or die ("select failed: " . mysql_error(); 

while ($myArray = mysql_fetch_array($Duplicate) ) {
  ... do something with each row selected ...
}

brianstorm

thank you again, both.

i am reading articles, and tutorials, but sometimes you can't see the wood for the trees....

cheers🙂