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 F
`anti_space`$$ CREATE
FUNCTION `anti_spac' at line 1
I've tried 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 possibl
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 'DE
ate: 2008/9/16
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 spreadsh
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 a
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 "$diff"; //output: 0.03
$a = 1754.00 ;
$b = 1754.09 ;
$diff = abs($b) - abs($a);
echo "$diff"; //output :0.08999
$a = 1754.01 ;
$
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 (scr
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: ht