[Resolved] Parse Error on line 114 - </html> ??

Myrkul

Parse error: parse error in /home/swhyperspace/expansion/form.php on line 114

[code=php]Code deleted for thread clarity - Myrkul[/code]

line 114 is "</html>"
what exactly is the matter?

thanks in advance!

WinterDragon

You're missing a } at the very end... you forgot to end the else statement... so.. open PHP and put a } then close it.

thats the problem hehe

Myrkul

ah thank you very much that did the trick.

now another problem..the code to view the dbase:

<?php 

$db = mysql_connect ("localhost", "user", "pass") or die ('I cannot connect to the database.. darnit.');
mysql_select_db ("swhyperspace") or die ("damn!"); 

$result = mysql_query ("SELECT * FROM cards ORDER BY ID DESC", $db) OR die("shit!");

while ($row = mysql_fetch_array($result))
{
 echo "<table width=\"545\" border=\"1\" cellspacing=\"2\" cellpadding=\"0\">";
 echo "<tr>";
 echo "<td>alias</td>";
 echo "<td>email</td>";
 echo "<td>fleet</td>";
 echo "<td>title</td>";
 echo "<td>side</td>";
 echo "<td>destiny</td>";
 echo "<td>deploy</td>";
 echo "<td>forfiet</td>";
 echo "<td>lore</td>";
 echo "<td>game</td>";
 echo "<td>image</td>";
 echo "<td>type</td>";
 echo "<td>type2</td>";
 echo "<td>PILOT</td>";
 echo "<td>NAVIGATOR</td>";
 echo "<td>WARRIOR-WAR2</td>";
 echo "<td>BOUNTY</td>";
 echo "<td>GAMBLER</td>";
 echo "<td>INFO</td>";
 echo "<td>LEADER</td>";
 echo "<td>SCOUT</td>";
 echo "<td>SENATOR</td>";
 echo "<td>SMUGGLER</td>";
 echo "<td>SPY</td>";
 echo "</tr>";
 echo "<tr>";
 echo "<td>".$row["alias"]"</td>";
 echo "<td>".$row["email"]"</td>";
 echo "<td>".$row["fleet"]"</td>";
 echo "<td>".$row["title"]"</td>";
 echo "<td>".$row["side"]"</td>";
 echo "<td>".$row["destiny"]"</td>";
 echo "<td>".$row["deploy"]"</td>";
 echo "<td>".$row["forfiet"]"</td>";
 echo "<td>".$row["lore"]"</td>";
 echo "<td>".$row["game"]"</td>";
 echo "<td>".$row["iamge"]"</td>";
 echo "<td>".$row["type"]"</td>";
 echo "<td>".$row["type2"]"</td>";
 echo "<td>".$row["c1"]"</td>";
 echo "<td>".$row["c2"]"</td>";
 echo "<td>".$row["c3"]"</td>";
 echo "<td>".$row["c4"]"</td>";
 echo "<td>".$row["c5"]"</td>";
 echo "<td>".$row["c6"]"</td>";
 echo "<td>".$row["c7"]"</td>";
 echo "<td>".$row["c8"]"</td>";
 echo "<td>".$row["c9"]"</td>";
 echo "<td>".$row["c10"]"</td>";
 echo "<td>".$row["c11"]"</td>";
 echo "</tr>";
 echo "</table>";
}

mysql_close($db);

?>

Parse error: parse error, expecting ','' or';'' in /home/swhyperspace/expansion/view.php on line 38

thats this line: echo "<td>".$row["alias"]"</td>";
I have the ; in place and the " are proper it looks like..

WinterDragon

You need to make it single quotes within the array... er.. look

echo "<td>".$row["alias"]"</td>";

needs to be $row['alias']

I tested it out with the double quotes within the $row[] and it gave me the same error...

change that, it should fix it.

Myrkul

alright i did that and i still get the same error on the same line..
sample:

echo "<td>".$row['alias']"</td>";
 echo "<td>".$row['email']"</td>";
 echo "<td>".$row['fleet']"</td>";
 echo "<td>".$row['title']"</td>";

WinterDragon

OOOOH I SEE!!

echo "<td>" . $row['alias'] . "</td>";

You're missing a period after the $row['alias']!!! so i changed it for you right there... so do that with the rest of them

Myrkul

yes! thank you! that did it.. uhoh now I get

shit!

I looked into my code and it failed here:

$result = mysql_query ("SELECT * FROM cards ORDER BY ID DESC", $db) OR die("shit!");

I wrote all of this from scratch except that line there, mabye the
"ORDER BY ID DESC" is wrong? I'm not sure what it does.

WinterDragon

