Hello,
Here is a link which gives you two markers with name "Best" :
http://www.oukwakan.org/phpsqlajax_genxml.php?nom=best

One of the markers has lat lat="-37.1235"
But if you enter
http://www.oukwakan.org/phpsqlajax_genxml.php?nom=Best&lat=-37.1235
... you get an empty xml.

For now, I'm just testing xml production and I have a PHP/MYSQL syntax
problem.

Here is my get code that tries to listen for URL-passed parameters :
// Retrieve data from Query String
$nom = $_GET['nom'];
$adresse = $_GET['adresse'];
$descriptif = $_GET['descriptif'];
$lat = $_GET['lat'];
$lng = $_GET['lng'];
$entreprise = $_GET['entreprise'];
$educatif = $_GET['educatif'];

My problem lies in my coding of the php to parse the SELECT request, I
think. (In fact, I want to end up with coding to do an OR search but
I'm using AND coding I found in a web tutorial)

$query = "SELECT * FROM markers WHERE nom = '$nom'";
if(is_numeric($adresse))
        $query .= " AND adresse <= $adresse";
if(is_numeric($descriptif))
        $query .= " AND descriptif <= $descriptif";
if(is_numeric($lat))
        $query .= " AND lat <= $lat";
if(is_numeric($lng))
        $query .= " AND lng <= $lng";
if(is_numeric($entreprise))
        $query .= " AND entreprise <= $entreprise";
if(is_numeric($educatif))
        $query .= " AND educatif <= $educatif";
        //Execute query
$result = mysql_query($query);
if (!$result) {
  die('Invalid query: ' . mysql_error());

A big help would be a link to a web page that tells me how to use OR
in a mysql query. Thanks in advance for any advice.

-- 
You received this message because you are subscribed to the Google Groups 
"Google Maps JavaScript API v3" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/google-maps-js-api-v3?hl=en.

Reply via email to