* tmb > I'm Running RedHat Linux 7.3 - Apache - MySQL & > scripting with PHP on an Intel box... > > Question 1: > I want to print a specified field or fields, in > specified records of an mysql db to the line printer > several times a day...
OK, let's see if we can break this down into smaller tasks: 1) You want specified field/fields from specified records... 2) ...sent to the printer.... 3) ...several times a day The details: 1) To get data from a mysql database, you use the SELECT statement: <URL: http://www.mysql.com/doc/en/SELECT.html > 2) To send data to a printer in a Linux environment, take a look at the 'lp' utility by entering 'man lp' on the linux command line. 3) To do this periodically, you can use the cron facility of your linux system, see 'man cron'. > Can anyone get me started on the PHP script to do > this? Are you sure you want to use PHP for this? PHP is very well suited for making web pages, but not so good for tasks like this... anyway, to get you started with PHP and mysql: <URL: http://www.php.net/manual/en/ref.mysql.php > > Question 2: > Is there a better place to post PHP & MySQL > questions? This list is for mysql questions, but even if your question is mostly PHP related many of the users on this list will be able to help you. Of course, if it is not related to mysql at all, you should not post it to this list. If there is a better place to post PHP & MySQL qustions, I don't know. -- Roger --------------------------------------------------------------------- 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
