Re: [PHP-DB] creating mysql functions using php

2008-10-09 Thread Andrew Martin
putting the delimiter call in it's own query() call, but no luck so far. Thanks, Andy 2008/10/8 Chris [EMAIL PROTECTED]: Andrew Martin wrote: Hello, Is it possible to create a mysql function from php, or is it command line only? $db = get_db(); $a = $db-query( DELIMITER $$ ); echo $db

Re: [PHP-DB] creating mysql functions using php

2008-10-09 Thread Andrew Martin
Right, problem's obvious really: There's never any need to use delimiter in an API call, as delimiters aren't used - separate calls are made instead. So the following code works just fine: $link = mysql_connect('localhost', 'root', 'pass'); mysql_select_db( 'test' ); $ret = mysql_query( 'DROP

[PHP-DB] creating mysql functions using php

2008-10-08 Thread Andrew Martin
Hello, Is it possible to create a mysql function from php, or is it command line only? $db = get_db(); $a = $db-query( DELIMITER $$ ); echo $db-error; // You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

Fwd: [PHP-DB] Reading excel files

2008-09-17 Thread Andrew Martin
Subject: Re: [PHP-DB] Reading excel files To: Andrew Martin [EMAIL PROTECTED] Are your Excel files nicely organized by columns with column names? On 9/16/08, Andrew Martin [EMAIL PROTECTED] wrote: Hello, Does anybody have experience with excel spreadsheet reader packages, either free

[PHP-DB] Reading excel files

2008-09-16 Thread Andrew Martin
Hello, Does anybody have experience with excel spreadsheet reader packages, either free or commercial? The old PEAR class is no longer maintained and the current sourceforge-hosted reader fails to read files above a certain size - I have attempted to debug it but to no avail. I have a commercial

[PHP-DB] mathematical discrepancies

2008-08-14 Thread Andrew Martin
Hello, Can anybody shed any light on this behaviour please? PHP Version 5.2.5 on XP $a = 1754.00 ; $b = 1754.03 ; $diff = abs($b) - abs($a); echo $diffbr/; //output: 0.03 $a = 1754.00 ; $b = 1754.09 ; $diff = abs($b) - abs($a); echo $diffbr/; //output :0.08999 $a = 1754.01

[PHP-DB] MySQL circular buffer

2008-06-20 Thread Andrew Martin
Hello, I'm looking at implementing a database-level stack for a (multi stack) mail merge queue (able to queue up to 1 million messages per stack). Current workflow: server 1 (containing main db) transmits data sets (used to populate mail merge template) to server 2 server 2 web-facing script

[PHP-DB] Serializing mySQLi result resource

2008-06-08 Thread Andrew Martin
Hello, Is it possible to serialize a MySQL(i) result resource? I am looking to insert results into the eAccelerator cache but the returned resource does not appear to be recognised by mysqli_fetch_assoc. Thanks, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: