omskrivning af streng

Hm. Skal det ikke være:

$query = "SELECT `LATITUDE`, `LONGITUDE` FROM GPS WHERE ".$timeframe_sql." AND (STATUS = 'A' OR STATUS = 'X' OR STATUS = 'C') ORDER BY GPSMSGID ASC";
$result = mysql_query($link, $query);

nej nok ikke helt
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource

<ole>

Hvad står der præcist i $timeframe_sql? Umiddelbart ville jeg mene, det er helt korrekt, hvad w13 foreslår. Prøv evt:

$query = "SELECT `LATITUDE`, `LONGITUDE` FROM GPS WHERE ".$timeframe_sql." AND (STATUS = 'A' OR STATUS = 'X' OR STATUS = 'C') ORDER BY GPSMSGID ASC";
$result = mysql_query($link, $query) or die ($query."<hr>\r\n".mysql_error());

/mvh
</bole>

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\web\esbnyt\gps\calc_gearth.php on line 20
SELECT `LATITUDE`, `LONGITUDE` FROM GPS WHERE TIME_RECEIVED >= CURDATE() AND (STATUS = 'A' OR STATUS = 'X' OR STATUS = 'C') ORDER BY GPSMSGID ASC

jeg ved ikke lige hvor tager $timeframe_sql fra

mysql_query($query,$link)

Hm, uden at vide det med sikkerhed, skal CURDATE() måske bare være DATE() eller DATE uden parenteserne?

Hehe. Ah.

det nærmeste jeg kan finde med timeframe er

//Calculate today
if (($gearthperiod == "today") || ($gearthperiod == "yesterday") || ($gearthperiod == "week")) {
    $timeframe = "today";
    $bestand .= calc_gearth($timeframe, "TIME_RECEIVED >= CURDATE()", $link);   
}

//Calculate yesterday
if (($gearthperiod == "yesterday") || ($gearthperiod == "week")) {
    $timeframe = "yesterday";
    $bestand .= calc_gearth($timeframe, "TIME_RECEIVED >= (CURDATE()-1) AND TIME_RECEIVED <= CURDATE()", $link);
}

//Calculate last week
if ($gearthperiod == "week") {
    $timeframe = date("d-m-Y", mktime(0,0,0,date("m"),date("d")-2,date("Y")));
    $bestand .= calc_gearth($timeframe, "TIME_RECEIVED >= (CURDATE()-2) AND TIME_RECEIVED <= (CURDATE()-1)", $link);

    //Calculate three days ago
    $timeframe = date("d-m-Y", mktime(0,0,0,date("m"),date("d")-3,date("Y")));
    $bestand .= calc_gearth($timeframe, "TIME_RECEIVED >= (CURDATE()-3) AND TIME_RECEIVED <= (CURDATE()-2)", $link);
   
    //Calculate four days ago
    $timeframe = date("d-m-Y", mktime(0,0,0,date("m"),date("d")-4,date("Y")));
    $bestand .= calc_gearth($timeframe, "TIME_RECEIVED >= (CURDATE()-4) AND TIME_RECEIVED <= (CURDATE()-3)", $link);
   
    //Calculate five days ago
    $timeframe = date("d-m-Y", mktime(0,0,0,date("m"),date("d")-5,date("Y")));
    $bestand .= calc_gearth($timeframe, "TIME_RECEIVED >= (CURDATE()-5) AND TIME_RECEIVED <= (CURDATE()-4)", $link);
   
    //Calculate six days ago
    $timeframe = date("d-m-Y", mktime(0,0,0,date("m"),date("d")-6,date("Y")));
    $bestand .= calc_gearth($timeframe, "TIME_RECEIVED >= (CURDATE()-6) AND TIME_RECEIVED <= (CURDATE()-5)", $link);
}

//Calculate last month
if ($gearthperiod == "month") {
    $timeframe = "last month";
    $bestand .= calc_gearth($timeframe, "TIME_RECEIVED >= (CURDATE()-30)", $link);
}

//Calculate last year
if ($gearthperiod == "year") {
    $timeframe = "last year";
    $bestand .= calc_gearth($timeframe, "TIME_RECEIVED >= (CURDATE()-365)", $link);
}

har prøvet med at ændre alle curdate med date men viker heller ik

erikjacobsen antyder længere oppe, at rækkefølgen af argumenterne til mysql_query har betydning. Jeg synes det lyder klogt.

er det også, men hvis jeg bytter rundt som erik foreslår får jeg ik kontakt til mysql

men det kan være der andre der har fundet et tracking php system der kan fange mobil gps ?

Dooohhhh ... selvfølgelig har Erik ret! Den kommentar (og fejl) overså jeg fuldstændig!

Uanset, om du mener at have fat i MySQL eller ej, har Erik fuldstændig ret. Hvad siger fejlen, når du bytter om? For fra nu af kunne det naturligvis aldrig falde dig ind at lave et MySQL-kald uden helt automatisk at debugge med 'or die' ... vel?  =)

det den siger er
SELECT `LATITUDE`, `LONGITUDE` FROM GPS WHERE TIME_RECEIVED >= DATE() AND (STATUS = 'A' OR STATUS = 'X' OR STATUS = 'C') ORDER BY GPSMSGID ASC
--------------------------------------------------------------------------------
No database selected
jeg tror så w13 har lidt ret også angående curdate() at den kan ik bruges men skal ændres til noget med date() men det kræver der skal nogle parameter med

jeg så ik helt enig med ombytning af lin da connect til database vel skal komme først
$link = mysql_connect($dbhost, $dbuser, $dbpass, $dbname);

$dbname i kaldet til mysql_connect?
http://dk.php.net/mysql_connect

har du set denne funktion:
http://dk.php.net/mysql_select_db

ang CURDATE: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_curdate

vil det hjælpe hvis i ser hele koden;

<?php
//**********************************************************************************************
//**********************************************************************************************
//***** GG-Tracker is based on Aspicore GSM Tracker.                                      *****
//*****                                                                                    *****
//***** It's in a development phase and no warranties are given for anything. This program *****
//***** may not function the way you expect it and the author is not responsible for      *****
//***** anything. However, I hope you enjoy it and ammend it where possible!              *****
//*****                                                                                    *****
//***** An example of GG-Tracker is live at http://gg-tracker.eppenga.com                    *****
//**********************************************************************************************
//**********************************************************************************************

function calc_gearth($timeframe_human, $timeframe_sql, $link) {
/* Prepare an XML file for Google Earth */

    $timestamp = gmdate("D, d M Y");
   
    $query = 'SELECT LATITUDE, LONGITUDE FROM GPS '
          . 'WHERE '.$timeframe_sql.' AND (STATUS = \'A\' OR STATUS = \'X\' OR STATUS = \'C\') '
          . 'ORDER BY GPSMSGID DESC';
    $result = mysql_query($query, $link) or die ($query."<hr>\r\n".mysql_error());
   
    if (!$result) {
      printf("Query failed: %s\n", mysql_error($link));
      exit();
    }
   
    //Start writing the XML
    $bestand = "
    <Placemark>
        <name>Distance of $timeframe_human</name>     
        <styleUrl>#yellowLineGreenPoly</styleUrl>
        <LineString>
            <extrude>1</extrude>
            <tessellate>1</tessellate>
            <altitudeMode>absolute</altitudeMode>
            <coordinates>\r\n";
   
    //Write the coordinates to the Google Earth XML file
    while ($line = mysql_fetch_array($result, mysql_ASSOC)) {
      foreach ($line as $col_value) {
            $lon = $line['LONGITUDE'];
            $lat = $line['LATITUDE'];
            if ($lon && $lat) {
                $bestand .= "                ";
                $bestand .= $line['LONGITUDE'];
                $bestand .= ",";
                $bestand .= $line['LATITUDE'];
                $bestand .= "\r\n";
            }
        }
    }
   
    //Close the Google Earth XML properly
    $bestand .= "            </coordinates>
        </LineString>
    </Placemark>";
   
return $bestand;
}


//Open XML file with default header
$bestand = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>
<kml xmlns=\"http://earth.google.com/kml/2.2\">
    <Document>
    <name>GG-Tracker</name>
    <description>History of positions</description>
    <Style id=\"yellowLineGreenPoly\">
        <LineStyle>
            <color>7f00ffff</color>
            <width>4</width>
        </LineStyle>
        <PolyStyle>
            <color>7f00ff00</color>
        </PolyStyle>
    </Style>";

//Calculate today
$bestand .= calc_gearth("today", "TIME_RECEIVED >= CURDATE()", $link);

//Calculate yesterday
$bestand .= calc_gearth("yesterday", "TIME_RECEIVED >= (CURDATE()-1) AND TIME_RECEIVED <= CURDATE()", $link);

//Calculate last week
$bestand .= calc_gearth("last week", "TIME_RECEIVED >= (CURDATE()-7)", $link);

//Calculate last month
$bestand .= calc_gearth("last month", "TIME_RECEIVED >= (CURDATE()-30)", $link);

//Calculate last year
$bestand .= calc_gearth("last year", "TIME_RECEIVED >= (CURDATE()-365)", $link);


//Close XML file with default footer
$bestand .= "
    </Document>
</kml>";


//Write XML file, first erase old file then create new
$handle = fopen($gearthfile, 'w') or die("Can't open Google Earth file: ".$gearthfile);
fclose($handle);
unlink($gearthfile);
$handle = fopen($gearthfile, 'a');
fwrite($handle, $bestand);
fclose($handle);

?>

curdate er nu ændret til date("d M Y") som det formodes php virker med
echo af $link viser Resource id #3
fejlen er så stadig i $result = mysql_query( $link, $query) or die ($query."<hr>\r\n".mysql_error());

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\web\esbnyt\gps\calc_gearth.php on line 23
SELECT `LATITUDE`, `LONGITUDE` FROM GPS WHERE 1 AND (STATUS = 'A' OR STATUS = 'X' OR STATUS = 'C') ORDER BY GPSMSGID ASC

Det er ikke sådan du bruger mysql_query. Kig på kommentaren fra 20/06-2008 19:10:20, og læs på http://php.net/

ok har også prøvet omvendt $result = mysql_query($query,$link)
men fanger så ikke db

den eneste fejl nu er dette
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 'AND (STATUS = 'A' OR STATUS = 'X' OR STATUS = 'C') ORDER BY GPSMSGID ASC' at line 1

det som undre mig er det ligesom om første gennemløb seer det ud til at virke, men næste gennemløb mangler tallet 1 fra .$timeframe_sql.

SELECT `LATITUDE`, `LONGITUDE` FROM GPS WHERE 1 AND STATUS = 'A' OR STATUS = 'X' OR STATUS = 'C' ORDER BY GPSMSGID
--------------------------------------------------------------------------------
SELECT `LATITUDE`, `LONGITUDE` FROM GPS WHERE AND STATUS = 'A' OR STATUS = 'X' OR STATUS = 'C' ORDER BY GPSMSGID
--------------------------------------------------------------------------------
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 'AND STATUS = 'A' OR STATUS = 'X' OR STATUS = 'C' ORDER BY GPSMSGID' at line 1

Og hvad står der i SQL-sætningen?

Ja, hvis tallet mangler, så er der en SQL-fejl. Hvor kommer tallet fra? Og hvorfor står det der i det hele taget?

det jeg har nu er

$query = "SELECT `LATITUDE`, `LONGITUDE` FROM GPS WHERE ".$timeframe_sql." AND STATUS = 'A' OR STATUS = 'X' OR STATUS = 'C' ORDER BY GPSMSGID ";



    $result = mysql_query($query, $link)or die ($query."<hr>\r\n".mysql_error());

Og hvorfor bliver $timeframe_sql 1 eller tom?

det skulle den få fra index.php

<?php
//**********************************************************************************************
//**********************************************************************************************
//***** GG-Tracker is based on Aspicore GSM Tracker.                                      *****
//*****                                                                                    *****
//***** It's in a development phase and no warranties are given for anything. This program *****
//***** may not function the way you expect it and the author is not responsible for      *****
//***** anything. However, I hope you enjoy it and ammend it where possible!              *****
//*****                                                                                    *****
//***** An example of GG-Tracker is live at http://gg-tracker.eppenga.com                    *****
//**********************************************************************************************
//**********************************************************************************************

//**********************************************************************************************
//*****                                      PROGRAM                                      ******
//**********************************************************************************************

header("Expires: 0");
header("Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0");
header("Pragma: no-cache");
header("Content-Type: text/html; charset=ISO-8859-1");
header('Content-Disposition: inline; filename="response.html"');
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
            "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
  <style type="text/css">
  <!--
  td { font-family: verdana,arial,helvetica,sans-serif; font-size: 7pt;
      border: 1px solid black;
      vertical-align: baseline }
  th { font-family: verdana,arial,helvetica,sans-serif; font-size: 8pt; font-weight: bold;
      border: 1px solid black;
      border-style: solid; border-width: 1px;
      vertical-align: baseline }
  td.small { font-family: verdana,arial,helvetica,sans-serif; font-size: 6pt }
  body        { font-family: verdana,arial,helvetica,sans-serif; font-size: 8pt }
  base        { font-family: Courier,MONOSPACE; font-size: 10pt }
  table        { border-collapse: collapse; border: solid thin black }
  caption { font-family: verdana,arial,helvetica,sans-serif; font-size: 10pt; font-weight: bold }
  -->
  </style>
  <meta http-equiv="refresh" content="60;URL=." />
  <title>GG-Tracker (GSM and GPS location combined)</title>

<?php

/* Include settings */
include ("config.php");

/* Open and check connection */
$link = mysql_connect($dbhost, $dbuser, $dbpass, $dbname);
if (!$link) {
  printf("Connect failed: %s\n", mysql_connect_error());
  exit();
}

/* Calculate history and produce XML files for Google Earth */
if ($ghistory) include ("calc_gearth.php");

/* Get the last position with full details of the tracked phone */

$query = 'SELECT GPSMSGID, PHONE, STATUS, LATITUDE, LONGITUDE, SPEED_KNOTS, COURSE_DEG, TIME_RECEIVED, EVENT_TYPE, CELL_ID, LAC, MCC, MNC, NWNAME, LABEL, REMOTE_IP '
        . 'FROM GPS ORDER BY GPSMSGID DESC LIMIT 1';
$result = mysql_query($link, $query);

if (!$result) {
  printf("Query failed: %s\r\n", mysql_error($link));
  printf("Tried to execute the following SQL query:\r\n");
  printf("%s\r\n", $query );
  mysql_close($link);
  exit();}

$row_cnt = mysql_num_rows($result);
if ($row_cnt == 0) {
    printf("No data, connect Aspicore tracker first.\r\n");
    exit();
    }
else {
    $line = mysql_fetch_array($result, mysql_ASSOC);
    $id = $line['GPSMSGID'];
    $phone = $line['PHONE'];
    $status = $line['STATUS'];
    $latitude = $line['LATITUDE'];
    $longitude = $line['LONGITUDE'];
    $speed = round($line['SPEED_KNOTS']*1.852,2);
    $course = $line['COURSE_DEG'];
    $time = $line['TIME_RECEIVED'];
    $nwname = $line['NWNAME'];
    $cell = $line['CELL_ID'];
    $lac = $line['LAC'];
    $mcc = $line['MCC'];
    $mnc = $line['MNC'];
    $mode = $line['EVENT_TYPE'];
    $label = $line['LABEL'];
    $ipaddress = $line['REMOTE_IP'];
}

/* Get the last two good positions for a tail */
$query = 'SELECT LATITUDE, LONGITUDE '
      . 'FROM GPS WHERE (STATUS = \'A\' OR STATUS = \'X\' OR STATUS = \'C\') '
      . 'ORDER BY GPSMSGID DESC LIMIT 1,3';
$result = mysql_query($link, $query);

$row_cnt = mysql_num_rows($result);

if ($row_cnt == 3) {
    $line = mysql_fetch_array($result, mysql_ASSOC);
    $lat_1 = $line['LATITUDE'];
    $lon_1 = $line['LONGITUDE'];
    $line = mysql_fetch_array($result, mysql_ASSOC);
    $lat_2 = $line['LATITUDE'];
    $lon_2 = $line['LONGITUDE'];
    $line = mysql_fetch_array($result, mysql_ASSOC);
    $lat_3 = $line['LATITUDE'];
    $lon_3 = $line['LONGITUDE'];
}
else
{
    $lat_1 = $latitude;
    $lat_2 = $latitude;
    $lat_3 = $latitude;   
    $lon_1 = $longitude;
    $lon_2 = $longitude;   
    $lon_3 = $longitude;
}


