Re: MySQL access via C/C++

You have at least two choices: you can use the MySQL C API or you can use PHP compiled as a program. The MySQL C API is documented in the MySQL docs. http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#C (if your e-mail client wraps this long link, then you'll have to copy/paste it into your browser). If your PHP is already available as a program, then you can just write PHP scripts to do whatever you want. To find out if your administrator did this, just type "php -h" at your shell prompt. If you get something like this: Usage: php [-q] [-h] [-s] [-v] [-i] [-f <file>] | {<file> [args...]} -q Quiet-mode. Suppress HTTP Header output. -s Display colour syntax highlighted source. -f<file> Parse <file>. Implies `-q' -v Version number -c<path> Look for php.ini file in this directory -a Run interactively -d foo[=bar] Define INI entry foo with value 'bar' -e Generate extended information for debugger/profiler -z<file> Load Zend extension <file>. -i PHP information -h This help then you can cron PHP scripts. Doug At 04:15 AM 12/3/00 -0500, jeff marston wrote: >Can anybody point me to a library or something that lets me do basic SQL >with an existing mySQL database? I'm using PHP now, but I want to be able >to have a cron job to call a program that will automatically update/delete >entries from a table. >Or is there an easier way to do this? > >Thanks, Jeff