PHP Forum

**scottsgameroom** · 05-20-2005, 06:35 PM

I have coded the following page to utilist my database but i get the following error:

Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in /freeola/users/8/2/sr0173228/htdocs/testingground/top.php on line 34

here is my code

PHP Code:


			
<html>

<head>

<title>Scotts Game Room Portal</title>

<style><!--a:hover{color:yellow; text-decoration:none; }--></style>

<style>a{text-decoration:none}    </style>

</head>

<body bgcolor=white text=cccccc topmargin=0 leftmargin=0 link=458DE5 alink=458DE5 vlink=458DE5>

<center>

<?php

include 'db_connect.php';



$sql = "SELECT * FROM headerinfo";



$result = mysql_query($sql);

$results = mysql_fetch_array($result);



$spotlightimage = $results["spotlightimage"];

$spotlighttext = $results["spotlighttext"];

$spotlightlink = $results["spotlightlink"];

$newsimage = $results["newsimage"];

$newstext = $results["newstext"];

$newslink = $results["newslink"];

$reviewsimage = $results["reviewsimage"];

$reviewstext = $results["reviewstext"];

$reviewslink = $results["reviewslink"];

$previewsimage = $results["previewsimage"];

$previewstext = $results["previewstext"];

$previewslink = $results["previewslink"];



echo "



<br>

<table width=97% cellspacing=0 cellpadding=0 border=0 bordercolor=black>

    <tr><td bgcolor=458DE5 width=25% style="border: 1px solid #000000"><font face=arial size=1 color=white>&nbsp;Spotlight</td>

    <td bgcolor=458DE5 width=25% style="border: 1px solid #000000"><font face=arial size=1 color=white>&nbsp;News</td>

    <td bgcolor=458DE5 width=25% style="border: 1px solid #000000"><font face=arial size=1 color=white>&nbsp;Reviews</td>

    <td bgcolor=458DE5 width=25% style="border: 1px solid #000000"><font face=arial size=1 color=white>&nbsp;Previews</td></tr>

    <tr><td bgcolor=cccccc width=25% style="border: 1px solid #000000"><center><img src="$spotlightimage"></td>

    <td bgcolor=cccccc width=25% style="border: 1px solid #000000"><center><img src="$newsimage"></td>

    <td bgcolor=cccccc width=25% style="border: 1px solid #000000"><center><img src="$reviewsimage"></td>

    <td bgcolor=cccccc width=25% style="border: 1px solid #000000"><center><img src="$previewsimage"></td></tr>

    <tr><td bgcolor=041A6E width=25% style="border: 1px solid #000000"><font face=arial size=1>$spotlighttext

    <br><a href="$spotlightlink" target="main">Click here for more</a></td>

    <td bgcolor=041A6E width=25% style="border: 1px solid #000000"><font face=arial size=1>$newstext

    <br><a href="$newslink" target="main">Click here for more</a></td>

    <td bgcolor=041A6E width=25% style="border: 1px solid #000000"><font face=arial size=1>$reviewstext

    <br><a href="$reviewslink" target="main">Click here for more</a></td>

    <td bgcolor=041A6E width=25% style="border: 1px solid #000000"><font face=arial size=1>$previewstext

    <br><a href="$previewslink" target="main">Click here for more</a></td></tr>

</table>



";



?>

Hope you can help!

**mikeroq** · 05-20-2005, 06:38 PM

Code:

<tr><td bgcolor=458DE5 width=25% style="border: 1px solid #000000"><font face=arial size=1 color=white>&nbsp;Spotlight</td>

change the "s to 's

cause your echo is using echo ", if it was echo ' it would work,
example

Code:

<?php
echo "<table widht"800">";
?>

wouldnt work
so it has to be

Code:

<?php
echo "<table width='800'>";
?>

**mikeroq** · 05-20-2005, 06:43 PM

in fact just use this cause you did it everywhere

PHP Code:


			
<html>

<head>

<title>Scotts Game Room Portal</title>

<style><!--a:hover{color:yellow; text-decoration:none; }--></style>

<style>a{text-decoration:none}    </style>

</head>

<body bgcolor=white text=cccccc topmargin=0 leftmargin=0 link=458DE5 alink=458DE5 vlink=458DE5>

<center>

<?php

include 'db_connect.php';



$sql = "SELECT * FROM headerinfo";



$result = mysql_query($sql);

$results = mysql_fetch_array($result);



$spotlightimage = $results["spotlightimage"];

$spotlighttext = $results["spotlighttext"];

$spotlightlink = $results["spotlightlink"];

$newsimage = $results["newsimage"];

$newstext = $results["newstext"];

$newslink = $results["newslink"];

$reviewsimage = $results["reviewsimage"];

$reviewstext = $results["reviewstext"];

$reviewslink = $results["reviewslink"];

$previewsimage = $results["previewsimage"];

$previewstext = $results["previewstext"];

$previewslink = $results["previewslink"];



echo '



<br>

