PHP/Mysql - Tabellen laten verdwijnen

[Verwijderd]

Hallo

Ik ben met Dreamweaver een php pagina aan het maken.

Nu word er een mysql tabel uitgelezen en geplaatst in en tabel in een php website.
Nou is de vraag, als er een entry mist in mysql, hoe kan ik er dan voor zorgen dat die rij ook uit de tabel verweiderd word uit de pagina?

[Verwijderd]

uhm eerst de query uitvoeren
dan een if result = 1 { teken tabel }

[Verwijderd]

Mischien iets duidelijkere uitleg?
ben nog niet lang bezig met php

[Verwijderd]

Hier de hele php code (paar dingen weggehaald voor veiligheid hier)

"
<?php require_once('******************'); ?><?php
$maxRows_DetailRS1 = 10;
$pageNum_DetailRS1 = 0;
if (isset($_GET['pageNum_DetailRS1'])) {
$pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];
}
$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1;

mysql_select_db($database_Hobbynet, $Hobbynet);
$recordID = $_GET['recordID'];
$query_DetailRS1 = "SELECT * FROM provider WHERE provider = '$recordID' ORDER BY provider ASC";
$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1);
$DetailRS1 = mysql_query($query_limit_DetailRS1, $Hobbynet) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);

if (isset($_GET['totalRows_DetailRS1'])) {
$totalRows_DetailRS1 = $_GET['totalRows_DetailRS1'];
} else {
$all_DetailRS1 = mysql_query($query_DetailRS1);
$totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1);
}
$totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-1;

$maxRows_DetailRS1 = 10;
$pageNum_DetailRS1 = 0;
if (isset($_GET['pageNum_DetailRS1'])) {
$pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];
}
$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1;

mysql_select_db($database_Hobbynet, $Hobbynet);
$recordID = $_GET['recordID'];
$query_DetailRS1 = "SELECT * FROM provider WHERE provider = '$recordID' ORDER BY provider ASC";
$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1);
$DetailRS1 = mysql_query($query_limit_DetailRS1, $Hobbynet) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);

if (isset($_GET['totalRows_DetailRS1'])) {
$totalRows_DetailRS1 = $_GET['totalRows_DetailRS1'];
} else {
$all_DetailRS1 = mysql_query($query_DetailRS1);
$totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1);
}
$totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-1;

$maxRows_DetailRS1 = 10;
$pageNum_DetailRS1 = 0;
if (isset($_GET['pageNum_DetailRS1'])) {
$pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];
}
$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1;

mysql_select_db($database_Hobbynet, $Hobbynet);
$recordID = $_GET['recordID'];
$query_DetailRS1 = "SELECT * FROM provider WHERE provider = '$recordID' ORDER BY provider ASC";
$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1);
$DetailRS1 = mysql_query($query_limit_DetailRS1, $Hobbynet) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);

if (isset($_GET['totalRows_DetailRS1'])) {
$totalRows_DetailRS1 = $_GET['totalRows_DetailRS1'];
} else {
$all_DetailRS1 = mysql_query($query_DetailRS1);
$totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1);
}
$totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-1;

$maxRows_DetailRS1 = 10;
$pageNum_DetailRS1 = 0;
if (isset($_GET['pageNum_DetailRS1'])) {
$pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];
}
$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1;

mysql_select_db($database_Hobbynet, $Hobbynet);
$recordID = $_GET['recordID'];
$query_DetailRS1 = "SELECT * FROM provider WHERE provider = '$recordID' ORDER BY provider ASC";
$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1);
$DetailRS1 = mysql_query($query_limit_DetailRS1, $Hobbynet) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);

if (isset($_GET['totalRows_DetailRS1'])) {
$totalRows_DetailRS1 = $_GET['totalRows_DetailRS1'];
} else {
$all_DetailRS1 = mysql_query($query_DetailRS1);
$totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1);
}
$totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-1;

$maxRows_DetailRS1 = 10;
$pageNum_DetailRS1 = 0;
if (isset($_GET['pageNum_DetailRS1'])) {
$pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];
}
$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1;

mysql_select_db($database_Hobbynet, $Hobbynet);
$recordID = $_GET['recordID'];
$query_DetailRS1 = "SELECT * FROM provider WHERE provider = '$recordID' ORDER BY provider ASC";
$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1);
$DetailRS1 = mysql_query($query_limit_DetailRS1, $Hobbynet) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);

if (isset($_GET['totalRows_DetailRS1'])) {
$totalRows_DetailRS1 = $_GET['totalRows_DetailRS1'];
} else {
$all_DetailRS1 = mysql_query($query_DetailRS1);
$totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1);
}
$totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-1;

mysql_select_db($database_Hobbynet, $Hobbynet);
$recordID = $_GET['recordID'];
$query_DetailRS1 = "SELECT * FROM provider WHERE provider = '$recordID'";
$DetailRS1 = mysql_query($query_DetailRS1, $Hobbynet) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);
$totalRows_DetailRS1 = mysql_num_rows($DetailRS1);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>

<table border="1" align="center">

