Hello,
I've been working on this script all day, but I'm getting the same failure
report each time:
Warning: Supplied argument is not a valid MySQL result resource in
c:\program files\apache group\apache\htdocs\motoerit\toon_alles.php on line
23
What could be wrong? This is the code I have:
line 23 is: while(list($ID, $Naam, $Adres, [......] $Bet_rest, $Overig_info)
= mysql_fetch_array ($result))
-----------------------------------
<HTML>
<HEAD><TITLE>Boekingen</TITLE>
<LINK HREF="motoerit.css" TYPE="text/css" REL="stylesheet">
<script language="JavaScript">
<!--
function openwin(location) {OpenWin = this.open(location, "nieuws",
"width=455,height=333,scrollbars");}
// -->
</script>
</HEAD>
<BODY>
<?php
include ("dburl.txt");
mysql_connect ($dbserver, 'username', 'password');
mysql_select_db('dbname');
if ($orderby == " ")
{$orderby == "ID";
}
$query = "SELECT * FROM boekingen order by $orderbyASC ";
$result = mysql_query($query);
while(list($ID, $Naam, $Adres, $Postcode, $Woonplaats, $Land, $Telefoon,
$Mobiel, $Fax, $Email, $Aantal_pers, $Voert_aantal, $Voert_soort,
$Voert_merk, $Voert_kent, $Voert_hoogte, $Voert_lengte, $Voert_aanhang,
$Party, $Dat_heen, $Tijd_heen, $Dat_terug, $Tijd_terug, $Maaltijd,
$Hut_soort, $Reiscode, $Reisdoel, $Maatschap, $Dat_voorschot, $Dat_rest,
$Bet_voorschot, $Bet_rest, $Overig_info) = mysql_fetch_array ($result))
print("<TABLE BORDER=0 CELLSPACING=1>");
print("<TR><TH bgcolor=\"#999999\"><FONT
COLOR=\"#FFFFFF\">ID:</FONT></TH><TH bgcolor=\"#999999\"><FONT
COLOR=\"#FFFFFF\">Naam:</FONT></TH><TH bgcolor=\"#999999\"><FONT
COLOR=\"#FFFFFF\">Reisdoel:</TH><TH bgcolor=\"#999999\"><FONT
COLOR=\"#FFFFFF\">Datum vertrek:</TH><TH bgcolor=\"#999999\"><FONT
COLOR=\"#FFFFFF\">Datum terugkomst:</FONT></TH><TH bgcolor=\"#999999\"><FONT
COLOR=\"#FFFFFF\">Datum betaling voorschot:</FONT></TH><TH
bgcolor=\"#999999\"><FONT COLOR=\"#FFFFFF\">Datum betaling
rest:</FONT></TH><TH> </TH><TH> </TH></TR>");
print("<TR><TD bgcolor=\"#999999\"><FONT
COLOR=\"#FFFFFF\">$ID</FONT></TD><TD bgcolor=\"#F5F5F5\"><div
CLASS=txtblack>$Naam</DIV></TD><TD>$Reisdoel</TD><TD>$Dat_heen</TD><TD>$Dat_
terug</TD><TD><a href=\"wijzig.php?ID=".$ID."\">Wijzigen</a></TD><TD><a
href=\"wis.php?ID=".$ID."\">Verwijderen</a></TD></TR>\n");
print("</TABLE>");
include ("footer.txt");
?>
-----------------------------------
Thanks in advance!
Kind regards,
Paul Sidler
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