//Google maps script, only execute if there are positions found
if ($status <> "Z") {
    echo "
        <script src=\"http://maps.google.com/maps?file=api&amp;v=2&amp;key=$gmaps\"
          type=\"text/javascript\"></script>
        <script type=\"text/javascript\">
   
        //<![CDATA[
        function load() {
          if (GBrowserIsCompatible()) {
            var map = new GMap2(document.getElementById(\"map\"));
            map.setCenter(new GLatLng($latitude, $longitude), 14);
            map.addControl(new GSmallMapControl());
            map.addControl(new GMapTypeControl());
            var marker = new GMarker(new GLatLng($latitude, $longitude));
            map.addOverlay(marker);
            GEvent.addListener(marker, \"click\", function() {
              var html = '<div style=\"width: 250px; height: 50; padding-right: 10px\"><font size=2><b>Hello World!</b><br>This is my my current position. If you enjoy this application, please <br><a href=\"http://blog.eppenga.com/2008/01/23/gsm-tracking-and-navigation/\">read my webblog.<\/a><\/font><\/div>';
              marker.openInfoWindowHtml(html);
              });
            var polyline = new GPolyline([
                new GLatLng($lat_3, $lon_3),               
              new GLatLng($lat_2, $lon_2),
                new GLatLng($lat_1, $lon_1),
                new GLatLng($latitude, $longitude)
            ], \"#ff0000\", 7);
            map.addOverlay(polyline);
          }
        }
       
        //]]>
        </script>
    ";
}

//Get some statistical data
include ("calc_stats.php");

//The rest of the internet page
echo "
  </head>

    <body onload=\"load()\" onunload=\"GUnload()\">
 
    <center>
    <table width=600 cellspacing=2 cellpadding=2>
        <tr align=center>
            <td colspan=3>
                <font size=2 color=red><b>Welcome to GG-Tracker (GPS and GSM Tracking)</b></font>
            </td>
        </tr>
        <tr>
            <td><b>Current location: $label</b></td>
            <td><b>Last report: $time</b></td>
            <td><b>Connection from IP: $ipaddress</b></td>
        </tr>
        <tr>
            <td><b>Topspeed today/ever: $maxspeed[1]/$maxspeed[0] km/h</b></td>
            <td><b>Distance home: $disthome km</b></td>
            <td><b>GSM antenna (useful/total): $gsm_antenna[0]/$gsm_antenna[1]</b></td>
        </tr>   
    </table>";
 
echo "   
    <table width=600 cellspacing=0 cellpadding=0)>
        <tr><td valign=middle width=600 height=400>";
 
if ($status == "Z")
  {
    echo "
        <br><br><br><br><br><br><br><br><br><br><br><br>
        <b>There is no image to display.</b><p>
        The GPS is not connected and the GSM location can not be found in the database.<p>
        Please check back later.";}
else
    {echo "<div id=\"map\" style=\"width: 596px; height: 400px\"></div>";}
 
echo "
    </td></tr>
</table>";
   
echo "
    <table width=600 cellspacing=2 cellpadding=2>
        <tr align=center>
            <td colspan=2><b>GSM Information</b></td>     
            <td colspan=2><b>GPS Information</b></td>
        </tr><tr align=left>
            <td>Network</td><td>$nwname</td>
            <td width=150>Status</td><td width=150>$status</td>
        </tr><tr align=left>     
            <td width=150>Cell ID</td><td width=150>$cell</td>
            <td>Latitude</td><td>$latitude deg</td>
        </tr><tr align=left>
            <td>LAC</td><td>$lac</td>
            <td>Longitude</td><td>$longitude deg</td>
        </tr><tr align=left>
            <td>MCC</td><td>$mcc</td>
            <td>Speed</td><td>$speed km/h</td>
        </tr><tr align=left>
            <td>MNC</td><td>$mnc</td>
            <td>Course</td><td>$course deg</td>
        </tr>";

//Display history line if set in config.php   
if ($ghistory) {   
    echo "<tr align=center>
            <td colspan=4><a href=\"google_earth.kml\"><font color=black><b>Show a history of positions in Google Earth (you need Google Earth installed)</b></font></a></td>
        </tr>";}
   
echo "
    </table>
   
    <br>
    <a href=\"http://www.eppenga.com/gg-tracker\" target=_top>
        <font size=2 color=red><b>More information, setup and download GG-Tracker application</b></font>
    </a>
    <br>   
    <a href=\"http://www.eppenga.com\">
        <font size=1 color=black><i>GG-Tracker is an open-source development project by Ebo Eppenga</i></font>
    </a>
 
    </center>\r\n\r\n";

/* Include footer */
include ("footer.php");
 
echo "    </body>\r\n";
echo "</html>";


/* Close and free everything */

// Free resultset
mysql_free_result($result);

/* Close connection */   
mysql_close($link);

?>

Hvor?

nej det var ik der, ok jeg løbet tør kan ikke finde fejlne

Det sker i function calc_gearth ? Så skal du finde hvor den bliver kaldt.

lukker