<newbie warning> I'm trying to write my first shell script using MySQL. I've checked Welling & Thomson and Google but I think I'm searching the wrong keywords or something.
The shell script will be non-interactive, but interactively this is what I would do: mysql> select * from specialdays where month="6" and day=5; +-------+-----+-------------+-----+------------+ | month | day | who | uid | type | +-------+-----+-------------+-----+------------+ | 6 | 5 | Homer Burns | 8 | Birthday | +-------+-----+-------------+-----+------------+ Then I take the UID and search the 'names' table to get the corresponding email address mysql> select email from names where uid=8; +--------------------------+ | email | +--------------------------+ | [EMAIL PROTECTED] | +--------------------------+ Now what I would really like to get is something that looks like this: 6/5 Homer Burns [EMAIL PROTECTED] Birthday I'd appreciate any tips on how to proceed.... I'm stumped. TjL --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
