Zergman

I really can't figure out why the guy built these tables like he did but whatever .... Anyways let me better try to ask my question. There is one DB that has 2 tables. The main table (tbl1) stores all employee information. The second table (tbl2) has a record in it if the an employee is assigned to another temp manager. Both tables have indentical fields for the employee ID numbers (employee_id). What I need this process too do is as follows. 1) Page loads that has 1 field in it <input type="text" name="employee_id" id="employee_id" /> 2) User enters a ID of an employee into the field and hits Search 3) It checks tbl2 for a record and if found, displays (manager_id) ... if no record is found 4) Pulls the record from tbl1 and displays (employee_pdl_mgr_id) I know this isn't right and probably FAR from correct but its something SELECT * FROM tbl1, tbl2 WHERE tbl1.employee_id AND tbl2.employee_id = '%$employee_id%' im at my wits end ... seems simple, yet I just can't get it.

Sorry, was playing around with it but due to my spaz spelling, it wouldn't work lol. Got it now function setCities(){ cntrySel = document.getElementById('country'); stateSel = document.getElementById('state'); citySel = document.getElementById('city'); //<--START NEW CODE--> stateValue = stateSel[stateSel.selectedIndex].value; inputVisability = (stateValue=='Pixelization') ? '': 'hidden'; document.getElementById('dslam').style.visibility = inputVisability; //<--END NEW CODE--> cityList = cities[cntrySel.value][stateSel.value]; changeSelect(citySel, cityList); } Thanks for the help and code for this

I put in the code as you provided and changed SubOption2 to a real value in the app but it seems the dslam box appears fine when the country box option is selected. Is there anyway to change this so the dslam box appears based on whats selected in the state box?

Hmm, now that I think about it, I believe I did get that code from here LOL! Thanks mjdamato It really doesn't matter apparently which SubOption2 is selected. In the real code, there are repeats of the same thing in the 3rd box depending on what the first and second boxes are. I was asked that if SubOption2 is selected ... regardless of the first two boxes, to have it open the text box to gather more data. Ill try what you suggested and post back the results.

I have a dynamic 3 list box system that was used for a country/state/city. var states = new Array(); states['Item1'] = new Array('Option1','Option2'); states['Item2'] = new Array('Option1','Option2'); states['Item3'] = new Array('Option1','Option2'); // City lists var cities = new Array(); cities['Item1'] = new Array(); cities['Item1']['Option1'] = new Array('SubOption1','SubOption2'); cities['Item1']['Option2'] = new Array('SubOption1','SubOption2'); cities['Item2'] = new Array(); cities['Item2']['Option1'] = new Array('SubOption1','SubOption2'); cities['Item2']['Option2'] = new Array('SubOption1','SubOption2'); cities['Item3'] = new Array(); cities['Item3']['Option1'] = new Array('SubOption1','SubOption2'); cities['Item3']['Option2'] = new Array('SubOption1','SubOption2'); function setStates(){ cntrySel = document.getElementById('country'); stateSel = document.getElementById('state'); stateList = states[cntrySel.value]; changeSelect(stateSel, stateList); setCities(); } function setCities(){ cntrySel = document.getElementById('country'); stateSel = document.getElementById('state'); citySel = document.getElementById('city'); cityList = cities[cntrySel.value][stateSel.value]; changeSelect(citySel, cityList); } //**************************************************************************// // FUNCTION changeSelect(fieldObj, valuesAry, [optTextAry], [selectedVal]) // //**************************************************************************// function changeSelect(fieldObj, valuesAry, optTextAry, selectedValue) { //Clear the select list fieldObj.options.length = 0; //Set the option text to the values if not passed optTextAry = (optTextAry)?optTextAry:valuesAry; //Itterate through the list and create the options for (i in valuesAry) { selectFlag = (selectedValue && selectedValue==valuesAry[i])?true:false; fieldObj.options[fieldObj.length] = new Option(optTextAry[i], valuesAry[i], false, selectFlag); } } Used on page <select name="country" size="10" class="textareastyle" id="country" onchange="setStates();"> <option value="Item1">Item1</option> <option value="Item2">Item2</option> <option value="Item3">Item3</option> </select> <select name="state" size="10" class="textareastyle" id="state" onchange="setCities();"> <option value=""> </option> </select> <select name="city" size="10" class="textareastyle" id="city" onchange=" "> <option value=""> </option> </select> What I was asked to do is to have the following textbox only show if SubOption2 was selected. Textbox <input type="text" name="dslam" id="dslam" class="textboxstyle" value="DSLAM Info" size="32" /> Can't figure this out due to the nature of the dynamic list boxes.

Gotcha, i've tinkered enough and wasted enough time trying to figure this out myself I got some example code from the guy who built the DB and uses these tables, he's just not accessible to help. Here's the example he gave me. function get_true_manager($employee_id){ include("system/db.php"); $emp_id=str_pad($employee_id,8,"0", STR_PAD_LEFT); $db_sys_emp_sql="SELECT tbl1.employee_pdl_mgr_id, tbl2.manager_id "; $db_sys_emp_sql.="FROM tbl1 "; $db_sys_emp_sql.="LEFT JOIN tbl2 ON tbl1.employee_id = tbl2.employee_id "; $db_sys_emp_sql.="WHERE tbl1.employee_id ='".$emp_id."' "; $db_sys->SetFetchMode(ADODB_FETCH_ASSOC);// Return associative array $rs_sys = &$db_sys->Execute($db_sys_emp_sql); if (!$rs_sys) { print $db_sys->ErrorMsg();// while ($row_sys = $rs_sys->FetchNextObject()) { $mgr_pdl=$row_sys->EMPLOYEE_PDL_MGR_ID; $mgr_other=$row_sys->MANAGER_ID; } if(is_null($mgr_other)){ $true_manager=$mgr_pdl; } else { $true_manager=$mgr_other; } return $true_manager; } Problem is I don't understand half of what this is doing and seems over complicated to what I need it to do. I just need to have 1 box where the user will put in a numerical employee id and it will pull the manager id from the right table. .... ugh

Somewhat ... I can tinker with them but this is making my head hurt

To be honest, im not sure im even describing the problem right lol. Im not going to be using AJAX ... I think, so perhaps instead of doing a dynamically populating form, i can do it on 2 different pages. Just using php.

So here's my issue. I was given access to another DB to extract data from when submitting a form that submits to another DB. In this new DB, there are 2 tables. Table 1 is the primary table with employee data. Table 2 is if the employee is assigned a temporary manager, it will be updated here. What I need to accomplish is this. On my form, they enter the ID number of the employee. The form needs to check the manager name of both tables and if different use the one from Table 2. I have no clue how to do this. Was hoping that after the agent id field looses focus, it would execute the query to check the tables and populate the manager name field before the main form is submitted. That way the users can enter the agent ID then tab off the field and it would fetch the manager name automatically. I hope this isn't confusing cause I know I sure am confused.

From reading more, it appears that FF can't do it without use of a plugin.

Thanks for the advise Mchl. Good to know im on the right track using tables for what I thought they were meant for. As for using CSS styled lists, thats on the To Do list of learning. I do see the flexability by using css and div layouts though, just not easy changing from the old ways of tables tables tables.

Thats good to know, thanks for the tip! While I have someones attention and this is all new to me, for people that are 100% div users, are tables still used for keeping structure for data output? Like what im doing now is placing a table inside a div to keep structure to things. Page headers with lots of little things or outputting massive data. I've been trying it without, but its a real mess and a headache plus there are things I don't think you could do without tables....

im trying to convert to full div layouts now. Used to be a hardcore table user but the code sometimes got to the point of insane and I couldn't figure it out sometimes. I do admit that pages load quite a bit faster using div but i got a lot of learning to do. One thing I realized that IE and firefox don't handle div right for me. using a width of 100% shows properly in IE but in FF, its expanding off the screen by about 4px. Feel the same as you right now trying to figure out the bugs. Tables were easier Not sure but im right now about 60% div, 40% tables

I trying to open a networked folder from a link on our app. <a href="file://server/link/to/network/share/" target="_blank">Schedules</a> Works fine in IE, not in firefox. Anyone know whats up?

Thanks darkfreaks, muchly appreciated

Im trying to prevent the sessions from timing out on my form. I know this isn't safe or smart, but it was requested so yeah ..... Im using a simple page set to auto refresh and putting it in the form using an iframe. I've had luck doing it this way before but for this new app, it isn't working. Here's my keep alive page <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>KEEPALIVE</title> <script> <!-- var limit="12:59" if (document.images){ var parselimit=limit.split(":") parselimit=parselimit[0]*60+parselimit[1]*1 } function beginrefresh(){ if (!document.images) return if (parselimit==1) window.location.reload() else{ parselimit-=1 curmin=Math.floor(parselimit/60) cursec=parselimit%60 if (curmin!=0) curtime=curmin+" - Keep Alive Activated" else curtime=cursec+" seconds left until update" window.status=curtime setTimeout("beginrefresh()",1000) } } window.onload=beginrefresh //--> </script> </head> <body> KEEPALIVE </body> </html> Here's how im putting it in the form. Its right above the </body> tag. <iframe src="../keepalive.html" width="0" height="0"></iframe> Before I left the office last night, I loaded the page, turned off my monitor and walked away. This morning, I refreshed and i reverted to the login page. ?

