Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: bos_ad_typesbos_ad_types
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

Showing rows 0 - 7 (8 total, Query took 0.0005 sec)
SQL-query: 
SELECT *
FROM `bos_ad_types`
LIMIT 0 , 30
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]

   
row(s) starting from record #
in mode and repeat headers after cells
   
Sort by key:  
Partial Texts
type_id
type_title
type_required
type_use
option1
def_option1
option2
def_option2
option3
def_option3
option4
def_option4
option5
def_option5
option6
def_option6
option7
def_option7
option8
def_option8
option9
def_option9
option10
def_option10
template
Edit Delete 12 Fundraiser Ad 3609 7961 state 3|1|1|Texas beneficiary 2||| contact #1 1||| contact #2 1|||                        
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>
Edit Delete 22 Artist Ad 116249 124697 state 3|1|1|Texas group name 1|||         genre 1||| # members 1||| booking contact 1||| booking # 1|||         <table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>
Edit Delete 23 Clubs/Bars 423449 524057 state 3|1|1|Texas| cover charge 1|||| contact # 1|||| drink selection 5|4||beer|draft|wine|liquor food avail? 4|2|2|yes|no patio seating? 4|2|2|yes|no music 5|5||piped|jukebox|karaoke|dj|band other stuff 5|2|pool|big screens event mo 3|12||jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec| event date 1|||| <table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>
Edit Delete 24 Mariachis 7705 7961 state 3|1|1|Texas group name 1||| # members 1||| group gender 4|2|2|all male|all female|mixed                        
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>
Edit Delete 25 Halls 5657 7961 state 3|1|1|Texas contact# 1 1||| contact #2 1||| max capacity 1|||                         <table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>
Edit Delete 19 Concert/Festival Ad 32281 32537 state 3|1|1|Texas ticket price 2||| headliner 2||| venue name 1||| seating 4|3|2|indoor|outdoor|both event month 3|12||jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec|                 <table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>
Edit Delete 20 DJ Ad 129049 523545 state 3|1|1|Texas company name 1||| dj name(s) 2||| genre types 2||| genre specialties 1||| equip 5|2|sound|lights available area 1||| contact #1 1||| contact #2 1||| other comments 2|||

<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>
Edit Delete 21 Happy Hour Ad! 249369 257817 State 3|1|1|Texas| Cover Charge 1|||| Phone 1||||     Drinks Avail 5|4||beer|draft|wine|liquor Food Avail? 4|2|2|yes|no Patio Seating? 4|2|2|yes|no music 5|5||piped|jukebox|karaoke|dj|band other stuff 5|2||pool|big screens     <table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>
  With selected: Check All  /  Uncheck All   With selected:   

   
row(s) starting from record #
in mode and repeat headers after cells
   
Insert new rowInsert new row   Print viewPrint view   ExportExport