Reply to thread

Message

<blockquote data-quote="Kristopher" data-source="post: 155131" data-attributes="member: 1958">[PHP]&lt;?php&nbsp; &nbsp; $campaign = mysql_query(&quot;SELECT * FROM cms_campaigns ORDER BY `id` DESC&quot;); // Query, Select data from cms_camps..&nbsp; &nbsp; if(mysql_num_rows($campaign) == 0){&nbsp; &nbsp; &nbsp; &nbsp; echo 'MAKE A CAMPAIGN TO FIX ME!!!'; // No campaigns? This will show.&nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;div class=&quot;habblet-container &quot;&gt;'; // Container..&nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;div class=&quot;cbb clearfix orange &quot;&gt;'; // Decor..&nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;h2 class=&quot;title&quot;&gt;Hot Campaigns&lt;/h2&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;hotcampaigns-habblet-list-container&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;hotcampaign-container&quot;&gt;';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; while($row = mysql_fetch_array($campaign)){ // Fetch shit from $camps..&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Start variables&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $id = $row[&quot;id&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $caption = $row[&quot;caption&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $image_url = $row[&quot;image_url&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $description = $row[&quot;description&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $url = $row[&quot;url&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // End variables&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;ul id=&quot;hotcampaigns-habblet-list&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li class=&quot;even&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;a href=&quot;'.$url.'&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img src=&quot;'.$image_url.'&quot; align=&quot;left&quot; alt=&quot;'.$caption.'&quot; /&gt;&lt;/a&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;h3&gt;'.$caption.'&lt;/h3&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;p&gt;'.$description.'&lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;p class=&quot;link&quot;&gt;&lt;a href=&quot;'.$url.'&quot;&gt;Go there &amp;raquo;&lt;/a&gt;&lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/li&gt; &lt;/ul&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ';&nbsp; &nbsp; }&nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;[/PHP]&nbsp;[CODE]CREATE TABLE IF NOT EXISTS `cms_campaigns` (&nbsp; `id` int(11) NOT NULL AUTO_INCREMENT,&nbsp; `order_id` int(11) NOT NULL DEFAULT '1',&nbsp; `enabled` enum('0','1') NOT NULL DEFAULT '1',&nbsp; `image_url` text NOT NULL,&nbsp; `caption` text NOT NULL,&nbsp; `description` text NOT NULL,&nbsp; `url` text NOT NULL,&nbsp; PRIMARY KEY (`id`)) ENGINE=MyISAM&nbsp; DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;[/CODE]&nbsp;&nbsp;For Housekeeping: <a href="http://devbest.com/threads/1-x-x-housekeeping-release.24211/" target="_blank">http://devbest.com/threads/1-x-x-housekeeping-release.24211/</a>&nbsp;Credits:Cookiemonsta - CampaignsSledmore - HKMyself - Little edit</blockquote>

[QUOTE="Kristopher, post: 155131, member: 1958"] [PHP]<?php $campaign = mysql_query("SELECT * FROM cms_campaigns ORDER BY `id` DESC"); // Query, Select data from cms_camps.. if(mysql_num_rows($campaign) == 0){ echo 'MAKE A CAMPAIGN TO FIX ME!!!'; // No campaigns? This will show. }else{ echo '<div class="habblet-container ">'; // Container.. echo '<div class="cbb clearfix orange ">'; // Decor.. echo '<h2 class="title">Hot Campaigns</h2> <div id="hotcampaigns-habblet-list-container"> <div class="hotcampaign-container">'; } while($row = mysql_fetch_array($campaign)){ // Fetch shit from $camps.. // Start variables $id = $row["id"]; $caption = $row["caption"]; $image_url = $row["image_url"]; $description = $row["description"]; $url = $row["url"]; // End variables echo '<ul id="hotcampaigns-habblet-list"> <li class="even"> <a href="'.$url.'"> <img src="'.$image_url.'" align="left" alt="'.$caption.'" /></a> <h3>'.$caption.'</h3> '.$description.' <a href="'.$url.'">Go there »</a> </li> </ul> '; } ?> </div></div>[/PHP] [CODE]CREATE TABLE IF NOT EXISTS `cms_campaigns` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_id` int(11) NOT NULL DEFAULT '1', `enabled` enum('0','1') NOT NULL DEFAULT '1', `image_url` text NOT NULL, `caption` text NOT NULL, `description` text NOT NULL, `url` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;[/CODE] For Housekeeping: [URL]http://devbest.com/threads/1-x-x-housekeeping-release.24211/[/URL] Credits: Cookiemonsta - Campaigns Sledmore - HK Myself - Little edit [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members