Ja det er kun ID der er med stort...
Her er hele koden:
<?php require_once('Connections/Herbalife.php'); ?>
<?php
mysql_select_db($database_Herbalife, $Herbalife);
$query_Recordset1 = "SELECT * FROM herbalife";
$Recordset1 = mysql_query($query_Recordset1, $Herbalife) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<title>Liv & Velvære</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
background-color: #FFFFFF;
}
-->
</style>
<link href="css/bg.css" rel="stylesheet" type="text/css">
<script language="JavaScript" 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_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
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_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<link href="css/tablegreen.css" rel="stylesheet" type="text/css">
<link href="css/text.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
a:link {
text-decoration: none;
color: #999999;
}
a:visited {
text-decoration: none;
color: #999999;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
color: #999999;
}
-->
</style>
</head>
<body onLoad="MM_preloadImages('jpg/menutomGover.jpg')">
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" style="border-bottom : 1pt solid Black; border-top : 1pt solid Black; border-left : 1pt solid Black; border-right : 1pt solid Black;">
<tr>
<td height="123" valign="bottom" class="top1"><table width="760" border="0" cellspacing="0" cellpadding="0" valign="bottom">
<tr>
<td width="168"><a href="administrer/oversigt.php"><img src="jpg/tom.jpg" width="10" height="10" border="0"></a></td>
<td width="580" valign="bottom" align="right">
<form name="form1" method="post" action="search_results.php" style="margin-bottom: 4px">
<input name="search" type="text" class="search" id="search" size="16">
<input name="Submit" type="submit" class="brodtekst" value="Søg">
</form>
</div></td>
</tr>
</table></td>
</tr>
<tr>
<td class="top2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="22%"> </td>
<td width="78%" class="menukategorier"><a href="index.php"><span class="menukategorier">Forside</span></a> - <strong>Søge resultat </strong></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="19%" rowspan="2" valign="top" bgcolor="#E7EBEA" style="border-right : 1pt solid Black;"><table width="145" border="0" cellspacing="0" cellpadding="0" class="menu">
<tr>
<td height="18" colspan="2" bgcolor="#CCCCCC" class="menukategorier" style="border-bottom : 1pt solid Black; border-top : 1pt solid Black;"><div align="center"><span class="style6">Menu:</span></div></td>
</tr>
<tr>
<td height="20" colspan="2" style="border-bottom : 1pt solid Silver; background : #CDE5C6;"><a href="index.php" target="_parent" class="menugreen" onMouseOver="MM_swapImage('Image1','','jpg/menutomGover.jpg',1)" onMouseOut="MM_swapImgRestore()"><img src="jpg/menutomG.jpg" name="Image1" width="15" height="10" border="0" id="Image1">Forside</a></td>
</tr>
<tr>
<td height="20" colspan="2" style="border-bottom : 1pt solid Silver; background : #CDE5C6;"><a href="resultater.php" target="_parent" class="menugreen" onMouseOver="MM_swapImage('Image2','','jpg/menutomGover.jpg',1)" onMouseOut="MM_swapImgRestore()"><img src="jpg/menutomG.jpg" name="Image2" width="15" height="10" border="0" id="Image2">Resultater</a></td>
</tr>
<tr>
<td height="20" colspan="2" style="border-bottom : 1pt solid Silver; background : #CDE5C6;"><a href="forretning.php" target="_parent" class="menugreen" onMouseOver="MM_swapImage('Image3','','jpg/menutomGover.jpg',1)" onMouseOut="MM_swapImgRestore()"><img src="jpg/menutomG.jpg" name="Image3" width="15" height="10" border="0" id="Image3">Forretning</a></td>
</tr>
<tr>
<td height="20" colspan="2" style="border-bottom : 1pt solid Silver; background : #CDE5C6;"><a href="herbalife.php" target="_parent" class="menugreen" onMouseOver="MM_swapImage('Image4','','jpg/menutomGover.jpg',1)" onMouseOut="MM_swapImgRestore()"><img src="jpg/menutomG.jpg" name="Image4" width="15" height="10" border="0" id="Image4">Herbalife</a></td>
</tr>
<tr>
<td height="20" colspan="2" style="border-bottom : 1pt solid Silver; background : #CDE5C6;"><a href="omsitet.php" target="_parent" class="menugreen" onMouseOver="MM_swapImage('Image5','','jpg/menutomGover.jpg',1)" onMouseOut="MM_swapImgRestore()"><img src="jpg/menutomG.jpg" name="Image5" width="15" height="10" border="0" id="Image5">Om sitet </a></td>
</tr>
<tr>
<td height="18" colspan="2"> </td>
</tr>
<tr>
<td height="18" colspan="2" bgcolor="#CCCCCC" class="menukategorier" style="border-bottom : 1pt solid Black; border-top : 1pt solid Black;"><div align="center"><span class="style6">Produkter:</span></div></td>
</tr>
<tr>
<td height="20" colspan="2" style="border-bottom : 1pt solid Silver; background : #CDE5C6;"><a href="weight.php" target="_parent" class="menugreen" onMouseOver="MM_swapImage('Image6','','jpg/menutomGover.jpg',1)" onMouseOut="MM_swapImgRestore()"><img src="jpg/menutomG.jpg" name="Image6" width="15" height="10" border="0" id="Image6">Vægt-regulering</a></td>
</tr>
<tr>
<td height="20" colspan="2" style="border-bottom : 1pt solid Silver; background : #CDE5C6;"><a href="nutrition.php" target="_parent" class="menugreen" onMouseOver="MM_swapImage('Image7','','jpg/menutomGover.jpg',1)" onMouseOut="MM_swapImgRestore()"><img src="jpg/menutomG.jpg" name="Image7" width="15" height="10" border="0" id="Image7">Ernæring</a></td>
</tr>
<tr>
<td height="20" colspan="2" style="border-bottom : 1pt solid Silver; background : #CDE5C6;"><a href="skin.php" target="_parent" class="menugreen" onMouseOver="MM_swapImage('Image8','','jpg/menutomGover.jpg',1)" onMouseOut="MM_swapImgRestore()"><img src="jpg/menutomG.jpg" name="Image8" width="15" height="10" border="0" id="Image8">Hudpleje</a></td>
</tr>
<tr>
<td height="20" colspan="2" style="border-bottom : 1pt solid Silver; background : #CDE5C6;"><a href="hair.php" target="_parent" class="menugreen" onMouseOver="MM_swapImage('Image9','','jpg/menutomGover.jpg',1)" onMouseOut="MM_swapImgRestore()"><img src="jpg/menutomG.jpg" name="Image9" width="15" height="10" border="0" id="Image9">Hår & Bad </a></td>
</tr>
<tr>
<td height="20" colspan="2" style="border-bottom : 1pt solid Silver; background : #CDE5C6;"><a href="parfume.php" target="_parent" class="menugreen" onMouseOver="MM_swapImage('Image10','','jpg/menutomGover.jpg',1)" onMouseOut="MM_swapImgRestore()"><img src="jpg/menutomG.jpg" name="Image10" width="15" height="10" border="0" id="Image10">Dufte</a></td>
</tr>
<tr>
<td height="20" colspan="2" style="border-bottom : 1pt solid Silver; background : #CDE5C6;"><a href="accessories.php" target="_parent" class="menugreen" onMouseOver="MM_swapImage('Image11','','jpg/menutomGover.jpg',1)" onMouseOut="MM_swapImgRestore()"><img src="jpg/menutomG.jpg" name="Image11" width="15" height="10" border="0" id="Image11">Tilbehør</a></td>
</tr>
<tr>
<td height="18" colspan="2"> </td>
</tr>
<tr>
<td height="18" colspan="2" bgcolor="#CCCCCC" class="menukategorier" style="border-bottom : 1pt solid Black; border-top : 1pt solid Black;"><div align="center"><span class="style6">Kontakt:</span></div></td>
</tr>
<tr>
<td height="20" colspan="2" style="border-bottom : 1pt solid Silver; background : #CDE5C6;"><a href="vejleder.php" target="_parent" class="menugreen" onMouseOver="MM_swapImage('Image12','','jpg/menutomGover.jpg',1)" onMouseOut="MM_swapImgRestore()"><img src="jpg/menutomG.jpg" name="Image12" width="15" height="10" id="Image12" border="0">Personlig Vejleder</a></td>
</tr>
<tr>
<td height="20" colspan="2" style="border-bottom : 1pt solid Silver; background : #CDE5C6;"><a href="bestilling.php" target="_parent" class="menugreen" onMouseOver="MM_swapImage('Image13','','jpg/menutomGover.jpg',1)" onMouseOut="MM_swapImgRestore()"><img src="jpg/menutomG.jpg" name="Image13" width="15" height="10" border="0" id="Image13">Bestil</a></td>
</tr>
<tr>
<td height="20" colspan="2" style="border-bottom : 1pt solid Silver; background : #CDE5C6;"><a href="levering.php" target="_parent" class="menugreen" onMouseOver="MM_swapImage('Image14','','jpg/menutomGover.jpg',1)" onMouseOut="MM_swapImgRestore()"><img src="jpg/menutomG.jpg" name="Image14" width="15" height="10" border="0" id="Image14">Levering / Vilkår </a></td>
</tr>
<tr>
<td height="18" colspan="2"> </td>
</tr>
<tr valign="middle">
<td height="18" bgcolor="#CCCCCC" class="menukategorier" style="border-bottom : 1pt solid Black; border-top : 1pt solid Black;"><div align="right"><a href="kurv.php"><span class="style6 style8"><img src="jpg/kurv_lille.gif" width="15" height="13" border="0"></span></a> </div> <div align="center"></div></td>
<td height="18" bgcolor="#CCCCCC" class="menukategorier" style="border-bottom : 1pt solid Black; border-top : 1pt solid Black;"><a href="kurv.php"><span class="style6 style8">Kurv:</span></a></td>
</tr>
<tr>
<td height="20" colspan="2" bgcolor="CDE5C6"><img src="jpg/menutomG.jpg" name="Image15" width="15" height="10" border="0" id="Image15">? Vare(r) i <a href="kurv.php"><span class="brodtekst"><u>kurven</u></span></a> </td>
</tr>
<tr>
<td width="57" height="20" bgcolor="CDE5C6"><img src="jpg/menutomG.jpg" name="Image16" width="15" height="10" border="0" id="Image16"><strong>I alt</strong></td>
<td width="88" bgcolor="CDE5C6"><div align="right">? <strong>DKK</strong><img src="jpg/menutomG.jpg" name="Image17" width="15" height="10" border="0" id="Image17"></div></td>
</tr>
<tr>
<td height="20" colspan="2"> </td>
</tr>
</table></td>
<td> </td>
<td valign="top"> </td>
</tr>
<tr>
<td width="3%"> </td>
<td width="78%" valign="top">
<table width="550" height="" border="0" cellpadding="0" cellspacing="0" align="center">
<tr height="18">
<td width="100" bgcolor="#6C8462" class="tabeltitel"><div align="center">Foto</div></td>
<td width="150" bgcolor="#6C8462" class="tabeltitel">Beskrivelse</td>
<td width="150" bgcolor="#6C8462"> </td>
<td width="50" bgcolor="#6C8462" class="tabeltitel"><div align="center">Info</div></td>
<td width="100" bgcolor="#6C8462" class="tabeltitel">Pris</td>
<td width="50" bgcolor="#6C8462" class="tabeltitel"><div align="center">Køb</div></td>
</tr>
</table>
<?php
if(is_array($HTTP_POST_VARS)) {
$search = $HTTP_POST_VARS['search'];
} elseif (is_array($_POST)) {
$search = $_POST['search'];
}
$sql = "SELECT navn, info, beskrivelse, varenr, pris, lager, billede FROM herbalife WHERE navn LIKE '%$search%' ";
$res = mysql_query($sql) or die(mysql_error());
echo"<table width=\"550\" cellpadding=0 cellspacing=0 align=center style=\"border-top: #6C8462 1pt solid\">";
while($row = mysql_fetch_assoc($res)) {
echo "<tr>
<td rowspan=2 height=100 width=100 align=center style=\"border-left: #6C8462 1px solid ; border-bottom: #6C8462 1px solid ; border-right: #6C8462 1px solid\"><a href=\"produktdetalje.php?ID={$row_Recordset1['ID']}\"><img src=\"jpg/produkter/$row[billede]\" name=produktbillede width=50 height=75 border=0 id=produktbillede></a></td>
<td height=15 width=150 class=varenr>Varenr: $row[varenr]</td>
<td width=150 class=varenr align=center style=\"border-right: #6C8462 1pt solid\">$row[lager]</td>
<td rowspan=2 width=50 align=center valign=top style=\"border-right: #6C8462 1pt solid ; border-bottom: #6C8462 1pt solid\"><img src=jpg/infoknap.gif width=20 height=22 border=0></td>
<td width=100 valign=bottom class=menukategorier style=\"border-right: #6C8462 1pt solid\"><b>$row[pris] DKK</b></td>
<td rowspan=2 width=50 align=center valign=top style=\"border-right: #6C8462 1pt solid ; border-bottom: #6C8462 1pt solid\"><img src=jpg/koeb.gif width=26 height=21></td>
</tr>
<tr>
<td colspan=2 height=85 width=300 valign=top class=menukategorier style=\"border-bottom: #6C8462 1px solid ; border-right: #6C8462 1px solid\"><b>$row[navn]</b><br>$row[info]</td>
<td style=\"border-right: #6C8462 1pt solid ; border-bottom: #6C8462 1pt solid\">.</td>
<tr>";
}
echo "</table>";
exit;
?>
</td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>