When using MySql, some time you may want to query the rows of a table that don’t match another table. Well Ive got the perfect solution for you!


SELECT t1.ID
FROM Table1 t1
LEFT JOIN Table2 t2 ON t1.ID = t2.ID
WHERE t2.ID IS NULL


Just change t1 and t2 to mach you table names!

All is great right? Wrong. Chances are the author of that plugin will add updates to that plugin which will overwrite all custom changes made! Of course you could ignore the pesky update reminders, but if you hand a website over to client, they will not understand. That’s where this strong little code comes in.


add_filter('site_transient_update_plugins', 'dd_remove_update_nag');
function dd_remove_update_nag($value) {
unset($value->response[ plugin_basename(__FILE__) ]);
return $value;
}


You’ll want to add this to the bottom of the main page in the plugin. This isn’t always the index.php page. You’ll want to look for the page with the following code at the top:

/*

*/

Hope this helps other wordpress users. Cheers!

Heres an example without alternating rows

1
2
3
4
5
6
7
8
9

$sql = "SELECT * FROM fruits ORDER BY id";
$query = mysql_query($sql);					
while($result = mysql_fetch_assoc($query)) {
 
	echo "<div class='rName'>{$result['name']}</div>";
	echo "<div class='rDate'>{$result['date']}</div>";
	echo "<div class='rEdit'>{$result['edit']}</div>";
 
}

Which looks like this:

Now the same example with alternating rows

1
2
3
4
5
6
7
8
9
10
11
12
13

$sql = "SELECT * FROM fruits ORDER BY id";
$query = mysql_query($sql);					
while($result = mysql_fetch_assoc($query)) {
 
	//heres our alternating hack
	if($css != "On"){ $css = "On"; }else{ $css = "Off"; }
 
	//append $css to the end of your style
	echo "<div class='rName{$css}'>{$result['name']}</div>";
	echo "<div class='rDate{$css}'>{$result['date']}</div>";
	echo "<div class='rEdit{$css}'>{$result['edit']}</div>";
 
}

Now I have a situation where my classes are either “on” or “off”. What you need to do now is create styles for each “toggle”. Heres the styles for my example:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

/** ON STYLES **/
.rNameOn {
	padding:10px;
	float:left;
	width:300px;
	background-color:#E9EBEA;
	}
.rDateOn, .rEditOn {
	padding:10px;
	float:left;
	width:100px;
	background-color:#E9EBEA;
	}
/** OFF STYLES **/
.rNameOff {
	padding:10px;
	float:left;
	width:300px;
	background-color:#fff;
	}
.rDateOff, .rEditOff {
	padding:10px;
	float:left;
	width:100px;
	background-color:#fff;
	}

Our final result:

In this part 1 I will be using a simple box show the difference between ugly css styles, and how you can improve them. So lets get going already with the example.

Mr. Coffee© Coffee Maker – Red
Price: $19.95
Shipping: $5.95
Description: 12c Coffee Maker- Red Brewing Pause n Serve lets you pour a cup of coffee while the coffeemaker is still brewing. Removable Filter Insert lifts out of Brew Basket for fast and easy filling and cleaning. 2-hour Auto Shut-Off keeps your coffee warm for 2 hours and then automatically shuts off. Delay Brew allows you to program the clock up to 24 hours in advance to begin brewing at a specific time.

Email to a freind Add to wish list Add to Cart

Wow, Thats ugly

All the information and functions that are needed for this product is here, but it looks very cluttered and unprofessional. Lets begin fixing this beast by add in some spacing, we dont want anything to be touching, becuase its messy.

Mr. Coffee© Coffee Maker – Red
Price: $19.95
Shipping: $5.95
Description: 12c Coffee Maker- Red Brewing Pause n Serve lets you pour a cup of coffee while the coffeemaker is still brewing. Removable Filter Insert lifts out of Brew Basket for fast and easy filling and cleaning. 2-hour Auto Shut-Off keeps your coffee warm for 2 hours and then automatically shuts off. Delay Brew allows you to program the clock up to 24 hours in advance to begin brewing at a specific time.

Email to a freind Add to wish list Add to Cart

Better…

After adding some padding, this product is already starting to look better. This is where I’d like to play with the colors. The colors in example 2 are just plain ugly and too much gray is like pumping poison into a design.

Mr. Coffee© Coffee Maker – Red
Price: $19.95
Shipping: $5.95
Description: 12c Coffee Maker- Red Brewing Pause n Serve lets you pour a cup of coffee while the coffeemaker is still brewing. Removable Filter Insert lifts out of Brew Basket for fast and easy filling and cleaning. 2-hour Auto Shut-Off keeps your coffee warm for 2 hours and then automatically shuts off. Delay Brew allows you to program the clock up to 24 hours in advance to begin brewing at a specific time.

Email to a freind Add to wish list Add to Cart

Wow, much different

A good color scheme is very important to a great design. There are many ways to get some good colors. Try choosing a color scheme before you start your design, that way things will stay consistant.

I’m still not happy with my product box, I’ll do a little bit more tweaking on the css styles, and see how I can make this look more elegent.

Mr. Coffee© Coffee Maker – Red
Price: $19.95
Shipping: $5.95
Description: 12c Coffee Maker- Red Brewing Pause n Serve lets you pour a cup of coffee while the coffeemaker is still brewing. Removable Filter Insert lifts out of Brew Basket for fast and easy filling and cleaning. 2-hour Auto Shut-Off keeps your coffee warm for 2 hours and then automatically shuts off. Delay Brew allows you to program the clock up to 24 hours in advance to begin brewing at a specific time.

EMAIL TO A FRIEND

ADD TO WISH LIST

Add to Cart

I like this now

So without changing the layout or adding any custom graphics, we went from a basic and quite ugly design, to one that is clean and elegent. This is a great example of how a existing design can be updated, with little effort. This also shows us the great thing about using css, we can drastically change a layout with very little effort.

Of course there alot of other css tricks I could do to better this layout. What are some ways you keep your designs clean and professional? What would you do to better my example?