Go Back  HTML Forums - Free Webmaster Forums and Help Forums > WEBSITE DEVELOPMENT > Databasing
User Name:
Password:
 

Reply
Thread Tools   Display Modes
  View First Unread
 
Old 03-15-2007, 09:47 AM
  #1
slimrob
Novice (Level 1)
 
Join Date: Nov 2006
Posts: 9
iTrader: (0)
slimrob is an unknown quantity at this point
Unhappy employee directory--HELP?

Hi Guys,
I'm trying to create an employee directory on the intranet that I update. Something simple, but professional. I want you to be able to click on a letter and have the page list everyone's last name that starts with that letter, or have the ability to search for a specific last name. The data will be a .csv extract from our HR system. Do you guys know of a product or form or anything that is capable of doing this? Thanks for any help you guys can provide. If this post is in the wrong area, please let me know where it should be. Thanks.
slimrob is offline   Add to del.icio.us Add to del.icio.us    Can you digg it?Can you digg it? Reply With Quote
Old 03-17-2007, 10:05 AM
  #2
adamcube
Soldier (Level 11)
 
Join Date: Aug 2006
Posts: 107
iTrader: (0)
adamcube is an unknown quantity at this point
Hey Slimrob,

I'd say you'd be looking to pop the .csv into a database of sorts, I'd recommend MySQL. You would then have to use a server-side language, such as PHP, to query your database and draw up a table with the last names, ect. It's not all that difficult to do in truth.

In the PHP, something like...

PHP Code:
$query mysql_query("SELECT * FROM `employees` WHERE `last_name` = 'M'");
$query_num mysql_num_rows($query);

echo 
"<ul>";

for (
$i=0$i $query_num$i++) {

$last_name mysql_result($query$i'last_name');
echo 
"<li>$last_name</li>";

}

echo 
"</ul>"
...would query this MySQL database for all last names in the employees table beginning with M, and then run a loop to display them in a list format.

I would research the functions and languages I've mentioned in this post, and hopefully you'll be able to get started with something.

Adam
adamcube is offline   Add to del.icio.us Add to del.icio.us    Can you digg it?Can you digg it? Reply With Quote
Old 03-24-2007, 03:34 PM
  #3
scoutt
Mister Admin to you
 
scoutt's Avatar
 
Join Date: Jul 2001
Posts: 30,730
iTrader: (0)
scoutt is a jewel in the roughscoutt is a jewel in the roughscoutt is a jewel in the rough
so like this

http://www.snippetlibrary.com/tutori...s.php/2/16/257
__________________
Have a Script or Snippet you want to share?

WWW Standards: HTML 4.01, CSS2.1, CSS3, XHTML 1.0
PHP Standards: PHP Standards
scoutt is offline   Add to del.icio.us Add to del.icio.us    Can you digg it?Can you digg it? Reply With Quote

Reply
KEEP TABS
SPONSORS
 
Boxedart
 
 


 
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
  
 
 
 



 
  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
Thread Tools
Display Modes

Forum Jump

 

All times are GMT -5. The time now is 09:54 PM.

   

Mascot team created by Drawshop.com

Powered by vBulletin® Version 3.6.7
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.

Server Monitoring by ENIACmonitor 0.01
HTMLforums.com © Big Resources, Inc. Web Design by BoxedArt.com
vRewrite 1.5 beta SEOed URLs completed by Tech Help Forum and Chalo Na.