Search found 6 matches

by Blade
Mon Oct 21, 2002 7:49 am
Forum: Databases
Topic: How do I get data from mysql based on week number?
Replies: 2
Views: 1023

Thats it :)

Thanks a lot. I did look at the mysql page before, but I didnt really understand how to use the info until now.
by Blade
Mon Oct 21, 2002 6:48 am
Forum: Databases
Topic: How do I get data from mysql based on week number?
Replies: 2
Views: 1023

How do I get data from mysql based on week number?

I want to extract data from a mysql table based on week numbers. something like this: select * from table where (date = week 42) I know how to do it in php, but I there is no need to load the whole database into memory, when I know it can be done with a simple sql statement. I just dont know how, so...
by Blade
Mon May 27, 2002 4:23 pm
Forum: PHP - Code
Topic: How do I show age from a birthdate?
Replies: 4
Views: 2526

oh yeah, of course that old hack..

Thanks again :)
by Blade
Mon May 27, 2002 7:42 am
Forum: PHP - Code
Topic: How do I show age from a birthdate?
Replies: 4
Views: 2526

Yay, that did it..

Thanks for the fast reply :)

Gotta love those sql statements. My select statement is aprox. 800 chars long now, with 9 joins :)

Oh, just one thing, is it possible to remove those zero'es at the begining of the result? I mean without using php.

/Blade
by Blade
Mon May 27, 2002 7:32 am
Forum: PHP - Code
Topic: I'd like to know the average OS for a web programmer
Replies: 21
Views: 11677

I use win2000 and textpad and have for the last couple of years. But Im gonna try dreamweaver soon. Ive heard a lot of good stuff about it.

I've installed samba on my test server (running redhat 7.0), that way I dont need to use ftp, just use the old win shares :) gotta love samba.

Blade
by Blade
Mon May 27, 2002 7:14 am
Forum: PHP - Code
Topic: How do I show age from a birthdate?
Replies: 4
Views: 2526

How do I show age from a birthdate?

Hi. I need to show how old a person is from his/her birthdate. The birthdates come from a mysql db. I found this script on php.net, but its not working 100% ----- <?php $nowdate = mktime(0,0,0,date("m"),date("d"),date("Y")); $birthday = mktime(0,0,0,"05"...