riverwire Posted May 20, 2009 Share Posted May 20, 2009 Hi guys i really need some help been working on this for ever it seems and now my head has exploded and i can no longer think. im a total novice when it comes to SQL too which doesn't help . Bascially im getting this error : 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY Name , 10' at line 1 From this File : <?php //error_reporting (E_ALL); require_once ('./includes/config.php'); include ('./includes/functions.php'); ?> <!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> <title> <?php $cat_id = $_GET['cat_id']; $getosscategory = "SELECT OSSCategoryId, Category FROM osscategory WHERE OSSCategoryId='.$cat_id.'"; $osscategoryrs = mysql_query($getosscategory, $conn) or die (mysql_errno() . ": " . mysql_error()). "\n"; while($osscategory = mysql_fetch_array($osscategoryrs)) { $oss_category = $osscategory['Category']; echo "Open Source CMS - " .$oss_category ." Systems"; } mysql_free_result($osscategoryrs); ?> </title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <meta name="keywords" content="open source cms, open source <?php echo $oss_category; ?>, <?php echo $oss_category; ?> cms, open source software, free cms, free content managment system, content management system, open source applications" /> <meta name="description" content="Open source <?php echo $oss_category; ?> content management systems." /> <meta name="robots" content="index,follow" /> <meta name="author" content="TriPHP" /> <meta name="resource-type" content="document" /> <meta name="copyright" content="Copyright (c) 2004 - 2006, TriPHP" /> <meta name="revisit-after" content="1 day" /> <meta name="distribution" content="global" /> <meta name="generator" content="TriPHP" /> <meta name="rating" content="general" /> <link href="http://www.triphp.com/style.css" rel="stylesheet" type="text/css" /> </head> <body> <?php include_once("header.php"); ?> <div class="heading"><a href="/oss.php">Open Source Scripts and Applications</a></div> <br /> <table cellpadding="2" cellspacing="1" class="freewebs_layout"> <tr> <td style="background-color:#f8f8f8;"> <div style="padding:2px 0px 2px 2px;"> <div><strong>Sponsored Links</strong></div> </div> </td> </tr> <tr> <td class="freewebs_data"> <div style="padding:3px;"> <script type="text/javascript"><!-- google_ad_client = "pub-9358805988358620"; google_ad_width = 336; google_ad_height = 280; google_ad_format = "336x280_as"; google_ad_type = "text_image"; google_ad_channel ="0346520389"; google_color_border = "FFFFFF"; google_color_link = "0484CB"; google_color_bg = "FFFFFF"; google_color_text = "717171"; google_color_url = "717171"; //--></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> </div> </td> </tr> </table> <br /> <?php // this is the default page = #1 if(!isset($_GET['page' ])) { $page = 1; } else { $page =$_GET ['page' ]; } // Define the number of results per page $max_results = 10; // Figure out the limit for the query based on the current page number. $from = (( $page *$max_results ) - $max_results ); //$getfreeoss = "SELECT * FROM freeoss WHERE Status = '1' and OSSCategoryId=".$cat_id." ORDER BY Hits DESC LIMIT $from, $max_results"; $getfreeoss = "SELECT * FROM freeoss WHERE Status = '1' and OSSCategoryId=".$cat_id." ORDER BY Name , $max_results"; $freeossrs = mysql_query($getfreeoss, $conn) or die (mysql_errno() . ": " . mysql_error()). "\n"; while($freeoss = mysql_fetch_array($freeossrs)) { $ossid = $freeoss['FreeOSSId']; $ossname = $freeoss['Name']; $description = $freeoss['Description']; $url = $freeoss['URL']; $demo = $freeoss['DemoURL']; $download = $freeoss['DownloadURL']; ?> <table cellpadding="2" cellspacing="1" class="freewebs_layout"> <tr> <td style="background-color:#f8f8f8;"> <div style="padding:2px 0px 2px 2px;"> <div><a href="/ossjump/<?php echo $ossid; ?>.html" target="_blank"><strong><?php echo $ossname; ?></strong></a></div> </div> </td> <td align="right" style="background-color:#f8f8f8;"> <div style="font-size:10px; padding:2px;"> <a href="/ossjump/<?php echo $ossid; ?>.html" target="_blank">Home</a> | <a href="<?php echo $demo; ?>" target="_blank">Demo</a> | <a href="<?php echo $download; ?>" target="_blank">Download</a> </div> </td> </tr> <tr> <td class="freewebs_data" colspan="2"> <div style="padding:3px;"> <div style="text-align:justify;"><?php echo $description; ?></div> </div> </td> </tr> </table> <br /> <?php } mysql_free_result($freeossrs); // Figure out the total number of results in DB: $query = "SELECT COUNT(*) as Num FROM freeoss WHERE Status ='1' and OSSCategoryId=$cat_id"; $results = mysql_query($query); $total_results = mysql_result($results); //$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM freeoss WHERE Status ='1' and OSSCategoryId=".$cat_id."" ), 0); // Figure out the total number of pages. Always round up using ceil() $total_pages =ceil ($total_results /$max_results ); ?> <div class="pagination"> <strong>Page: </strong> <?php // Build Previous Link if( $page>1) { $prev = ( $page -1); echo "<a href=\"/opensource/".$cat_id."/page".$prev.".html\"><img src=\"/images/prev.gif\" alt=\"\" /> " ; } for( $i =1;$i <= $total_pages ;$i ++) { if(( $page ) == $i ) { echo "<strong>$i</strong> "; } else { echo "<a href=\"/opensource/".$cat_id."/page".$i.".html\"><strong>$i</strong></a> " ; } } // Build Next Link if( $page <$total_pages ) { $next = ( $page +1); echo "<a href=\"/opensource/".$cat_id."/page".$next.".html\"> <img src=\"/images/next.gif\" alt=\"\" /></a>" ; } ?> </div> <?php mysql_close($conn) ?> </div> </td> <!-- right column //--> <td id="right_layout"> <div style="padding:0px 0px 10px 0px;" align="right"> <table cellpadding="0" cellspacing="0" class="box_layout"> <tr> <td valign="top" width="4"> <img src="/images/box_tl.gif" width="4" height="4" alt="" /></td> <td class="box_top" width="100%"><img src="/images/spacer.gif" alt="" /></td> <td valign="top" align="right" width="4"> <img src="/images/box_tr.gif" width="4" height="4" alt="" /></td> </tr> <tr> <td colspan="3" class="box_content"> <div style="padding:0px 2px 0px 3px;"> <div class="heading" align="left"> <a href="/directory">Webmaster Directory</a></div> <div style="float:left; padding:3px 5px 5px 5px;"><img src="/images/directory.gif" alt="webmaster directory" /></div> <div align="left">Submit your site to our search-engine friendly webmaster directory.</div> </div> </td> </tr> <tr> <td valign="top"> <img src="/images/box_bl.gif" width="4" height="4" alt="" /></td> <td class="box_bottom"><img src="/images/spacer.gif" alt="" /></td> <td valign="top"> <img src="/images/box_br.gif" width="4" height="4" alt="" /></td> </tr> </table> </div> <div style="padding:0px 0px 10px 0px;" align="right"> <table cellpadding="0" cellspacing="0" class="box_layout"> <tr> <td valign="top" width="4"> <img src="/images/box_tl.gif" width="4" height="4" alt="" /></td> <td class="box_top" width="100%"><img src="/images/spacer.gif" alt="" /></td> <td valign="top" align="right" width="4"> <img src="/images/box_tr.gif" width="4" height="4" alt="" /></td> </tr> <tr> <td colspan="3" class="box_content"> <div style="padding:0px 2px 0px 3px;"> <div class="heading" align="left"> <a href="/hosting.php">Premium Web Hosting</a></div> <div style="float:left; padding:3px 5px 5px 5px;"><img src="/images/hosting.gif" alt="cheap web hosting" /></div> <div align="left">Browse our directory of premium and professional web hosting providers.</div> </div> </td> </tr> <tr> <td valign="top"> <img src="/images/box_bl.gif" width="4" height="4" alt="" /></td> <td class="box_bottom"><img src="/images/spacer.gif" alt="" /></td> <td valign="top"> <img src="/images/box_br.gif" width="4" height="4" alt="" /></td> </tr> </table> </div> <div style="padding:0px 0px 10px 0px;" align="right"> <table cellpadding="0" cellspacing="0" class="box_layout"> <tr> <td valign="top" width="4"> <img src="/images/box_tl.gif" width="4" height="4" alt="" /></td> <td class="box_top" width="100%"><img src="/images/spacer.gif" alt="" /></td> <td valign="top" align="right" width="4"> <img src="/images/box_tr.gif" width="4" height="4" alt="" /></td> </tr> <tr> <td colspan="3" class="box_content"> <div style="padding:0px 2px 0px 3px;"> <div class="heading" align="left"> <a href="http://tritemplates.triphp.com" target="_blank">Premium Web Templates</a></div> <div style="float:left; padding:3px 5px 5px 5px;"><img src="/images/templates.gif" alt="premium web templates" /></div> <div align="left">High-end professional website templates at a very affordable prices.</div> </div> </td> </tr> <tr> <td valign="top"> <img src="/images/box_bl.gif" width="4" height="4" alt="" /></td> <td class="box_bottom"><img src="/images/spacer.gif" alt="" /></td> <td valign="top"> <img src="/images/box_br.gif" width="4" height="4" alt="" /></td> </tr> </table> </div> <div style="padding:0px 0px 10px 0px;" align="right"> <table cellpadding="0" cellspacing="0" class="box_layout"> <tr> <td valign="top" width="4"> <img src="/images/box_tl.gif" width="4" height="4" alt="" /></td> <td class="box_top" width="157"><img src="/images/spacer.gif" alt="" /></td> <td valign="top" align="right" width="4"> <img src="/images/box_tr.gif" width="4" height="4" alt="" /></td> </tr> <tr> <td colspan="3" class="box_content"> <div style="padding:3px 0px 3px 0px;" align="right"> <script type="text/javascript"><!-- google_ad_client = "pub-9358805988358620"; google_ad_width = 160; google_ad_height = 600; google_ad_format = "160x600_as"; google_ad_type = "text_image"; google_ad_channel ="0346520389"; google_color_border = "FFFFFF"; google_color_link = "0484CB"; google_color_bg = "FFFFFF"; google_color_text = "717171"; google_color_url = "717171"; //--></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> </div> </td> </tr> <tr> <td valign="top"> <img src="/images/box_bl.gif" width="4" height="4" alt="" /></td> <td class="box_bottom"><img src="/images/spacer.gif" alt="" /></td> <td valign="top"> <img src="/images/box_br.gif" width="4" height="4" alt="" /></td> </tr> </table> </div> </td> <!-- end right column //--> <?php include_once("footer.php"); ?> </body> </html> And the 2 SQL tables associated with this file is in the post below Quote Link to comment Share on other sites More sharing options...
riverwire Posted May 20, 2009 Author Share Posted May 20, 2009 -- phpMyAdmin SQL Dump -- version 2.11.9.5 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 20, 2009 at 05:12 PM -- Server version: 5.0.77 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `fmdiscus_testserver` -- -- -------------------------------------------------------- -- -- Table structure for table `freeoss` -- CREATE TABLE IF NOT EXISTS `freeoss` ( `FreeOSSId` int(11) NOT NULL auto_increment, `OSSCategoryId` tinyint(4) NOT NULL default '0', `Name` varchar(200) NOT NULL default '', `Description` mediumtext NOT NULL, `URL` varchar(100) NOT NULL default '', `DemoURL` varchar(255) NOT NULL default '', `DownloadURL` varchar(200) NOT NULL default '', `DateAdded` date NOT NULL default '0000-00-00', `Hits` int(11) NOT NULL default '0', `Status` enum('0','1') NOT NULL default '0', PRIMARY KEY (`FreeOSSId`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=73 ; -- -- Dumping data for table `freeoss` -- INSERT INTO `freeoss` (`FreeOSSId`, `OSSCategoryId`, `Name`, `Description`, `URL`, `DemoURL`, `DownloadURL`, `DateAdded`, `Hits`, `Status`) VALUES (1, 1, 'Joomla!', 'Joomla! is one of the most powerful Open Source Content Management Systems on the planet. It is used all over the world for everything from simple websites to complex corporate applications. Joomla! is easy to install, simple to manage, and reliable.', 'http://www.joomla.org/', 'http://demo.joomla.org/', 'http://developer.joomla.org/sf/go/projects.joomla/frs.joomla_1_0', '2006-05-01', 262, '1'), (2, 1, 'XOOPS', 'XOOPS is an extensible, OO (Object Oriented), easy to use dynamic web content management system written in PHP. XOOPS is the ideal tool for developing small to large dynamic community websites, intra company portals, corporate portals, weblogs and much more.', 'http://www.xoops.org/', 'http://www.xoops.org/', 'http://www.xoops.org/modules/core/', '2006-05-01', 251, '1'), (3, 1, 'e107', 'e107 is a content management system written in php and using the popular open source mySQL database system for content storage. It''s completely free and totally customisable, and in constant development.', 'http://www.e107.org/', 'http://www.e107.org/', 'http://e107.org/edownload.php', '2006-05-02', 269, '1'), (4, 1, 'EZ Publish', 'eZ publish is a world leading Open Source Enterprise Content Management System and development framework. eZ publish includes advanced functionality for web publishing, intranets, e-commerce and more. eZ publish has been downloaded more than one million times from ez.no stating the international success the system has achieved since the first release in 1999.\r\n\r\nThousands of enterprises, governmental offices, non-profit organizations, small and middle sized companies and educational institutions around the world trust eZ publish for running their web solutions.', 'http://ez.no/products/ez_publish', 'http://ez.no/products/ez_publish/demo', 'http://ez.no/download', '2006-05-01', 288, '1'), (5, 1, 'Drupal', 'Drupal is software that allows an individual or a community of users to easily publish, manage and organize a great variety of content on a website. Tens of thousands of people and organizations have used Drupal to set up scores of different kinds of web sites. Drupal is open source software licensed under the GPL, and is maintained and developed by a community of thousands of users and developers.', 'http://drupal.org/', 'http://drupal.org/', 'http://drupal.org/project', '2006-05-01', 231, '1'), (6, 1, 'Geeklog', 'Geeklog is a PHP/MySQL based application for managing dynamic web content. "Out of the box", it is a blog engine, or a CMS with support for comments, trackbacks, multiple syndication formats, spam protection, and all the other vital features of such a system. ', 'http://www.geeklog.net/', 'http://demo.geeklog.net/', 'http://www.geeklog.net/filemgmt/viewcat.php?cid=8', '2006-05-01', 232, '1'), (7, 1, 'PHP-Nuke', 'PHP-Nuke is a news automated system specially designed to be used in Intranets and Internet. The Administrator has total control of his web site, registered users, and he will have in the hand a powerful assembly of tools to maintain an active and 100% interactive web site using databases.', 'http://www.phpnuke.org/index.php', 'http://www.phpnuke.org/index.php', 'http://www.phpnuke.org/modules.php?name=Downloads', '2006-05-01', 302, '1'), (8, 1, 'Mambo', 'Mambo is a full-featured content management system that can be used for everything from simple websites to complex corporate applications.', 'http://www.mamboserver.com/', 'http://demo.mamboserver.com/', 'http://mamboxchange.com/frs/?group_id=5', '2006-05-01', 478, '1'), (9, 1, 'Typo3', 'TYPO3 is a free Open Source content management system for enterprise purposes on the web and in intranets. It offers full flexibility and extendability while featuring an accomplished set of ready-made interfaces, functions and modules.', 'http://typo3.com/', 'http://typo3.com/', 'http://typo3.org/download/', '2006-05-01', 241, '1'), (10, 1, 'phpWebsite', 'phpWebSite provides a complete web site content management system. Web-based administration allows for easy maintenance of interactive, community-driven web sites.', 'http://phpwebsite.appstate.edu/', 'http://phpwebsite.appstate.edu/demo/0.10.x/', 'http://phpwebsite.appstate.edu/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=6&MMN_position=4:4', '2006-05-01', 157, '1'), (11, 1, 'Exponent', 'Exponent is a website content management system (or CMS) that allows site owners to easily create and manage dynamic websites without necessarily directly coding web pages, or managing site navigation.', 'http://www.exponentcms.org/', 'http://www.exponentcms.org/', 'http://sourceforge.net/project/showfiles.php?group_id=118524', '2006-05-01', 251, '1'), (12, 1, 'Dragonfly CMS', 'Dragonfly CMS is a powerful, feature-rich, Open Source content management system which was based on PHP-Nuke 6.5 in the "CPG-Nuke CMS" days. We have spent over a year developing Dragonfly CMS, paying close attention to security and reliability. The release of Dragonfly marks yet another exciting milestone in our history.', 'http://www.cpgnuke.com/', 'http://www.cpgnuke.com/', 'http://www.cpgnuke.com/Downloads.html', '2006-05-01', 151, '1'), (13, 1, 'Jaws', 'Jaws is a Framework and Content Management System for building dynamic web sites. It aims to be User Friendly giving ease of use and lots of ways to customize web sites, but at the same time is Developer Friendly, it offers a simple and powerful framework to hack your own modules.', 'http://www.jaws.com.mx/', 'http://www.jaws.com.mx/', 'http://www.jaws.com.mx/?page/download', '2006-05-01', 159, '1'), (14, 1, 'Xaraya', 'Xaraya is an extensible, Open Source web application framework written in PHP and licensed under the GNU General Public License. Xaraya delivers the requisite infrastructure and tools to create custom web applications that include fully dynamic multi-platform Content Management Solutions (CMS).\r\n\r\nXaraya''s modular, database independent architecture introduces tools that separate form, function, content, and design with on-the-fly extensions allowing greater control and versatility.', 'http://www.xaraya.com/', 'http://www.xaraya.com/', 'http://www.xaraya.com/index.php/docs/75', '2006-05-01', 163, '1'), (15, 1, 'OneCMS', 'OneCMS is an Open Source CMS also released under GPL allowing users to run there own game site easily. From the powerful template system to top-notch support, OneCMS is a great option for gaming sites.', 'http://www.insanevisions.com/', 'http://www.insanevisions.com/', 'http://www.insanevisions.com/downloads.html', '2006-05-01', 173, '1'), (16, 1, 'phpComasy', 'phpComasy is a free, Open Source content management system for small websites. For this reason, it is a very easy to use content management system for everybody. Each person can administrate content with phpComasy! Some extra features are the uniform control interface, the special template system (no PHP knowledge is needed) and the dynamic picture functions.', 'http://www.phpcomasy.org', 'http://www.phpcomasy.org', 'http://www.phpcomasy.org', '2006-05-01', 196, '1'), (17, 2, 'WordPress', 'WordPress is a state-of-the-art semantic personal publishing platform with a focus on aesthetics, web standards, and usability. What a mouthful. WordPress is both free and priceless at the same time.', 'http://wordpress.org/', 'http://blog.triphp.com', 'http://wordpress.org/download/', '2006-05-01', 227, '1'), (18, 2, 'NucleusCMS', 'Nucleus offers you the building blocks you need to create a web presence. Whether you want to create a personal blog, a family page, or an online business site, Nucleus CMS can help you achieve your goals.', 'http://nucleuscms.org/', 'http://demo.nucleuscms.org/', 'http://nucleuscms.org/download.php', '2006-05-01', 233, '1'), (19, 2, 'Textpattern', 'A free, flexible, elegant, easy-to-use content management system for all kinds of websites, even weblogs. When it comes to publishing on the internet, beginners and experts alike are met with a bothersome paradox: word processors and graphics applications allow anyone to do a pretty good job of managing text and images on a personal computer, but to make these available to the worldwide web – a seemingly similar environment of documents and destinations – ease of use vanishes behind sudden requirements for multilingual programming skills, proficiency in computer-based graphic design, and, ultimately, the patience of a saint.', 'http://www.textpattern.com/', 'http://www.textpattern.com/', 'http://www.textpattern.com/download', '2006-05-01', 223, '1'), (20, 2, 'b2evolution', 'b2evolution is probably the most comprehensive blog engine you can find! It includes almost any feature you could expect from a blog tool, and more ', 'http://www.b2evolution.net/', 'http://demo.b2evolution.net/', 'http://b2evolution.net/downloads/index.html', '2006-05-01', 237, '1'), (21, 2, 'boastMachine', 'boastMachine is an open source, state of the art publishing platform that makes your web publishing experience so fun and easy as never before! From the fully automated installation to advanced content management featuresto spam fighting, boastMachine provides you with all that you would ever need!', 'http://www.boastology.com', 'http://www.boastology.com', 'http://www.boastology.com/pages/download.php', '2006-05-01', 218, '1'), (22, 2, 'bBlog', 'bBlog is a powerful, elegant personal publishing system written in PHP and released as free, Open Source software under the GPL. It is a flexible but simple way to blog that works for blogging beginners, and can grow into a more advanced user''s needs.', 'http://www.bblog.com/', 'http://www.bblog.com/', 'http://www.bblog.com/download.php', '2006-05-01', 183, '1'), (23, 2, 'Serendipity', 'Serendipity is a weblog/blog system, implemented with PHP. It is standards compliant, feature rich and open source (BSD License). Serendipity is constantly under active development, with a team of talented developers trying to make the best PHP powered blog on the net.', 'http://www.s9y.org/', 'http://blog.s9y.org/', 'http://www.s9y.org/12.html', '2006-05-01', 233, '1'), (24, 2, 'BLOG:CMS', 'BLOG:CMS is the most complete, feature-packed, personal publishing system\r\non the market, developed by Radek Hulán. It\r\nincludes state-of-the-art weblog, forum, wiki engine, news aggregator (atom /\r\nrss), and photo gallery.', 'http://blogcms.com/', 'http://blogcms.com/', 'http://blogcms.com/', '2006-05-01', 240, '1'), (25, 2, 'blur6ex', 'blur6ex is a simple weblog and content system built with PHP. It offers basic features found in more established systems and is extensible enough for any number of new features to be added. Ideal, at the moment, for those who don''t want overkill in their setup.', 'http://www.blursoft.com/blur6ex/', 'http://www.blursoft.com/demo/', 'http://www.blursoft.com/blur6ex/', '2006-05-01', 228, '1'), (26, 2, 'Loudblog', 'Loudblog is a sleek and easy-to-use Content Management System (CMS) for publishing media content on the web. It automatically generates a skinnable website and an RSS-Feed for Podcasting. Just upload your audio/video files, add some notes and links, and you’re done!', 'http://loudblog.de/', 'http://testblog.be/loudblog/', 'http://loudblog.de/index.php?s=download', '2006-05-01', 244, '1'), (27, 3, 'MyBB', 'MyBB is a powerful, efficient and free forum package developed in PHP and MySQL. MyBB has been designed with the end users in mind, you and your subscribers. Full control over your discussion system is presented right at the tip of your fingers, from multiple styles and themes to the ultimate customisation of your forums using the template system.', 'http://www.mybboard.com/', 'http://community.mybboard.net/', 'http://www.mybboard.com/downloads.php', '2006-05-01', 226, '1'), (28, 3, 'phpBB', 'phpBB is a high powered, fully scalable, and highly customizable Open Source bulletin board package. phpBB has a user-friendly interface, simple and straightforward administration panel, and helpful FAQ. Based on the powerful PHP server language and your choice of MySQL, MS-SQL, PostgreSQL or Access/ODBC database servers, phpBB is the ideal free community solution for all web sites.', 'http://www.phpbb.com/', 'http://www.phpbb.com/demo.php', 'http://www.phpbb.com/downloads.php', '2006-05-01', 235, '1'), (29, 3, 'Simple Machines Forum', 'Simple Machines Forum - SMF in short - is a free, professional grade software package that allows you to set up your own online community within minutes. Its powerful custom made template engine puts you in full control of the lay-out of your forum and with our unique SSI - or Server Side Includes - function you can let your forum and your website interact with each other. SMF is written in the popular language PHP and uses a MySQL database. It is designed to provide you with all the features you need while having an absolute minimal impact on the resources of the server. SMF is the next generation of forum software, and best of all it is and will always remain completely free!', 'http://www.simplemachines.org/', 'http://www.simplemachines.org/community/', 'http://www.simplemachines.org/download/', '2006-05-01', 560, '1'), (30, 3, 'PunBB', 'PunBB is a fast and lightweight PHP-powered discussion board. It is released under the GNU General Public License. Its primary goals are to be faster, smaller and less graphically intensive as compared to other discussion boards. PunBB has fewer features than many other discussion boards, but is generally faster and outputs smaller, semantically correct XHTML-compliant pages.', 'http://www.punbb.org/', 'http://forums.punbb.org/', 'http://www.punbb.org/downloads.php', '2006-05-01', 237, '1'), (31, 3, 'miniBB', 'miniBB (an abbreviation of "minimalist bulletin board") is a flat-type (not threaded) bulletin board, discussion forums software, written in PHP and using mySQL or another PHP-compatible database as data backend. "Mini" doesn''t mean "nothing". Specially developed for small and medium forum communities, which have less than 100 unique posts per day, miniBB also could be used in large projects. If you take a look at miniBB settings file, or this manual, you''ll find a lot of options, both for users and administrator, which allow full and in-time control over the board.', 'http://www.minibb.net/', 'http://minibbtest.virtualis.lv/minibb-test.php', 'http://www.minibb.net/download.html', '2006-05-01', 235, '1'), (32, 3, 'Unclassified NewsBoard', 'The Unclassified NewsBoard (short UNB) is an open-source, PHP-based internet bulletin board system, mostly like those you may already know. But the difference is in a lot of details that make your life with this board, both as administrator and user, much easier. You’ll be surprised how easy things can be and how fast you can work with such a system! The Unclassified NewsBoard has a lot of innovative features the world has never seen before in this way. I run this project in my spare time, mostly because over two years ago, none of the freely available forum systems fully convinced me and because I found fun in that job.', 'http://newsboard.unclassified.de/', 'http://newsboard.unclassified.de/forum', 'http://newsboard.unclassified.de/download', '2006-05-01', 233, '1'), (33, 3, 'UseBB', 'UseBB is a light and Open Source PHP and MySQL based forum package, distributed freely under the GPL license. Developed with simplicity and usability in mind, UseBB is ideal for small to medium sized websites which need a clear and efficient forum package.', 'http://www.usebb.net/', 'http://www.usebb.net/community/index.html', 'http://www.usebb.net/downloads/', '2006-05-01', 234, '1'), (34, 4, 'Coppermine', 'Coppermine is a multi-purpose fully-featured and integrated web picture gallery script written in PHP using GD or ImageMagick as image library with a MySQL backend. Coppermine is free software which you can download and install on your webspace. ', 'http://coppermine-gallery.net', 'http://coppermine-gallery.net/demo/cpg14x/', 'http://sourceforge.net/project/showfiles.php?group_id=89658', '2006-05-01', 236, '1'), (35, 4, 'Gallery', 'Gallery is the next generation of open source photo sharing web applications. Gallery gives you an intuitive way to blend photo management seamlessly into your own website whether you''re running a small personal site or a large community site. Hundreds of thousands of people and organizations are using Gallery to create personalized photo albums on their websites.', 'http://gallery.menalto.com', 'http://gallery.menalto.com/gallery', 'http://gallery.menalto.com/downloads', '2006-05-01', 244, '1'), (36, 4, 'Snipe Gallery', 'Snipe Gallery is a searchable PHP/mySQL photo gallery manager with web based admin and dynamic thumbnailing. Our very first version was released in 2001, and we have come quite a ways since then, improving the user interface, troubleshooting capabilities, friendlier error messages, and more. Not to mention the imnplementation of a snazzy cropping and thumbnailing tool and the ability to frame your images within "picture frames".', 'http://www.snipegallery.com/', 'http://www.snipegallery.com/demo/', 'http://sourceforge.net/project/showfiles.php?group_id=116929&package_id=128193', '2006-05-01', 247, '1'), (37, 4, 'DAlbum', 'DAlbum is a free PHP photo album. It is small, easy to install and highly customizable at the same time. Features include slide shows, image comments, support for video and PDF files and many more.', 'http://www.dalbum.org/', 'http://www.dalbum.org/sample/index.php', 'http://www.dalbum.org/index.php?go=Downloads', '2006-05-01', 256, '1'), (38, 4, 'singapore', 'singapore is an open source, multilingual, template-driven image gallery web application... quite a mouthful! It is written in PHP and is licensed under the GNU General Public License. What makes singapore different from the hundreds of other similar scripts is that it was originaly conceived for displaying photographic art in an aesthetically pleasing fashion using a clean, uncluttered interface (see it in the online demo). Now, though, its powerful templating system allows you to display your images in pretty much any way that takes your fancy.', 'http://www.sgal.org/', 'http://www.sgal.org/livedemo/', 'http://www.sgal.org/download', '2006-05-01', 236, '1'), (39, 4, 'LinPHA', 'LinPHA is an easy to use, multilingual, flexible photo/image archive/album/gallery written in PHP. It uses a SQL database (MySQL/PostgreSQL/SQLite) to store information about your pictures. It comes with a HTML-based installer, so you don''t need experience in setting up SQL databases. Thumbnails are created as needed and stored in the SQL DB. It features complete user management, zip-album downloads, top ten statistics, hidden albums, web filemanager with upload capabilities, watermarks, printing, guestbook and much more.', 'http://linpha.sourceforge.net/wiki/index.php/Main_Page', 'http://linpha.org/', 'http://linpha.sourceforge.net/wiki/index.php/Downloads', '2006-05-01', 260, '1'), (40, 4, 'Plogger', 'Plogger is the next generation in open-source photo gallery systems. A web application not bloated with superfluous features or complicated configuration settings. Plogger is a simple yet powerful tool — everything you need to share your images with the world. Plogger is your photos integrated into your website, a fully featured photo sharing package with an attractive and easy to use administrative interface that makes managing your galleries a breeze. Integrating our gallery software into your website is as easy as inserting three lines of PHP code.', 'http://plogger.org/', 'http://plogger.org/demo/', 'http://plogger.org/', '2006-05-01', 234, '1'), (41, 4, 'MG2', 'MG2 / MiniGal is a FREE and easy to use PHP image gallery script. It is being offered as a non profit service for photographers and webmasters who want a simple, fast and good looking image gallery on their website.', 'http://www.minigal.dk/', 'http://www.minigal.dk/addons.php?searchfor=&type=skin&orderby=downloads&direction=DESC&prpage=10', 'http://www.minigal.dk/download.php', '2006-05-01', 233, '1'), (42, 4, 'Simple Picture Gallery Manager', 'SPGM is a PHP script that displays picture galleries on the web. It is intended to provide a very simple way to set up online photo albums: creating directories, filling them with pictures and uploading to your website.', 'http://spgm.sourceforge.net/', 'http://spgm.sourceforge.net/?lg=us&id=demos', 'http://spgm.sourceforge.net/?lg=us&id=download', '2006-05-01', 256, '1'), (43, 5, 'osCommerce', 'osCommerce is an Open Source based online shop e-commerce solution that is available for free under the GNU General Public License. It features a rich set of out-of-the-box online shopping cart functionality that allows store owners to setup, run, and maintain their online stores with minimum effort and with no costs, fees, or limitations involved.', 'http://www.oscommerce.com/', 'http://www.oscommerce.com/shops/demonstration', 'http://www.oscommerce.com/solutions/downloads', '2006-05-01', 239, '1'), (44, 5, 'phpShop', 'phpShop is a shopping cart application. The goal of the phpShop development team is to provide a stable web application platform that allows for additional development.', 'http://www.phpshop.org/', 'http://demo.phpshop.org/', 'http://www.phpshop.org/wiki/Downloads', '2006-05-01', 261, '1'), (45, 5, 'Zen Cart', 'Zen Cart™ truly is the art of e-commerce; a free, user-friendly, open source shopping cart system. The software is being developed by group of like-minded shop owners, programmers, designers, and consultants that think e-commerce could be and should be done differently. Some "solutions" seem to be complicated programming exercises instead of responding to users'' needs, Zen Cart™ puts the merchants and shoppers requirements first. Similarly, other programs are nearly impossible to install and use without an IT degree, Zen Cart™ can be installed and set-up by anyone with the most basic web site building and computer skills.', 'http://www.zen-cart.com/', 'http://www.zen-cart.at/zdemo.htm', 'http://sourceforge.net/projects/zencart/', '2006-05-01', 242, '1'), (46, 5, 'CRE Loaded', 'This new release is super-charged with MORE THAN 50 popular and useful contributions pre-installed and tested for you! Easiest install ever with a beautifully-illustrated FREE included 10-page Quick Install & Setup Guide or 4-page Quick Upgrade Guide. Now anybody can install or upgrade their site by following these bullet-proof instructions.\r\n\r\nThis FREE release contains important bug and security fixes. Many requested improvements including: No more Default Admin; more and better discounting with Quantity Discount and Multiple Discounts; payment mods to Quick Commerce Pro and CC Payment Module so CCV "Credit Card Verification" system can be used. Define MainPage moved to Info Manager so all page editing is done in one place. (OPTIONAL) Dyamic drop-down DHTML Admin Menus uses half the clicks so you can administer your site faster than ever - enable it in your My Store settings. ', 'http://creloaded.com/', 'http://creloaded.com/Content/pid=15.html', 'http://creloaded.com/Downloads.html', '2006-05-01', 248, '1'), (47, 5, 'osc2nuke', 'Osc2nuke is the combination btw phpnuke (generaly the last version available) and oscommerce ms 2.2 (the time they finish the developement of ms 2.3), so it is a phpnuke site in which we have fully integrate the oscommerce shopping cart.', 'http://www.osc2nuke.com/', 'http://demo.osc2nuke.com/', 'http://www.osc2nuke.com/downloads.html', '2006-05-01', 229, '1'), (48, 6, 'phpGroupWare', 'phpGroupWare - formerly known as webdistro - is a multi-user groupware suite written in PHP.\r\n\r\nIt provides about 50 web-based applications, as there are the Calendar, Addressbook, an advanced Projects manager, Todo List, Notes, Email, Newsgroup- and Headlines Reader, a Filemanager and many more Applications. The calendar supports repeating events and includes alarm functions. The email system supports inline graphics and file attachments.\r\n\r\nThe system as a whole supports user preferences, themes, user permissions, multi-language support and unser groups. It includes modules to setup and administrate the working environment. The groupware suite is based on an advanced Application Programming Interface (API).', 'http://www.phpgroupware.org/', 'http://phpgroupware.org/demos', 'http://downloads.phpgroupware.org/', '2006-05-01', 254, '1'), (49, 6, 'dotProject', 'dotProject is a volunteer supported Project Management application. There is no "company" behind this project, it is managed, maintained, developed and supported by a volunteer group and by the users themselves. The software is free to anyone who would like to download it. Day to day support is provided free by volunteers.', 'http://www.dotproject.net/', 'http://www.dotproject.net/demo/', 'http://sourceforge.net/project/showfiles.php?group_id=21656&package_id=30225', '2006-05-01', 236, '1'), (50, 6, 'netOffice', 'netOffice is a free web based project-management environment written in php/mySQL. netOffice allows managing and sharing information about teams, projects, tasks, deadlines and much more. It?s intuitive interface makes it a fast and optimal solution for medium size companies.', 'http://netoffice.sourceforge.net/', 'http://netoffice.sourceforge.net/demo/', 'http://netoffice.sourceforge.net/modules/mydownloads/', '2006-05-01', 352, '1'), (51, 6, 'ACollab', 'ACollab is an accessible, open source, multi-group, Web-based collaborative work environment. ACollab is available as a work groups addon for ATutor 1.4+ , and as a standalone collaborative work environment that will run on its own. ACollab is ideal for groups working at a distance developing documentation, collaborating on research, or writing joint papers, and ideal for online educators who wish to add group learning activities to their ATutor courses.', 'http://www.atutor.ca/acollab/', 'http://www.atutor.ca/acollab/demo.php', 'http://www.atutor.ca/acollab/download.php', '2006-05-01', 329, '1'), (52, 6, 'eGroupWare', 'eGroupWare is a free enterprise ready groupware software for your network. It enables you to manage contacts, appointments, todos and many more for your whole business. eGroupWare is a groupware server. It comes with a native web-interface which allowes to access your data from any platform all over the planet. Moreover you also have the choice to access the eGroupWare server with your favorite groupware client (Kontact, Evolution, Outlook) and also with your mobile or PDA via SyncML.', 'http://www.egroupware.org/', 'http://egroupware.org/egroupware/login.php?domain=demo', 'http://www.egroupware.org/download', '2006-05-01', 248, '1'), (53, 6, 'PMtool', 'PMtool is a PHP based project management software to create tasks for change/bug requests, post timesheets, and calculate number of time used.', 'http://www.pmtool.org/', 'http://www.pmtool.org/demo/', 'http://www.pmtool.org/index.php?page=2', '2006-05-01', 287, '1'), (54, 7, 'MediaWiki', 'MediaWiki is a free software package originally written for Wikipedia but is now run on other projects of the non-profit Wikimedia Foundation and many other wikis.', 'http://www.mediawiki.org/', 'http://www.mediawiki.org/wiki/MediaWiki', 'http://www.mediawiki.org/wiki/Download', '2006-05-01', 243, '1'), (55, 7, 'DokuWiki', 'DokuWiki is a standards compliant, simple to use Wiki, mainly aimed at creating documentation of any kind. It is targeted at developer teams, workgroups and small companies. It has a simple but powerful syntax which makes sure the datafiles remain readable outside the Wiki and eases the creation of structured texts. All data is stored in plain text files – no database is required.', 'http://wiki.splitbrain.org/wiki:dokuwiki', 'http://wiki.splitbrain.org/wiki:dokuwiki', 'http://www.splitbrain.org/projects/dokuwiki', '2006-05-01', 236, '1'), (56, 7, 'WikkiTikkiTavi', 'WikkiTikkiTavi is an amazing wiki engine --- it is a PHP script that runs wiki sites. Wikis are a revolutionary new form of collaboration and online community. Although there exist many WikiEngines and wikis around the world, this wiki is dedicated to the WikkiTikkiTavi and those of you who might want to use it for your wiki.', 'http://tavi.sourceforge.net/', 'http://tavi.sourceforge.net/', 'http://tavi.sourceforge.net/TaviDownload', '2006-05-01', 280, '1'), (57, 7, 'Wikepage', 'Wikepage is a wiki-standart, easy to use and small wiki software derived from Tipiwiki2 Wikepage has some security features that Tipiwiki does not have, like password protected structure, and 4 patched important security flaw, table support, upload support, multilanguage and multisite support...etc...', 'http://www.wikepage.org', 'http://www.wikepage.org', 'http://sourceforge.net/project/showfiles.php?group_id=128991', '2006-05-01', 285, '1'), (58, 7, 'UniWakka', 'UniWakka is a Wiki Engine derived from WakkaWiki external link (dead link), a light-weight, easy to install and to configure collaborative editing software for web content. Derived from Wakka-0.1.3-dev, UniWakka is mostly intended for an university or scientific environment', 'http://uniwakka.sourceforge.net/', 'http://www.istitutocolli.org/uniwakka/HomePage', 'http://www.istitutocolli.org/uniwakka/HomePage', '2006-05-01', 333, '1'), (59, 7, 'PmWiki', 'PmWiki is a wiki-based system for collaborative creation and maintenance of websites. PmWiki pages look and act like normal web pages, except they have an "Edit" link that makes it easy to modify existing pages and add new pages into the website, using basic editing rules. You do not need to know or use any HTML or CSS. Page editing can be left open to the public or restricted to small groups of authors. ', 'http://www.pmwiki.org/', 'http://www.pmwiki.org/', 'http://www.pmwiki.org/wiki/PmWiki/Download', '2006-05-01', 247, '1'), (60, 7, 'WikkaWiki', 'WikkaWiki is a flexible, standards-compliant and lightweight wiki engine written in PHP, which uses MySQL to store pages. Forked from WakkaWiki. Designed for speed, extensibility, and security. Released under the GPL license.', 'http://wikkawiki.org/', 'http://wikkawiki.org/', 'http://wikkawiki.org/HomePage', '2006-05-01', 234, '1'), (61, 8, 'Moodle', 'Moodle is a course management system (CMS) - a free, Open Source software package designed using sound pedagogical principles, to help educators create effective online learning communities. You can download and use it on any computer you have handy (including webhosts), yet it can scale from a single-teacher site to a 50,000-student University.', 'http://moodle.org/', 'http://moodle.org/course/category.php?id=2', 'http://download.moodle.org/', '2006-05-01', 240, '1'), (62, 8, 'ATutor', 'ATutor is an Open Source Web-based Learning Content Management System (LCMS) designed with accessibility and adaptability in mind. Administrators can install or update ATutor in minutes, and develop custom templates to give ATutor a new look. Educators can quickly assemble, package, and redistribute Web-based instructional content, easily retrieve and import prepackaged content, and conduct their courses online. Students learn in an adaptive learning environment.', 'http://www.atutor.ca/', 'http://www.atutor.ca/atutor/demo.php', 'http://www.atutor.ca/atutor/download.php', '2006-05-01', 245, '1'), (63, 8, 'Interact', 'Interact is an open source Learning Community Environment. It could also be called an LMS (Learning Managment System), a CMS (Course Management System), or a VLE (Virtual Learning Environment). It is flexible enough to be used for building online communities or communities of practice in any environment, not just education.', 'http://www.interactlms.org/', 'http://www.interactlms.org/modules/page/page.php?space_key=1&module_key=5&link_key=5&group_key=0', 'http://sourceforge.net/project/showfiles.php?group_id=69681', '2006-05-01', 283, '1'), (64, 8, 'Site@School', 'Site@School is a Content Management System (CMS) to manage and maintain the website of a primary school. It is Open Source Software, licensed under the General Public license.', 'http://siteatschool.sourceforge.net/', 'http://siteatschool.sourceforge.net/index.php?section=1&category=&page=35', 'http://siteatschool.sourceforge.net/index.php?section=2&page=5', '2006-05-01', 339, '1'), (65, 8, 'Dokeos', 'Dokeos is an Open Source elearning and course management web application translated in 34 languages and helping more than 1.000 organisations worldwide to manage learning and collaboration activities.', 'http://www.dokeos.com/', 'http://campus.dokeos.com/courses/1234bcc0/', 'http://www.dokeos.com/download.php', '2006-05-01', 238, '1'), (66, 8, 'Claroline', 'Claroline is a free application based on PHP/MySQL allowing teachers or education organizations to create and administrate courses through the web. Developed from teachers to teachers, Claroline is built over sound pedagogical principles allowing a large variety of pedagogical setup including widening of traditional classroom and online collaborative learning.', 'http://www.claroline.net/', 'http://www.claroline.net/demo.htm', 'http://www.claroline.net/download.htm', '2006-05-01', 245, '1'), (67, 8, 'Docebo', 'Docebo is an open source e-learning suite that\r\ncontains an LMS (for online courses), and a CMS\r\n(for web portal building). Scorm support.', 'http://www.docebolms.org/', 'http://accessibility.docebo.org/doceboCms/', 'http://www.docebolms.org/doceboCms/page/8/E_Learning_open_source_download.html', '2006-05-01', 245, '1'), (68, 1, 'AngelineCMS', 'AngelineCMS is an open source Content Management System (CMS) and a complete Web Development Framework (Application server). It''s written from ground up to take advance of PHP5''s object-oriented features. AngelineCMS is Open Source software under OSI approved Mozilla Public License. AngelineCMS aims for easy, innovative solutions for daily web publishing problems. Along with the CMS part, we''re aiming for as perfect a web development framework as possible!', 'http://angelinecms.info/', 'http://devel.viltsu.net/demo/', 'http://angelinecms.info/site/index.php/download', '2006-05-01', 188, '1'), (69, 1, 'Etomite', 'Etomite is a Content Management System, which allows you to remotely administer your website from anywhere that you have an Internet Connection and a compatible Web-Browser.', 'http://www.etomite.org/', 'http://www.opensourcecms.com/index.php?option=content&task=view&id=549&Itemid=159', 'http://www.etomite.org/downloads.html', '2006-05-01', 154, '1'), (70, 9, 'phpAdsNew', 'phpAdsNew is an open-source ad server, with an integrated banner management interface and tracking system for gathering statistics. With phpAdsNew you can easily rotate paid banners and your own in-house advertisements. You can even integrate banners from third party advertising companies.', 'http://phpadsnew.com/two/', 'http://phpadsnew.com/two/', 'http://phpadsnew.com/two/', '2006-05-01', 243, '1'), (71, 9, 'SugarCRM', 'Sugar Open Source enables sales, marketing, and support organizations to manage their customer interactions more efficiently and profitably and is intended for both large and small companies worldwide. Platform agnostic, Sugar Open Source is the least complex, most portable, and most cost-efficient customer relationship management (CRM) solution. Natively built on the LAMP (Linux, Apache, MySQL and PHP) stack, Sugar Open Source can be deployed in virtually any environment.', 'http://www.sugarcrm.com/crm/community/sugarcrm-community.html', 'http://demo.sugarondemand.com/sugarcrm_os/index.php?action=Login&module=Users', 'http://www.sugarcrm.com/crm/community/sugarcrm-community.html', '2006-05-01', 301, '1'), (72, 9, 'phpMyAdmin', 'phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats and is available in 50 languages.', 'http://www.phpmyadmin.net/', 'http://www.phpmyadmin.net/home_page/demos.php', 'http://www.phpmyadmin.net/home_page/downloads.php', '2006-05-01', 242, '1'); -- -------------------------------------------------------- -- -- Table structure for table `osscategory` -- CREATE TABLE IF NOT EXISTS `osscategory` ( `OSSCategoryId` tinyint(4) NOT NULL auto_increment, `Category` varchar(100) NOT NULL default '', PRIMARY KEY (`OSSCategoryId`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `osscategory` -- INSERT INTO `osscategory` (`OSSCategoryId`, `Category`) VALUES (1, 'Portals (CMS)'), (2, 'Blogs'), (3, 'Forums'), (4, 'Image Galleries'), (5, 'eCommerce'), (6, 'Groupware'), (7, 'Wiki'), (8, 'eLearning'), (9, 'Miscellaneous'); Quote Link to comment Share on other sites More sharing options...
xtopolis Posted May 21, 2009 Share Posted May 21, 2009 First, thanks for providing your code in a convenient manner. (Copy-pasteable for the most part). That really helped. I only get the issue you describe when accessing the page without supplying a cat_id via GET superglobal. Line12 $cat_id = $_GET['cat_id']; could be changed to $cat_id = (isset($_GET['cat_id'])) ? intval($_GET['cat_id']) : 1; which would default the category to 1 if the page is accessed without selecting a category. I also had an error around line 117 with your mysql_result function. It requires another argument. Let us know if that doesn't fix what you want to happen. Quote Link to comment Share on other sites More sharing options...
balachandar Posted May 22, 2009 Share Posted May 22, 2009 Hai, You have missed the needed parameter in mysql_result() function. you wrote like this, $total_results = mysql_result($results); But it should be like this, $total_results = mysql_result($results,0); Hope this will work... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.