Sometime you will need a query that will return a resultset of ranked records. The following MySQL query will do the trick:
SELECT @rownum:=@rownum+1 AS rank, companies.* FROM conpanies p, (SELECT @rownum:=0) r ORDER BY profit DESC LIMIT 20;
Sometime you will need a query that will return a resultset of ranked records. The following MySQL query will do the trick:
SELECT @rownum:=@rownum+1 AS rank, companies.* FROM conpanies p, (SELECT @rownum:=0) r ORDER BY profit DESC LIMIT 20;
I had used this service before and spent a while trying to track down the URL again. Here it is for future reference.
These screen solutions were based upon an existing website belonging to a local pet shop.
Sample homepage
The large page-header shows a random recommendation and photograph each time the page loads. The content welcomes visitors to the website, makes important announcements and offers expert advice. The latest news entries and gallery thumbnails are displayed within the right-hand sidebar.
Sample internal page
All internal pages follow the same two-column layout as the homepage, but the page-header is reduced in height so only the site title shows. The primary navigation remains consistent throughout.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"/> <title>title</title> <link rel="stylesheet" type="text/css" href="style.css"/> <script type="text/javascript" src="script.js"></script> </head> <body> </body> </html>
Private Function ConvertHtmlToPlainText(ByVal htmlText As String) As String
Return Regex.Replace(htmlText, "<[^>]*>", String.Empty)
End Function
Development upon another new project has begun. FlatspinRecords.co.uk, will be an e-commerce website specialising in rare and collectable, 50s and 60s vinyl.
My latest project, AirCooledBugs.com, a specialist site for VW Beetle owners, is currently under development and will be launching in the near future.
Thanks to a reply to one of my posts within the SubSonic forums, I was pointed to this very nifty utility at Developer Fusion – a tool that will automatically convert C# code to VB.Net and back again.
I’ve just been participating in a discussion over at SitePoint on the subject of “Is it safe to write your email in your website?“. I knew I had read somewhere about it being UK law that all service providers must display a certain amount of contact information upon their websites – luckly someone else had also read it and provided a source.
“The email address of the service provider must be given. It is not sufficient to include a ‘contact us’ form without also providing an email address.”