Question about reading an array

[runway27]

I need to insert email address into a table, before that i need to make sure that this email address is not already in the table. to check this i used =

if(in_array($email, $emailrows)) = This works however it only reads the value of email in the First row only not the remaining rows in the table.

please provide the code to check all the rows in the table for the Email field.

[Lumpy]

Any chance that we can see the code you have that is running your query. That might help to get a better idea of what your doing and where the code might need a little tweaking.

[w0rKInPHP]

//sql?
<?php
$query = "select pk from tablename where email = 'emailaddress'";
$result = pg_query($query); //mysql_query() for mysql
$total = pg_num_rows($result); //mysql_num_rows() for mysql
 
if($total == 0)
{
  //code goes here.
}
?>
 
 
//array?
foreach($emailarray as $email)
{
  if(strcasecmp($email, $otheremail) == 0)//case insensitive comparison
  {
    //code goes here
  }
}

[aym]

//sql?
<?php
$query = "select pk from tablename where email = 'emailaddress'";
$result = pg_query($query); //mysql_query() for mysql
$total = pg_num_rows($result); //mysql_num_rows() for mysql
 
if($total == 0)
{
  //code goes here.
}
?>
 
 
//array?
foreach($emailarray as $email)
{
  if(strcasecmp($email, $otheremail) == 0)//case insensitive comparison
  {
    //code goes here
  }
}

the first thing that I noticed is that u forgot to put the $ sign near "where email = 'emailaddress'".
last thing is that I could not understand ur question well. Please declare more.

[pbmods]

Heya, runway27.

Try using the REPLACE keyword instead of INSERT.