if sætning
Hej eksperten.Jeg har to tabeller. Den ene hedder kundebase og den anden kundeprogram.
"kundebase" har felterne: ID, kundenr, begynderdato, vaegt, bryst, talje, hofte, vlaar, hlaar.
"kundeprogram" har felterne: kundenr, maaldag, maalvaegt, maalbryst, maaltalje, maalhofte, maalvlaar, maalhlaar.
Det skulle gerne være sådan, at når kundenr i tabellen "kundebase" er det samme som kundenr i tabellen "kundeprogram" skal den vise de andre oplysninger der står i record'en. F.eks kundenr i "kundebase" et sat til 2, skal den vise den record i "kundeprogram" hvor kundenr er også er sat til 2.
Min kode ser sådan ud:
<?php require_once('Connections/connection.php'); ?>
<?php
$colname_Recordset1 = "1";
if (isset($_GET['ID'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['ID'] : addslashes($_GET['ID']);
}
mysql_select_db($database_connection, $connection);
$query_Recordset1 = sprintf("SELECT * FROM kundebase WHERE ID = %s", $colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $connection) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
mysql_select_db($database_connection, $connection);
$query_Recordsetprogram = "SELECT * FROM kundeprogram";
$Recordsetprogram = mysql_query($query_Recordsetprogram, $connection) or die(mysql_error());
$row_Recordsetprogram = mysql_fetch_assoc($Recordsetprogram);
$totalRows_Recordsetprogram = mysql_num_rows($Recordsetprogram);
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];
$queryString_Recordset1 = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
$params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Recordset1") == false &&
stristr($param, "totalRows_Recordset1") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Recordset1 = "&" . implode("&", $newParams);
}
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Resultater</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="css/text.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="620" border="1" align="center" bordercolor="#000099" bgcolor="#CCCCCC">
<tr>
<td><table width="619" border="0">
<tr>
<td><div align="left" class="style2">1.dag</div></td>
<td class="style2"><?php echo $row_Recordset1['begynderdato']; ?></td>
<td><div align="left" class="style2"><span class="style2"><?php echo $row_Recordset1['vaegt']; ?></span> kg</div> </td>
<td class="style2"><?php echo $row_Recordset1['bryst']; ?> cm </td>
<td class="style2"><?php echo $row_Recordset1['talje']; ?> cm </td>
<td class="style2"><?php echo $row_Recordset1['hofte']; ?> cm </td>
<td class="style2"><?php echo $row_Recordset1['hlaar']; ?>/<?php echo $row_Recordset1['vlaar']; ?> cm</td>
<td> </td>
<td> </td>
</tr>
<?php
if (kundebase.kundenr == kundeprogram.kundenr) { /*hvis dette er sand skal række nedenunder vises*/
?>
<tr>
<td class="oplysninger"><div align="right"></div></td>
<td> </td>
<td class="style2"><?php echo $row_Recordsetprogram['maalvaegt']; ?> kg</td>
<td class="style2"><?php echo $row_Recordsetprogram['maalbryst']; ?> cm</td>
<td class="style2"><?php echo $row_Recordsetprogram['maaltalje']; ?> cm</td>
<td class="style2"><?php echo $row_Recordsetprogram['maalhofte']; ?> cm</td>
<td class="style2"><?php echo $row_Recordsetprogram['maalhlaar']; ?>/<?php echo $row_Recordsetprogram['maalvlaar']; ?> cm</td>
<td> </td>
<td> </td>
</tr>
</table>
</td>
</tr>
<?php
}
?>
</table>
</body>
</html>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordsetprogram);
?>
Håber i kan hjælpe mig.
Hilsen Rampagezz
