Neji

Yes you can. You need to make a custom segment in GA, but that takes a matter of seconds.
 
A bit more about segments here: https://www.google.com/intl/en_uk/analytics/features/advanced-segments.html
 
Segments allow you to filter all GA report data to match the criteria you set - for example, only users who are using Chrome, or who speak Spanish, or come from Germany. You can combine them too.
 
Your approach to link tracking is indeed correct.

Pretty much. Google is intuitive but it won't assume your website is relevant to Gaming, just because it's relevant to gamers and video games.
 
Google will look at the text on your website and build up a relationship between words. So you don't have to have "Web Design London" all the way through a website for it to get picked up as a term. You could have:
 
We are an amazing London company offering web design
 
Google will then be able to pick out the words London, web and design. By having a few instances of these closely proximity words, Google will then establish that your website is relevant to "Web Design London"
 
If that makes sense?
 
It just can't start ranking your website for variations of a word simply because they're related to your website. Absolutely no instance of that word in your on page or off page SEO and it won't rank for it.

Try and build that keyword into the SEO campaign. Google picks up on keyword relationships but it won't rank your website for variants of a keyword if it's not within the document or backlinks.
 
It's like asking Google to rank a website that is about fruit for Apples because you've targeted for the keyword "Banana". But if you put it in the text of the website and backlinks then you'll rank for it
 
The term Gamer could mean something completely different to the term Gaming. Google determines this by looking at relationships between various words on a website.
 
I hope that makes sense? If it's something you're actively targeting, then chuck it into the campaign.

I think the most important thing on twitter is to remember that it's a social medium. Definitely follow your customers, potentials, and industry-related accounts, but remember to talk to people.
 
Accounts whose every tweet is a link or a business related thing quickly get very boring. In order to engage your audience, they need to get a sense of the human typing those tweets. Sure, that person represents the company, so shouldn't say anything damaging to the business or its competitors, but don't be afraid to let your hair down.
 
If I asked you to think of 5 people on twitter that you follow, just off the top of your head, I'd be willing to bet that the 5 you pick all post in this way. Everyone else just gets buried in the noise.
 
Also think about your noise to signal ratio. As a rule, post 4 'conversational' tweets for every promotional one. Twitter is not a direct sales medium, and if you treat it like one you'll be wasting your time.
 
One of the best uses for twitter when it comes to larger companies is as a customer service tool. If you monitor mentions of your company and your competitors, you can step in a help people, or guide them to your products & services if appropriate.
 
Hope some of that helps

Larry Ullman's books, PHP & MySQL for Dynamic Websites and PHP Advanced have chapters on security techniques. In his Effortless E-Commerce he also addresses security.

I'd avoid mass following people int he hope of getting a follow back. I think there is nothing worse then seeing a company that follows 20k people and has 10k followers.
 
To answer your question, us both technioques. Talk about the company, what they're doing, intersting insights into how it's run. But at the same time, provide links to useful articles, interesting pictures and so on. Social media allows you to strike up a very intimate relationship with customers, new and old, and potential clients. Never, ever use twitter in the hope of increasing conversions.
 
Follow like minded companies, and interact with them. If they post something that you might disagree with, tweet back at them, try and strike up a conversation.
 
People who use twitter for businesses need to step out of the business mind set and stop trying to sell their services over a social platform. Thats why Facebooks ad system isn't powerful, because nobody goes on a social networking site with the mindset of buying something.
 
As I've said, interact with similar businesses, tweet about intersting articles related to your field and post insights into your company. Post pictures of staff doing stuff, fund raising days, dress down friday, special visits etc.
 
(By you, I mean you/your client)
 
Hope this kind of helps?

You're in luck.
 
Awesome book, really well written and by folks who know WordPress inside out.

Id use a singleton pattern heres an example of one
 
 

