suchfeld soll beim absenden nicht beachtet werden (optional) [7]

Jörg]Ja, das ist die Query, die an die Datenbank gesendet wird. Die sollte eigentlich Ergebnisse liefern. In der Tabelle Eingabe befinden sich auch Datensätze?

Und wie sieht der HTML-Teil aus, in dem die Ergebnisse ausgegeben werden?

<?php require_once('Connections/Eingabe.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case 'text':
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$maxRows_R1 = 20;
$pageNum_R1 = 0;
if (isset($_GET['pageNum_R1'])) {
  $pageNum_R1 = $_GET['pageNum_R1'];
}
$startRow_R1 = $pageNum_R1 * $maxRows_R1;
mysql_select_db($database_Eingabe, $Eingabe);
$query_R1 = "SELECT * FROM Eingabe WHERE ";
$colname_R1 = "KEIN EINTRAG";
if (isset($_POST['abfahrtsort']) && $_POST['abfahrtsort'] != 'Abfahrtsort') {
    $query_R1 .= " abfahrtsort = " . GetSQLValueString($_POST['abfahrtsort'], 'text') . " AND ";
}
if (isset($_POST['zielort']) && $_POST['zielort'] != 'Zielort') {
   $query_R1 .= " zielort  = " . GetSQLValueString($_POST['zielort'], 'text') . " AND ";
}
if (isset($_POST['tag']) && $_POST['tag'] != '-') {
    $query_R1 .= " tag = " . GetSQLValueString($_POST['tag'], 'text') . " AND ";
}
if (isset($_POST['jahr']) && $_POST['jahr'] != '-') {
    $query_R1 .= " jahr = " . GetSQLValueString($_POST['jahr'], 'text') . " AND ";
}
if (isset($_POST['monat']) && $_POST['monat'] != '-') {
    $query_R1 .= " monat = " . GetSQLValueString($_POST['monat'], 'text') . " AND ";
}
if (isset($_POST['stunde']) && $_POST['stunde'] != '-') {
    $query_R1 .= " stunde = " . GetSQLValueString($_POST['stunde'], 'text') . " AND ";
}
if (isset($_POST['hinfahrtladeflaeche']) && $_POST['hinfahrtladeflaeche'] != 'Angaben zur Ladefläche') {
    $query_R1 .= " hinfahrtladeflaeche = " . GetSQLValueString($_POST['hinfahrtladeflaeche'], 'text') . " AND ";
}
if (isset($_POST['hilfeeinausladen']) && $_POST['hilfeeinausladen'] != '-') {
    $query_R1 .= " hilfeeinausladen = " . GetSQLValueString($_POST['hilfeeinausladen'], 'text') . " AND ";
}
if (isset($_POST['rueckfahrt']) && $_POST['rueckfahrt'] != '-') {
    $query_R1 .= " rueckfahrt = " . GetSQLValueString($_POST['rueckfahrt'], 'text') . " AND ";
}
if (isset($_POST['rueckfahrtladeflaeche']) && $_POST['rueckfahrtladeflaeche'] != 'K.A. zur Ladefläche') {
    $query_R1 .= " rueckfahrtladeflaeche = " . GetSQLValueString($_POST['rueckfahrtladeflaeche'], 'text') . " AND ";
}
if (isset($_POST['marke']) && $_POST['marke'] != '') {
    $query_R1 .= " marke LIKE '%" . mysql_real_escape_string($_POST['marke']) . "%' AND ";
}
if (isset($_POST['model']) && $_POST['model'] != '') {
    $query_R1 .= " model LIKE '%" . mysql_real_escape_string($_POST['model']) . "%' AND ";
}
if (isset($_POST['laderaumhoehe']) && $_POST['laderaumhoehe'] != '') {
    $query_R1 .= " laderaumhoehe = " . GetSQLValueString($_POST['laderaumhoehe'], 'text') . " AND ";
}
if (isset($_POST['laderaumbreite']) && $_POST['laderaumbreite'] != '') {
    $query_R1 .= " laderaumbreite = " . GetSQLValueString($_POST['laderaumbreite'], 'text') . " AND ";
}
if (isset($_POST['laderaumlaenge']) && $_POST['laderaumlaenge'] != '') {
    $query_R1 .= " laderaumlaenge = " . GetSQLValueString($_POST['laderaumlaenge'], 'text') . " AND ";
}
if (isset($_POST['laderaumvolumen']) && $_POST['laderaumvolumen'] != '') {
    $query_R1 .= " laderaumvolumen = " . GetSQLValueString($_POST['laderaumvolumen'], 'text') . " AND ";
}
if (isset($_POST['treibstoff']) && $_POST['treibstoff'] != '-') {
    $query_R1 .= " treibstoff = " . GetSQLValueString($_POST['treibstoff'], 'text') . " AND ";
}
if (isset($_POST['getriebe']) && $_POST['getriebe'] != '-') {
    $query_R1 .= " getriebe = " . GetSQLValueString($_POST['getriebe'], 'text') . " AND ";
}
$query_R1 .= "1 ORDER BY Eingabe.monat, Eingabe.tag, Eingabe.stunde, Eingabe.`minute`";
$query_limit_R1 = sprintf("%s LIMIT %d, %d", $query_R1, $startRow_R1, $maxRows_R1);

$R1 = mysql_query($query_limit_R1, $Eingabe) or die(mysql_error());
$row_R1 = mysql_fetch_assoc($R1);

if (isset($_GET['totalRows_R1'])) {
  $totalRows_R1 = $_GET['totalRows_R1'];
} else {
  $all_R1 = mysql_query($query_R1);
  $totalRows_R1 = mysql_num_rows($all_R1);
}
$totalPages_R1 = ceil($totalRows_R1/$maxRows_R1)-1;

$currentPage = $_SERVER["PHP_SELF"];

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$maxRows_R1 = 20;
$pageNum_R1 = 0;
if (isset($_GET['pageNum_R1'])) {
  $pageNum_R1 = $_GET['pageNum_R1'];
}
$startRow_R1 = $pageNum_R1 * $maxRows_R1;

$colname6_R1 = "NULL";
if (isset($_POST['minute'])) {
  $colname6_R1 = $_POST['minute'];
}
$colname7_R1 = "NULL";
if (isset($_POST['hinfahrtladeflaeche'])) {
  $colname7_R1 = $_POST['hinfahrtladeflaeche'];
}
$colname5_R1 = "NULL";
if (isset($_POST['stunde'])) {
  $colname5_R1 = $_POST['stunde'];
}
$colname_R1 = "KEIN EINTRAG";
if (isset($_POST['abfahrtsort'])) {
  $colname_R1 = $_POST['abfahrtsort'];
}
$colname1_R1 = "KEIN EINTRAG";
if (isset($_POST['zielort'])) {
  $colname1_R1 = $_POST['zielort'];
}
$colname2_R1 = "KEIN EINTRAG";
if (isset($_POST['tag'])) {
  $colname2_R1 = $_POST['tag'];
}
$colname3_R1 = "KEIN EINTRAG";
if (isset($_POST['monat'])) {
  $colname3_R1 = $_POST['monat'];
}
$colname4_R1 = "KEIN EINTRAG";
if (isset($_POST['jahr'])) {
  $colname4_R1 = $_POST['jahr'];
}
$colname8_R1 = "NULL";
if (isset($_POST['hilfeeinausladen'])) {
  $colname8_R1 = $_POST['hilfeeinausladen'];
}
$colname9_R1 = "NULL";
if (isset($_POST['rueckfahrt'])) {
  $colname9_R1 = $_POST['rueckfahrt'];
}
$colname10_R1 = "NULL";
if (isset($_POST['rueckfahrtladeflaeche'])) {
  $colname10_R1 = $_POST['rueckfahrtladeflaeche'];
}
$colname11_R1 = "NULL";
if (isset($_POST['marke'])) {
  $colname11_R1 = $_POST['marke'];
}
$colname12_R1 = "NULL";
if (isset($_POST['model'])) {
  $colname12_R1 = $_POST['model'];
}
$colname13_R1 = "NULL";
if (isset($_POST['laderaumhoehe'])) {
  $colname13_R1 = $_POST['laderaumhoehe'];
}
$colname14_R1 = "NULL";
if (isset($_POST['laderaumbreite'])) {
  $colname14_R1 = $_POST['laderaumbreite'];
}
$colname15_R1 = "NULL";
if (isset($_POST['laderaumlaenge'])) {
  $colname15_R1 = $_POST['laderaumlaenge'];
}
$colname16_R1 = "NULL";
if (isset($_POST['laderaumvolumen'])) {
  $colname16_R1 = $_POST['laderaumvolumen'];
}
$colname17_R1 = "NULL";
if (isset($_POST['treibstoff'])) {
  $colname17_R1 = $_POST['treibstoff'];
}
$colname18_R1 = "NULL";
if (isset($_POST['getriebe'])) {
  $colname18_R1 = $_POST['getriebe'];
}
$queryString_R1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_R1") == false && 
        stristr($param, "totalRows_R1") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_R1 = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_R1 = sprintf("&totalRows_R1=%d%s", $totalRows_R1, $queryString_R1);
?>

[b]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>mit-umzug-gelegenheit.de</title>
<script src="Scripts/swfobject_modified.js" type="text/javascript"></script>
<script type="text/JavaScript">
<!--


function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_nbGroup(event, grpName) { //v6.0
  var i,img,nbArr,args=MM_nbGroup.arguments;
  if (event == "init" && args.length > 2) {
    if ((img = MM_findObj(args[2])) != null && !img.MM_init) {
      img.MM_init = true; img.MM_up = args[3]; img.MM_dn = img.src;
      if ((nbArr = document[grpName]) == null) nbArr = document[grpName] = new Array();
      nbArr[nbArr.length] = img;
      for (i=4; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {
        if (!img.MM_up) img.MM_up = img.src;
        img.src = img.MM_dn = args[i+1];
        nbArr[nbArr.length] = img;
    } }
  } else if (event == "over") {
    document.MM_nbOver = nbArr = new Array();
    for (i=1; i < args.length-1; i+=3) if ((img = MM_findObj(args[i])) != null) {
      if (!img.MM_up) img.MM_up = img.src;
      img.src = (img.MM_dn && args[i+2]) ? args[i+2] : ((args[i+1])? args[i+1] : img.MM_up);
      nbArr[nbArr.length] = img;
    }
  } else if (event == "out" ) {
    for (i=0; i < document.MM_nbOver.length; i++) {
      img = document.MM_nbOver[i]; img.src = (img.MM_dn) ? img.MM_dn : img.MM_up; }
  } else if (event == "down") {
    nbArr = document[grpName];
    if (nbArr)
      for (i=0; i < nbArr.length; i++) { img=nbArr[i]; img.src = img.MM_up; img.MM_dn = 0; }
    document[grpName] = nbArr = new Array();
    for (i=2; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {
      if (!img.MM_up) img.MM_up = img.src;
      img.src = img.MM_dn = (args[i+1])? args[i+1] : img.MM_up;
      nbArr[nbArr.length] = img;
  } }
}
//-->
</script>
<style type="text/css">
<!--
@import url("schriftangaben1111111111.css");
body {
    margin-top: 50px;
}
.Schriftangaben {
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-size: 10px;
    font-weight: bold;
    background-position: right center;
}
.Schriftstil {    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-size: 10px;
    font-weight: bold;
}
#Layer1 {
    position:absolute;
    left:2px;
    top:1px;
    width:1692px;
    height:4821px;
    z-index:1;
    visibility: hidden;
}
-->
</style>
<script type="text/javascript">
<!--
function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
<link href="Seiten/Seiten/Stylesheet Formular.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
@import url("Staedtenamen.css");
-->
</style>
<link href="Staedtenamen.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.Stil1 {color: #990000}
-->
</style>
</head>
<body onload="MM_preloadImages('Bilder/Home 3.png','Bilder/Home 4.png','Bilder/Mit-Umzug-Angebote 3.png','Bilder/Mit-Umzug-Angebote 4.png','Bilder/Eingabe 3.png','Bilder/Eingabe 2.png','Bilder/Eingabe 4.png','Bilder/MeinKonto 3.png','Bilder/MeinKonto 4.png','Bilder/Hilfe 3.png','Bilder/Hilfe 2.png','Bilder/Hilfe 4.png','Bilder/Mit-Umzug-Angebote 2.png','Bilder/MeinKonto 2.png','Bilder/Home 2.png')" tracingsrc="1home.php" tracingopacity="100" tracingx="0" tracingy="3458793">
<div id="Layer1"></div>
<table width="859" border="0" cellspacing="0">
  <tr> </tr>
</table>
<table width="857" border="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr>
    <td width="125">&nbsp;</td>
    <td width="125">&nbsp;</td>
    <td width="125">&nbsp;</td>
    <td width="356" align="right" valign="bottom" class="Schriftangaben"><a href="8Impressum.php" class="schriftangaben11111111111">impressum</a></td>
    <td width="81" align="right" valign="bottom" class="Schriftangaben"><a href="9RegistrierungEinfach.php" class="schriftangaben11111111111">registrierung</a></td>
    <td width="33" align="right" valign="bottom" class="schriftangaben11111111111"><a href="6Meinkontologin.php" class="schriftangaben11111111111">login</a></td>
  </tr>
</table>
<table width="4293" border="0" cellpadding="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr>
    <td width="54" height="160" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>
    <td valign="top"><img src="Bilder/Mit-Umzug-Gelegenheit Hauptbild.png" width="805" height="160" vspace="5" /></td>
    <td width="53" valign="bottom">&nbsp;</td>
    <td width="4" valign="bottom">&nbsp;</td>
    <td width="65"></td>
  </tr>
  <tr>
    <td width="54" height="2"></td>
    <td width="4117"></td>
    <td></td>
    <td></td>
    <td></td>
  </tr>
  <tr>
    <td width="54" height="96"></td>
    <td colspan="3" valign="top"><table border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td><a href="1home.php" target="_top" onclick="MM_nbGroup('down','group1','Home1','Bilder/Home 3.png',1)" onmouseover="MM_nbGroup('over','Home1','Bilder/Home 2.png','Bilder/Home 4.png',1)" onmouseout="MM_nbGroup('out')"><img src="Bilder/Home 1.png" alt="" name="Home1" border="0" id="Home1" onload="" /></a></td>
        <td><a href="AngeboteoderGesuche1.php" target="_top" onclick="MM_nbGroup('down','group1','MitUmzugAngebote1','Bilder/Mit-Umzug-Angebote 3.png',1)" onmouseover="MM_nbGroup('over','MitUmzugAngebote1','Bilder/Mit-Umzug-Angebote 2.png','Bilder/Mit-Umzug-Angebote 4.png',1)" onmouseout="MM_nbGroup('out')"><img src="Bilder/Mit-Umzug-Angebote 1.png" alt="" name="MitUmzugAngebote1" hspace="5" border="0" id="MitUmzugAngebote1" onload="" /></a></td>
        <td><a href="6Meinkontologin.php" target="_top" onclick="MM_nbGroup('down','group1','Eingabe1','Bilder/Eingabe 3.png',1)" onmouseover="MM_nbGroup('over','Eingabe1','Bilder/Eingabe 2.png','Bilder/Eingabe 4.png',1)" onmouseout="MM_nbGroup('out')"><img src="Bilder/Eingabe 1.png" alt="" name="Eingabe1" hspace="5" border="0" id="Eingabe1" onload="" /></a></td>
        <td><a href="6Meinkontologin.php" target="_top" onclick="MM_nbGroup('down','group1','MeinKonto1','Bilder/MeinKonto 3.png',1)" onmouseover="MM_nbGroup('over','MeinKonto1','Bilder/MeinKonto 2.png','Bilder/MeinKonto 4.png',1)" onmouseout="MM_nbGroup('out')"><img src="Bilder/MeinKonto 1.png" alt="" name="MeinKonto1" hspace="5" border="0" id="MeinKonto1" onload="" /></a></td>
        <td><a href="7hilfe.php" target="_top" onclick="MM_nbGroup('down','group1','Hilfe1','Bilder/Hilfe 3.png',1)" onmouseover="MM_nbGroup('over','Hilfe1','Bilder/Hilfe 2.png','Bilder/Hilfe 4.png',1)" onmouseout="MM_nbGroup('out')"><img src="Bilder/Hilfe 1.png" alt="" name="Hilfe1" border="0" id="Hilfe1" onload="" /></a></td>
      </tr>
    </table></td>
    <td></td>
  </tr>
  <tr>
    <td width="54" height="39"></td>
    <td align="right" valign="bottom"><!--DWLayoutEmptyCell-->&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td></td>
  </tr>
  <tr>
    <td width="54" height="103"></td>
    <td valign="top"><img src="Bilder/Ihre Suchergebnisse 2.png" width="4115" height="50" />
      <table width="4116" height="102" border="0" cellspacing="0" class="schaltfl&auml;che">
        <tr align="center" valign="middle" bordercolor="#FFFFFF" bgcolor="#ECE9D8">
          <th width="2" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="107" height="33" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">abfahrtsort</span></th>
          <th width="2" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="80" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">zielort</span></th>
          <th width="2" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="68" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">datum</span></th>
          <th width="2" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="71" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">uhrzeit</span></th>
          <th width="2" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="166" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">ladefl&auml;che hinfahrt</span></th>
          <th width="2" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="133" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">hilfe ein ausladen</span></th>
          <th width="2" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="97" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">r&uuml;ckfahrt</span></th>
          <th width="2" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="167" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">ladefl&auml;che r&uuml;ckfahrt</span></th>
          <th width="2" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="175" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">beschreibung</span></th>
          <th width="2" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="65" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">preis</span></th>
          <th width="2" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="71" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">marke</span></th>
          <th width="2" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="134" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">model</span></th>
          <th width="1" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="248" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">laderaumh&ouml;he</span></th>
          <th width="1" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="185" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">laderaumbreite</span></th>
          <th width="1" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="130" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">laderauml&auml;nge</span></th>
          <th width="1" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="308" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">laderaumvolumen</span></th>
          <th width="1" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="158" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">treibstoff</span></th>
          <th width="1" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="82" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">getriebe</span></th>
          <th width="1" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="133" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">tempo</span></th>
          <th width="1" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="113" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">name</span></th>
          <th width="1" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="80" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">mail</span></th>
          <th width="1" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="90" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">handy</span></th>
          <th width="1" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
          <th width="111" bgcolor="#EAEBD0" scope="col"><span class="Schriftangaben">tel</span></th>
          <th width="2" bgcolor="#EAEBD0" scope="col">&nbsp;</th>
        </tr>
        <?php do { ?>
          <tr align="center" valign="middle" bordercolor="#EAEBD0">
            <td width="2" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td height="52" bordercolor="#EAEBD0"><?php echo $row_R1['abfahrtsort']; ?></td>
            <td width="2" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['zielort']; ?></td>
            <td width="2" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td width="68" bordercolor="#EAEBD0"><?php echo $row_R1['tag']; ?>.<?php echo $row_R1['monat']; ?>.<?php echo $row_R1['jahr']; ?></td>
            <td width="2" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td width="71" bordercolor="#EAEBD0"><p><?php echo $row_R1['stunde']; ?>:<?php echo $row_R1['minute']; ?></p></td>
            <td width="2" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['hinfahrtladeflaeche']; ?></td>
            <td width="2" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['hilfeeinausladen']; ?></td>
            <td width="2" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['rueckfahrt']; ?></td>
            <td width="2" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['rueckfahrtladeflaeche']; ?></td>
            <td width="2" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['beschreibung']; ?></td>
            <td width="2" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['preis']; ?></td>
            <td width="2" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['marke']; ?></td>
            <td width="2" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['model']; ?></td>
            <td width="1" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['laderaumhoehe']; ?></td>
            <td width="1" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['laderaumbreite']; ?></td>
            <td width="1" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['laderaumlaenge']; ?></td>
            <td width="1" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['laderaumvolumen']; ?></td>
            <td width="1" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['treibstoff']; ?></td>
            <td width="1" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['getriebe']; ?></td>
            <td width="1" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['tempo']; ?></td>
            <td width="1" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['nutzername']; ?></td>
            <td width="1" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td width="80" bordercolor="#EAEBD0"><?php echo $row_R1['mail']; ?></td>
            <td width="1" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['handy']; ?></td>
            <td width="1" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td bordercolor="#EAEBD0"><?php echo $row_R1['tel']; ?></td>
            <td width="2" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
          </tr>
          <tr align="center" valign="middle" bordercolor="#EAEBD0" bgcolor="#EAEBD0">
            <td width="2" height="17" bordercolor="#EAEBD0" bgcolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td width="80" height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
            <td height="17" bordercolor="#EAEBD0">&nbsp;</td>
          </tr>
          <?php } while ($row_R1 = mysql_fetch_assoc($R1)); ?>
      </table></td>
    <td rowspan="2" align="left" valign="top">&nbsp;</td>
    <td rowspan="2" align="left" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>
    <td></td>
  </tr>
  <tr>
    <td width="54" height="388" rowspan="2"></td>
    <td rowspan="2" align="left" valign="top" bordercolor="#EAEBD0"></td>
    <td rowspan="2"></td>
  </tr>
  <tr>
    <td height="590">&nbsp;</td>
    <td align="left" valign="top">&nbsp;</td>
  </tr>
  <tr>
    <td width="54" height="19"></td>
    <td align="left" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>
    <td>&nbsp;</td>
    <td align="left" valign="top">&nbsp;</td>
    <td></td>
  </tr>
  <tr>
    <td width="54" height="19"></td>
    <td align="left" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>
    <td>&nbsp;</td>
    <td align="left" valign="top">&nbsp;</td>
    <td></td>
  </tr>
  <tr>
    <td width="54" height="19"></td>
    <td align="left" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td></td>
  </tr>
  <tr>
    <td width="54" height="19"></td>
    <td align="left" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td></td>
  </tr>
</table>
<script type="text/javascript">
<!--
swfobject.registerObject("mehr hilfe");
//-->
</script>
</body>
</html>
<?php
mysql_free_result($R1);
?>

Fehler

SQL-Befehl:

$query_limit_R1 = sprintf(
"%s LIMIT %d, %d", $query_R1, $startRow_R1, $maxRows_R1
)

MySQL meldet:
#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 '$query_limit_R1 = sprintf("%s LIMIT %d, %d", $query_R1, $startRow_R1, $maxRows_R' at line 1

Zitat von Jörg

Diese SQL-Query:

SELECT * FROM Eingabe WHERE 1 ORDER BY Eingabe.monat, Eingabe.tag, Eingabe.stunde, Eingabe.`minute` LIMIT 0, 20

Zitat von Jörg

Dann ist die Query korrekt und der Fehler liegt woanders. In dem HTML-Teil konnte ich aber auch keinen Fehler entdecken.

Du hast bei dem Test in Beitrag 59 die Ergebnisseite über die Suchseite aufgerufen (so wie vorher, als keien Ergebnisse angezeigt wurden)?

 AND treibstoff = 'Null' AND getriebe = 'NULL'