brocky

ok i got this sorted. i downloaded the source code and it works fine now. got to love open source

ok i have now got them both with a common feild however when i do a join i end up with the following output: timewheref cachetimefromfhitmissssizehowwheref mimetypeurl 1218001890http://adserver2.synnex.com.au/openads/adjs.php?22041218001890192.168.100.10ALLOWED2204GEThttp://adserver2.synnex.com.au/openads/adjs.php?-http://adserver2.synnex.com.au/openads/adjs.php?n=... 1218001890http://adserver2.synnex.com.au/openads/adjs.php?19821218001890192.168.100.10ALLOWED2204GEThttp://adserver2.synnex.com.au/openads/adjs.php?-http://adserver2.synnex.com.au/openads/adjs.php?n=... 1218001890http://adserver2.synnex.com.au/openads/adjs.php?22041218001890192.168.100.10ALLOWED1982GEThttp://adserver2.synnex.com.au/openads/adjs.php?-http://adserver2.synnex.com.au/openads/adjs.php?n=... 1218001890http://adserver2.synnex.com.au/openads/adjs.php?19821218001890192.168.100.10ALLOWED1982GEThttp://adserver2.synnex.com.au/openads/adjs.php?-http://adserver2.synnex.com.au/openads/adjs.php?n=... Its doubling up on them in some spots because none of the data is unique. Does anyone no how to get it to only dispaly it once

sometimes the data is in common sometimes its almost the same.

I don't see how they would be of any use. Unless someone can demonstrate that it can be used

I have a problem with my database. I have two tables which i want to join together. However these two tables have nothing in common. I want to match up how much came from cache in log_squid to all the other data in log_dg. The wheref fields are sometimes the same and other times different. I am usually pretty good at working these things out but this one has me stumped. I know there is a MySQL LIKE statement but couldn't get that to work. Any ideas would be great. Thanks (See the attached files for some sample data) [attachment deleted by admin]

Does anyone know how to logon to an LDAP/AD database. I am able to read it and all but don't know where to go from there so the user can log on. I am also only wanting to restrict this logon to the Administrators Group only. Any help would be great thanks

For those wondering i forgot to put a setInterval around the div updater

Hi i was wanting to have a div that updates every second or so that displays how long the user has left on the network. I have a basic script that will fetch fro PHP the time the user entered into the zone through MySQL, it all works except for it doesn't update when the data changes. Any ideas anyone? Javascript code (ajax.php) <?php include_once("../../../config.php"); include_once($CFG->dirroot . "/lib/lib.php"); prep_js("ajax.php"); ?> //The core AJAX script for all ajax calls made in this site function createRequestObject() { var req; if(window.XMLHttpRequest) { //Firefox, Safari, Opera... req = new XMLHttpRequest(); } else if(window.ActiveXObject) { //Internet Explorer 5+ req = new ActiveXObject("Microsoft.XMLHTTP"); } else { //There is an error creating the object, just as an old browser is being used. alert('Problem creating the XMLHttpRequest object'); } return req; } var http = createRequestObject(); //Make the XMLHttpRequest object //The code for the AJAX calls made by the login form (mainly the Country -> State -> City selector) function sendTimeInQuar(timeVar) { http.open('get', '<?php echo $CFG->wwwroot; ?>/lib/ajax.php?a=time&timeVar=' + timeVar); http.onreadystatechange = handleTimeInQuar; http.send(null); } function handleTimeInQuar() { if(http.readyState == 4 && http.status == 200) { var response = http.responseText; //Text returned FROM the PHP script if(response) { if(document.getElementById("Remaining")) document.getElementById("Remaining").innerHTML = response; else alert("An AJAX error has occured"); } } } PHP code (ajax.php) <?php include_once("../config.php"); include_once($CFG->dirroot . "/lib/lib.php"); if(($_GET['timeVar']+300)-time() > 0) { echo date("i:s", ($_GET['timeVar']+300)-time()); } else { echo "<span style=\"font-weight:bold;color:#FF0000\">Expired</span>"; } ?> PHP code (index.php) <span id="Remaining"></span><script type="text/javascript">sendTimeInQuar('<?php echo select_client("time"); ?>');</script>

yeah that was going to be a last resort. But by the looks of it, it will be my only resort. Thanks anyway mate

I was just wondering if there was a way to make a progress bar without having to use any perl?

Hey, I need help with a login script. Again. I just want to know how to send a user back to where they just come from Anyone with any ideas please email me (nerd_central@hotmail.com) or post back here Thanks, Glenn

Ok i've almost got it finished. I just can't get the value from the last drop down box in the form. Even when i print out all post values and keys there is no $_POST['city']. Does any1 no why this is or how to fix it? If you have any ideas please post here or email me Regards, Glenn

Ok ive got to the AJAX stage and have done a fair bit in it but im stuck again. Im needing a form that has three drop down boxes not two and don't quiet understand how this works. please email me if you have any suggestions. Ive also got the source code for all + sql database structure. Just i can't post it on the net anywhere

Thanks but i couldn't get the demo code to work any ideas?

I need help with a javascript problem that also includes PHP and SQL. The problem being is that i've got three drop down boxes: the first a country, the second a state/region, and the third is a city. I need it to so when you select a country the states from that country appear in the second drop down box and when you select a state the cities of that state appear in the third drop down box. All this has to be done without reloading the page if possible. I've so far got it to do the selection part and all but it has to reload the page every time it is changed and deletes all user information that was already entered in the form. If you need the source code as well please email me for it. If you have any ideas about this problem please post here ,email, or pm me at: [b]nerd_central@hotmail.com[/b]