HI there 
I would like to know how I should go do work to convert this:
Airport_LAT AS latitude,
Airport_LNG AS longitude,
ID AS record_id, Title AS name,
address AS address,
city AS city,
state AS state,
zip AS zip
FROM dz_Links
WHERE $dist < $rad ** 2
ORDER BY $dist
LIMIT 0, $maxSearchRes";
to something like this:
my $result = $table->select({Airport_LAT},{$dist => $rad ** 2} );
I have read through the documentation that came with the installation, but I am still clueless. If someone could explain it step by step I would really appreciate it
Thank you....
Sacrifice is not about what you lose,
it is about what you gain in the process.
I would like to know how I should go do work to convert this:
Code:
my $sql = "SELECT sqrt($dist) AS distance, Airport_LAT AS latitude,
Airport_LNG AS longitude,
ID AS record_id, Title AS name,
address AS address,
city AS city,
state AS state,
zip AS zip
FROM dz_Links
WHERE $dist < $rad ** 2
ORDER BY $dist
LIMIT 0, $maxSearchRes";
to something like this:
Code:
my $result = $table->select({Airport_LAT},{$dist => $rad ** 2} );
I have read through the documentation that came with the installation, but I am still clueless. If someone could explain it step by step I would really appreciate it
Thank you....
Sacrifice is not about what you lose,
it is about what you gain in the process.
MySQL Query??