james182

I have a time array and a event array and i need the 2 to join, could i get some help. So basically the All the times need be there and if there is a match event then it shown and if not nothing. What i have so far: Time Array Array ( [06:00:00] => 06:00:00 [07:00:00] => 07:00:00 [08:00:00] => 08:00:00 [09:00:00] => 09:00:00 [09:30:00] => 09:30:00 [17:30:00] => 17:30:00 [18:00:00] => 18:00:00 [18:30:00] => 18:30:00 [19:30:00] => 19:30:00 ) Event Array Array ( [0] => stdClass Object ( [class_id] => 1 [class_name] => Fit Box [class_description] => Fitbox is a high energy aerobic workout utilizing focus pads, kick pads, heavy bags, and speed balls. This class increases muscle strength and cardiovascular fitness and also includes strength and endurance circuit style training. Excellent for co-ordination, reflexes and to pump out the adrenalin! The class is 1 hour in duration. [class_time] => 06:00:00 [class_day] => Tuesday [class_status] => active [class_colour] => blue ) [1] => stdClass Object ( [class_id] => 2 [class_name] => Hot Boxing [class_description] => test description [class_time] => 08:00:00 [class_day] => Wednesday [class_status] => active [class_colour] => grey ) [2] => stdClass Object ( [class_id] => 3 [class_name] => Punch Face [class_description] => test again [class_time] => 09:00:00 [class_day] => Thursday [class_status] => active [class_colour] => grey ) [3] => stdClass Object ( [class_id] => 4 [class_name] => MOS [class_description] => test again [class_time] => 19:30:00 [class_day] => Monday [class_status] => active [class_colour] => yellow ) [4] => stdClass Object ( [class_id] => 5 [class_name] => Yoga [class_description] => test description [class_time] => 08:00:00 [class_day] => Wednesday [class_status] => active [class_colour] => grey ) ) The Code that aims at displaying all the times and each time has all the days, then each day needs to show events if they have them. $result_array = array(); $days_array = array("Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"); foreach($timetable_times as $time_key => $time_value) { // initialize all the days of the week for each time entry $result_array[$time_value['time']] = array(); foreach($days_array as $day) { $result_array[$time_value['time']][$day] = ""; } if (array_key_exists($day, $timetable_classes)) { $event_entry = $timetable_classes[$time_value['time']]; foreach($event_entry as $event_day => $events) { $result_array[$time_value['time']][$day][] = $events; } } } print_r($result_array); My desired outcome is below $arr = array( "06:00:00" => array( "Sunday" => array( array( 'event_title' => "item_1", 'event_desc' => "item_1", 'event_link' => "item_1", ), ), "Monday" => array( array( 'event_title' => "item_1", 'event_desc' => "item_1", 'event_link' => "item_1", ), array( 'event_title' => "item_1", 'event_desc' => "item_1", 'event_link' => "item_1", ), ), "Tuesday" => "", "Wednesday" => "", "Thursday" => "", "Friday" => "", "Saturday" => "" ), "07:00:00" => array("Sunday" => "", "Monday" => "", "Tuesday" => "", "Wednesday" => "", "Thursday" => "", "Friday" => "", "Saturday" => ""), "08:00:00" => array("Sunday" => "", "Monday" => "", "Tuesday" => "", "Wednesday" => "", "Thursday" => "", "Friday" => "", "Saturday" => ""), "09:30:00" => array("Sunday" => "", "Monday" => "", "Tuesday" => "", "Wednesday" => "", "Thursday" => "", "Friday" => "", "Saturday" => ""), "17:00:00" => array("Sunday" => "", "Monday" => "", "Tuesday" => "", "Wednesday" => "", "Thursday" => "", "Friday" => "", "Saturday" => ""), );

I have that too. but why is it adding the \' to it ??? the \' is stopping my query from working.. SELECT * FROM (`default_products_diamonds`) WHERE `shape` = 'Princess' AND `colour` IN ('\'D\',\'E\',\'F\'')

i have a problem. $colours = implode("','", explode('-', substr_replace($colour ,"",-1))); // outputs: D','E','F "','" is getting placed in the query as "\',\'" need to change '\'E\',\'F\'' SELECT * FROM (`default_products_diamonds`) WHERE `shape` = 'Princess' AND `colour` IN ('\'D\','\'E\',\'F\'') Needs to be like this: SELECT * FROM (`default_products_diamonds`) WHERE `shape` = 'Princess' AND `colour` IN ('D','E','F')

