29. september 2002 - 00:59
Der er
6 kommentarer og
1 løsning
gemme hvis forespørgsel ikke passer!
Jeg har lige et lille problem.
Jeg har i en fil 3 forespørgsler til 3 forskellige tabeller i MySql-databsen
Det er så ikke altid at der i den enkelte forespørgsel er noget i databsen der passer til. Hvis dette hænder at der ikke er noget der passer til, skal denne enkelte forespørgsel, så bare ignoreres, så den ikke viser noget fra den forespørgsel.
Håber der er nogen der kan hjælpe og forstår spørgsmålet
29. september 2002 - 01:03
#1
$result = mysql_query( $sql_kommando ) or die(mysql_error()); // spørg
if ( mysql_num_rows( $result ) > 0 ) {
// der blev fundet noget, så udskriv det inden i denne if.
...
}
mvh JakobA
29. september 2002 - 01:18
#4
Her er koden... du kan se 2 forespørgseler og hvis den nederste ikke har noget der passer i tabellen, så skal den ikke vise noget overhovedet
<?
$time1 = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
$time2 = $time1 + 24 * 60 * 60;
$result = mysql_query("SELECT * FROM euromatch WHERE dato > $time1 AND dato < $time2 ORDER BY dato");
if (mysql_num_rows($result) > 0){
while($row = mysql_fetch_array($result)){
if ($lastgoals != $row["turnering"]){
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; border: 1px solid black; margin-top: 5; margin-bottom: 5\" width=\"350\" bgcolor=\"#3E3E3E\">";
echo "<tr><td width=\"350\" align=\"center\" colspan=\"2\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">DANMARK - SUPERLIGAEN</td></tr>";
echo "<tr><td width=\"150\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . date("G:i") . "</td><td width=\"200\" align=\"right\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . strftime("%d. %B") . "</td></tr>";
echo "</table>";
}
$lastgoals = $row["turnering"];
$taeller++;
if ($taeller % 2 == 1){
echo "<table width=\"350\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse;\">";
echo " <tr style=\"cursor: hand;\">";
echo " <a href=\"#\" onclick=\"window.open('../vis_match.php?id=" . $row["matchid"] . "','mitvindue','width=450,height=550');return false;\" style=\"text-decoration: none\"><td width=\"100\" style=\"border-left: 1px solid black; border-bottom: 1px solid black\" align=\"left\" bgcolor=\"#3C5946\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . date("G:i", $row["dato"]) . " " . $row["status"] . "</font></td>";
echo " <td style=\"text-decoration: none\" style=\"border-bottom: 1px solid black; border-right: 1px solid black\" align=\"left\" width=\"200\" bgcolor=\"#3C5946\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . $row["hometeam"] . " - " . $row["awayteam"] . "</font></td>";
echo " <td style=\"text-decoration: none; border-right: 1px solid black; border-bottom: 1px solid black\" align=\"center\" width=\"50\" bgcolor=\"#596C68\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . $row["homegoal"] . " - " . $row["awaygoal"] . "</font></td></a>";
echo " </tr>";
echo "</table>";
} else {
echo "<table width=\"350\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse;\">";
echo " <tr style=\"cursor: hand;\">";
echo " <a href=\"#\" onclick=\"window.open('../vis_match.php?id=" . $row["matchid"] . "','mitvindue','width=450,height=550');return false;\" style=\"text-decoration: none\"><td width=\"100\" style=\"border-left: 1px solid black; border-bottom: 1px solid black\" align=\"left\" bgcolor=\"#C8EACD\"><font face=\"verdana\" size=\"1\" color=\"#111111\">" . date("G:i", $row["dato"]) . " " . $row["status"] . "</font></td>";
echo " <td style=\"text-decoration: none\" style=\"border-bottom: 1px solid black; border-right: 1px solid black\" align=\"left\" width=\"200\" bgcolor=\"#C8EACD\"><font face=\"verdana\" size=\"1\" color=\"#111111\">" . $row["hometeam"] . " - " . $row["awayteam"] . "</font></td>";
echo " <td style=\"text-decoration: none; border-right: 1px solid black; border-bottom: 1px solid black\" align=\"center\" width=\"50\" bgcolor=\"#596C68\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . $row["homegoal"] . " - " . $row["awaygoal"] . "</font></td></a>";
echo " </tr>";
echo "</table>";
}
}
} else {
echo "<table width=\"350\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; margin-top: 5; margin-bottom: 5\">";
echo " <tr>";
echo "<td style=\"text-decoration: none\" style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-left: 1px solid black\" align=\"center\" width=\"165\" bgcolor=\"#3C5946\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">Ingen Superligakampe i dag!</font></td>";
echo " </tr>";
echo "</table>";
}
?>
<?
$time1 = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
$time2 = $time1 + 24 * 60 * 60;
$result = mysql_query("SELECT * FROM landskamp WHERE dato > $time1 AND dato < $time2 ORDER BY dato");
if (mysql_num_rows($result) > 0){
while($row = mysql_fetch_array($result)){
if ($lastgoals != $row["turnering"]){
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; border: 1px solid black; margin-top: 5; margin-bottom: 5\" width=\"350\" bgcolor=\"#3E3E3E\">";
echo "<tr><td width=\"350\" align=\"center\" colspan=\"2\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">DANMARK - SUPERLIGAEN</td></tr>";
echo "<tr><td width=\"150\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . date("G:i") . "</td><td width=\"200\" align=\"right\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . strftime("%d. %B") . "</td></tr>";
echo "</table>";
}
$lastgoals = $row["turnering"];
$taeller++;
if ($taeller % 2 == 1){
echo "<table width=\"350\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse;\">";
echo " <tr style=\"cursor: hand;\">";
echo " <a href=\"#\" onclick=\"window.open('../vis_match.php?id=" . $row["matchid"] . "','mitvindue','width=450,height=550');return false;\" style=\"text-decoration: none\"><td width=\"100\" style=\"border-left: 1px solid black; border-bottom: 1px solid black\" align=\"left\" bgcolor=\"#3C5946\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . date("G:i", $row["dato"]) . " " . $row["status"] . "</font></td>";
echo " <td style=\"text-decoration: none\" style=\"border-bottom: 1px solid black; border-right: 1px solid black\" align=\"left\" width=\"200\" bgcolor=\"#3C5946\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . $row["hometeam"] . " - " . $row["awayteam"] . "</font></td>";
echo " <td style=\"text-decoration: none; border-right: 1px solid black; border-bottom: 1px solid black\" align=\"center\" width=\"50\" bgcolor=\"#596C68\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . $row["homegoal"] . " - " . $row["awaygoal"] . "</font></td></a>";
echo " </tr>";
echo "</table>";
} else {
echo "<table width=\"350\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse;\">";
echo " <tr style=\"cursor: hand;\">";
echo " <a href=\"#\" onclick=\"window.open('../vis_match.php?id=" . $row["matchid"] . "','mitvindue','width=450,height=550');return false;\" style=\"text-decoration: none\"><td width=\"100\" style=\"border-left: 1px solid black; border-bottom: 1px solid black\" align=\"left\" bgcolor=\"#C8EACD\"><font face=\"verdana\" size=\"1\" color=\"#111111\">" . date("G:i", $row["dato"]) . " " . $row["status"] . "</font></td>";
echo " <td style=\"text-decoration: none\" style=\"border-bottom: 1px solid black; border-right: 1px solid black\" align=\"left\" width=\"200\" bgcolor=\"#C8EACD\"><font face=\"verdana\" size=\"1\" color=\"#111111\">" . $row["hometeam"] . " - " . $row["awayteam"] . "</font></td>";
echo " <td style=\"text-decoration: none; border-right: 1px solid black; border-bottom: 1px solid black\" align=\"center\" width=\"50\" bgcolor=\"#596C68\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">" . $row["homegoal"] . " - " . $row["awaygoal"] . "</font></td></a>";
echo " </tr>";
echo "</table>";
}
}
} else {
echo "<table width=\"350\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse;\">";
echo " <tr>";
echo "<td style=\"text-decoration: none\" style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-left: 1px solid black; margin-top: 5; margin-bottom: 5\" align=\"center\" width=\"165\" bgcolor=\"#3C5946\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">Ingen Superligakampe i dag!</font></td>";
echo " </tr>";
echo "</table>";
}
?>
29. september 2002 - 01:24
#5
så fjern else delen, dvs dette: (men ikke } tegnet foran else)
else {
echo "<table width=\"350\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse;\">";
echo " <tr>";
echo "<td style=\"text-decoration: none\" style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-left: 1px solid black; margin-top: 5; margin-bottom: 5\" align=\"center\" width=\"165\" bgcolor=\"#3C5946\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\">Ingen Superligakampe i dag!</font></td>";
echo " </tr>";
echo "</table>";
}
det er det der bliver skrevet hvis mysql_num_rows($result) er lig med 0.
mvh JakobA