FLOAT in PHP MyAdmin

[PHP Nubsauce]

Hi guys,

 

if anybody is able to help - I'm trying to install this function through PHP MyAdmin in the "Run SQL Queries" window.

 

It keeps barfing on my code - if anyone can help me re-write it or help me get this function installed another way, like an external install file or something, that would be great.

 

DELIMITER $$
CREATE FUNCTION LATLON_DIST_MI(lat1 FLOAT, lon1 FLOAT, lat2 FLOAT, lon2 FLOAT ) RETURNS FLOAT
DETERMINISTIC
BEGIN
    DECLARE dist FLOAT;
    SET dist = SIN( RADIANS(lat1) ) * SIN( RADIANS(lat2) ) + COS( RADIANS(lat1) ) * COS( RADIANS(lat2) ) * COS( RADIANS(lon1-lon2) );
    SET dist = DEGREES(ACOS(dist));
    RETURN dist * 60 * 1.1515;
END
$$

 

MySQL said:

#1064 - 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 $$

CREATE FUNCTION LATLON_DIST_MI(lat1 FLOAT, lon1 FLOAT, lat2 FLOAT,' at line 1

[fenway]

Which version?

[Mchl]

In phpMyAdmin do not include DELIMITER $$ in your code. Instead put your delimiter in a field below SQL teztarea.