Norse Technologies Knowledge Base Free Knowledge Articles

When using MySQL, and wanting to retrieve the first n records from a table, one can use the LIMIT function. It can also be used to grab a range of records, not just a series starting with the first record. Use as follows:

SELECT * FROM yourtable LIMIT yourlowlimit,yourhighlimit;

This will return all rows between the number yourlowlimit and yourhighlimit inclusive.

e.g. SELECT FROM users LIMIT 20,50
will return the rows 20, 21, 22,…, 49, 50

Thanks to dmxzone.com

Posted under Freeware, MySQL

The code in the HTML/PHP markup would look something like:

<?php mysql_query("DELETE FROM yourtable WHERE yourfield='yourvalue' ")
or die(mysql_error()); ?>

This code deletes any record from the table named “yourtable” when that record’s field named “yourfield” is identically equal to “yourvalue”. The names of these objects will, of course, be replaced by the unique names that your set up uses.

Source: tizag.com – excellent tutorials on all kinds of coding, programming, and other technical stuff.

Posted under Freeware, MySQL, WebDev

The redistributable package of Adobe Reader 9.1, without Adobe AIR or Download Manager bundled. This is the simple Reader-only package installer, no Internet connection needed once it is downloaded.

Find all current special offers on Adobe products.

Download

…

Adobe Download: Adobe Reader 9.1

If there is ever a problem when a PDF document is viewed, such as an error generated by Adobe or a failure to print the PDF file, then reinstalling the program is the best option. To do this, simply:

1. Uninstall any currently installed “Adobe Acrobat Reader” programs in the Control Panel’s Add/Remove programs (in Windows Vista and Windows 7 it is called “Programs and Features”).
2. If there are problems uninstalling Acrobat, such as an error such as “THE PATCH PACKAGE COULD NOT BE OPENED. Verify the patch package exists and you can access it, or contact the application vendor.” then do the following sub-routine:
   1. Download Microsoft’s Clean Up Utility.
   2. Run it to install the Clean Up program.
   3. Now run the Clean Up Utility program by clicking Start > All Programs > Windows Install Clean Up
   4. In the list of program that the utility offers fins Acrobat Reader, click once on it to select its line, then click the Remove button.
   5. Download and install Acrobat Reader from the link provided above.
   6. Once it is installed, now uninstall it in the Control Panel’s Add/Remove programs (in Windows Vista and Windows 7 it is called “Programs and Features”).
3. Install the Acrobat program after downloading it from the link above. The program has been “reinstalled” now. This reinstallation takes care of most problems that can occur in Reader, and it’s plugin / add-on for Mozilla Firefox and Internet Explorer.

There have been some mentions of an Adobe Cleanup Tool or Adobe Uninstall Tool made to uninstall Reader manually, but these are still unavailable from the Adobe website to the public. Perhaps their technical support staff can provide the utility if a customer contacts them, as one blogger stated.

Posted under Browsers, Downloads, Freeware, Microsoft