PHP - Unique Within Foreach

Hi I am new this forum and looking for some much appreciated help with something that has me stumped.

I have extracted regions from image names in a directory.

example: 'edinburgh_castle_(Edinburgh).jpg' (Extracted Edinburgh from in-between the brackets)

So I have a list of Regions, extracted from all the various image names in the directory which I want to populate into a dynamic drop down menu for filtering purposes.

Here's my issue...

I want there to be only one 'Edinburgh' option appearing in my drop down menu. I don't want duplicates.
  Here is my code so far.
  php: [Select]

I have a mysql table which will store users email addresses (each is unique and is the primary field) and a timestamp. 
I have added another column called `'unique_code' (varchar(64), utf8_unicode_ci)`.

What I would very much appreciate assistance with is;

a) Generating a 5 digit alphanumeric code, ie: 5ABH6 
b) Check all rows the 'unique_code' column to ensure it is unique, otherwise re-generate and check again 
c) Insert the uniquely generated 5 digit alphanumeric code into `'unique_code'` column, corresponding to the email address just entered. 
d) display the code on screen.

What code must I put and where?


**My current php is as follows:**

Code: [Select]
    require "includes/connect.php";
   
    $msg = '';
   
    if($_POST['email']){
   
    // Requested with AJAX:
    $ajax = ($_SERVER['HTTP_X_REQUESTED_WITH']  == 'XMLHttpRequest');
   
    try{
    if(!filter_input(INPUT_POST,'email',FILTER_VALIDATE_EMAIL)){
    throw new Exception('Invalid Email!');
    }
   
    $mysqli->query("INSERT INTO coming_soon_emails
    SET email='".$mysqli->real_escape_string($_POST['email'])."'");
   
    if($mysqli->affected_rows != 1){
    throw new Exception('You are already on the notification list.');
    }
   
    if($ajax){
    die('{"status":1}');
    }
   
    $msg = "Thank you!";
   
    }
    catch (Exception $e){
   
    if($ajax){
    die(json_encode(array('error'=>$e->getMessage())));
    }
   
    $msg = $e->getMessage();
    }
    }

This topic has been moved to Application Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=355772.0

Hello PHP freaks,   my codes dont allow me to log-in to Student Home with unique id. It says "Invalid Login or Password" this is my form

<tr bgcolor="#E1E1E1" class="stylesmall">
              <td width="35%" align="left" class="style7 style1">Learner Id : </td>
                <td width="65%" align="left"><input name="learner_id" type="text" id="learner_id" action="Student_Home.php" method="post"></td>
              </tr>
            <tr bgcolor="#E1E1E1" class="stylesmall">
              <td align="left" class="style7 style1">Password:</td>
                <td align="left"><input name="student_password" type="password" id="student_password"><
/td>

and this is my handler.

<?php
	session_start();
	include 'Connect.php';
	$flag = "";
	$learner_id = $_POST['learner_id'];
	$student_id = $_POST['student_id'];
	$student_password = $_POST['student_password'];
	$query = "select last_login_date from student_information where student_id='$student_id' and student_password='$student_password'";
	$result = mysql_query($query,$link_id);
	if(mysql_error() != null){
		die(mysql_error());
	}
	if($date = mysql_fetch_array($result))
	{
        $lastdate = $date['last_login_date'];
	$date2 = date("d-m-Y h:i A",strtotime($lastdate));
	$_SESSION["student_id"] = $_POST["student_id"];
        $_SESSION["lastlogin"] =$date2;
	$_SESSION["type"] = "Student";
	mysql_query("UPDATE student_information SET last_login_date=now() where student_id='$student_id'",$link_id);
	if(mysql_error() != null){
	die(mysql_error());
	}
	header("location:  Student_Home.php?id={$student_id}");
		 die();
	}
	else
	{
		$flag = "invalid";
		header("location:Student_login.php?flag=$flag");
		die();		
	} 	
?>

PLease help me PHP friends to correct my codes.

I'm not sure if the title explains it very well, but here is an image of it. I am trying to figure out how to access the option selected (equal, not equal, etc.), along with its input box, for each column (the checkboxes on the right) selected. The purpose of this is to allow a non-programming administrator user to create a custom query to access information. I can find out which checkboxes are selected no problem, but finding the accompanying drop-down option and input box is difficult for me. How do I do this?

If you have a suggestion on how to change it, I'm very open. Thank you in advance!



Code: [Select]
if(!isset($_POST['submit']))
{
echo "
<form method='post'>
<table>
 <tr>
  <td valign='top'>SELECT</td>
  <td valign='top'>
   <table>";
 
// LIST ALL COLUMNS IN A TABLE
$result = mysql_query("SELECT * FROM table_name") or die(mysql_error());
$rowcount=mysql_num_rows($result);
$y=mysql_num_fields($result);
for ($x=0; $x<$y; $x++)
{ echo "
    <tr>
<td>
  <input type='checkbox' name='fields[]' value='".mysql_field_name($result, $x)."'>".mysql_field_name($result, $x)."
     </td>
</tr>"; }
 
   echo "
   </table>
  </td>
  <td valign='top'>FROM allocations</td>
  <td valign='top'>WHERE</td>
  <td>
   <table>";
   
// LIST ALL COLUMNS IN A TABLE
$result = mysql_query("SELECT * FROM table_name") or die(mysql_error());
$rowcount=mysql_num_rows($result);
$y=mysql_num_fields($result);
for ($x=0; $x<$y; $x++)
{ echo "
    <tr>
<td>
  <input type='checkbox' name='column[]' value='".mysql_field_name($result, $x)."'>".mysql_field_name($result, $x)."
</td>
<td>
  <select name='operator[]'>
          <option value='='>equals</option>
          <option value='<>'>does not equal</option>
          <option value='>'>greater than</option>
          <option value='<'>less than</option>
          <option value='>='>greater than or equal to</option>
          <option value='<='>less than or equal to</option>
          <option value='LIKE'>is like</option>
         </select>
</td>
     <td><input type='text' name='criteria[]'></td>
</tr>"; }

   echo "
   </table>
  </td>
  <td valign='top'><input type='submit' value='Process Query' name='submit' class='submit'></td>
 </tr>
</table>
</form>";
}
else
{
 echo "<b>Fields to edit:</b> ";
foreach ($_POST['fields'] as $fields) {
echo $fields,", ";
}

 echo "<br><br>";
 echo "<b>Columns to query:</b> ";
foreach ($_POST['column'] as $columns) {
echo $columns," HERE IS THE SPOT, ";
}
}