I don't seem to be having much luck with this any help would be great. Trying to select multiple colours. $query = "SELECT * FROM diamonds WHERE colour IN ('D', 'E', 'F')"; ... Not working My exact Code public function get_diamond_by_shape($shape,$scat_id,$colour,$clarity,$certification,$cut,$polish,$symmetry,$fluorescence,$min_carat,$max_carat,$min_price,$max_price) { //$colours = "'". implode("','", explode('-', substr_replace($colour ,"",-1))) ."'"; $colours = explode('-', substr_replace($colour ,"",-1)); $clarities = explode('-', substr_replace($clarity ,"",-1)); $certifications = explode('-', substr_replace($certification ,"",-1)); print_r($shape); $this->db->where('shape', $shape); $this->db->or_where_in('colour', $colours); $this->db->or_where_in('clarity', $clarities); $this->db->or_where_in('certification_type', $certifications); /* $this->db->where('cut', $cut); $this->db->where('polish', $polish); $this->db->where('symmetry', $symmetry); $this->db->where('fluorescence', $fluorescence); */ $this->db->where('carat >=', $min_carat); $this->db->where('carat <=', $max_carat) ; $this->db->where('cost BETWEEN ' . $min_price . ' AND ' . $max_price); $diamonds = $this->db->get('products_diamonds'); return $diamonds->result_array(); } Post data is: certi all, clarity all, colour = D-E-F-G-, cut = all, flou = all, maxprice = 100000, maxval = 5, minprice = 100, minval = 0.01, pg = 1, polish = all, scat_id = null, shape = Princess, sym = all Using CodeIgniter Framework

Thanks for that.

i am trying to get this to format the data properly. I want it to format like this 'D',E','F','G','H' But this is what i get: "D"E","F","G","H","I",J" "", $colour = "D-E-F-G-H-I-J-"; // string to be formatted. $colours = explode('-', $colour); $num_items = count($colours); $colour_is = ''; $i = 0; foreach ($colours as $key => $value) { if ($i == 0) { // first $colour_is .= ' "'. $value; } else if ($i == $num_items - 1) { // last $colour_is .= $value. '" '; }else{ $colour_is .= '"'. $value .'",'; } $i++; } print_r($num_items .' - '. $colour_is); Help on this would be nice. Thanks.

any help??

