Re: [PHP-DB] mysqldump via php

mysqldump is a .exe, and therefore it will not work within mysql_query(); You may be able to use mysqldump from PHP using the system function check out http://uk.php.net/system Ade Jeffrey wrote: I would like to do a backup of an entire MySQL database via php. My thought was to use

[PHP-DB] PDF BLOB to Email

Hi I have pdf's stored as a blob in a MySQL database, how can i set a script (PHP obviously!) to email these blobs as pdf files. The only way i can think of at the moment is to write them to disk and then attach them to the mail before sending it. This doesn't seem that efficient but

Re: [PHP-DB] PDF BLOB to Email

[snip] No, not Obviously, PHP is not well suited for many tasks (or has a high cost to get the suit tailored) :) [/snip] Obviously because i am posting to a PHP list, numpty! but thank you for the recommendation anyway. JupiterHost.Net wrote: Adrian Bruce wrote: Hi Hello, I have

Re: [PHP-DB] MySQL creating new tables using wrong engine...

--default-storage-engine option in your options file (my.ini) where engine is the the type of table engine you want to use, in your case MYISAM. If you cant change that then specify the engine type every time you create a table: create table table_name{ . } TYPE=myisam; Regards

Re: [PHP-DB] css #2

Jerry Not a php related question at all for starters but anywayi think you need to read up on CSS layout's if the site is properly structure using CSS then you will not have much to worry about regarding different resolutions. Ever heard of floats? google will show you the light! Ade

[PHP-DB] PDF generation on the fly

Hi Do any of you use pdflib for generating PDF files on the fly? Ive got the demo working and it looks good so far, i was expecting it be open source but found out that it has a price tag of 450 euros per processor, this is fairly reasonable of course but i was wandering if anyone knew of

Re: [PHP-DB] PDF generation on the fly

thanks a lot, i'll take a look at it Bastien Koert wrote: www.fpdf.org bastien From: Adrian Bruce [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] PDF generation on the fly Date: Mon, 23 Jan 2006 15:31:48 + Hi Do any of you use pdflib for generating PDF files on the fly

Re: [PHP-DB] SELECT

Possibility? WHERE (`date_created` = '$date_90_minutes_ago' AND `time_created` = '$time_90_minutes_ago') or (`date_created` '$date_90_minutes_ago' AND `time_created` '01:30:00') Ade Ron Piggott (PHP) wrote: Yesterday I asked how to get the date time 90 minutes ago and I received

Re: [PHP-DB] formatting a date from mysql

farily straight forward to withinn the query itself, check out http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html or for php http://uk.php.net/date RTFM Regards Adrian Eternity Records Webmaster wrote: I need to figure out how to format the date format: year-month-day

[PHP-DB] Specific order by MySQL statement

Hi I am trying to get results from a MySQL query in a specific order, just using ASC or DESC will not work. For Example I have a field that can contain 4 possible values: 'Current', 'Completed','Withdrawn' or 'Transferred', I would like to order the results specifically like: Current