Ptah Dunbar has released a very cool Photoshop design framework to handle some of the tasks that commonly arise when you start to layout any design in photoshop.
It’s based around a 960 pixel grid and has both 12 and 16 column layout guides. It also has standard IAB advert sizes and a library of other assets that I haven’t got into yet.
If you design, or are planning on designing, a WordPress theme then you really should check this out.
I’ve just come across this post showing the new post revision screens in 2.6. I haven’t tried it out myself yet but it looks like it has some excellent functionality that I never even thought of.
I really am very glad I never got the chance to finish my page versions plugin that I was writing while 2.5 was in production as I would be scrapping it fairly shortly.
I’m stuck on a SQL query for my next WordPress plugin. I have tried Google but I am coming up empty, perhaps becasue I don’t really know what to search for, so I am hoping that one you guys can help me out with some advice.
Here’s the problem:
I have a table and in it are two important columns (There are others but they don’t matter). The first is called ‘Names’ and the second is called ‘Values’
I want to run a query that will return a single row. Each column in that row will be have the name that is stored in the ‘Names’ column in the original table, and the value that is stored in the ‘Values’ column.
The diagram below should hopefully make it a little clearer.
Does anyone have any ideas?
WordPress weekly is a great weekly podcast, about WordPress, by Jeffro.
Last week’s episode was an open mic episode where we discussed topics like Woopra, and WordPress brand restrictions and it was pretty interesting.
Notable about the last show was the announcement that Matt Mullenweg will be appearing on the next show on the 23rd.
This one will be unmissable!