Book Image

Joomla! 1.5 Cookbook

By : Tom Canavan
Book Image

Joomla! 1.5 Cookbook

By: Tom Canavan

Overview of this book

If you are a Joomla! site owner, you must already be aware of how this robust, easy to use, open source content management system can help you build a great looking site instantly. You must also be aware of the many problems that it can throw up from time to time. Find the solutions to all your basic and advanced Joomla! queries, so you don't have to wait for someone on the forums to help you out every time.The Joomla! 1.5 Cookbook will provide you with quick and direct solutions to the most common and uncommon problems faced by you, the Joomla! site owner, sidestepping all the theoretical fuss.Joomla! is the insanely popular, award winning content management system which helps you build professional looking websites, even if you don't have any HTML programming experience or design skills.Although, sometimes you might trip over some common pitfalls which would slow the progress of your website down. This book will help you find a direct and quick way through these common problems which can be easily avoided with a few tips and tricks. It starts of with solutions the most common queries that you might face during the installation and setup for Joomla! 1.5 moving on swiftly to guide you through Joomla! templates, modules, security, managing your users and much more. So the next time when things go wrong with your Joomla! site and you are wondering, for example, how to work with your site's database; just pick up this book and quickly find your way through this.
Table of Contents (18 chapters)
Joomla! 1.5 Cookbook
Credits
About the Author
About the Reviewer
Preface
Index

Removing content from a table


There might be times you wish to remove JUST the data from a table, such as if a spammer inserts names into your mailing database, or you wish to remove all of the data from any table. There are many times this might come in handy.

You will see how to delete a single row of data and delete the entire data set from the table.

In any case, the same warnings apply.

Tip

BACKUP YOUR DATABASE BEFORE YOU START!

Getting ready

You will need your username and password for accessing your database in your cPanel® and your FileZilla client.

Depending on your hosting you may need your username and password for the database.

You will need a copy of your database. You can use the recipe to EXPORT your data for safety and backup.

How to do it...

  1. Navigate to your main database menu. You should be here:

    Once again we will review the GUI method first, then the command-line method.

  2. Locate your table of choice - we'll once again use jos_Corn_Syrup as our table. In this example, we WANT to wipe...