Skip to content
Archive of posts tagged Data Types

A MySQL Stored Procedure To Return The Total Years, Months And Days Of All Person Records

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 a program, such [...]

PHP’s session_register() And The Fine Art Of Variable Poisoning

Recently asked on Yahoo! Answers:
Using session_register() to register objects?
I’ve just started with OOP, and I’m making an app that uses objects that need to retain their data. Looking for an answer to this, I’ve discovered serialization. Whenever I go to a tutorial page about it, they always seem to mention the use of session_register() [...]

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 $result2 variable

$result2 = [...]

In Reply To Comments Made On “Working With A Simple Structure Array In VB.NET”

Olive Oyl left the following comment in response to my blog post, “Working With A Simple Structure Array In VB.NET,” which responds to her Yahoo! Answers question:
Thank you!
I really appreciate all of the time and effort, and thought that has obviously gone into this answer.
I had already figured out the answer to the problem, and [...]

Working With A Simple Structure Array In VB.NET

Recently asked in Yahoo! Answers:

In Visual Basic.NET how do you assign a grading scale to an array of structure variables?
I want to assign a grading scale to an array of structure variables. HOW do you assign a range of values, such as 0 to 299, to a variable within a structure? (In Visual Basic.NET)
Example:
‘declare array [...]

The Value Of Relational Databases: A Case Study

Recently asked on Yahoo! Answers:

SQL / Access query?
I have a 1-table client database which, as well as all the usual name / address info, includes client ‘˜visit’™ fields. Each client may have between 1 and 5 visits per week (Mon to Fri) and each visit can be at a different time, duration and frequency (weekly, [...]