Dear reader,
I have a problem, here is the code:
<?php
$db = mysql_connect("$db", "$user", "$pass");
mysql_select_db("$dbname", $db);
if (actie == "gratis")
{
$sql="SELECT * FROM freebees ORDER BY count DESC LIMIT 0, 50";
}
elseif (actie == "gratis02")
{
$sql="SELECT * FROM freebees ORDER BY count DESC LIMIT 51, 100";
}
elseif (actie == "gratis03")
{
$sql="SELECT * FROM freebees ORDER BY count DESC LIMIT 101, 150";
}
elseif (actie == "gratis03")
{
$sql="SELECT * FROM freebees ORDER BY count DESC LIMIT 101, 150";
}
elseif (actie == "cdroms")
{
$sql="SELECT * FROM freebees WHERE type = '1' ORDER BY count DESC LIMIT 0, 50";
}
elseif (actie == "smsfax")
{
$sql="SELECT * FROM freebees WHERE type = '2' ORDER BY count DESC LIMIT 0, 50";
}
elseif (actie == "tshirts")
{
$sql="SELECT * FROM freebees WHERE type = '3' ORDER BY count DESC LIMIT 0, 50";
}
elseif (actie == "stickersposters")
{
$sql="SELECT * FROM freebees WHERE type = '4' ORDER BY count DESC LIMIT 0, 50";
}
?>
<?php
$result = mysql_query($sql);
echo mysql_error();
while ($row = mysql_fetch_object($result)) {
?>
the error is in the line starting with "while"
you can see output of this error here:
www.dopmeijer.f2s.com/freebees/main.php3?actie=tshirts
Thanks in advance,
tim
