Jump to content

Cools

Members
  • Posts

    501
  • Joined

  • Last visited

Everything posted by Cools

  1. Cools

    A2Z

    Office: +44 (0)1530 265656
  2. take the mortgage out with the people you with now.. it should be easyer then take a new one some where else..
  3. Cools

    A2Z

    my old account manager now works for PROMO IT.. i always ask if he's been fired.. yet.. 5 days a go i got a "Errr.. yes.." 28th last moth they went under.. he said. and most of them work for PROMO IT now..
  4. Can I look at your Moodle......please? Dirty boy..
  5. Well i re-did the page.. found some code.. so not all my work. from :: How to use PHP & MySQL Search Rows Data and Paging/Pagination | ShotDev.Com so here it is of any one needs it if you need the autocomplete.js msg me.. or see zip above. session_start(); ob_start(); require_once "conf.inc.php"; ?> <br /> .tableth {<br /> font-family: Tahoma, Geneva, sans-serif;<br /> }<br /> </pre><form name="frmSearch" method="get" action="<?=%24_SERVER%5B'SCRIPT_NAME'%5D;?>"> Students Name "> </form><br><br>if($_GET["txtKeyword"] != "")<br>{<br>$objConnect = mysql_connect("localhost","root","C0nfus3d!") or die(mysql_error());<br>$objDB = mysql_select_db("sen");<br>// Search By Name or Email<br>$strSQL = "SELECT * FROM comments WHERE (users_name LIKE '%".$_GET["txtKeyword"]."%')";<br>$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");<br>$Num_Rows = mysql_num_rows($objQuery);<br><br><br>$Per_Page = 5; // Per Page<br><br>$Page = $_GET["Page"];<br>if(!$_GET["Page"])<br>{<br> $Page=1;<br>}<br><br>$Prev_Page = $Page-1;<br>$Next_Page = $Page+1;<br><br>$Page_Start = (($Per_Page*$Page)-$Per_Page);<br>if($Num_Rows<=$Per_Page)<br>{<br> $Num_Pages =1;<br>}<br>else if(($Num_Rows % $Per_Page)==0)<br>{<br> $Num_Pages =($Num_Rows/$Per_Page) ;<br>}<br>else<br>{<br> $Num_Pages =($Num_Rows/$Per_Page)+1;<br> $Num_Pages = (int)$Num_Pages;<br>}<br><br><br>$strSQL .=" order by date DESC LIMIT $Page_Start , $Per_Page";<br>$objQuery = mysql_query($strSQL);<br><br>?><br><table bgcolor="#0080FF" cellpadding="0" cellspacing="1" width="80%" border="0" align="center"> Student Name Date Comments Lesson Staff Memeber while($objResult = mysql_fetch_array($objQuery)) { ?> =$objResult["users_name"][/url]?> =$objResult["date"][/url]?> =$objResult["lesson"][/url]?> =$objResult["stuser"][/url]?> } ?> </table><br><br><br><br> <p align="center">Total = $Num_Rows;?> Record : =$Num_Pages;?> Page : if($Prev_Page) { echo " << Back "; } for($i=1; $i<=$Num_Pages; $i++){ if($i != $Page) { echo "[ $i ]"; } else { echo " $i "; } } if($Page!=$Num_Pages) { echo " Next>> "; } mysql_close($objConnect); } ?> </p><br><script type="text/javascript"><br /> // <![CDATA[<br /> $(document).ready(function(){ <br /> $("#txtKeyword").autocomplete("ac/get_list.php", {<br /> width: 260,<br /> matchContains: true,<br /> //mustMatch: true,<br /> //minChars: 0,<br /> //multiple: true,<br /> //highlight: false,<br /> //multipleSeparator: ",",<br /> selectFirst: false<br /> });<br /> }); <br /> // ]]><br /> </script><br><br><br><b
  6. Dont worry i spoke to soon.. lol now i have added more test students. it's still not working right.. lol.. but at least next/prev page is working if you want to have a look.. goto http://server.ilimits.co.uk/epms/sen i have zip code to have a look at. http://server.ilimits.co.uk/epms/sen/sen.zip PS. i working from tget2.php to get in fro from DB...
  7. I love you Bud... lol Got it working... i did not need... $totalusers = mysql_num_rows(mysql_query("SELECT id FROM $tablen"));[php] but i need... [php]$totalrows = mysql_num_rows(mysql_query("SELECT id FROM $tablen"));// Counts the total rows [php] but changed to.... [php]$totalrows = mysql_num_rows(mysql_query("SELECT users_name FROM $tablen"));// Counts the total rows [php] and now it works... new code.. [php] include("conf.inc.php"); // Includes the db and form info. $tablen = $con;//Sets the table name $users_name=$_POST['users_name']; //Pagination $limit = 10;// Set the limit of results per page $page = $_GET['page'];// Sets the page, the default is ?page= $totalrows = mysql_num_rows(mysql_query("SELECT users_name FROM $tablen"));// Counts the total rows if(empty($page))// If the page is empty { $page = '1';// Page is 1 }; $start = ($page-1)*$limit; $start = round($start,0);// Sets the start $result = mysql_query("SELECT * FROM $tablen ORDER BY date DESC LIMIT $start, $limit");// Normal query while ($r = mysql_fetch_array($result)) { echo nl2br(" </pre><table align='\"center\"' width='\"80%\"' bgcolor='\"#d8EEF4\"' border='\"0\"' cellpadding='\"1\"' cellspacing='\"0\"'> ".$r["users_name"]." - ".$r["lesson"]." ".$r["comment"]." ".$r["date"]." By ".$r["stuser"]." "); echo (" Delete | Edit "); echo " </table><br>";// Echoes the content<br>};<br>//$totalusers = mysql_num_rows(mysql_query("SELECT id FROM $tablen"));<br>// echo "<br>Total posts: $totalusers<br>";// Echoes the total users<br>$totalpages = $totalrows / $limit;// Get the total pages<br>$totalpages = ceil($totalpages);// Rounds the total pages to the highest possible numer<br>if($page == 1)// If the page is 1<br>{<br>$actualpage = '1';// Sets the actual page<br>}<br>else// Else<br>{<br>$actualpage = "$page";// The page is the one it's specified in ?page=<br>}<br>if($page < $totalpages)// If the actual page is smaller than the totalpages<br>{<br>$nv = $page+1;// Sets the next variable<br>$pv = $page-1;// Sets the preview variable<br>$nextpage = "<a href="?page=%24nv" rel="">></a>";// Sets the next page<br>$prevpage = "<a href="?page=%24pv" rel=""><</a>";// Sets the prev page<br>$firstpage = "<a href="%5C%22?page=1%5C%22" rel="">«</a>";// Sets the first page<br>$finalpage = "<a href="%5C%22?page=%24totalpages%5C%22" rel="">»</a>";// Sets the final page<br>}<br>if($page == '1')<br>{<br>$nv = $page+1;<br>$nextpage = "<a href="?page=%24nv" rel="">></a>";<br>$prevpage = "<";<br>$firstpage = "«";<br>$finalpage = "<a href="%5C%22?page=%24totalpages%5C%22" rel="">»</a>";<br>}elseif($page == $totalpages){<br>$pv = $page-1;<br>$nextpage = ">";<br>$prevpage = "<a href="?page=%24pv" rel=""><</a>";<br>$firstpage = "<a href="%5C%22?page=1%5C%22" rel="">«</a>";<br>$finalpage = "»";<br>}<br>if($totalpages == '1' || $totalpages == '0'){<br> $nextpage = ">";<br> $prevpage = "<";<br> $firstpage = "«";<br> $finalpage = "»";<br>}<br>echo "<p align='\"center\"' class='\"post-footer' align-center> $firstpage $prevpage Actual Page: $actualpage $nextpage $finalpage Pages: $totalpages </p> ";<br><br>?><b
  8. i dont get it.. does this part of the code not do that $result = mysql_query("SELECT * FROM $tablen ORDER BY date DESC LIMIT $start, $limit");// Normal query while ($r = mysql_fetch_array($result)) { echo nl2br(" </pre><table align='\"center\"' width='\"50%\"' border='\"1\"' cellpadding='\"1\"' cellspacing='\"0\"'> ".$r["users_name"]." - ".$r["lesson"]." ".$r["comment"]." ".$r["date"]." By ".$r["stuser"]." "); echo (" Delete | Edit "); echo " </table><br><br>";// Echoes the content <br>}
  9. it's for SEN.. A comment is post in to the MySQL db with Values of : ID, Student_name , Staff_name, Date, Lesson and Comment. so I want to get the same back out but in date order when I search for a student. Other staff members need see the comments as there are added.. at the other end of the school saving on paper work....
  10. wondering if any one could help.. wondering of the any's...... i want to pull a student info from mysql DB, searching for Studen by name but output ordered by date. The code is below... if there's a simple way of doing it.. im all up for it.. it's a OLD bit of code i found and it works so im happy.. it's not for public use, just for in house for staff. ------- this line $result = mysql_query("SELECT * FROM $tablen ORDER BY date DESC LIMIT $start, $limit");// Normal query if i add WHERE users_name='$users_name' $result = mysql_query("SELECT * FROM $tablen WHERE users_name='$users_name' ORDER BY date DESC LIMIT $start, $limit");// Normal query i can search for name and it displays in date order for the next and prev does not work. Thanks. Add a commnet. include("conf.inc.php"); // Includes the db and form info. $tablen = $con;//Sets the table name $users_name=$_POST['users_name']; //Pagination $limit = 10;// Set the limit of results per page $page = $_GET['page'];// Sets the page, the default is ?page= $totalrows = mysql_num_rows(mysql_query("SELECT id FROM $tablen"));// Counts the total rows if(empty($page))// If the page is empty { $page = '1';// Page is 1 }; $start = ($page-1)*$limit; $start = round($start,0);// Sets the start $result = mysql_query("SELECT * FROM $tablen ORDER BY date DESC LIMIT $start, $limit");// Normal query while ($r = mysql_fetch_array($result)) { echo nl2br(" </pre><table align='\"center\"' width='\"50%\"' border='\"1\"' cellpadding='\"1\"' cellspacing='\"0\"'> ".$r["users_name"]." - ".$r["lesson"]." ".$r["comment"]." ".$r["date"]." By ".$r["stuser"]." "); echo (" Delete | Edit "); echo " </table><br><br>";// Echoes the content<br>};<br>$totalusers = mysql_num_rows(mysql_query("SELECT id FROM $tablen"));<br>// echo "<br>Total posts: $totalusers<br>";// Echoes the total users<br>$totalpages = $totalrows / $limit;// Get the total pages<br>$totalpages = ceil($totalpages);// Rounds the total pages to the highest possible numer<br>if($page == 1)// If the page is 1<br>{<br>$actualpage = '1';// Sets the actual page<br>}<br>else// Else<br>{<br>$actualpage = "$page";// The page is the one it's specified in ?page=<br>}<br>if($page < $totalpages)// If the actual page is smaller than the totalpages<br>{<br>$nv = $page+1;// Sets the next variable<br>$pv = $page-1;// Sets the preview variable<br>$nextpage = "<a href="?page=%24nv" rel="">></a>";// Sets the next page<br>$prevpage = "<a href="?page=%24pv" rel=""><</a>";// Sets the prev page<br>$firstpage = "<a href="%5C%22?page=1%5C%22" rel="">«</a>";// Sets the first page<br>$finalpage = "<a href="%5C%22?page=%24totalpages%5C%22" rel="">»</a>";// Sets the final page<br>}<br>if($page == '1')<br>{<br>$nv = $page+1;<br>$nextpage = "<a href="?page=%24nv" rel="">></a>";<br>$prevpage = "<";<br>$firstpage = "«";<br>$finalpage = "<a href="%5C%22?page=%24totalpages%5C%22" rel="">»</a>";<br>}elseif($page == $totalpages){<br>$pv = $page-1;<br>$nextpage = ">";<br>$prevpage = "<a href="?page=%24pv" rel=""><</a>";<br>$firstpage = "<a href="%5C%22?page=1%5C%22" rel="">«</a>";<br>$finalpage = "»";<br>}<br>if($totalpages == '1' || $totalpages == '0'){<br> $nextpage = ">";<br> $prevpage = "<";<br> $firstpage = "«";<br> $finalpage = "»";<br>}<br>echo "<p align='\"center\"' class='\"post-footer' align-center> $firstpage $prevpage Actual Page: $actualpage $nextpage $finalpage Pages: $totalpages </p> ";<br><br>?><br><br><br><br><b
  11. Pc or MAC ffmpeg look up BinKit-v2.0 in google. theres a mac ver and PC and Nix. it has scripts built in for 240p-360p-480p-720p-iphone outputs to flv but i use it for staff using flip cams that make mod files.to convert them to wmv just need to mod script to it outputs to mp4.
  12. try this i use it all the time.. Install XP from USB - reboot.pro ----USB_MultiBoot.cmd - Install XP from USB-----
  13. Here’s how the changes will work: ■New Spotify users will be able to enjoy our unrivalled free service as it is today for the first 6 months. ■As of May 1st, any user who signed up to the free service on or before November 1st 2010 will be able to play each track for free up to a total of 5 times. Users who signed up after the beginning of November will see these changes applied 6 months after the time they set up their Spotify account. ■Additionally, total listening time for free users will be limited to 10 hours per month after the first 6 months. That’s equivalent to around 200 tracks or 20 albums. https://www.spotify.com/se/blog/archives/2011/04/14/upcoming-changes-to-spotify-free-open/
  14. only ever got sso to work with IE.. and that was with IIS and on Nix ..
  15. the "Windows Thin PC by Microsoft | Windows Enterprise " looks good get windows 7 on a pc and it only takes up 270 mb ram.. and i have 4gb to play with.. of it does not have all the nice gui but who needs it.. and it runs fast and loads fast.. might have to start installing some software on it.. theres nothing thinclient about it.. just windows 7 thined down to XP speeds and ram.. install is still big.. might be good to keep the life of the PC's going for a extra yr and gives you the space to move to windows 7 on some of the older pcs..... need to test on my very old end PC's now....
  16. it's very simple.. have a look at for things you my ask.. http://www.edugeek.net/forums/thin-client-virtual-machines/2038-thinstation.html
  17. for a sans i would go for Dell Equallogic you can have half ssd and half sas the SSD will give you the boot speed for the RD's in the morn... and SAS for storage.. the more its used the better it learns to place that start up profiles, so you get max speed from it at client boot up.. smart bit of kit..
  18. PXE Boot thinstation... Job Done.. :: Thinstation - a light, full-featured Linux thin client OS ::
  19. Try this line... robocopy.exe "d:\From" "X:\To" *.* /S /COPY:DATSO /MOVE /ZB /NP /XA:RHS /XF *.ini *.ico /MINLAD:20080901 /R:2 /W:10 i had the same problem i had to change /COPYATSO /MOVE to /COPY:DATSO /MOVE after i added /MINLAD:20080901
  20. lol.. what ever next..
  21. change the /MINLAD:730 you the date format YYYYMMDD 20090901 the 730 is days ..
  22. Any one know much about wan optimization...?? looking to improve BB Speed.. I have look at Traffic Squeezer - Open Source WAN Optimization
  23. sorry i did not mean /MINAGE:... what i meant was /MINLAD: as Plexer corrected me on.. we have to look at 2 things: 1. Space wasted from files never accessed for more then 2 years and the cost of space on SAS. (and also WAV files and WMV to MPEG that can be compressed) 2. We are only archiving not deleting as you may have to keep the data for a number of years. I see it better to archive files not access more then 2years "from there last access date" and hard backup to a data storage device usb/nas/Whatever for fast access if you need to.
  24. Well My "staffarea" with set to 730 days moved over 51GB of old files. Still got staff personal folders to do.. lol.. might user last access time for that...
×
×
  • Create New...