I didn't know mysql_query() took two arguments...? If you selected the db, and stuff, you shouldn't have to choose a db... anyways... I dunno... let me look at some stuff

WinterDragon

ok here is a better question... what exactly are you wanting to do? sort or what?

Myrkul

just display all the data in the table... all 20 fields or so... it wont look to pretty but i just want to see the data.

WinterDragon

OOOOOH Ok do this...

$query = "SELECT * FROM your_table";
$results = mysql_query($query);

while($rest = mysql_fetch_array($result)) {
echo "$rest['columnname']<br>";
}

Ok there, you can use mysql_fetch_row, or mysql_fetch_object, I like the array...

but that displays all records.

Myrkul

ok how would i incorporate that into mine?
(whats "echo "$rest['columnname']<br>";" columname?)

WinterDragon

The same way you've been doing it... just put it in the while loop...

$query = "SELECT * FROM your_table";
$results = mysql_query($query);

while($rest = mysql_fetch_array($result)) {
echo "<table width=\"545\" border=\"1\" cellspacing=\"2\" cellpadding=\"0\">";
 echo "<tr>";
 echo "<td>alias</td>";
 echo "<td>email</td>";
 echo "<td>fleet</td>";
 echo "<td>title</td>";
 echo "<td>side</td>";
 echo "<td>destiny</td>";
 echo "<td>deploy</td>";
 echo "<td>forfiet</td>";
 echo "<td>lore</td>";
 echo "<td>game</td>";
 echo "<td>image</td>";
 echo "<td>type</td>";
 echo "<td>type2</td>";
 echo "<td>PILOT</td>";
 echo "<td>NAVIGATOR</td>";
 echo "<td>WARRIOR-WAR2</td>";
 echo "<td>BOUNTY</td>";
 echo "<td>GAMBLER</td>";
 echo "<td>INFO</td>";
 echo "<td>LEADER</td>";
 echo "<td>SCOUT</td>";
 echo "<td>SENATOR</td>";
 echo "<td>SMUGGLER</td>";
 echo "<td>SPY</td>";
 echo "</tr>";
 echo "<tr>";
 echo "<td>" . $row['alias'] . "</td>";
 echo "<td>" . $row['email'] . "</td>";
 echo "<td>" . $row['fleet'] . "</td>";
 echo "<td>" . $row['title'] . "</td>";
 echo "<td>" . $row['side'] . "</td>";
 echo "<td>" . $row['destiny'] . "</td>";
 echo "<td>" . $row['deploy'] . "</td>";
 echo "<td>" . $row['forfiet'] . "</td>";
 echo "<td>" . $row['lore'] . "</td>";
 echo "<td>" . $row['game'] . "</td>";
 echo "<td>" . $row['iamge'] . "</td>";
 echo "<td>" . $row['type'] . "</td>";
 echo "<td>" . $row['type2'] . "</td>";
 echo "<td>" . $row['c1'] . "</td>";
 echo "<td>" . $row['c2'] . "</td>";
 echo "<td>" . $row['c3'] . "</td>";
 echo "<td>" . $row['c4'] . "</td>";
 echo "<td>" . $row['c5'] . "</td>";
 echo "<td>" . $row['c6'] . "</td>";
 echo "<td>" . $row['c7'] . "</td>";
 echo "<td>" . $row['c8'] . "</td>";
 echo "<td>" . $row['c9'] . "</td>";
 echo "<td>" . $row['c10'] . "</td>";
 echo "<td>" . $row['c11'] . "</td>";
 echo "</tr>";
 echo "</table>";
}

THERE!! That should freaking fix it, and incorporate it into your script... hehe

Myrkul

alright I removed the s from "$results = mysql_query($query);"

And it still doesnt work.. :/

<?php 
$db = mysql_connect ("localhost", "user", "pass") or die ('I cannot connect to the database.. darnit.');
mysql_select_db ("swhyperspace") or die ("damn!"); 

$query = "SELECT * FROM cards"; 
$result = mysql_query($query); 

