PHPLens

CategoryName Description 1 Beverages Soft drinks, coffees, teas, beers, and ales 2 Condiments Sweet and savory sauces, relishes, spreads, and seasonings 3 Confections Desserts, candies, and sweet breads 4 Dairy Products Cheeses 5 Grains/Cereals Breads, crackers, pasta, and cereal 6 Meat/Poultry Prepared meats 7 Produce Dried fruit and bean curd 8 Seafood Seaweed and fish

PHPLens (Page 1)

Notes

Now we hide the CategoryID and Picture columns by using the gridLens property. Only columns we want to display are listed here.

$lens->gridLens = "CategoryName;Description";

You can also hide the columns dynamicly by clicking on the [pict here] button and selecting the columns you want to see in the grid [picture here]

For best performance, instead of hiding columns, only retrieve the columns you need. In SQL, use:
SELECT categoryname, description FROM categories