Toni_montana

there are many scripts around that are able to export mysql to excel. You might wanna search google for it. It's easyer than writing it yourself. good luck rogier

I don't know whether this is already really familiair for you guys, but it wasn't for me. I use e-mail validation for my site to limit the amout of "crap" i receive. So i would send a unique link to the e-mail adress provided by a new user. This works great. But now i saw that quite a few people used a @spam.la address to logon. This is an e-mail service that displays everyhing out in the public no matter what is in front of the @ so if your name is jan, you just specifiy jan@spam.la. and 5 minutes later everybody can find the e-mail, containing the activation link published on the internet. Although the e-mail adres doesn;t even exist. Since i rely on e-mail correspondece to tell the users of my sites if interesting things have happened, it's important for me to know that te e-mail address exists. This service totally circumvents this security measurement. I would suggest that you should also filter on @spam.la addresses and don't allow then to be specified. Good luck rogier

Aren't we all in need of some help

Guys, NOBODY of you can solve this one? Seems i'm only helping others these days...

Hey there, $orderID seems to have a certain key to it. (unique, or primary) that doesn't allow identical values. This is good. You need one of these in every DB. it's probably wise to use auto_increment because, when you insert a new one, the $orderID value is still at '0'. This will cause your next insert to malfunction, because there is already a '0'. So either change it to auto_increment or use proper orderID's. That are non-identical. Good luck Rogier

In my opinion, you don't need the exact age to tell wheter someon is above 18 or not. Just use one of the solutions you found, and instead of round() use floor(). This will round the age down. good luck rogier [!--quoteo(post=352475:date=Mar 7 2006, 07:47 AM:name=fohanlon)--][div class=\'quotetop\']QUOTE(fohanlon @ Mar 7 2006, 07:47 AM) [snapback]352475[/snapback][/div][div class=\'quotemain\'][!--quotec--] Hi I need to be able to calculate the exact age of a person based on a comparison to todays date. I have tried to use timestamp but I run into the 1970 problem. The dob the user can choose can go from 1st jan 1910. For example: Today is the 7th march 2006 Using the following dates I need to be able to get the results below: DOB: 6th March 1988 - return whether 18 or not DOB: 7th March 1988 - return whether 18 or not DOB: 8th March 1988 - return whether 18 or not I have searched the web but all code rounds to nearest year but I need to be exact as the solution will determine a calculated cost. Any help would be greatly appreciated. Thanks, Fergal. [/quote]

Hey there, This is my case. I have an mysql db in which names are stored. Some of them have a rating, some don't. Now i want to make a top 10 based on this rating. But i also want to show the 10 last ones. (i exclude the ones without a rating from the top10). Now this is where i'm stuck because i also want to have the 10 last ones in a descending order. (So ORDER BY rating DESC LIMIT 10) won't do. I'll have to resort the result i get from this. Anyone any ideas? Rogier

I'm not sure wheter this is gonna solve your problem, But i think it's better to use $page =$_GET['page']; over just asuming that $page will contain the variable passed by GET. I don't think that the way you do it is supported by all OS. good luck rogier