I get "parse error on line 106" when running this piece of code:
<?php
print "<link rel='stylesheet' href='tips.css' type='text/css'>";
print "<b>Resultat av tippningen för omgång $omg</b><br>";
print "<table width='300' border='0' cellspacing='0' cellpadding='0' bgcolor='#000000'><tr><td></td></tr></table><br>";
$open = mysql_connect("localhost", "root") or die ("Couldn't connect to MySQL-server!");
mysql_select_db("tipset", $open) or die ("Hittade inte databasen!");
$finns_sql = "SELECT count(*) FROM resultat WHERE omg = $omg";
$finns_result = mysql_query($finns_sql);
if ($finns_result)
{
$finns_row = mysql_fetch_row ($finns_result);
if ($finns_row[0] == 0) // thats the value of count(*)
{
die("Omgång $omg har inte rättats! Rätta omgången och försök igen.");
}
$ratt_rad = mysql_query("SELECT FROM ratt_rad WHERE omg = '$omg'") or die("fukk"); // Rätt rad
$visa_res = mysql_query("SELECT FROM resultat WHERE omg = '$omg'"); // Resultat-poäng
$visa_tum = mysql_query("SELECT FROM tumtum WHERE omg = '$omg'"); // Tumtums tips
$visa_inc = mysql_query("SELECT FROM incognito WHERE omg = '$omg'"); // Incognitos tips
$visa_jar = mysql_query("SELECT FROM jarna WHERE omg = '$omg'"); // Järnas tips
$visa_san = mysql_query("SELECT FROM sandviken WHERE omg = '$omg'"); // Sandvikens tips
$visa_pao = mysql_query("SELECT FROM paok WHERE omg = '$omg'"); // PAOKs tips
$visa_mea = mysql_query("SELECT FROM meatballs WHERE omg = '$omg'"); // Meatballs tips
$visa_moc = mysql_query("SELECT FROM mockasinen WHERE omg = '$omg'"); // Mockasinens tips
$matcher = mysql_query("SELECT FROM matcher WHERE omg = '$omg'"); // Matcherna
//Rätt rad
while($rattrad_row = mysql_fetch_array($ratt_rad))
{
$ratt_hemma1 = $rattrad_row["hemma1"];
$ratt_hemma2 = $rattrad_row["hemma2"];
$ratt_hemma3 = $rattrad_row["hemma3"];
$ratt_hemma4 = $rattrad_row["hemma4"];
$ratt_borta1 = $rattrad_row["borta1"];
$ratt_borta2 = $rattrad_row["borta2"];
$ratt_borta3 = $rattrad_row["borta3"];
$ratt_borta4 = $rattrad_row["borta4"];
}
//Resultat av rättningen
while($resultat_row = mysql_fetch_array($visa_res))
{
//---
$tump1 = $resultat_row["tum1"];
$tump2 = $resultat_row["tum2"];
$tump3 = $resultat_row["tum3"];
$tump4 = $resultat_row["tum4"];
$tump = $resultat_row["tum"];
//---
$incp1 = $resultat_row["inc1"];
$incp2 = $resultat_row["inc2"];
$incp3 = $resultat_row["inc3"];
$incp4 = $resultat_row["inc4"];
$incp = $resultat_row["inc"];
//---
$jarp1 = $resultat_row["jar1"];
$jarp2 = $resultat_row["jar2"];
$jarp3 = $resultat_row["jar3"];
$jarp4 = $resultat_row["jar4"];
$jarp = $resultat_row["jar"];
//---
$sanp1 = $resultat_row["san1"];
$sanp2 = $resultat_row["san2"];
$sanp3 = $resultat_row["san3"];
$sanp4 = $resultat_row["san4"];
$sanp = $resultat_row["san"];
//---
$paop1 = $resultat_row["pao1"];
$paop2 = $resultat_row["pao2"];
$paop3 = $resultat_row["pao3"];
$paop4 = $resultat_row["pao4"];
$paop = $resultat_row["pao"];
//---
$meap1 = $resultat_row["mea1"];
$meap2 = $resultat_row["mea2"];
$meap3 = $resultat_row["mea3"];
$meap4 = $resultat_row["mea4"];
$meap = $resultat_row["mea"];
//---
$mocp1 = $resultat_row["moc1"];
$mocp2 = $resultat_row["moc2"];
$mocp3 = $resultat_row["moc3"];
$mocp4 = $resultat_row["moc4"];
$mocp = $resultat_row["moc"];
//---
}
//Matcherna
while($matcher_row = mysql_fetch_array($matcher))
{
$match1h = $matcher_row["hemmalag1"];
$match2h = $matcher_row["hemmalag2"];
$match3h = $matcher_row["hemmalag3"];
$match4h = $matcher_row["hemmalag4"];
$match1b = $matcher_row["bortalag1"];
$match2b = $matcher_row["bortalag2"];
$match3b = $matcher_row["bortalag3"];
$match4b = $matcher_row["bortalag4"];
}
include("res_vars.php");
?> [this is line 106!]
What is wrong?!
Thanks!
Vasse
