What's wrong with this?

8 Message(s) by 3 Author(s) originally posted in php sql

From: Mad Hatter

Date: Thursday, October 11, 2007

I need to find out whos birthdays land today. The DOB is store

[probably from "main store"] In some varieties of Commonwealth
	hackish, the preferred synonym for {core}.  Thus, "bringing a
	program into store" means not that one is returning
	shrink-wrapped software but that a program is being {swap}ped
	in.

	[{Jargon File}]

d in a
standard Unix

<operating system> /yoo'niks/ (Or "UNIX", in the authors'
	words, "A weak pun on Multics") Plural "Unices".  An
	interactive {time-sharing} {operating system} invented in 1969
	by {Ken Thompson} after {Bell Labs} left the {Multics}
	project, originally so he could play games on his scavenged
	{PDP-7}.  {Dennis Ritchie}, the inventor of {C}, is considered
	a co-author of the system.

	The turning point in Unix's history came when it was
	reimplemented almost entirely in C during 1972 - 1974, making
	it the first {source-portable} OS.  Unix subsequently
	underwent mutations and expansions at the hands of many
	different people, resulting in a uniquely flexible and
	{developer}-friendly environment.

	By 1991, Unix had become the most widely used {multi-user}
	general-purpose operating system in the world.  Many people
	consider this the most important victory yet of hackerdom over
	industry opposition (but see {Unix weenie} and {Unix
	conspiracy} for an opposing point of view).

	Unix is now offered by many manufacturers and is the subject
	of an international standardisation effort [called?].
	Unix-like operating systems include {AIX}, {A/UX}, {BSD},
	{Debian}, {FreeBSD}, {GNU}, {HP-UX}, {Linux}, {NetBSD},
	{NEXTSTEP}, {OpenBSD}, {OPENSTEP}, {OSF}, {POSIX}, {RISCiX},
	{Solaris}, {SunOS}, {System V}, {Ultrix}, {USG Unix}, {Version
	7}, {Xenix}.

	"Unix" or "UNIX"?  Both seem roughly equally popular, perhaps
	with a historical bias toward the latter.  "UNIX" is a
	registered trademark of {The Open Group}, however, since it is
	a name and not an acronym, "Unix" has been adopted in this
	dictionary except where a larger name includes it in upper
	case.  Since the OS is {case-sensitive} and exists in many
	different versions, it is fitting that its name should reflect
	this.

	{The UNIX Reference Desk
	(http://www.geek-girl.com/unix.html)}.

	{Spanish fire extinguisher
	(ftp://linux.mathematik.tu-darmstadt.de/pub/linux/people/okir/unix_flame.gif)}.

	[{Jargon File}]

	(2001-05-14)

timestamp. I'm trying to use the following but it throws up a
syntax

The structure of strings in some language.  A language's
	syntax is described by a {grammar}.  For example, the syntax
	of a binary number could be expressed as

		binary_number = bit [ binary_number ]

		bit = "0" | "1"

	meaning that a binary number is a bit optionally followed by a
	binary number and a bit is a literal zero or one digit.

	The meaning of the language is given by its {semantics}.

	See also {abstract syntax}, {concrete syntax}.

	(1994-10-31)

error.

SELECT numberx FROM member WHERE date

<convention, data> A string unique to a time duration of 24
	hours between 2 successive midnights defined by the local time
	zone.  The specific representation of a date will depend on
	which calendar convention is in force; e.g., Gregorian,
	Islamic, Japanese, Chinese, Hebrew etc. as well as local
	ordering conventions such as UK: day/month/year, US:
	month/day/year.

	Inputting and outputting dates on computers is greatly
	complicated by these {localisation} issues which is why they
	tend to operate on dates internally in some unified form such
	as seconds past midnight at the start of the first of January
	1970.

	Many software and hardware representations of dates allow only
	two digits for the year, leading to the {year 2000} problem.

	{Unix manual page}: date(1), ctime(3).

	(1997-07-11)

('d m',dob)=date('d m',time())

Where am I going wrong?

From: Virginner

Date: Thursday, October 11, 2007

wrote in message

In {object-oriented programming} sending a message to an
	{object} (to invoke a {method}) is equivalent to calling a
	{procedure} in traditional programming languages, except that
	the actual code executed may only be selected at run time
	depending on the {class} of the object.  Thus, in response to
	the message "drawSelf", the method code invoked would be
	different if the target object were a circle or a square.

	(1995-02-16)

I need to find out whos birthdays land today. The DOB is stored in a
standard Unix timestamp. I'm trying to use the following but it throws up
a
syntax error.
SELECT numberx FROM member WHERE date('d m',dob)=date('d m',time())
Where am I going wrong?

DATE() doesn't take any parameters - you're getting confused with PHP's
date, or SQL

<language, database, standard> /S Q L/ An industry-standard
	language for creating, updating and, querying {relational
	database management systems}.

	SQL was developed by {IBM} in the 1970s for use in {System R}.
	It is the {de facto standard} as well as being an {ISO} and
	{ANSI} {standard}.  It is often embedded in general purpose
	programming languages.

	The first SQL standard, in 1986, provided basic language
	constructs for defining and manipulating {tables} of data; a
	revision in 1989 added language extensions for {referential
	integrity} and generalised {integrity} {constraints}.  Another
	revision in 1992 provided facilities for {schema} manipulation
	and {data administration}, as well as substantial enhancements
	for data definition and data manipulation.

	Development is currently underway to enhance SQL into a
	computationally complete language for the definition and
	management of {persistent}, complex objects.  This includes:
	generalisation and specialisation hierarchies, {multiple
	inheritance}, user defined {data types}, {triggers} and
	{assertions}, support for {knowledge based systems},
	{recursive query expressions}, and additional data
	administration tools.  It also includes the specification of
	{abstract data types} (ADTs), object identifiers, {methods},
	{inheritance}, {polymorphism}, {encapsulation}, and all of the
	other facilities normally associated with object data
	management.

	The emerging {SQL3} standard is expected to be complete in
	1998.

	According to Allen G. Taylor, SQL does _not_ stand for
	"Structured Query Language".  That, like "SEQUEL" (and its
	pronunciation /see'kw*l/), was just another unofficial name
	for a precursor of SQL.  However, the IBM SQL Reference manual
	for DB2 and Craig Mullins's "DB2 Developer's Guide" say SQL
	_does_ stand for "Structured Query Language".

	{SQL Standards (http://www.jcc.com/sql_stnd.html)}.

	{An SQL parser
	(ftp://ftp.ora.com/published/oreilly/nutshell/lexyacc/)} is
	described in "Lex & Yacc", by Levine, Mason & Brown published
	by O'Reilly.

	{The 1995 SQL Reunion: People, Projects, and Politics
	(http://www.mcjones.org/System_R/SQL_Reunion_95/)}.

	["A Guide to the SQL Standard", C.J. Date, A-W 1987].

	["SQL for Dummies", Allen G. Taylor, IDG Books Worldwide].

	(2005-11-17)

's DATE_FORMAT
TIME() only returns the time of day

Are you sure you've the dob as a Unix Timestamp? That'd be weird.
Now for example'd be "1192147732" in Unix Time.

It's more likely you've the dob as a DATE column-type, e.g. 1943-12-31

It that's the case, then use:

SELECT numberx FROM member WHERE DAYOFYEAR(dob)=DAYOFYEAR(NOW())

Have fun.

From: Captain Paralytic

Date: Friday, October 12, 2007

wrote in message:

I need to find out whos birthdays land today. The DOB is stored in a
standard Unix timestamp. I'm trying to use the following but it throws up a
syntax error.
SELECT numberx FROM member WHERE date('d m',dob)=date('d m',time())
Where am I going wrong?

In future, might I suggest that you post the text

1. Executable code, especially a "pure code" portion shared
	between multiple instances of a program running in a
	{multitasking} {operating system}.

	Compare {English}.

	2. Textual material in the mainstream sense; data in ordinary
	{ASCII} or {EBCDIC} representation (see {flat ASCII}).  "Those
	are text files; you can review them using the editor."

	These two contradictory senses confuse hackers too.

	[{Jargon File}]

	(1995-03-16)

of the error!

From: Mad Hatter

Date: Friday, October 12, 2007

DATE() doesn't take any parameters - you're getting confused with PHP's
date, or SQL's DATE_FORMAT
TIME() only returns the time of day

That's where I'm going wrong then. I'm using php commands on a sql query
:-(

Are you sure you've the dob as a Unix Timestamp? That'd be weird.
Now for example'd be "1192147732" in Unix Time.

Yup, definetely Unix timestamp. I prefer storing dates that way.

It's more likely you've the dob as a DATE column-type, e.g. 1943-12-31
It that's the case, then use:

Thanks but due to unix date no help :-(

From: Captain Paralytic

Date: Friday, October 12, 2007

wrote in message:

Hi
> DATE() doesn't take any parameters - you're getting confused with PHP's
> date, or SQL's DATE_FORMAT
> TIME() only returns the time of day
That's where I'm going wrong then. I'm using php commands on a sql query
:-(
> Are you sure you've the dob as a Unix Timestamp? That'd be weird.
> Now for example'd be "1192147732" in Unix Time.
Yup, definetely Unix timestamp. I prefer storing dates that way.
> It's more likely you've the dob as a DATE column-type, e.g. 1943-12-31
> It that's the case, then use:
Thanks but due to unix date no help :-(

Well, let's look at this.

Most of us when using a tool

1. <tool> A program used primarily to create, manipulate,
	modify, or analyse other programs, such as a compiler or an
	editor or a cross-referencing program.  Opposite: {app},
	{operating system}.

	2. A {Unix} {application program} with a simple, "transparent"
	(typically text-stream) interface designed specifically to be
	used in programmed combination with other tools (see {filter},
	{plumbing}).

	3. <jargon> ({MIT}: general to students there) To work; to
	study (connotes tedium).  The {TMRC} Dictionary defined this
	as "to set one's brain to the grindstone".  See {hack}.

	4. <jargon, person> ({MIT}) A student who studies too much and
	hacks too little.  MIT's student humour magazine rejoices in
	the name "Tool and Die".

	[{Jargon File}]

	(1996-12-12)

like a database

1. <database> One or more large structured sets of persistent
	data, usually associated with software to update and {query}
	the data.  A simple database might be a single file containing
	many {records}, each of which contains the same set of
	{fields} where each field is a certain fixed width.

	A database is one component of a {database management system}.

	See also {ANSI/SPARC Architecture}, {atomic}, {blob}, {data
	definition language}, {deductive database}, {distributed
	database}, {fourth generation language}, {functional
	database}, {object-oriented database}, {relational database}.

	{Carol E. Brown's tutorial
	(http://accounting.rutgers.edu/raw/aies/www.bus.orst.edu/faculty/brownc/lectures/db_tutor/db_tutor.htm)}.

	2. <hypertext> A collection of {nodes} managed and stored in
	one place and all accessible via the same {server}.  {Links}
	outside this are "external", and those inside are "internal".

	On the {World-Wide Web} this is called a {website}.

	3. All the facts and rules comprising a {logic programming}
	program.

	(2005-11-17)

system

1. The {supervisor} program or {operating system} on a
	computer.

	2. The entire computer system, including input/output devices,
	the {supervisor} program or {operating system} and possibly
	other {software}.

	3. Any large program.

	4. Any method or {algorithm}.

	[{Jargon File}]

choose the most
appropriate facilities, to ensure efficiency and ease of maintenance.
You think you know better and choose to store times as unix times.

Next, you've proved that you couldn't be bothered to check your
problem in the manual. If I get a syntax error, I go to the manual to
see what I have done wrong. There you would've seen that you were
using totally the wrong syntax and would've seen the correct one.

When I want to do something and I'm not sure how to, I try searching
Google

<World-Wide Web> The {World-Wide Web} {search engine} that
	indexes the greatest number of web pages - over two billion by
	December 2001 and provides a free service that searches this
	index in less than a second.

	The site's name is apparently derived from "{googol}", but
	note the difference in spelling.

	The "Google" spelling is also used in "The Hitchhikers Guide
	to the Galaxy" by Douglas Adams, in which one of Deep
	Thought's designers asks, "And are you not," said Fook,
	leaning anxiously foward, "a greater analyst than the
	Googleplex Star Thinker in the Seventh Galaxy of Light and
	Ingenuity which can calculate the trajectory of every single
	dust particle throughout a five-week Dangrabad Beta sand
	blizzard?"

	{Home (http://www.google.com/)}.

	(2001-12-28)

or the manual.
Putting the words
mysql unix timestamp
into Google brings up the correct page of the mysql user manual as the
first hit

1. <architecture> {cache hit}.

	2. <World-Wide Web> A request to a {web server} from a {web
	browser} or other {client} (e.g. a {robot}).

	The number of hits on a server may be important for
	determining advertising revenue.

	In the course of loading a single {web page}, a browser may
	hit a web server many times e.g. to retrieve the page itself
	and each {image} on the page.  In contrast, caching by
	browsers and {web proxies} reduces the number of hits on the
	server because some requests are satisfied from the cache.

	3. <jargon> To press and release a key on the keyboard.  Some
	prefer the less aggressive "tap".

	(2000-02-20)

. Going to that page (by the way, that'sthe page you'd
already have been on had you bothered to llok up he syntax error) and
searching for UNIX, you would've hit straight upon the FROM_UNIXTIME
function.

So, not only do you "prefer" not to store times properly, you also
"prefer" not to bother looking at the manual or doing any other
obvious searches to help yourself. You "prefer" to get other people to
sort out your messes for you.

From: Virginner

Date: Friday, October 12, 2007

wrote in message

Hi
DATE() doesn't take any parameters - you're getting confused with PHP's
date, or SQL's DATE_FORMAT
TIME() only returns the time of day
That's where I'm going wrong then. I'm using php commands on a sql query
:-(

Are you sure you've the dob as a Unix Timestamp? That'd be weird.
Now for example'd be "1192147732" in Unix Time.
Yup, definetely Unix timestamp. I prefer storing dates that way.

It's more likely you've the dob as a DATE column-type, e.g. 1943-12-31
It that's the case, then use:
Thanks but due to unix date no help :-(

(Still do not know why you'd store a dob as Unix Timestamp, but anyway)

.... simply convert your UNIX_TIMPSTMP to a normal date/time, using
FROM_UNIXTIME()

So, for example, to get today's day of the yea if it was a Unix Timestamp:

SELECT DAYOFYEAR(FROM_UNIXTIME(UNIX_TIMESTAMP()))

So, to solve your problem:

SELECT numberx FROM member
WHERE DAYOFYEAR(FROM_UNIXTIME(dob))=DAYOFYEAR(NOW())

From: Mad Hatter

Date: Friday, October 12, 2007

wrote in message:

Well, let's look at this.
Most of us when using a tool like a database system choose the most
appropriate facilities, to ensure efficiency and ease of maintenance.
You think you know better and choose to store times as unix times.

I have my own reasons for storing as a Unix timestamp. I'm sure that at
some time in the past you may have done something that others (or even the
manual!) says isn't the right way of doing things because it's far more
convenient.

Next, you've proved that you couldn't be bothered to check your
problem in the manual. If I get a syntax error, I go to the manual to
see what I have done wrong. There you would've seen that you were
using totally the wrong syntax and would've seen the correct one.

I did look at the manual but as it was late at night and I was tired I made
the mistake of looking at the php manual and not the mysql manual. But
there again I'm sure a Mr.Perfect like yourself is incapable of making such
mistakes.

I can not be bothered with the rest of your message. Your just not worth the
effort. Perhaps one day you might need help (but I doubt it seeing as you
know everything) and someone gives you such a helpful reply

See {followup}.

as the one you
gave me.

I'm just glad there are people like Virginner about who are wiling to help.

From: Mad Hatter

Date: Friday, October 12, 2007

wrote in message:

Thanks for the reply. I have got everything worked out now :-)

Next Message: Slow results

Blogs related to What's wrong with this?

What's wrong with this picture?
QUOTE(Michael_Aivaliotis @ Oct 8 2007, 12:03 AM) <{POST_SNAPBACK}>. Here's the VI, bonus to whoever figures it out... and yes, it works as expected. The caller will be broken if this output is not wired. ...

What's wrong with this picture?
How about detachable event structure nodes? [attachment=7213:1.png] [attachment=7214:detachableventnode.vi] (V8.5)

Please help me!? I don't know whats wrong.
I seem to have downloaded something by accident which is causing me loads of problems. For starters I keep getting security pop-ups, not from windows, but from some anti-spyware company, telling me i have bad malware/spyware/adware and ...

What's wrong with this picture?
QUOTE(Michael_Aivaliotis @ Oct 10 2007, 11:36 AM) <{POST_SNAPBACK}>. How about detachable event structure nodes? I remember that one: DetachableStructurePartsEnabled=TRUE. Does that mean the other thing can only be enabled with an INI ...

How to add some pages in Information slide-box
information box text in sideboxes/information.php define('BOX_INFORMATION_CONDITIONS', 'Conditions of Use'); define('BOX_INFORMATION_TEST1', 'Test page 1'); ... :frusty::frusty::frusty: What's wrong with me :no:

[C]What's wrong here?
EDIT: OMG IM SO STUPID lol. i found the error. thanks anyway! (I bolded the mistakes i had on the code) Please note that i'm only a beginner in C. So take it easy on me please.:blushing: #include int main() ...