Prevent Duplicate Entries...

Codewalkers Forums Sponsor:

December 4th, 2005, 06:47 PM

jweizenblut

Contributing User

Join Date: Apr 2007

Location: Miami, Fl. US

Posts: 522

Time spent in forums: 8 m 29 sec
Reputation Power: 2

Prevent Duplicate Entries...

I have a form select object that loads the options from my database. The code for it as follows:

php Code:

Original - php Code

 
include('/webserver/security/5206/includes/sql_connect.php');
$fields_needed = "unique_id, class_name";
$query_class_names = "SELECT $fields_needed FROM training_classes ORDER BY class_name";
$result_class_names = mysql_query($query_class_names);
while ( $myrow = mysql_fetch_array($result_class_names))
  {
    echo "<option value=".$myrow["unique_id"].">".$myrow["class_name"]."</option>";
  }
mysql_close($server);

I also have a text input as follows:

php Code:

Original - php Code
<input class="200_10_entry_area" type="text" name="new_class_name" maxlength="30">

 
<input class="200_10_entry_area" type="text" name="new_class_name" maxlength="30">

What I want to do is have JavaScript check all the current names for the select object and if any of them match what has been entered in the form input, for an error message to be displayed and focus back to the form input.

Any help would be appreciated.

December 4th, 2005, 09:16 PM

bakertrg

Contributing User

Join Date: Apr 2007

Location: Scottsdale AZ, US

Posts: 2,253

Time spent in forums: 2 h 48 m 45 sec
Reputation Power: 4

RE: Prevent Duplicate Entries...

if you want javascript to do this you need to load all the existing entries for the select box into a javascript array.

I would do a query at the top of the page and pull all the entries and store them in an array, then write a javascript function to validate the text area usuing a for loop to populate the array with php variables.

then the same php array can be used to create your list box without making another query

Viewing: Codewalkers Forums > Other Technologies > Client Side Things > Prevent Duplicate Entries...

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump