Zergman

The javascript is in the header for sure. I put in the changes you suggested but now the script won't fire. I guess I left out 1 piece of information. I changed from a <select> to a standard textbox in my app for this. <input type="text" name="findagentid" id="findagentid" class="textboxstyle" size="15" maxlength="8" value="<?php echo $emp_id; ?>" onchange="showUser(this.value)" /> Wouldn't I need to put something on the getusers.php to send the info BACK to the parent page?

Is it possible to display the results in something else other than div tags? Like possibly displaying the result in a hidden form field?

Using the tutorial found here http://www.w3schools.com/PHP/php_ajax_database.asp PHP file <?php $q=$_GET["q"]; $con = mysql_connect('localhost', 'peter', 'abc123'); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("ajax_demo", $con); $sql="SELECT * FROM user WHERE id = '".$q."'"; $result = mysql_query($sql); echo "<table border='1'> <tr> <th>Firstname</th> <th>Lastname</th> <th>Age</th> <th>Hometown</th> <th>Job</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['FirstName'] . "</td>"; echo "<td>" . $row['LastName'] . "</td>"; echo "<td>" . $row['Age'] . "</td>"; echo "<td>" . $row['Hometown'] . "</td>"; echo "<td>" . $row['Job'] . "</td>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?> Form on main page <form> <select name="users" onchange="showUser(this.value)"> <option value="">Select a person:</option> <option value="1">Peter Griffin</option> <option value="2">Lois Griffin</option> <option value="3">Glenn Quagmire</option> <option value="4">Joseph Swanson</option> </select> </form> <br /> <div id="txtHint"><b>Person info will be listed here.</b></div> Javascript <script type="text/javascript"> function showUser(str) { if (str=="") { document.getElementById("txtHint").innerHTML=""; return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById("txtHint").innerHTML=xmlhttp.responseText; } } xmlhttp.open("GET","getuser.php?q="+str,true); xmlhttp.send(); } </script> So what I need to do is store $row['LastName'] in my form to submit to the database. Right now, it shows it, but doesn't actually put it into the form For example <form> <select name="users" onchange="showUser(this.value)"> <option value="">Select a person:</option> <option value="1">Peter Griffin</option> <option value="2">Lois Griffin</option> <option value="3">Glenn Quagmire</option> <option value="4">Joseph Swanson</option> </select> </form> <br /> <div id="txtHint"><b><?php echo $row['LastName'] ;?></b></div> Any ideas?

Worked great, tanks a million!

So this is probably very simple, but I can't get it. Trying to send 1 email to a list of addresses from a mysql query. pcontact is the email addresses, here's the query to get them $query_rsFind = " SELECT pcontact FROM user_logins WHERE (pcontact_type = 'SMS' OR pcontact_type = 'Email') AND pcontact_active = '1' AND active = '1' "; $rsFind = mysql_query($query_rsFind, $cnepix) or die(mysql_error()); $row_rsFind = mysql_fetch_array($rsFind); What i'm trying to do is put these addresses into 1 variable to send separated by commas like [email protected], [email protected], [email protected] So ultimately, want this mail($sendTo, $subject, $body); Arg, hard to get across what I can't get. Basically want the results from my query to do this $sendTo = [email protected], [email protected], [email protected]

Problem I had with this approach is the user list is dynamic and changes all the time but is also stored in a database. Boss also changed the demand and asked that the rotation be manually set by him depending on the schedule he sets. So basically the way I do it is when he puts in a new schedule, it triggers the rotate script.

I really appreciate all the work and scripts you made Andy-H, really do but what you did was way over my head Finally got it to do what I wanted. Chaotic and amateur, but it works <?php $query_rsCheckTotal = " SELECT rotation_num FROM tcAgent_list WHERE active = '1' AND active_group = 'TC' ORDER BY rotation_num DESC "; $rsCheckTotal = mysql_query($query_rsCheckTotal, $cnepix) or die(mysql_error()); $row_rsCheckTotal = mysql_fetch_assoc($rsCheckTotal); $totalRows_rsCheckTotal = mysql_num_rows($rsCheckTotal); $swap = $totalRows_rsCheckTotal + 1; $max_emp = $totalRows_rsCheckTotal; mysql_query("UPDATE tcAgent_list SET rotation_num='$swap' WHERE active='1' AND active_group = 'TC' AND rotation_num='1'"); do { mysql_query("UPDATE tcAgent_list SET `rotation_num` = `rotation_num` - 1 WHERE active='1' AND active_group = 'TC' AND rotation_num NOT LIKE '$swap'"); } while ($max_emp<=1); mysql_query("UPDATE tcAgent_list SET rotation_num='$max_emp' WHERE active='1' AND active_group = 'TC' AND rotation_num='$swap'"); } ?> So basically it figures out how many there are, sets the current #1 person to one higher than the total, subtracts 1 from existing then changes the highest to 1 lower. Complex and clumsy YEP, but it works

Search didn't seem to show me an existing post so here it goes. I have dropdowns on my form. They are meant to show 3 colors. Green, Yellow, Red as the color, not the words. <select name="box1" id="box1" class="textboxstyle" size="1"> <option value="-" selected="selected">Please select</option> <option value="#00FF00" style="background-color: #00FF00"></option> <option value="#FFFF00" style="background-color: #FFFF00"></option> <option value="#FF0000" style="background-color: #FF0000"></option> </select> This works great in IE. In Firefox, it shows the colors when the menu is dropped down but once one is selected, the box shows white. The value is recorded, but looking at it, they are all just white regardless of what was selected. I tried to remove the general styling but it didn't help class="textboxstyle" .textboxstyle { font-family: Arial, Helvetica, sans-serif; font-size: 11px; color: #000; border: 1px solid #49166D; background-color: #FFFFFF; } Any ideas?

Sweet Mary Jane, thats pretty epic Andy-H!

Wicked stuff! When I do print_r($user); I see User1 Am i displaying this right? Also, how is this script rotating the users and what time frame is it basing this rotation? Like if I wanted the users to change say every sunday. Pardon my lack of programming knowledge. I'm just really digging this work and learning lots

Ok, starting to see how these are used. Getting Warning: Wrong parameter count for array_push() though, looks right when I checking the php manual for array_push.

Thanks for the quick response teamatomic. I've been reading up on what you suggested and I just can't grasp it. I'm by no means a good programmer so this basically went over my head. Although i'm learning a lot from the reading, I'm just not at a point where I can build it from scratch.

Every week we have a bid on scheduled shifts. What I want to do is make this list of users rotate every week so the person who got first pick this week is now last on the list. Example.... Week 1 User1 User2 User3 Week 2 User2 User3 User1 Week 3 User3 User1 User2 And so on with many other users. I have no idea where to start on this. All I could think was to assign each user a number then every week, add 10 to the first person in the list but I think this is not the way to do it. My app is done in PHP/MySQL.

Great stuff, thanks Mchl! I haven't heard of operator precedence before but i'm about to do some reading on it. Thanks for the info

I think I got it. Did this and it seems to work SELECT stn, tdate FROM NS_data WHERE stn LIKE '780%' AND tdate = '2010-04-29' OR stn LIKE '403%' AND tdate = '2010-04-29' Is this the right way to do it?

Good stuff everyone, thanks for the advise and info! Problem i'm running into now is that I can't figure out the proper way to do the entire query. This works for grabbing all numbers in the 3 area codes. SELECT stn, tdate FROM NS_data WHERE stn LIKE '780%' OR stn LIKE '403%' OR stn LIKE '587%' But when I do this SELECT stn, tdate FROM NS_data WHERE stn LIKE '780%' OR stn LIKE '403%' OR stn LIKE '587%' AND tdate = '$date' It doesn't narrow down by the $date variable which is just set to todays date. I'm guessing its got something to do with using OR's and AND's in the same query. Suggestions?

I have a column that stores 10 digit phone numbers from different provinces. What i'm trying to do is to extract all phone numbers from 1 province. This province has 3 different area codes. Here's what I have so far. <?php $sql = " SELECT dslam, COUNT(*) as total FROM NS_data WHERE stn IN ('780%','403%','587%') AND tdate = '$date' GROUP BY dslam ORDER BY total DESC "; $res = mysql_query($sql); while (list($id, $tot) = mysql_fetch_row($res)) { echo "$id - $tot <br />"; } ?> Problem as you can see is apparently you can't use wildcards with IN WHERE stn IN ('780%','403%','587%') Not sure how to make it work

actually its on the same page as the form. Trying to keep this as simple as possible lol. $upd_ePad = new tNG_update($conn_cnepix); $tNGs->addTransaction($upd_ePad); $upd_ePad->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Update1"); $upd_ePad->setTable("Pad_data"); $upd_ePad->addColumn("tdate", "DATE_TYPE", "POST", "tdate"); $upd_ePad->addColumn("ttime", "DATE_TYPE", "POST", "ttime"); $upd_ePad->addColumn("data", "STRING_TYPE", "POST", "data_entry"); $upd_ePad->setPrimaryKey("user_name", "STRING_TYPE", "SESSION", "logged_in_user"); $tNGs->executeTransactions(); $rsePad = $tNGs->getRecordset("Pad_data"); $row_rsePad = mysql_fetch_assoc($rsePad); $totalRows_rsePad = mysql_num_rows($rsePad);

I'm making a simple page by request from my boss. The page has 1 textarea. What he wants is when he types something in the textarea for it to save when the page looses focus. .... kinda like an auto save function. I've been trying to do this using a simple form and submitting it via javascript but its not saving to the database. <script type="text/javascript"> function submitform() { document.form1.submit(); } </script> <form method="post" name="form1" id="form1" action="entry.php"> <textarea name="data_entry" id="data_entry" class="textareastyle" cols="150" rows="24" onblur="submitform();"><?php echo KT_escapeAttribute($row_rsePad['data']); ?></textarea> <input type="hidden" name="tdate" id="tdate" value="<?php echo(date('Y-m-d'))?>" /> <input type="hidden" name="ttime" id="ttime" value="<?php echo(date('H:i:s'))?>" /> </form> The form submits, but its not being written to the database. Kinda like the page is just being refreshed. If I add a submit button, it works but only if the button is clicked. Suggestions?

Great stuff! Only problem im having is when I use $resolved and $dispatch, the output I get is Array and not the actual value. I'm stumped

Tried this, but its not working. SELECT level1, level2, resolution, count( * ) AS "total" FROM `NS_data` WHERE tdate = '$date' GROUP BY level1, level2, resolution ORDER BY level1, level2, resolution Perhaps i'm not displaying it right

So I need to retrieve the totals of certain queries from the same DB table. Basically need to display the total records for certain conditions. For example, here's part of the queries $query_rsToday1 = " SELECT data_id FROM data WHERE tdate = '$date' AND resolution = 'Resolved' "; $rsToday1 = mysql_query($query_rsToday1, $cnepix) or die(mysql_error()); $totalRows_rsToday1 = mysql_num_rows($rsToday1); $query_rsToday2 = " SELECT data_id FROM data WHERE tdate = '$date' AND resolution = 'Dispatch' "; $rsToday2 = mysql_query($query_rsToday2, $cnepix) or die(mysql_error()); $totalRows_rsToday2 = mysql_num_rows($rsToday2); $query_rsToday3 = " SELECT data_id FROM data WHERE tdate = '$date' AND level1 = 'Abandon' "; $rsToday3 = mysql_query($query_rsToday3, $cnepix) or die(mysql_error()); $totalRows_rsToday3 = mysql_num_rows($rsToday3); I just then display the counts like <?php echo $totalRows_rsToday1; ?> There has got to be an easier way to condense the queries but I just can't figure it out.

Sorry, that makes total sense now. Thank you for the help

Thanks for the reply and code! but im not sure how to implement that. Sorry, still learning this crazy php stuff How would I use that in my code?

Hey all, got a problem. Please be kind against my barbaric code I have a textbox that will search the employee database by entering in the employee ID and it will return the result on the same page. Query if(isset($_GET['findagentid']) && $_GET['findagentid']<>""){ $emp_id = $_GET['findagentid']; mysql_select_db($database_cnccoems, $cnccoems); $query_rsagentquery1 = "SELECT tblEmployees.employee_pdl_mgr_id, tblManagerOverrides.manager_id, tblEmployees.employee_first_name, tblEmployees.employee_last_name, tblEmployees.employee_id FROM tblEmployees LEFT JOIN tblManagerOverrides ON tblEmployees.employee_id = tblManagerOverrides.employee_id WHERE tblEmployees.employee_id LIKE '%$emp_id%' "; $rsagentquery1 = mysql_query($query_rsagentquery1, $cnccoems) or die(mysql_error()); $row_rsagentquery1 = mysql_fetch_assoc($rsagentquery1); $totalRows_rsagentquery1 = mysql_num_rows($rsagentquery1); if(!is_null($row_rsagentquery1['manager_id'])){ $manager_id=$row_rsagentquery1['manager_id']; } else { $manager_id=$row_rsagentquery1['employee_pdl_mgr_id']; } } Form <form method="get" id="agentretrieval" action="callDetail1.php"> <table align="center" cellpadding="2" cellspacing="0"> <tr> <td><div align="right">Find Agent Info :</div></td> <td><div align="left"><input type="text" name="findagentid" id="findagentid" class="textboxstyle" size="10" maxlength="7" /> (Digits Only)</div><div class="accenttext"><?php echo $tNGs->displayFieldError("NS_data", "flagentTID"); ?></div> <div align="left"><input type="submit" class="button1" name="findagentbutton" id="findagentbutton" value="Find" /></div></td> </tr> </table> </form> This works great if entering in digits only like 845787 as they are stored in the database like 00845787. Problem I have is that the ID's are sometimes retrieved by users from another DB with a letter infront of the numbers (eg t845787 or x845787) in one database, but the one I retrieve from has no letter in front. Hard to explain. Basically Im trying to accomplish this. They can put t845787 in the text box, hit search and it will strip off the t or x from the ID and search the database. Did I explain that right? Can't figure this out