Hallo User,
habe folgendes Problem:
Will dynamisch mit unterschiedlichen Textfelder und Drop&Downfelder suchen hat auch soweit gut funktioniert bis zu dem Zeitpunkt wenn ich 4 Felder mit dem Befehl BETWEEN abfrage. Hier ist es LengthPart und WidthPart mit jeweils zwei Eingabe Felder welche Teile aus der Datenbank finden soll die eine Länge von z.B. von 60mm und zwischen 100mm und/oder/nicht die Breite von z.B. 20mm und zwischen 40mm.
Anbei der gesamte Code ist zwar etwas lang aber ich finde es ist besser.
Ich denke es liegt an SQL Abfrage oder an den ISSET Anweisungen weis aber nicht wie ich es ändern soll, dass es funktioniert.
Hoffe ihr könnt mir helfen
Habe das Thema bei Dreamworker gepostet habe dort aber das Thema geschlossen, da mir dort niemand helfen konnte (es ist daher kein Crossposting).
PHP-Code:<?php require_once('Connections/Verbindung.php'); ?>
<?php
$mysearchkey = $_POST['mysearch'];
$mysearchkey1 = $_POST['mysearch1'];
.
.
.
$mysearchkey16 = $_POST['mysearch16'];
$mysearchkey17 = $_POST['mysearch17'];
$mysearchkey18 = $_POST['mysearch18'];
$mysearchkey19 = $_POST['mysearch19'];
$mysearchkey20 = $_POST['mysearch20'];
$mysearchkey21 = $_POST['mysearch21'];
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;
}
}
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_Search = "SELECT * FROM tblpsrmonth WHERE ((PartNo LIKE '%$mysearchkey%') AND (SupplierName Like '%$mysearchkey1%') AND (Plant Like '%$mysearchkey2%') AND (Region Like '%$mysearchkey3%') AND (ProductLine Like '%$mysearchkey4%') AND (ProductGroup Like '%$mysearchkey5%') AND (Geometry Like '%$mysearchkey6%') AND (LabelCategory Like '%$mysearchkey7%') AND (LabelMaterial Like '%$mysearchkey8%') AND (TestSpec Like '%$mysearchkey9%') AND (DeliverySpec Like '%$mysearchkey10%') AND (MatSpec Like '%$mysearchkey11%') AND (MatCodeManuf Like '%$mysearchkey12%') AND (Adhesive Like '%$mysearchkey13%') AND (ColorRal Like '%$mysearchkey14%') AND (ColorPantone Like '%$mysearchkey15%') AND (Warntext Like '%$mysearchkey16%') AND (SupplierLcc Like '%$mysearchkey17%') AND (LengthPart Between '$mysearchkey18' AND '$mysearchkey19') AND (LengthPart Between '$mysearchkey20' AND '$mysearchkey21'))";
$rs_Search = mysql_query($query_rs_Search, $Verbindung) or die(mysql_error());
$row_rs_Search = mysql_fetch_assoc($rs_Search);
$totalRows_rs_Search = mysql_num_rows($rs_Search);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_Plant = "SELECT * FROM tblplant ORDER BY Plant";
$rs_Plant = mysql_query($query_rs_Plant, $Verbindung) or die(mysql_error());
$row_rs_Plant = mysql_fetch_assoc($rs_Plant);
$totalRows_rs_Plant = mysql_num_rows($rs_Plant);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_Supplier = "SELECT * FROM tblsupplier ORDER BY SupplierName";
$rs_Supplier = mysql_query($query_rs_Supplier, $Verbindung) or die(mysql_error());
$row_rs_Supplier = mysql_fetch_assoc($rs_Supplier);
$totalRows_rs_Supplier = mysql_num_rows($rs_Supplier);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_Region = "SELECT * FROM tblregion";
$rs_Region = mysql_query($query_rs_Region, $Verbindung) or die(mysql_error());
$row_rs_Region = mysql_fetch_assoc($rs_Region);
$totalRows_rs_Region = mysql_num_rows($rs_Region);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_ProductLine = "SELECT * FROM tblproductline";
$rs_ProductLine = mysql_query($query_rs_ProductLine, $Verbindung) or die(mysql_error());
$row_rs_ProductLine = mysql_fetch_assoc($rs_ProductLine);
$totalRows_rs_ProductLine = mysql_num_rows($rs_ProductLine);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_ProductGroup = "SELECT * FROM tblproductgroup";
$rs_ProductGroup = mysql_query($query_rs_ProductGroup, $Verbindung) or die(mysql_error());
$row_rs_ProductGroup = mysql_fetch_assoc($rs_ProductGroup);
$totalRows_rs_ProductGroup = mysql_num_rows($rs_ProductGroup);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_Geometry = "SELECT * FROM tblgeometry ORDER BY Geometry";
$rs_Geometry = mysql_query($query_rs_Geometry, $Verbindung) or die(mysql_error());
$row_rs_Geometry = mysql_fetch_assoc($rs_Geometry);
$totalRows_rs_Geometry = mysql_num_rows($rs_Geometry);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_LabelCategory = "SELECT * FROM tbllabelcategory ORDER BY LabelCategory";
$rs_LabelCategory = mysql_query($query_rs_LabelCategory, $Verbindung) or die(mysql_error());
$row_rs_LabelCategory = mysql_fetch_assoc($rs_LabelCategory);
$totalRows_rs_LabelCategory = mysql_num_rows($rs_LabelCategory);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_LabelMaterial = "SELECT * FROM tbllabelmaterial ORDER BY LabelMaterial";
$rs_LabelMaterial = mysql_query($query_rs_LabelMaterial, $Verbindung) or die(mysql_error());
$row_rs_LabelMaterial = mysql_fetch_assoc($rs_LabelMaterial);
$totalRows_rs_LabelMaterial = mysql_num_rows($rs_LabelMaterial);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_TestSpec = "SELECT * FROM tbltestspec ORDER BY TestSpec";
$rs_TestSpec = mysql_query($query_rs_TestSpec, $Verbindung) or die(mysql_error());
$row_rs_TestSpec = mysql_fetch_assoc($rs_TestSpec);
$totalRows_rs_TestSpec = mysql_num_rows($rs_TestSpec);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_DeliverySpec = "SELECT * FROM tbldeliveryspec ORDER BY DeliverySpec";
$rs_DeliverySpec = mysql_query($query_rs_DeliverySpec, $Verbindung) or die(mysql_error());
$row_rs_DeliverySpec = mysql_fetch_assoc($rs_DeliverySpec);
$totalRows_rs_DeliverySpec = mysql_num_rows($rs_DeliverySpec);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_MatSpec = "SELECT * FROM tblmaterialspec ORDER BY MatSpec";
$rs_MatSpec = mysql_query($query_rs_MatSpec, $Verbindung) or die(mysql_error());
$row_rs_MatSpec = mysql_fetch_assoc($rs_MatSpec);
$totalRows_rs_MatSpec = mysql_num_rows($rs_MatSpec);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_MatCodeManuf = "SELECT * FROM tblmatcodemanuf";
$rs_MatCodeManuf = mysql_query($query_rs_MatCodeManuf, $Verbindung) or die(mysql_error());
$row_rs_MatCodeManuf = mysql_fetch_assoc($rs_MatCodeManuf);
$totalRows_rs_MatCodeManuf = mysql_num_rows($rs_MatCodeManuf);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_Adhesive = "SELECT * FROM tbladhesive";
$rs_Adhesive = mysql_query($query_rs_Adhesive, $Verbindung) or die(mysql_error());
$row_rs_Adhesive = mysql_fetch_assoc($rs_Adhesive);
$totalRows_rs_Adhesive = mysql_num_rows($rs_Adhesive);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_ColorRal = "SELECT * FROM tblcolorral";
$rs_ColorRal = mysql_query($query_rs_ColorRal, $Verbindung) or die(mysql_error());
$row_rs_ColorRal = mysql_fetch_assoc($rs_ColorRal);
$totalRows_rs_ColorRal = mysql_num_rows($rs_ColorRal);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_Pantone = "SELECT * FROM tblcolorpantone";
$rs_Pantone = mysql_query($query_rs_Pantone, $Verbindung) or die(mysql_error());
$row_rs_Pantone = mysql_fetch_assoc($rs_Pantone);
$totalRows_rs_Pantone = mysql_num_rows($rs_Pantone);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_Warntext = "SELECT * FROM tblwarntext";
$rs_Warntext = mysql_query($query_rs_Warntext, $Verbindung) or die(mysql_error());
$row_rs_Warntext = mysql_fetch_assoc($rs_Warntext);
$totalRows_rs_Warntext = mysql_num_rows($rs_Warntext);
mysql_select_db($database_Verbindung, $Verbindung);
$query_rs_SupplierLcc = "SELECT * FROM tblsupplierlcc";
$rs_SupplierLcc = mysql_query($query_rs_SupplierLcc, $Verbindung) or die(mysql_error());
$row_rs_SupplierLcc = mysql_fetch_assoc($rs_SupplierLcc);
$totalRows_rs_SupplierLcc = mysql_num_rows($rs_SupplierLcc);
?>
<!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=utf-8" />
<title>Unbenanntes Dokument</title>
<style type="text/css">
<!--
.Schrift {
font-family: Verdana, Geneva, sans-serif;
font-size: 9px;
font-style: normal;
background-color: #FFC;
}
.Schrift_green {
font-family: Verdana, Geneva, sans-serif;
font-size: 9px;
background-color: #DFDFDF;
}
-->
</style>
</head>
<body>
<form ID="myform" name="myform" method="post" action="<?php htmlspecialchars($_SERVER['PHP_SELF']); ?>"><br />
<table width="" border="0" cellpadding="0">
<tr>
<td width="69" class="Schrift">Partno</td>
<td width="144"><input name="mysearch" type="text" class="Schrift" id="mysearch" /></td>
<td width="77" class="Schrift">Geometry</td>
<td width="163"><label for="mysearch6"></label>
<select name="mysearch6" class="Schrift" id="mysearch6">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_Geometry['Geometry']?>"><?php echo $row_rs_Geometry['Geometry']?></option>
<?php
} while ($row_rs_Geometry = mysql_fetch_assoc($rs_Geometry));
$rows = mysql_num_rows($rs_Geometry);
if($rows > 0) {
mysql_data_seek($rs_Geometry, 0);
$row_rs_Geometry = mysql_fetch_assoc($rs_Geometry);
}
?>
</select></td>
<td width="77" class="Schrift">Mat.-Code</td>
<td width="147"><label for="mysearch12"></label>
<select name="mysearch12" class="Schrift" id="mysearch12">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_MatCodeManuf['MatCodeManuf']?>"><?php echo $row_rs_MatCodeManuf['MatCodeManuf']?></option>
<?php
} while ($row_rs_MatCodeManuf = mysql_fetch_assoc($rs_MatCodeManuf));
$rows = mysql_num_rows($rs_MatCodeManuf);
if($rows > 0) {
mysql_data_seek($rs_MatCodeManuf, 0);
$row_rs_MatCodeManuf = mysql_fetch_assoc($rs_MatCodeManuf);
}
?>
</select></td>
<td width="80" class="Schrift">Length from</td>
<td width="144"><label for="mysearch18"></label>
<input name="mysearch18" type="text" class="Schrift" id="mysearch18" /></td>
<td width="68" class="Schrift">Length to</td>
<td width="164"><label for="mysearch19"></label>
<input name="mysearch19" type="text" class="Schrift" id="mysearch19" /></td>
</tr>
<tr>
<td class="Schrift">Supplier</td>
<td><label for="mysearch1"></label>
<label for="mysearch1"></label>
<select name="mysearch1" class="Schrift" id="mysearch1">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_Supplier['SupplierName']?>"><?php echo $row_rs_Supplier['SupplierName']?></option>
<?php
} while ($row_rs_Supplier = mysql_fetch_assoc($rs_Supplier));
$rows = mysql_num_rows($rs_Supplier);
if($rows > 0) {
mysql_data_seek($rs_Supplier, 0);
$row_rs_Supplier = mysql_fetch_assoc($rs_Supplier);
}
?>
</select></td>
<td class="Schrift">Category</td>
<td><label for="mysearch7"></label>
<select name="mysearch7" class="Schrift" id="mysearch7">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_LabelCategory['LabelCategory']?>"><?php echo $row_rs_LabelCategory['LabelCategory']?></option>
<?php
} while ($row_rs_LabelCategory = mysql_fetch_assoc($rs_LabelCategory));
$rows = mysql_num_rows($rs_LabelCategory);
if($rows > 0) {
mysql_data_seek($rs_LabelCategory, 0);
$row_rs_LabelCategory = mysql_fetch_assoc($rs_LabelCategory);
}
?>
</select></td>
<td class="Schrift">Adhesive</td>
<td><label for="mysearch13"></label>
<select name="mysearch13" class="Schrift" id="mysearch13">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_Adhesive['Adhesive']?>"><?php echo $row_rs_Adhesive['Adhesive']?></option>
<?php
} while ($row_rs_Adhesive = mysql_fetch_assoc($rs_Adhesive));
$rows = mysql_num_rows($rs_Adhesive);
if($rows > 0) {
mysql_data_seek($rs_Adhesive, 0);
$row_rs_Adhesive = mysql_fetch_assoc($rs_Adhesive);
}
?>
</select></td>
<td class="Schrift">Width from</td>
<td><label for="mysearch20"></label>
<input name="mysearch20" type="text" class="Schrift" id="mysearch20" /></td>
<td class="Schrift">Width to</td>
<td><label for="mysearch21"></label>
<input name="mysearch21" type="text" class="Schrift" id="mysearch21" /></td>
</tr>
<tr>
<td class="Schrift">Plant</td>
<td><label for="mysearch2"></label> <select name="mysearch2" class="Schrift" id="mysearch2">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_Plant['Plant']?>"><?php echo $row_rs_Plant['Plant']?></option>
<?php
} while ($row_rs_Plant = mysql_fetch_assoc($rs_Plant));
$rows = mysql_num_rows($rs_Plant);
if($rows > 0) {
mysql_data_seek($rs_Plant, 0);
$row_rs_Plant = mysql_fetch_assoc($rs_Plant);
}
?>
</select> <label for="mysearch2"></label></td>
<td class="Schrift">Material</td>
<td><label for="mysearch8"></label>
<select name="mysearch8" class="Schrift" id="mysearch8">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_LabelMaterial['LabelMaterial']?>"><?php echo $row_rs_LabelMaterial['LabelMaterial']?></option>
<?php
} while ($row_rs_LabelMaterial = mysql_fetch_assoc($rs_LabelMaterial));
$rows = mysql_num_rows($rs_LabelMaterial);
if($rows > 0) {
mysql_data_seek($rs_LabelMaterial, 0);
$row_rs_LabelMaterial = mysql_fetch_assoc($rs_LabelMaterial);
}
?>
</select></td>
<td class="Schrift">Color RAL</td>
<td><label for="mysearch14"></label>
<select name="mysearch14" class="Schrift" id="mysearch14">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_ColorRal['ColorRal']?>"><?php echo $row_rs_ColorRal['ColorRal']?></option>
<?php
} while ($row_rs_ColorRal = mysql_fetch_assoc($rs_ColorRal));
$rows = mysql_num_rows($rs_ColorRal);
if($rows > 0) {
mysql_data_seek($rs_ColorRal, 0);
$row_rs_ColorRal = mysql_fetch_assoc($rs_ColorRal);
}
?>
</select></td>
<td class="Schrift">Thickness from</td>
<td> </td>
<td class="Schrift">Thickness to</td>
<td> </td>
</tr>
<tr>
<td class="Schrift">Region</td>
<td><label for="mysearch3"></label>
<select name="mysearch3" class="Schrift" id="mysearch3">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_Region['Region']?>"><?php echo $row_rs_Region['Region']?></option>
<?php
} while ($row_rs_Region = mysql_fetch_assoc($rs_Region));
$rows = mysql_num_rows($rs_Region);
if($rows > 0) {
mysql_data_seek($rs_Region, 0);
$row_rs_Region = mysql_fetch_assoc($rs_Region);
}
?>
</select></td>
<td class="Schrift">Testspec.</td>
<td><label for="mysearch9"></label>
<select name="mysearch9" class="Schrift" id="mysearch9">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_TestSpec['TestSpec']?>"><?php echo $row_rs_TestSpec['TestSpec']?></option>
<?php
} while ($row_rs_TestSpec = mysql_fetch_assoc($rs_TestSpec));
$rows = mysql_num_rows($rs_TestSpec);
if($rows > 0) {
mysql_data_seek($rs_TestSpec, 0);
$row_rs_TestSpec = mysql_fetch_assoc($rs_TestSpec);
}
?>
</select></td>
<td class="Schrift">Color Pantone</td>
<td><label for="mysearch15"></label>
<select name="mysearch15" class="Schrift" id="mysearch15">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_Pantone['ColorPantone']?>"><?php echo $row_rs_Pantone['ColorPantone']?></option>
<?php
} while ($row_rs_Pantone = mysql_fetch_assoc($rs_Pantone));
$rows = mysql_num_rows($rs_Pantone);
if($rows > 0) {
mysql_data_seek($rs_Pantone, 0);
$row_rs_Pantone = mysql_fetch_assoc($rs_Pantone);
}
?>
</select></td>
<td class="Schrift">Spend from</td>
<td> </td>
<td class="Schrift">Spend to</td>
<td> </td>
</tr>
<tr>
<td class="Schrift">Productline</td>
<td><label for="mysearch4"></label>
<select name="mysearch4" class="Schrift" id="mysearch4">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_ProductLine['ProductLine']?>"><?php echo $row_rs_ProductLine['ProductLine']?></option>
<?php
} while ($row_rs_ProductLine = mysql_fetch_assoc($rs_ProductLine));
$rows = mysql_num_rows($rs_ProductLine);
if($rows > 0) {
mysql_data_seek($rs_ProductLine, 0);
$row_rs_ProductLine = mysql_fetch_assoc($rs_ProductLine);
}
?>
</select></td>
<td class="Schrift">Deliveryspec.</td>
<td><label for="mysearch10"></label>
<select name="mysearch10" class="Schrift" id="mysearch10">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_DeliverySpec['DeliverySpec']?>"><?php echo $row_rs_DeliverySpec['DeliverySpec']?></option>
<?php
} while ($row_rs_DeliverySpec = mysql_fetch_assoc($rs_DeliverySpec));
$rows = mysql_num_rows($rs_DeliverySpec);
if($rows > 0) {
mysql_data_seek($rs_DeliverySpec, 0);
$row_rs_DeliverySpec = mysql_fetch_assoc($rs_DeliverySpec);
}
?>
</select></td>
<td class="Schrift">Warntext</td>
<td><label for="mysearch16"></label>
<select name="mysearch16" class="Schrift" id="mysearch16">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_Warntext['Warntext']?>"><?php echo $row_rs_Warntext['Warntext']?></option>
<?php
} while ($row_rs_Warntext = mysql_fetch_assoc($rs_Warntext));
$rows = mysql_num_rows($rs_Warntext);
if($rows > 0) {
mysql_data_seek($rs_Warntext, 0);
$row_rs_Warntext = mysql_fetch_assoc($rs_Warntext);
}
?>
</select></td>
<td class="Schrift">Volume from</td>
<td> </td>
<td class="Schrift">Volume to</td>
<td> </td>
</tr>
<tr>
<td class="Schrift">ProductGroup</td>
<td><label for="mysearch5"></label>
<select name="mysearch5" class="Schrift" id="mysearch5">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_ProductGroup['ProductGroup']?>"><?php echo $row_rs_ProductGroup['ProductGroup']?></option>
<?php
} while ($row_rs_ProductGroup = mysql_fetch_assoc($rs_ProductGroup));
$rows = mysql_num_rows($rs_ProductGroup);
if($rows > 0) {
mysql_data_seek($rs_ProductGroup, 0);
$row_rs_ProductGroup = mysql_fetch_assoc($rs_ProductGroup);
}
?>
</select></td>
<td class="Schrift">Materialspec.</td>
<td><label for="mysearch11"></label>
<select name="mysearch11" class="Schrift" id="mysearch11">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_MatSpec['MatSpec']?>"><?php echo $row_rs_MatSpec['MatSpec']?></option>
<?php
} while ($row_rs_MatSpec = mysql_fetch_assoc($rs_MatSpec));
$rows = mysql_num_rows($rs_MatSpec);
if($rows > 0) {
mysql_data_seek($rs_MatSpec, 0);
$row_rs_MatSpec = mysql_fetch_assoc($rs_MatSpec);
}
?>
</select></td>
<td class="Schrift">LCC</td>
<td><label for="mysearch17"></label>
<select name="mysearch17" class="Schrift" id="mysearch17">
<option value="">Please Choose</option>
<?php
do {
?>
<option value="<?php echo $row_rs_SupplierLcc['SupplierLcc']?>"><?php echo $row_rs_SupplierLcc['SupplierLcc']?></option>
<?php
} while ($row_rs_SupplierLcc = mysql_fetch_assoc($rs_SupplierLcc));
$rows = mysql_num_rows($rs_SupplierLcc);
if($rows > 0) {
mysql_data_seek($rs_SupplierLcc, 0);
$row_rs_SupplierLcc = mysql_fetch_assoc($rs_SupplierLcc);
}
?>
</select></td>
<td class="Schrift">Currency Code</td>
<td> </td>
<td class="Schrift">Year</td>
<td> </td>
</tr>
</table>
<p>
<input type="submit" name="button" id="button" value="Suchen" />
</p>
</form>
<hr />
<?php
if(isset($_POST['mysearchkey']) && $_POST['mysearchkey'] != "" || isset($_POST['mysearchkey1']) && $_POST['mysearchkey1'] != "" || isset($_POST['mysearchkey2']) && $_POST['mysearchkey2'] != "" || isset($_POST['mysearchkey3']) && $_POST['mysearchkey3'] != "" || isset($_POST['mysearchkey4']) && $_POST['mysearchkey4'] != "" || isset($_POST['mysearchkey5']) && $_POST['mysearchkey5'] != "" || isset($_POST['mysearchkey6']) && $_POST['mysearchkey6'] != "" || isset($_POST['mysearchkey7']) && $_POST['mysearchkey7'] != "" || isset($_POST['mysearchkey8']) && $_POST['mysearchkey8'] != "" || isset($_POST['mysearchkey9']) && $_POST['mysearchkey9'] != "" || isset($_POST['mysearchkey10']) && $_POST['mysearchkey10'] != "" || isset($_POST['mysearchkey11']) && $_POST['mysearchkey11'] != "" || isset($_POST['mysearchkey12']) && $_POST['mysearchkey12'] != "" || isset($_POST['mysearchkey13']) && $_POST['mysearchkey13'] != "" || isset($_POST['mysearchkey14']) && $_POST['mysearchkey14'] != "" || isset($_POST['mysearchkey15']) && $_POST['mysearchkey15'] != "" || isset($_POST['mysearchkey16']) && $_POST['mysearchkey16'] != "" || isset($_POST['mysearchkey17']) && $_POST['mysearchkey17'] != "" || isset($_POST['mysearchkey18']) && $_POST['mysearchkey18'] != "" || isset($_POST['mysearchkey19']) && $_POST['mysearchkey19'] != "" || isset($_POST['mysearchkey20']) && $_POST['mysearchkey20'] != "" || isset($_POST['mysearchkey21']) && $_POST['mysearchkey21'] != "")
{
}
elseif(isset($_POST['mysearch']) || isset($_POST['mysearch1']) || isset($_POST['mysearch2']) || isset($_POST['mysearch3']) ||
.
.
.
isset($_POST['mysearch12']) || isset($_POST['mysearch13']) || isset($_POST['mysearch14']) || isset($_POST['mysearch15']) || isset($_POST['mysearch16']) || isset($_POST['mysearch17']) || isset($_POST['mysearch18']) || isset($_POST['mysearch19']) || isset($_POST['mysearch20']) || isset($_POST['mysearch21']))
{
do {
?>
<table width="300" style="table-layout:fixed" class="Schrift" id="Data">
.
.
.
.
.
.
</tr>
</table>
<?php } while ($row_rs_Search = mysql_fetch_assoc($rs_Search)); ?>
<?php
}
?>
</body>
</html>
<?php
mysql_free_result($rs_Search);
mysql_free_result($rs_Plant);
mysql_free_result($rs_Supplier);
mysql_free_result($rs_Region);
mysql_free_result($rs_ProductLine);
mysql_free_result($rs_ProductGroup);
mysql_free_result($rs_Geometry);
mysql_free_result($rs_LabelCategory);
mysql_free_result($rs_LabelMaterial);
mysql_free_result($rs_TestSpec);
mysql_free_result($rs_DeliverySpec);
mysql_free_result($rs_MatSpec);
mysql_free_result($rs_MatCodeManuf);
mysql_free_result($rs_Adhesive);
mysql_free_result($rs_ColorRal);
mysql_free_result($rs_Pantone);
mysql_free_result($rs_Warntext);
mysql_free_result($rs_SupplierLcc);
?>
Geändert von Frank2010 (14.02.2010 um 20:05 Uhr)
Aktive Benutzer in diesem Thema: 1 (Registrierte Benutzer: 0, Gäste: 1)
LinkBack URL
About LinkBacks
Zitieren