Reporting Tool

2001-12-20 Thread Zach Curtis
(e.g., tables, graphs, bar charts, pie charts, etc.). The data would of course need to be real-time. Any suggestions? Zach Curtis - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: Decrypting PASSWORD() from MySQL

2001-12-19 Thread Zach Curtis
/decipher Thanks, Zach -Original Message- From: Matt Wagner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:52 PM To: Zach Curtis Cc: [EMAIL PROTECTED] Subject: Re: Decrypting PASSWORD() from MySQL Zach Curtis writes: > I have a form for a user to request their forgot

Decrypting PASSWORD() from MySQL

2001-12-19 Thread Zach Curtis
ot;Could not execute database query:" . mysql_error() . ""; $row = mysql_fetch_array($result); $userName = "$row[userName]"; $password = "$row[password]"; $email = "$row[email]"; Thank you. Zach Curtis Programmer/Analyst POPULUS --

RE: Calculating Age

2001-11-16 Thread Zach Curtis
Ah, good idea. That should resolve my issue. Thanks! Zach -Original Message- From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 2:08 PM To: Zach Curtis; [EMAIL PROTECTED] Subject: RE: Calculating Age > I am trying to calculate an approximate

Calculating Age

2001-11-15 Thread Zach Curtis
do I... A) bring these two fields together B) assign a day value to calculate age, if needed C) calculate the age I was trying something like the following syntax but this doesn't combine the fields or use a date format. SELECT (TO_DAYS(NOW())-TO_DAYS(???)/365) FROM table; Thank you. Zach C