Where can I use Where?

Anon

Hello,
I have a database of 46,000 customers. Each customer has a birth date on file "dob". I would like to know who's dob it is today. Just a simple list. If I remove the "WHERE" portion of the following, I get all 46,000 names of course. If I leave it in, I get this:

Warning: Supplied argument is not a valid MySQL result resource

$result=mysql_query ("SELECT * FROM customer order by first_name ASC WHERE dob=$today");
if ($rr = mysql_fetch_array($result))
{ do {
printf("<b>%s, %s </b><br>\n", $rr[2], $rr[1]);
} while ($rr = mysql_fetch_array($result));
}

could somebody please help me?

mithril

What is the content of $today? Have you tried putting it in quotes?

ie.

"SELECT * FROM customer order by first_name ASC WHERE dob='$today'"

-geoff

Anon

The content of $today is a formated date. I did all kinds of stuff to make it look exactly like the dates in the dod column. $today is not the problem, I tried it with other more simple fields (such as first_name, $today="joe"; then in the mysql part I put first_name='$today' and the same result came back I know I have over 200 Joes)and it still gives me the same error. Also, Yes. I did try dod='$today'" No dice.

Thank You!

staffanolin

Try moving the WHERE ...
so it looks like this

"SELECT * FROM customer WHERE dob=$today order by first_name ASC"

Don't know if that is the problem though.
Just a thought.

/Staffan

[deleted]

As Staffan said, the ORDER should come after the WHERE (you will want to read the MySQL manual about how to write SQL: http://www.mysql.com/doc/S/E/SELECT.html)

Secondly, what type is the 'dob' column?
And what exactly do you put in $today?