[PHP-DB] Sorting the result

2002-02-27 Thread Kristjan Kanarik
Hi, I've come across a problem and I'm affraid that I'm lacking the skills of writing proper SQL queries in order to solve this. I'm building a little search engine for my site (yes, from scratch! It doesn't have to be the best, but I think that for my personal use it will be enough) and the bit

Re: [PHP-DB] Sorting the result

2002-02-28 Thread Kristjan Kanarik
ACCOURANCE IN article_text DESC) or die (mysql_error()); How to make MySQL to understand this 'Q ACCOURANCE IN article_text' is the tricky part for me. Kristjan : - Original Message - : From: Kristjan Kanarik [EMAIL PROTECTED] : To: [EMAIL PROTECTED] : Sent: Wednesday, February 27, 2002 2

[PHP-DB] Next birthday?

2002-03-08 Thread Kristjan Kanarik
I have a table called 'members' with a field (among many others) 'member_dob' - the birthday of a particular member. The data type of this field is date (-mm-dd). What I'd like to do now is to fetch one particular row from the database (I am using MySQL 3.23.37) - namely the row of the

RE: [PHP-DB] Next birthday?

2002-03-08 Thread Kristjan Kanarik
BY last_name This really seems like overkill. This query would be much simpler if you just showed everyone's birthday next month (or something like that). Robert Zwink http://www.zwink.net/daid.php -Original Message- From: Kristjan Kanarik [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08