<?php class DB{ private static $db_instance; //Connection properties protected $DbHost; protected $DbUser; protected $DbPass; protected $DbDatabase; /**Instance of database object**/ public static function DbInstance(){ $db_class = __CLASS__; if(!isset(self::$db_instance)){ self::$db_instance = new $db_class; } return self::$db_instance; } /**OTHER DATABASE METHODS**/ } /**FUNCTION USED FOR REFERENCING OUR DATABASE CLASS**/ function Db(){ return DB::DbInstance(); } ?>
 
then you can do this to reference your database class without creating the object over and over again
 

<?php //Call a database method, just an example the method DbQuery does not actually exist Db()->DbQuery("Your sql query"); ?>
 
this also helps prevent you having to use the keyword global inside any function that u need to reference your database class for example doing your way u would have to do this inside a function global $db; or global $conn; that requires database interaction.
 
Not that this is relivent but you also could try setting up some method chaining by returning $this inside some of your methods this would allow you to call different methods in a chaining fasion like so
 

<?php Db()->DbQuery("Your sql query")->DbNumRows(); ?>

In that case, you would probably look at using a UNION, but that means ensuring that both tables have the same column names, data types and layouts. This link explains it: http://www.w3schools.com/sql/sql_union.asp. Of course, there may be other ways that I am unaware of. Personally, I only ever use joins by creating primary and foreign key relationships between tables.
 
Hope this helps,
Lyndsey.

The 'ON' clause is what allows you to define the link between two tables. For example, say you have these two tables:
 
Persons - Fields: PersonID, Name
Orders - Fields: OrderID, PersonID.
 
The Orders table is linked to the Persons table through PersonID. The reason that these two tables are separate is because a Person may have multiple orders (this is called a 1:M one-to-many relationship) and therefore needs to be contained separately to avoid primary key duplication (If OrderID was inside the Persons table, we would need to duplicate PersonID which in this case would be a Primary Key, and that is not allowed).
 
When it comes to displaying a history of the person's order, we would need to get the persons name from the Persons table, whilst also getting a list of the orderID's from Orders. Therefore, instead of creating two different SQL statements, we simply join the two tables together using a JOIN statement, like this:
 
SELECT * FROM Persons INNER JOIN Orders ON Persons.PersonID = Orders.PersonID
 
This will return a Recordset containing PersonID, Name and OrderID. We haven't defined a WHERE clause so the Recordset will return everything for those 'Persons' that have an order.
 
To limit the Recordset to a specific user, we say something like:
 
WHERE PersonID = 1
 
------
There are of course other factors to consider such as the type of JOIN you wish to create. As you see above I created an INNER JOIN which means that the Recordset returned will contain only those people that have an order. Any users inside the Persons table that don't have an OrderID inside the Orders table will not be returned.
 
I'm not that good at explanations so I've found a few links for you, hope they help:
 
http://www.halfgaar.net/sql-joins-are-easy
http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
 
This is related to the types of Joins:
 
http://www.w3schools.com/sql/sql_join.asp
 
 
Lyndsey.

Yeah, you're going to need to give the join definition as well. You also only seem to be running the search on one table column (title). You should have
 
WHERE (title LIKE '%$search_term%' OR newsTitle LIKE '%$search_term%')";

The JOIN statement doesn't look correct. The Join doesn't state the link between the two tables e.g.
 
JOIN Ultrasound ON news.columnname = Ultrasound.columnname
 
Where 'columnname' is the primary/foreign key link between the two tables.
 
Lyndsey.

You can rename field names using an alias, such as
SELECT `column_name` AS `alias_name` FROM .....

http://db.tt/7ns74Xvt
 
Here's how it looks ba!

Okay... you're going to laugh... but there's a text book I used when I was studying for a database module at uni last year. I used to have the same problem as you, namely that I found it boring. I was in Waterstones one day browsing the computing section when I came across this:
 
Ta-daa!
 
Yeah, I know what you're thinking. But seriously, it was actually well written and illustrated and actually pretty entertaining to read. I'm a pretty massive nerd fan of this kind of stuff anyway so it kinda resonated. It went into enough depth to cover pretty much 80% of the material on my course, but it obviously wouldn't be suitable as a big serious reference book (or even something you'd want on your shelf at work). But anyway, it worked for me, so I figured I'd sling it out there.
 
(I ended up passing that module with a first as well, so make of that what you will )

I'm in a similar boat. I'm working on a project with scaling in mind.
 
Depending what your database is for look at Drupal modules / Wordpress plugins that do something similar. The successful ones will have scaling in mind considering the size of some Wordpress/Drupal sites.
 