while($rest = mysql_fetch_array($result)) { 
echo "<table width=\"545\" border=\"1\" cellspacing=\"2\" cellpadding=\"0\">"; 
echo "<tr>"; 
echo "<td>alias</td>"; 
echo "<td>email</td>"; 
echo "<td>fleet</td>"; 
echo "<td>title</td>"; 
echo "<td>side</td>"; 
echo "<td>destiny</td>"; 
echo "<td>deploy</td>"; 
echo "<td>forfiet</td>"; 
echo "<td>lore</td>"; 
echo "<td>game</td>"; 
echo "<td>image</td>"; 
echo "<td>type</td>"; 
echo "<td>type2</td>"; 
echo "<td>PILOT</td>"; 
echo "<td>NAVIGATOR</td>"; 
echo "<td>WARRIOR-WAR2</td>"; 
echo "<td>BOUNTY</td>"; 
echo "<td>GAMBLER</td>"; 
echo "<td>INFO</td>"; 
echo "<td>LEADER</td>"; 
echo "<td>SCOUT</td>"; 
echo "<td>SENATOR</td>"; 
echo "<td>SMUGGLER</td>"; 
echo "<td>SPY</td>"; 
echo "</tr>"; 
echo "<tr>"; 
echo "<td>" . $row['alias'] . "</td>"; 
echo "<td>" . $row['email'] . "</td>"; 
echo "<td>" . $row['fleet'] . "</td>"; 
echo "<td>" . $row['title'] . "</td>"; 
echo "<td>" . $row['side'] . "</td>"; 
echo "<td>" . $row['destiny'] . "</td>"; 
echo "<td>" . $row['deploy'] . "</td>"; 
echo "<td>" . $row['forfiet'] . "</td>"; 
echo "<td>" . $row['lore'] . "</td>"; 
echo "<td>" . $row['game'] . "</td>"; 
echo "<td>" . $row['iamge'] . "</td>"; 
echo "<td>" . $row['type'] . "</td>"; 
echo "<td>" . $row['type2'] . "</td>"; 
echo "<td>" . $row['c1'] . "</td>"; 
echo "<td>" . $row['c2'] . "</td>"; 
echo "<td>" . $row['c3'] . "</td>"; 
echo "<td>" . $row['c4'] . "</td>"; 
echo "<td>" . $row['c5'] . "</td>"; 
echo "<td>" . $row['c6'] . "</td>"; 
echo "<td>" . $row['c7'] . "</td>"; 
echo "<td>" . $row['c8'] . "</td>"; 
echo "<td>" . $row['c9'] . "</td>"; 
echo "<td>" . $row['c10'] . "</td>"; 
echo "<td>" . $row['c11'] . "</td>"; 
echo "</tr>"; 
echo "</table>"; 
}

mysql_close($db);

?>

WinterDragon

uh whats it saying now? hehe..
OOOPS I SEE!!
change thissssss

while($rest = mysql_fetch_array($result)) { 
#To this down here..
while($row = mysql_fetch_array($result)) {

IS THAT OK!? hehehe should fix it

Myrkul

hehe thanks so veru much.. but uh it still doesn't work 🙁

WinterDragon

um, wtf is it saying now? hrmph lol

Myrkul

absolutley nothing.. just a blank page

WinterDragon

are you sure you have information in the db?

Myrkul

:/ I used the form and entered info.. didnt give me any errors...
but it also showed me the form again..it didnt:

echo "<font color=\"white\">Thank you! Card Information entered.</font>\n";

like it was supposed to.. here is the form.php code again:

<html>
<header>
<title>STARS Star Wars Cards - Submissions</title>
</header>
<body bgcolor="#000000" text="#ffffff" link="#00ff00" vlink="#3cb371">
<center>
<IMG src= "starsreb.png"  width=174 height=37><br>
<h1>Expansion Set</h1>
<h2><i>Submissions</i></h2>
<p>
</center>
<font size="+1">If you are sending in more than one card idea, you may leave off your email address & fleet, on all but the first card idea.<br>
Special abilities maybe entered either by putting them in the flavour text or using the buttons at the bottom of the Character section.<br>
After sending one card idea, before typing in the next one, you will need to clear all the fields by pressing "CLEAR". Wow that's a novel idea!<p>
To submit a Finished Card Image, save it as a GIF file & email it to <a href="mailto:seb_sb@hotmail.com">Johny Storm</a>, with a Subject line of "STARS Cards".<p> 
<center>
</font>
<?php
if ($submit) {
 // process form
  $db = mysql_connect ("localhost", "user", "pass") or die ('I cannot connect to the database.. darnit.');
  mysql_select_db ("swhyperspace") or die ("damn!"); 
 $sql = "INSERT INTO cards (alias,email,fleet,title,side,destiny,deploy,forfiet,power,abilman,speed,arm,lore,game,image,type,type2,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11) VALUES ('$malias','$memail','$mfleet','$mtitle','$mside','$mdestiny','$mdeploy','$mforfiet','$mlore','$mpower,'$mabilman','$mspeed','$marm','$mgame','$mimage','$mtype','$mtype2','$mc1','$mc2','$mc3','$mc4','$mc5','$mc6','$mc7','$mc8','$mc9','$mc10','$mc11')";

  $result = mysql_query($sql);

  echo "<font color=\"white\">Thank you! Card Information entered.</font>\n";

} else{



  // display form
  }
 ?>