Asked recently on Yahoo! Answers: 10 Points…Help MYSQL? i have a table named ‘Students’ and it has the coulumns ‘Name’,’DateBirth’,’Age’ how do i do to know how many years, months, and days do all the students united have, THANKS What the questioner wants to do is fairly complicated in MySQL. If we were working with [...]
Archive of posts tagged Database
Revisited: Adding Non-Selectable ListItem Controls To An ASP.NET DataBound List Control
Last August I had quickly blogged on the subject of adding non-selectable ListItem controls to an ASP.NET DropDownList. At the time I didn’t have an easy way to demonstrate how that code worked — and, in all honesty, I hadn’t tested it thoroughly, so it had some problems. But now, thanks to GoDaddy’s dirt-cheap ASP.NET [...]
A Simple Page Click Count System Using PHP And MySQL
Recently asked on Yahoo! Answers: Click Counter in Dreamweaver? I am looking to create a hit counter so I can have the top ten clicked stories on my website. I have a separate field for the count but i need the code to update the field +1. This isn’t something you can do with Dreamweaver’s [...]
The Trouble With PHP’s Weak Data Types: An Example Examined And Explained
Asked recently on Yahoo! Answers: Multiple nested MySQL functions in PHP? I was going through code today, trying to make some things more compact. The application worked without problems, so I knew that mysql error statements were superfluous. This is the type of statement I was changing, I figured that I’d remove the seemingly unnecessary [...]
The Difference Between Null, Empty And Zero-Length Data / Strings
A common problem faced by new programmers is understanding the difference between null, empty and zero-length variables, especially when working with database records. While, for most intents and purposes, the three things have the same effect — either you have some data you can work with, or you don’t — they arise from different circumstances. [...]
Describing ‘Red’ To A Blind Man: The Dilemma Of Ontology
Recently asked on Yahoo! Answers: How to map a keyword to a category? I have a bunch of general categories, such as: Games, Modeling, Business, Finance, etc. My question is, how can I take a keyword such as “Xbox 360″ and automatically map it to a category such as “Games”? This is an easy example, [...]
