Some database management tools refuse to admit you can add multiple primary key columns to one table, so you might have to do it with direct sql syntax ( deep intake of breath ).
Multiple primary keys make ‘ON DUPLICATE KEY UPDATE column = column + 100’ type queries a shed load more flexible.
Anyway, on with the code:
ALTER TABLE tablename ADD PRIMARY KEY (column_one, column_two)
And there you have it. Robert’s your fathers brother.
Why is it that banks are always 5 years behind when it comes to the internet?
For those not in ‘the know’, a ‘webhook’ is where you define a url ( or address ) you would like to be notified when certain things happen on a website you use.
As an example, you tell PayPal to notify your payment confirm url when your business account receives a payment. They then send the payment details to that url so an automated script can do something with them. Usually tell you to send the item they bought.
When you try and use cookies in php, you can’t use dots / periods [.] in the names. So this won’t work:
$var = $_COOKIE['cookie.name.with.dots'];You can set them with dots using Javascript, but when you go to access them, the dots magically become underscores [ _ ]
It is mentioned on the Panic site, but it took me ages to find it.
You can add bookmarks or tags to a file that will appear on Coda’s code navigator. Most of the time it’s as simple as an !
CSS: /* !bookmark */ HTML: <!-- !bookmark --> Javascript: /* !bookmark */ or // !bookmark PHP: /* !bookmark */ or // !bookmark
You can of course replace the word bookmark with anything you like.
For a full list:
http://www.panic.com/coda/developer/quicktip/5.php
Occasionally working with SQL databases (not my beloved MySQL) I always struggled getting the number of rows in a consistant manner.
Until now…