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->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 'DELIMITER $$' at line 1
$a = $db->query( "
DROP FUNCTION IF EXISTS `anti_space`$$
CREATE FUNCTION `anti_space` (
inString VARCHAR(1000),
replaceThis VARCHAR(1000),
replaceWith VARCHAR(1000)
)
// 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 '$$ CREATE FUNCTION `anti_space` ( inString VARCHAR(1000),
replaceThis VARCHA' at line 1
What's your query method look like?
What happens if you try using
mysql_query($query);
instead of $db->query($query) ?
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php