MSSQL IF (multiple fields > one value)
In MySQL I use IF(value,then,else) quite often, but in a new project I am doing I need to do the same in MSSQL. SELECT field1, field2, IF(field3 = '1', 'Started',…
A bunch of ramblings about PHP programming, JQuery, MySQL and other 'stuff'
In MySQL I use IF(value,then,else) quite often, but in a new project I am doing I need to do the same in MSSQL. SELECT field1, field2, IF(field3 = '1', 'Started',…
So, once you’re all set up and running, you may want to give users access from the outside world. This is clearly an entry point for hackers and script kiddies,…
If you are trying to ignore a file and git is mucking you about, it may be because the file you are trying to ignore is already in the repository,…
Had some CSS that worked in Chrome, but not Firefox or Opera. Firebug reported this: Turns out, that my media atributes were incorrect, media="screen print" will not work in FF…
Using Apache you can stop directory listing with this line in your .htaccess Options -Indexes Basically it says stop access for folders without and index (index.html, index.php, etc)
Before you say it, I know there are better ways of streamlining your CSS based on the browser, but this is good to ‘know’ @media screen and (-webkit-min-device-pixel-ratio:0) { .element_class…
RewriteEngine on RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule .* index.php/$0
I found that a script I was running was calling some linux functions using exec() but they weren’t always successful and I couldn’t tell why. exec('command to run'); This would…