Horizontal list...

2004-03-17 Thread Richard Carlier
| 3 | 1 | +---++ Based on a group by or something... A + -- *~~~~* Richard CARLIER http://www.rcarlier.net (o_- Votre association et Internet (mai 2002, VMP, 2-7440-6013-5) //\- Profe

Hierarchical list...

2004-03-07 Thread Richard Carlier
t, libelle FROM links_categories WHERE (id = 2 or parent = 2) Works for the father and the son, but for the others... :( A + -- *~~~~* Richard CARLIER http://www.rcarlier.net (o_- Votre asso

Re[2]: Regex and email

2003-09-01 Thread Richard Carlier
Bonjour Matthew ! MS> Not sure about php syntax, but check out the perl module (in CPAN) MS> Email::Valid. I'm not searching the PHP syntax, but the SQL syntax... :) A + -- *~~~~* Rich

Regex and email

2003-09-01 Thread Richard Carlier
email FROM mailing WHERE email REGEXP '^([a-zA-Z0-9])+([\.a-zA-Z0-9_-])*@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+'; But some of "false" mails are accepted, like "[EMAIL PROTECTED]". Can you help me ? Regards -- *~~~~~~~~