Closing as this is not a good way to accomplish what I want.

Ok, I see how you're doing it. So you're using a separate table (groups) to store access permissions then the pages are pulling access from the (user_to_groups) table. Im just having an issue wrapping my head around exactly how to implement this design. So in group 1's part of the site, I restrict access to only allow group 1 to see the pages? $restrict->addLevel("1"); But since user_id 1 also has access to group 3's part, he should also be able to access group 3's site since those pages have $restrict->addLevel("3"); Am I on the right track here?

I have an application that is used by different groups from within the company. I have a main menu page that everyone see's after logging in that will show them the links to their group based on their access level. This is working fine. What im running into now is that there are a few people that have access to 2 or more groups. This won't work as they won't see the other groups depending on what I have their access level set to in the DB. I thought about trying to see if I could do comma seperated values so I could add multiple groups to 1 user but can't get that going. Thought about making more access levels for multi group people but that seems like a lot of work. What is the best way to accomplish this easily?

I have a simple form that has a list with 4 values in it. Its set to multiple as I want to allow for more than 1 selection. Problem is im getting a syntax error when submitting the form. Here's the code for the comma seperated part $access = $_GET['access']; if (isset($_GET['access'])) { $comma_separated = "'" . implode("','", $access) . "'"; } else { $comma_separated = "'vsuser','vsadmin','nsuser','nsadmin'"; } if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) { $updateSQL = sprintf("UPDATE user_logins SET user_name=%s, password=%s, email=%s, 'access' IN ($comma_separated), first_name=%s, last_name=%s, theme=%s, layout=%s, status=%s, `group`=%s WHERE id=%s", GetSQLValueString($_POST['user_name'], "text"), GetSQLValueString($_POST['password'], "text"), GetSQLValueString($_POST['email'], "text"), GetSQLValueString($_POST['first_name'], "text"), GetSQLValueString($_POST['last_name'], "text"), GetSQLValueString($_POST['theme'], "text"), GetSQLValueString($_POST['layout'], "text"), GetSQLValueString($_POST['status'], "text"), GetSQLValueString($_POST['group'], "text"), GetSQLValueString($_POST['id'], "int")); Not sure what im doing wrong

sasa, thank you very much for your help. Its really cool learning new things like this

k, that is pretty wicked, im really going to have to read up on this more. One last thing that will solve this issue. I want to make the output link to the same variable name as whats shown. This is what I have so far but not doing something right here. <?php mysql_select_db($database_cntrackanator, $cntrackanator); $query_rssql = "SELECT * FROM templates_categories WHERE uname = '$username' ORDER BY category_name"; $rssql = mysql_query($query_rssql, $cntrackanator) or die(mysql_error()); $row_rssql = mysql_fetch_assoc($rssql); $totalRows_rssql = mysql_num_rows($rssql); while($row_rssql = mysql_fetch_assoc($rssql)) echo '<div class="cat_name">[<a href="">',$row_rssql['category_name'],"</a>]</div>\n "; ?> I want to use the same $row_rssql['category_name'] in the hyperlink but can't get the proper syntax right.

Thats pretty cool sasa, im just not that good with css formatting quite yet. Can you point me in the right direction of what im looking for regarding the css formatting for this?

I can't seem to figure out how to repeat my data horizontally instead of vertically. I tried searching google, but most of the results are for a dreamweaver extension to do it. Can't find out how to do it by hand. Here is my query. Pardon my newbish skills, still learning <?php mysql_select_db($database_cntrackanator, $cntrackanator); $query_rssql = "SELECT * FROM templates_categories WHERE uname = '$username' ORDER BY category_name"; $rssql = mysql_query($query_rssql, $cntrackanator) or die(mysql_error()); $row_rssql = mysql_fetch_assoc($rssql); $totalRows_rssql = mysql_num_rows($rssql); echo $row_rssql['category_name']; ?> So how can I get this to loop vertically instead of down?

Worked like a charm. Makes sense now that I see what you did. Thanks a million!