<table width=97% cellspacing=0 cellpadding=0 border=0 bordercolor=black>

    <tr><td bgcolor=458DE5 width=25% style="border: 1px solid #000000"><font face=arial size=1 color=white>&nbsp;Spotlight</td>

    <td bgcolor=458DE5 width=25% style="border: 1px solid #000000"><font face=arial size=1 color=white>&nbsp;News</td>

    <td bgcolor=458DE5 width=25% style="border: 1px solid #000000"><font face=arial size=1 color=white>&nbsp;Reviews</td>

    <td bgcolor=458DE5 width=25% style="border: 1px solid #000000"><font face=arial size=1 color=white>&nbsp;Previews</td></tr>

    <tr><td bgcolor=cccccc width=25% style="border: 1px solid #000000"><center><img src="$spotlightimage"></td>

    <td bgcolor=cccccc width=25% style="border: 1px solid #000000"><center><img src="$newsimage"></td>

    <td bgcolor=cccccc width=25% style="border: 1px solid #000000"><center><img src="$reviewsimage"></td>

    <td bgcolor=cccccc width=25% style="border: 1px solid #000000"><center><img src="$previewsimage"></td></tr>

    <tr><td bgcolor=041A6E width=25% style="border: 1px solid #000000"><font face=arial size=1>$spotlighttext

    <br><a href="$spotlightlink" target="main">Click here for more</a></td>

    <td bgcolor=041A6E width=25% style="border: 1px solid #000000"><font face=arial size=1>$newstext

    <br><a href="$newslink" target="main">Click here for more</a></td>

    <td bgcolor=041A6E width=25% style="border: 1px solid #000000"><font face=arial size=1>$reviewstext

    <br><a href="$reviewslink" target="main">Click here for more</a></td>

    <td bgcolor=041A6E width=25% style="border: 1px solid #000000"><font face=arial size=1>$previewstext

    <br><a href="$previewslink" target="main">Click here for more</a></td></tr>

</table>



';



?> <html>

<head>

<title>Scotts Game Room Portal</title>

<style><!--a:hover{color:yellow; text-decoration:none; }--></style>

<style>a{text-decoration:none}    </style>

</head>

<body bgcolor=white text=cccccc topmargin=0 leftmargin=0 link=458DE5 alink=458DE5 vlink=458DE5>

<center>

<?php

include 'db_connect.php';



$sql = "SELECT * FROM headerinfo";



$result = mysql_query($sql);

$results = mysql_fetch_array($result);



$spotlightimage = $results["spotlightimage"];

$spotlighttext = $results["spotlighttext"];

$spotlightlink = $results["spotlightlink"];

$newsimage = $results["newsimage"];

$newstext = $results["newstext"];

$newslink = $results["newslink"];

$reviewsimage = $results["reviewsimage"];

$reviewstext = $results["reviewstext"];

$reviewslink = $results["reviewslink"];

$previewsimage = $results["previewsimage"];

$previewstext = $results["previewstext"];

$previewslink = $results["previewslink"];



echo '



<br>

<table width=97% cellspacing=0 cellpadding=0 border=0 bordercolor=black>

    <tr><td bgcolor=458DE5 width=25% style="border: 1px solid #000000"><font face=arial size=1 color=white>&nbsp;Spotlight</td>

    <td bgcolor=458DE5 width=25% style="border: 1px solid #000000"><font face=arial size=1 color=white>&nbsp;News</td>

    <td bgcolor=458DE5 width=25% style="border: 1px solid #000000"><font face=arial size=1 color=white>&nbsp;Reviews</td>

    <td bgcolor=458DE5 width=25% style="border: 1px solid #000000"><font face=arial size=1 color=white>&nbsp;Previews</td></tr>

    <tr><td bgcolor=cccccc width=25% style="border: 1px solid #000000"><center><img src="$spotlightimage"></td>

    <td bgcolor=cccccc width=25% style="border: 1px solid #000000"><center><img src="$newsimage"></td>

    <td bgcolor=cccccc width=25% style="border: 1px solid #000000"><center><img src="$reviewsimage"></td>

    <td bgcolor=cccccc width=25% style="border: 1px solid #000000"><center><img src="$previewsimage"></td></tr>

    <tr><td bgcolor=041A6E width=25% style="border: 1px solid #000000"><font face=arial size=1>$spotlighttext

    <br><a href="$spotlightlink" target="main">Click here for more</a></td>

    <td bgcolor=041A6E width=25% style="border: 1px solid #000000"><font face=arial size=1>$newstext

    <br><a href="$newslink" target="main">Click here for more</a></td>

    <td bgcolor=041A6E width=25% style="border: 1px solid #000000"><font face=arial size=1>$reviewstext

    <br><a href="$reviewslink" target="main">Click here for more</a></td>

    <td bgcolor=041A6E width=25% style="border: 1px solid #000000"><font face=arial size=1>$previewstext

    <br><a href="$previewslink" target="main">Click here for more</a></td></tr>

</table>



';



?> <?php /* Created on: 5/20/2005 */ ?>

<html>

<body>

<?php



?>

</body>

</html>

**scottsgameroom** · 05-20-2005, 06:44 PM

Thank you so so so so much ive been trying to get this to work for ages...ive finally got round to working on the script and it was that easy!

Cheers rookie mistake! lol

**mtishetsky** · 05-21-2005, 04:01 AM

Why do you use echo to output HTML? You can do it like this:

PHP Code:


			
<html>

<body>

<?

$somevar = define_some_var();

?>

<table>

   <tr>

      <td><?= $somevar?></td>

   </tr>

</table>

</body>

</html>

**scottsgameroom** · 05-21-2005, 05:18 AM

Thats a good point...i just use echo because thats the way i taught myself!

**leavethisplace** · 05-21-2005, 05:53 AM

I always use echo, and i have no idea why, nothin wrong with it is there?