All you need to do is look at the tables and try to reverse engineer them, it's a great learning exercise.

You need to learn the concept of "3rd normal form", this is designing a database so that data needn't be stored more than once.
 
For instance, if you had a website where people signed up and wanted to buy cars they might have to choose 3 car models that they are interested in, this could be shown as such in a users table
 
1 | Adam | Smith | 23 | Male | *email* | Vauxhall
2 | Adam | Smith | 23 | Male | *email* | Ford
3 | Adam | Smith | 23 | Male | *email* | Toyota
 
This is inefficient because your database would soon be 5/6 times the size and it would take longer to search and have much the same data, 3rd normal form would split it up as such and turn that 1 table into 3; User, Cars, UserCars
 
User
1 | Adam | Smith | 23 | Male | *email *
 
Cars
1 | Ford
2 | Renault
3 | Mazda
4 | Toyota
5 | Vauxhall
 
UserCars
UserID | CarID
1 | 1
1 | 4
1 | 5
 
 
This is a basic example, the joining table links the user to the cars, this method can be used no matter how big the database is or how much information you may have in it.
 
So start by searching 3rd normal form.
 

I've noticed a lot of people recommending Sitepoint's Principles of Beautiful Web Design book, it's not one I've read myself but I've certainly seen it mentioned in plenty of places. It seemed to have a few negative reviews but I think that's to be expected when ordering online, you can't have a proper good flick through the book so it's inevitabnle some people won't get what they were expecting.
 
Just last night I ordered myself The Non-Designers Design Book and Logo Design Love. I'm not sure about that last one but I've been looking at the first for a while now, fingers crossed it does the trick.
 
Two other books on the subject that I already own are A Practical Guide to Designing for the Web and Designing for Emotion. Both come highly recommended but if I had to plump for one I'd go for Mark Boulton's Designing for the Web, it's packed full of information (although there's virtually no mention or examples of code whatsoever) and it genuinely feels like a guide to how the professional's do it right from beginning to end.
 
But don't spend all your time stockpiling books and never actually making any websites, that's how you end up like me!!!
 
Hope that helped, cheers.

Can't agree with the above post at all, design is definitely something you can learn, there are plenty of books out there dedicated to it. It will be harder if you don't have the natural talent for it ( but learning the principles will give you a good boost. 'The Principles of Beautiful Web Design' is a good place to start.
 
Other than that, sit for a while looking at CSS galleries, they'll give you loads of inspiration.

If you make an image fit a specific size, without cropping, you'll end up with images that are either squashed or stretched. This is always gonna look worse than cropping.
 
You either have to crop them so they are all the exact same dimensions and proportions - or you re-size them and maintain their individual proportions and you end up with different sized/shaped images.

I dont quite follow what your trying to achieve (why 3 sizes, surely a thumb of some sort, would link to the actual full size image?)
 
But (and not sure if this helps) I am working on a site right now, and i dont want the full size image on the page, so i use photoshop to find out what to propotionally size the thumbnail. So say I have a full size image of 900x273, if i want a thumb width of say 100px, then using the image resize tool i can tell the width will be 100px and the height (prop) is 30..which i just resize in wp to that size, linking to the fullsize image.
 
Like I said, I'm not 100% sure what you are trying to achieve, but hope I helped.

You also need to set a more readable line-height on your paragraph - I'd almost never suggest less than 1.2, usually 1.3-1.5.

Pseudo Elements can provide an alternative way of doing this.
 
http://jsfiddle.net/UckXW/3/
 
Adjust the bottom positioning to move the line up or down.
 
The only down side is this will not work in IE7.

I tried setting the line-height to 1em (100% of font size) but that didn't do it, so it's not dependent on line-height.
 
You could try setting the display of your links in the paragraph to display: inline-block and adding padding-bottom: 2px to it. That seemed to work pixel-perfect in Firefox and Chrome (and honestly if you are using a reset that should work in every modern browser). However, inline-block isn't supported in earlier versions of IE, so it will just default to inline and you won't get pixel-precision on the spacing.

Not very orthodox, but could try a negative bottom padding to the element?
 
Edit: Looking at your nav, it could be the line height as the dotted line appears fine on letters like 'g' and 'y'.