<tr>
<td>Provider</td>
<td><?php echo $row_DetailRS1['provider']; ?> </td>
</tr>
<tr>
<td>Website</td>
<td><?php echo $row_DetailRS1['website']; ?> </td>
</tr>
<tr>
<td>E-Mail</td>
<td><?php echo $row_DetailRS1['email']; ?> </td>
</tr>
<tr>
<td>Abbonement 1 </td>
<td><?php echo $row_DetailRS1['adsl1']; ?> </td>
</tr>
<tr>
<td>Prijs</td>
<td><?php echo $row_DetailRS1['prijsabbo1']; ?> </td>
</tr>
<tr>
<td>Snelheid</td>
<td> <?php echo $row_DetailRS1['snelheidabbo1']; ?> </td>
</tr>
<tr>
<td>Abbonement 2 </td>
<td><?php echo $row_DetailRS1['adsl2']; ?> </td>
</tr>
<tr>
<td>Prijs</td>
<td><?php echo $row_DetailRS1['prijsabbo2']; ?> </td>
</tr>
<tr>
<td>Snelheid</td>
<td><?php echo $row_DetailRS1['snelheidabbo2']; ?> </td>
</tr>
<tr>
<td>Abbonement 3 </td>
<td><?php echo $row_DetailRS1['adsl3']; ?> </td>
</tr>
<tr>
<td>Prijs</td>
<td><?php echo $row_DetailRS1['prijsabbo3']; ?> </td>
</tr>
<tr>
<td>Snelheid</td>
<td> <?php echo $row_DetailRS1['snelheidabbo3']; ?></td>
</tr>
<tr>
<td>Abbonement 4 </td>
<td><?php echo $row_DetailRS1['adsl4']; ?> </td>
</tr>
<tr>
<td>Prijs</td>
<td><?php echo $row_DetailRS1['prijsabbo4']; ?> </td>
</tr>
<tr>
<td>Snelheid</td>
<td><?php echo $row_DetailRS1['snelheidabbo4']; ?> </td>
</tr>
<tr>
<td>Abbonement 5 </td>
<td><?php echo $row_DetailRS1['adsl5']; ?> </td>
</tr>
<tr>
<td>Prijs</td>
<td><?php echo $row_DetailRS1['prijsabbo5']; ?> </td>
</tr>
<tr>
<td>Snelheid</td>
<td><?php echo $row_DetailRS1['snelheidabbo5']; ?> </td>
</tr>
<tr>
<td>Abbonement</td>
<td><?php echo $row_DetailRS1['adsl6']; ?> </td>
</tr>
<tr>
<td>Prijs</td>
<td><?php echo $row_DetailRS1['prijsabbo6']; ?> </td>
</tr>
<tr>
<td>Snelheid</td>
<td><?php echo $row_DetailRS1['snelheidabbo6']; ?> </td>
</tr>
<tr>
<td>Abbonement 7 </td>
<td><?php echo $row_DetailRS1['adsl7']; ?> </td>
</tr>
<tr>
<td>Prijs</td>
<td><?php echo $row_DetailRS1['prijsabbo7']; ?> </td>
</tr>
<tr>
<td>Snelheid</td>
<td><?php echo $row_DetailRS1['snelheidabbo7']; ?> </td>
</tr>
<tr>
<td>Abbonement 8</td>
<td><?php echo $row_DetailRS1['adsl8']; ?> </td>
</tr>
<tr>
<td>Prijs</td>
<td><?php echo $row_DetailRS1['prijsabbo8']; ?> </td>
</tr>
<tr>
<td>Snelheid</td>
<td><?php echo $row_DetailRS1['snelheidabbo8']; ?> </td>
</tr>
<tr>
<td>Abbonement 9 </td>
<td><?php echo $row_DetailRS1['adsl9']; ?> </td>
</tr>
<tr>
<td>Prijs</td>
<td><?php echo $row_DetailRS1['prijsabbo9']; ?> </td>
</tr>
<tr>
<td>Snelheid </td>
<td><?php echo $row_DetailRS1['snelheidabbo9']; ?> </td>
</tr>
<tr>
<td>Abbonement 10 </td>
<td><?php echo $row_DetailRS1['adsl10']; ?> </td>
</tr>
<tr>
<td>Prijs</td>
<td><?php echo $row_DetailRS1['prijsabbo10']; ?> </td>
</tr>
<tr>
<td>Snelheid</td>
<td><?php echo $row_DetailRS1['snelheidabbo10']; ?> </td>
</tr>
<tr>
<td>Telefoon Nummer </td>
<td><?php echo $row_DetailRS1['telefoonnr']; ?> </td>
</tr>
<tr>
<td>Extra services </td>
<td><?php echo $row_DetailRS1['extraservices']; ?> </td>
</tr>
<tr>
<td>Prijs telefoon CPM</td>
<td><?php echo $row_DetailRS1['prijstelefooncmp']; ?> </td>
</tr>
<tr>
<td>Extra hulp diensten </td>
<td><?php echo $row_DetailRS1['extrahulp']; ?> </td>
</tr>
<tr>
<td>Dataverkeer per maand </td>
<td><?php echo $row_DetailRS1['dataverkeer']; ?> </td>
</tr>
<tr>
<td>Aantal email adressen </td>
<td><?php echo $row_DetailRS1['aantalmail']; ?> </td>
</tr>
<tr>
<td>Entreekosten</td>
<td><?php echo $row_DetailRS1['entreekosten']; ?> </td>
</tr>


</table>


</body>
</html><?php
mysql_free_result($DetailRS1);
?>
"


Iemand die hulp kan bieden?

[gorgi_19]

Mja, met zo een lap code denk ik dat 99% van de bezoekers direct je topic wegklikt. Zie P&W FAQ - De "quickstart" voor welke eisen we stellen aan een topic