Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199903

Re: [PHP3] php/mysql and mapping applications? From: Adam Gotheridge (adam <email protected>)
Date: 03/28/99

> figure out how to sort from closest location to furthest within the
> recordset. Well, that information is generated on the fly for each record
> that gets returned, so I can't do an ORDER BY or anything like that.

I haven' totally followed this thread, but I think you have 2 options.

1. You should be able to move the trig functions into the SQL statement, and
better yet, the SQL statement should be a stored procedure.
2. If the above is not available for your db, you should be able to read the
results into an array, sort the array, and then generate the html.

Adam

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3
List administrator:  zeev-list-admin <email protected>