I am trying to get the script to insert the new order into the mysql db but don't know how any help. below is the working up down list but i need it to save / update the new positions. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-US"> <head profile="http://gmpg.org/xfn/11"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>test list sort</title> <script type='text/javascript' src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script> <script> $(document).ready( function () { $('table tbody a.control').live('click', function (e) { e.preventDefault(); var tr = $(this); // Start with this link and work upwards from there, this allows the TR element itself to be the control if desired var iterations = 0; while(tr.attr('tagName') != 'TR') { tr = tr.parent(); iterations += 1; if (iterations == 100) { return false; // Bail out, surely something is wrong or there is lots and lots of html in there } } if ($(this).attr('rel') == 'up' && tr.prev().length) tr.fadeTo('medium', 0.1, function () { tr.insertBefore(tr.prev()).fadeTo('fast', 1); // If you want to do any more to the table after the move put it here, I am running the reorder function (defined below) reorder(); }); else if ($(this).attr('rel') == 'down' && tr.next().length) // Same as above only this is for moving elements down instead of up tr.fadeTo('fast', 0.1, function () { tr.insertAfter(tr.next()).fadeTo('fast', 1); // If you want to do any more to the table after the move put it here, I am running the reorder function (defined below) reorder(); }); else //Can't do anything with these return false; return false; }); function reorder () { var position = 1; $('table tbody tr').each(function () { // Change the text of the first TD element inside this TR $('td:first', $(this)).text(position); //Now remove current row class and add the correct one $(this).removeClass('row1 row2').addClass( position % 2 ? 'row1' : 'row2'); position += 1; }); } }); </script> </head> <body> <?php echo '<table> <thead> <tr> <th>Position</th><th>Name</th><th>Controls</th> </tr> </thead> <tbody>'; $con = mysql_connect("localhost", "*******", "*********") or die(mysql_error()); mysql_select_db("my_test", $con) or die(mysql_error()); $sql = "SELECT * FROM tbl_items ORDER BY item_order ASC"; $result = mysql_query($sql); $i = 1; while($r = mysql_fetch_assoc($result)): echo '<tr class="'.$i.'"> <td>'. $i .'</td><td>'. $r['item_name'] .'</td><td> <a href="#up" rel="up" class="control">Up</a> <a href="#down" rel="down" class="control">Down</a></td> </tr>'; $i++; endwhile; echo '</tbody></table>'; ?> </body> </html> db table: item_id | item_name | item_order ---------|--------------|------------- 1 | green | 1 2 | blue | 2 3 | red | 3

ok here is my code it works great in Firefox but not at all in IE. The code should post the id of a item via ajax post method. Javascript: $(document).ready(function(){ $('a.addFavs').click(function(){ var favData = $(this).attr('id'); $.post("path/to/addFav.php",{ send_favData: favData }, function(data){ $('#msg').html(data.returnValue); }, "json"); }); addFav.php <?php include_once("config.php"); //addFavourite($_GET['send_favData']); // TESTING if (isset($_POST['send_favData'])){ $value = $_POST['send_favData']; }else{ $value = "No Data"; } echo json_encode(array("returnValue"=>"Value Returned: ".$value), true); ?> Function.php function addFavourite($favData){ global $link; $data = explode(",", $favData); $query = "INSERT INTO tbl_favourites (fav_id, fav_user_id, fav_item_id, fav_cat_id, fav_section_id) VALUES (NULL, '$data[0]', '$data[1]', '$data[2]', '$data[3]')"; $result = mysql_query($query, $link) or die("add Favourites fatal error: ".mysql_error()); if($result){ echo "<p>Successful!</p>"; }else{ echo "<p>Failed!</p>"; } }

So probably the question i should be asking is how to send data to a var. Is this right?? class myClass { var myVar; echo $myVar; function test() { $myVar = "test"; } }

ok let me say that my code all works except for the the storing of the array item number: if($value != self::show_page_name($page_name)): echo '<li><a class="h-ico ico-'. $menu_item_icon[$i] .'" href="'. parent::get_site_url() .'admin/'. $menu_item_link[$i] .'"><span>'. $value .'</span></a></li>'; else: echo ''; $this->item_key = $value; // PROBLEM IS HERE, IT'S NOT SENDING TO VAR OUTSIDE OF THIS FUNCTION. endif;

function show_page_name($string) { $page_name = $string; $words = split("[/]", $page_name); $page_name = $words[3]; $page_name = substr($page_name, 0, strrpos($page_name, '.')); $page_name = ucfirst($page_name); return $page_name; } show page name just remove slashes in string eg: "/to/be/members.php" becomes "members". Have i gone about storing the data in a var the right way???

The problem is that it's not storing the data. for example if i click the members btn (which is 8 in the array) the number 8 should be echo'd out, in my test echo (echo 'Key: '. $this->item_key; // Testing purpose only.).

i am trying to pull out the correct item key in and array and store it in the "item_key" variable. class myClass{ var $item_key; function get_menu($page_name) { $menu_item = array("Dashboard", "Content", "Comments", "Media", "Syndication", "Newsletter", "Affiliate", "Appearance", "Members", "Settings"); $menu_item_link = array("dashboard", "content", "comments", "media", "syndication", "newsletter", "affiliate", "appearance", "members", "settings"); $menu_item_icon = array("dashboard", "edit", "comments", "media", "syndication", "send", "cash", "color", "users", "advanced"); echo 'Key: '. $this->item_key; // Testing purpose only. echo '<h2><span class="h-ico ico-'. $menu_item_icon[$this->item_key] .'"><span>'. self::show_page_name($page_name) .'</span></span> <span class="h-arrow"></span> </h2>'; echo '<ul class="clearfix">'; $i=0; foreach($menu_item as $key => $value): if($value != self::show_page_name($page_name)): echo '<li><a class="h-ico ico-'. $menu_item_icon[$i] .'" href="'. parent::get_site_url() .'cp/'. $menu_item_link[$i] .'"><span>'. $value .'</span></a></li>'; else: echo ''; $this->item_key = $key; endif; $i++; endforeach; echo '</ul>'; } }

Well thats just it i'm not. nothing happens i should get a response either successful or failed. not getting anything.

i'm trying to get this ajax login script to work. getting no response from ajax. Please if someone can fix it, that would be great. jquery.js: /*************************************** * LOGIN AJAX ***************************************/ $(document).ready(function() { $('#errorConsole').hide(); $('form[name=admin_login]').submit(function() { $('#errorConsole').slideUp(); $.post('../login.php', { username: $('[name=username]').val(), password: $('[name=password]').val() }, function(data) { if(data.success) { location.href = data.redirect; } else { $('#errorConsole').html(data.message).slideDown(); } }, 'json'); return false; }); }); login.php: if($_REQUEST['action'] == "login"){ if($log->login("logon", $_REQUEST['username'], $_POST['password']) == true){ //do something on successful login $data['success'] = true; $data['redirect'] = '#'; }else{ //do something on FAILED login echo 'WRONG ... '; $data['success'] = false; $data['message'] = 'Oops'; } echo json_encode($data); } Index.php: <div class="box box-50 altbox"> <div class="boxin"> <div class="header"> <h3><img src="_css/img/logo-login.png" alt="CMS Admin" /></h3> <ul> <li><a href="#" class="active">login</a></li><!-- .active for active tab --> <li><a href="#">lost password</a></li> </ul> </div> <FORM id="'.$formname.'" class="'.$formclass.'" method="post" name="'.$formname.'" action="'.$formaction.'" > <!-- Default forms (table layout) --> <div class="inner-form"> <div id="errorConsole" class="msg msg-error"></div> <table cellspacing="0"> * Notify me of replies. <tr> <th><label for="username">Username:</label></th> <td><input class="txt" type="text" id="username" name="username" value="demo" /></td> </tr> <tr> <th><label for="password">Password:</label></th> <td><input class="txt pwd" type="password" id="password" name="password" value="demos" /></td><!-- class error for wrong filled inputs --> </tr> <tr> <th></th> <td class="tr proceed"> <input id="action" value="login" type="hidden" name="action"> <input class="button" type="submit" value="Log in" /> </td> </tr> </table> </div> </form> </div> </div>

trying to get my image gallery script working. the probelm is the setup of the images. i need to display like: 123 456 $limit = 6; // img per page $start = 1; $slice = 9; $img_category = "CV"; //$img_category = $_GET['img_category']; $query = "SELECT * FROM tbl_imagebank WHERE img_category = '$img_category' ORDER BY img_name ASC "; $result = mysql_query($query, $link) or die("pagination fatal error: ".mysql_error()); $totalrows = mysql_num_rows($result); if(!isset($_GET['pg']) ||!is_numeric($_GET['pg'])){ $page = 1; } else { $page = $_GET['pg']; } $numofpages = ceil($totalrows / $limit); $limitvalue = $page * $limit - ($limit); $query = "SELECT * FROM tbl_imagebank WHERE img_category = '$img_category' ORDER BY img_name ASC LIMIT $limitvalue, $limit "; $result = mysql_query($query, $link) or die("pagination fatal error: ".mysql_error()); echo "<table border='0' cellpadding='10' cellspacing='10'>"; $num = 0; while($r = mysql_fetch_array($result)){ $num = $num + 1; if($num % 2 == 0){ echo "<td valign='top' width='50%'>"; echo "<table class='product_display'>"; echo "<tr><td>"; echo "<a href='#' id='". $r["img_file"] ."' class='preview'><img src='". $r["img_file"] ."' width='100' border='0' /></a>"; echo "</td></tr>"; echo "</table>"; echo "</td></tr>"; }else{ echo "<tr><td valign='top' width='50%'>"; echo "<table class='product_display'>"; echo "<tr><td>"; echo "</td></tr>"; echo "</table>"; echo "</td>"; } } if($num % 2 != 0){ echo "</td></tr>"; } echo "</table>"; echo "<p>"; if($page!= 1){ $pageprev = $page - 1; echo '<a href="image_bank.php?pg='.$pageprev.'&img_category='.$img_category.'">PREV</a> - '; }else{ echo "PREV - "; } if (($page + $slice) < $numofpages) { $this_far = $page + $slice; } else { $this_far = $numofpages; } if (($start + $page) >= 10 && ($page - 10) > 0) { $start = $page - 10; } for ($i = $start; $i <= $this_far; $i++){ if($i == $page){ echo "<b>".$i."</b> "; }else{ echo '<a href="image_bank.php?pg='.$i.'&img_category='.$img_category.'">'.$i.'</a> '; } } if(($totalrows - ($limit * $page)) > 0){ $pagenext = $page + 1; echo ' - <a href="image_bank.php?pg='.$pagenext.'&img_category='.$img_category.'">NEXT</a>'; }else{ echo " - NEXT"; } echo "</p>";

Spot on, thanks.

ok i have a random key generator which works fine but i need to split it into groups of 4 and seperated by "-". eg: 0000-0000-0000-0000-0000 <- this is may goal. Below is my code so far. function str_makerand($country, $state, $minlength, $maxlength, $useupper, $usespecial, $usenumbers){ $charset = "abcdefghijklmnopqrstuvwxyz"; if ($useupper) $charset .= "ABCDEFGHIJKLMNOPQRSTUVWXYZ"; if ($usenumbers) $charset .= "0123456789"; if ($usespecial) $charset .= "~@#$%^*()_+-={}|]["; // Note: using all special characters this reads: "~!@#$%^&*()_+`-={}|\\]?[\":;'><,./"; if ($minlength > $maxlength){ $length = mt_rand ($maxlength, $minlength); }else{ $length = mt_rand ($minlength, $maxlength); for ($i=0; $i<$length; $i++){ $key .= $charset[(mt_rand(0,(strlen($charset)-1)))]; } } $seq = $country ."". $state ."". $key; // split string to XXXX-XXXX-XXXX-XXXX-XXXX return $seq; }

Look at my code thats the whole thing

here is my full search code: <div id="global_search"> <div id="search_form"> <p>Search for: Clients, Jobs, Members, Documents, and more.</p> <form action="<?php site_url();?>search/8/true/" method="POST" > <p>Find:<input type="text" name="name" value="" class="searchField" /> <input type="hidden" name="name_store" value="<?php echo $_POST['name']?>" class="searchField" /> <select name="tblSearch" class="searchSelect"> <option value="tbl_clients" selected>Clients</option> <option value="tbl_jobdata">Jobs</option> <option value="tbl_users">Members</option> <option value="tbl_docs">Documents</option> </select> <input type="submit" name="submit" value="Search" class="searchbtn" /></p> </form> </div> </div> <?php if(isset($_POST['submit'])){ field_validator("name", $_POST['name'], "alphanumeric", 2, 150); echo "begin: ". $_POST['name'] ."<br />"; if($messages){ //showForm(); echo "Type more then 2 charaters"; exit; } if(isset($_GET['go'])){ echo "<div id='search_results'>"; if(preg_match('|^[a-zA-Z0-9!@#$%^&*();:_.\\\\ /\t-]+$|', $_POST['name'])){ $q = $_POST['name']; $db_tbl = $_POST['tblSearch']; echo "after: ". $_POST['name'] ."<br />"; global $link; switch($db_tbl){ case "tbl_clients": $query = "SELECT * FROM tbl_clients WHERE client_name LIKE '%" . $q . "%' OR client_postal_address LIKE '%" . $q ."%' OR client_street_address LIKE '%" . $q ."%' OR client_industry LIKE '%" . $q ."%' "; $result = mysql_query($query, $link) or die("Search Clients fatal error: ".mysql_error()); echo "<ul>"; while($r = mysql_fetch_array($result)){ ?> <li><a href="<?php site_url() ?>search_detail/8/<?php echo $db_tbl ?>/<?php echo $r["client_id"] ?>/<?php echo $_POST['name'] ?>/">» <?php echo $r["client_name"]; ?></a><br> <b>Contact:</b> <?php echo $r["client_contact"] ?> ~ <b>Industry:</b> <?php echo $r["client_industry"] ?></li> <?php } echo "</ul>"; break; case "tbl_jobdata": $query = "SELECT * FROM tbl_jobdata WHERE job_name LIKE '%" . $q . "%' OR job_number LIKE '%" . $q ."%' OR job_office LIKE '%" . $q ."%' "; $result = mysql_query($query, $link) or die("search fatal error: ".mysql_error()); echo "<ul>"; while($r = mysql_fetch_array($result)){ ?> <li><a href="<?php site_url() ?>search_detail/8/<?php echo $db_tbl ?>/<?php echo $r["job_id"] ?>/">» <?php echo $r["job_name"] ?></a> <br /> <b>Job #:</b> <?php echo $r["job_number"] ?> ~ <b>Leader:</b> <?php echo $r["job_leader"] ?> ~ <b>Office:</b> <?php echo $r["job_office"] ?></li> <?php } echo "</ul>"; break; case "tbl_users": $query = "SELECT * FROM tbl_users WHERE user_firstname LIKE '%" . $q . "%' OR user_surname LIKE '%" . $q ."%' ORDER BY user_firstname ASC "; $result = mysql_query($query, $link) or die("search fatal error: ".mysql_error()); echo "<ul>"; while($r = mysql_fetch_array($result)){ $user_firstname = $r["user_firstname"]; $user_surname = $r["user_surname"]; $user_id = $r["user_id"]; ?> <li><a href="<?php site_url();?>account/3/<?php echo $user_id ?>/user/">» <?php echo $user_firstname ?> <?php echo $user_surname ?></a><br /> <b>Email:</b> <a href="mailto:<?php echo $r["user_email"] ?>"><?php echo $r["user_email"] ?></a> ~ <b>EXT:</b> <?php echo $r["user_extension"] ?></li> <?php } echo "</ul>"; break; case "tbl_docs": $query = "SELECT * FROM tbl_docs WHERE doc_name LIKE '%" . $q . "%' OR doc_tags LIKE '%" . $q ."%' "; $result = mysql_query($query, $link) or die("search fatal error: ".mysql_error()); echo "<ul>"; while($r = mysql_fetch_array($result)){ $doc_name = $r["doc_name"]; $doc_tags = $r["doc_tags"]; $doc_id = $r["doc_id"]; ?> <li><a href="<?php site_url() ?>doc_view/<?php echo $r["doc_id"] ?>/">» <?php echo $doc_name ?></a><br /> <b>Description:</b> <?php echo $r["doc_description"] ?><br /> <b>Tags:</b> <?php echo $r["doc_tags"] ?></li> <?php } echo "</ul>"; break; } }else{ echo "<p>Please enter a search query</p>"; } echo "</div>"; } }

i am trying to search my DB if i type a word it's fine but if i use a space between words like hello world, i don't get anything even if i know that there is data to display. Below is my preg_match statement for checking, i need to allow spaces. if(preg_match('|^[a-zA-Z0-9!@#$%^&*();:_.\\\\ /\t-]+$|', $_POST['name'])){ }

this has me stumped! phpMyAdmin is not connecting to MySQL. the error: #2005 - Unknown MySQL Server host 'localhost' (11004) Config below: Apache: Listen 80 SERVERNAME localhost:80 MySQL: port = 3306 phpMyAdmin Config: /* Servers configuration */ $i = 0; /* Server: localhost [1] */ $i++; $cfg['Servers'][$i]['verbose'] = 'localhost'; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = '3306'; $cfg['Servers'][$i]['socket'] = ''; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'myUsername'; $cfg['Servers'][$i]['password'] = 'myPassword'; $cfg['Servers'][$i]['AllowNoPasswordRoot'] = true; /* End of servers configuration */ These settings work on my pc but not on the windows server (Windows 2003 Server).

final stage just need it to open and close properly.... please help this is getting nuts.

Ok here is the full code, folder attached. i have the output from the DB done but the tree menu still wont operate correctly. Run it and see. CREATE TABLE tbl_tree_menu ( treeview_id int(11) NOT NULL auto_increment, treeview_name varchar(155) NOT NULL, treeview_desc varchar(155) NOT NULL, treeview_ext varchar(4) NOT NULL, treeview_parent_id int(11) NOT NULL, PRIMARY KEY (treeview_id) ) TYPE=MyISAM AUTO_INCREMENT=79 ; -- -- Dumping data for table 'tbl_treeview' -- INSERT INTO tbl_tree_menu (treeview_id, treeview_name, treeview_desc, treeview_ext, treeview_parent_id) VALUES (1, 'root', 'folder', '', 0), (2, '1. Corporate', 'folder', '', 1), (3, '2. Divisional', 'folder', '', 1), (4, '1. Systems', 'folder', '', 2), (5, '2. Policies', 'folder', '', 2), (6, '3. Processes', 'folder', '', 2), (7, '4. Quality Assurance', 'folder', '', 2), (8, '5. Risk Management', 'folder', '', 2), (9, '6. Administration', 'folder', '', 2), (10, '1. Standards', 'folder', '', 7), (11, '2. Guidelines', 'folder', '', 7), (12, '3. Templates', 'folder', '', 7), (13, '4. Forms', 'folder', '', 7), (14, '5. Registers', 'folder', '', 7), (15, '1. Standards', 'folder', '', , (16, '2. Guidelines', 'folder', '', , (17, '3. Templates', 'folder', '', , (18, '4. Forms', 'folder', '', , (19, '5. Registers', 'folder', '', , (20, '1. General Administration', 'folder', '', 9), (21, '2. Human Resources', 'folder', '', 9), (22, '3. WH&S', 'folder', '', 9), (23, '4. Finance', 'folder', '', 9), (24, '5. IT', 'folder', '', 9), (25, '6. Legal', 'folder', '', 9), (26, '1. Civil', 'folder', '', 3), (27, '2. Structural', 'folder', '', 3), (28, '3. Hydraulic', 'folder', '', 3), (29, '4. Building', 'folder', '', 3), (30, '5. Telco', 'folder', '', 3), (31, '6. Project Management', 'folder', '', 3), (32, '7. Drafting', 'folder', '', 3), (33, '8. Cross Divisional General', 'folder', '', 3), (34, '1. Standards', 'folder', '', 26), (35, '2. Guidelines', 'folder', '', 26), (36, '3. Templates', 'folder', '', 26), (37, '4. Forms', 'folder', '', 26), (38, '5. Register', 'folder', '', 26), (39, '1. Standards', 'folder', '', 27), (40, '2. Guidelines', 'folder', '', 27), (41, '3. Templates', 'folder', '', 27), (42, '4. Forms', 'folder', '', 27), (43, '5. Registers', 'folder', '', 27), (44, '1. Standards', 'folder', '', 28), (45, '2. Guidelines', 'folder', '', 28), (46, '3. Templates', 'folder', '', 28), (47, '4. Forms', 'folder', '', 28), (48, '5. Registers', 'folder', '', 28), (49, '1. Standards', 'folder', '', 29), (50, '2. Guidelines', 'folder', '', 29), (51, '3. Templates', 'folder', '', 29), (52, '4. Forms', 'folder', '', 29), (53, '5. Registers', 'folder', '', 29), (54, '1. Standards', 'folder', '', 30), (55, '2. Guidelines', 'folder', '', 30), (56, '3. Templates', 'folder', '', 30), (57, '4. Forms', 'folder', '', 30), (58, '5. Registers', 'folder', '', 30), (59, '1. Standards', 'folder', '', 31), (60, '2. Guidelines', 'folder', '', 31), (61, '3. Templates', 'folder', '', 31), (62, '4. Forms', 'folder', '', 31), (63, '5. Registers', 'folder', '', 31), (64, '1. Standards', 'folder', '', 32), (65, '2. Guidelines', 'folder', '', 32), (66, '3. Templates', 'folder', '', 32), (67, '4. Forms', 'folder', '', 32), (68, '5. Registers', 'folder', '', 32), (69, '1. Standards', 'folder', '', 33), (70, '2. Guidelines', 'folder', '', 33), (71, '3. Templates', 'folder', '', 33), (72, '4. Forms', 'folder', '', 33), (73, '5. Registers', 'folder', '', 33), (74, 'MyDocument', 'document', 'doc', 4), (75, 'my Document 2', 'document', 'jpg', 4), (76, 'my Document 3', 'document', 'doc', 4), (77, 'My Testing', 'document', 'xls', 10), (78, 'My Dooda', 'document', 'xml', 10); [attachment deleted by admin]