phpMyAdmin

Server:

mysql.puroparty.com

Database:

Table:

Structure

Browse

SQL

Search

Insert

Export

Empty

Drop

Showing rows 0 - 7 (8 total, Query took 0.0004 sec)
SQL-query: SELECT * FROM `jos_banner` ORDER BY `catid` ASC LIMIT 0 , 30
[Edit] [Explain SQL] [Create PHP Code] [Refresh]

Sort by key:

			bid	cid	type	name	alias	imptotal	impmade	clicks	imageurl	clickurl	date	showBanner	checked_out	checked_out_time	editor	custombannercode	catid	description	sticky	ordering	publish_up	publish_down	tags	params
			1	1	banner	OSM 1	osm-1	0	43	0	osmbanner1.png	http://www.opensourcematters.org	2004-07-07 15:31:29	1	0	0000-00-00 00:00:00			13		0	1	0000-00-00 00:00:00	0000-00-00 00:00:00
			2	1	banner	OSM 2	osm-2	0	49	0	osmbanner2.png	http://www.opensourcematters.org	2004-07-07 15:31:29	1	0	0000-00-00 00:00:00			13		0	2	0000-00-00 00:00:00	0000-00-00 00:00:00
			3	1		Joomla!	joomla	0	2748	698		http://www.joomla.org	2006-05-29 14:21:28	1	0	0000-00-00 00:00:00		<a href="{CLICKURL}" target="_blank">{NAME}</a> <br/> Joomla! The most popular and widely used Open Source CMS Project in the world.	14		0	1	0000-00-00 00:00:00	0000-00-00 00:00:00
			4	1		JoomlaCode	joomlacode	0	2748	1130		http://joomlacode.org	2006-05-29 14:19:26	1	0	0000-00-00 00:00:00		<a href="{CLICKURL}" target="_blank">{NAME}</a> <br/> JoomlaCode, development and distribution made easy.	14		0	2	0000-00-00 00:00:00	0000-00-00 00:00:00
			5	1		Joomla! Extensions	joomla-extensions	0	2743	1633		http://extensions.joomla.org	2006-05-29 14:23:21	1	0	0000-00-00 00:00:00		<a href="{CLICKURL}" target="_blank">{NAME}</a> <br/> Joomla! Components, Modules, Plugins and Languages by the bucket load.	14		0	3	0000-00-00 00:00:00	0000-00-00 00:00:00
			6	1		Joomla! Shop	joomla-shop	0	2743	706		http://shop.joomla.org	2006-05-29 14:23:21	1	0	0000-00-00 00:00:00		<a href="{CLICKURL}" target="_blank">{NAME}</a> <br/> For all your Joomla! merchandise.	14		0	4	0000-00-00 00:00:00	0000-00-00 00:00:00
			7	1		Joomla! Promo Shop	joomla-promo-shop	0	8262	642	shop-ad.jpg	http://shop.joomla.org	2007-09-19 17:26:24	1	0	0000-00-00 00:00:00			33		0	3	0000-00-00 00:00:00	0000-00-00 00:00:00
			8	1		Joomla! Promo Books	joomla-promo-books	0	8182	606	shop-ad-books.jpg	http://shop.joomla.org/amazoncom-bookstores.html	2007-09-19 17:28:01	1	0	0000-00-00 00:00:00			33		0	4	0000-00-00 00:00:00	0000-00-00 00:00:00

Check All / Uncheck All With selected:

Insert new row

Print view

Export