Can anyone see the problem :\

[illuz1on]

Hey, I have a problem which I havent been able to overcome, and its killing me!! Please can someone help me fix this piece of code - When beaches.php is reached i want it to display the list of beaches, and when one of those beaches is clicked it displays the 'more info' of that specific beach. And then has a link back to beaches.php to see the list again.

 

Would love any suggestions! Thanks

 

 

<?php

require_once('db.php');

 

if (isset($_GET['view']))

{

$sql = "SELECT * FROM beaches";

$data = mysql_query($sql);

while($record = mysql_fetch_assoc($data))

{

$id = $record['id'];

$name2 = $record['name'];

    $picture = $record['picture'];

    $rating = $record['rating'];

    $desc = $record['desc'];

 

echo "$id, $name2, $picture, $rating, $desc";

 

}

?>

<font class="header">Cape Town Beaches</font><br>

<br>

<?php

$sql = "SELECT * FROM shops";

$data = mysql_query($sql);

while($record = mysql_fetch_assoc($data))

{

 

        echo "<a href="beaches.php?view=$id&name=$name2"><$name2><br></a>";

}

?>

[Orio]

So... What's the problem with the script?

 

Orio.

[JasonLewis]

echo "<a href="beaches.php?view=$id&name=$name2"><$name2>
</a>";

 

to this:

 

echo "<a href='beaches.php?view={$id}&name={$name2}'>{$name2}</a>";

[illuz1on]

Thanks for the quick response...

I tried putting that line in and ..

 

 

Parse error: parse error, unexpected $ in /home/capetown/public_html/beaches.php on line 30

 

 

[redarrow]

<?php
require_once('db.php');

if (isset($_GET['view']))
{
$sql = "SELECT * FROM beaches";
$data = mysql_query($sql);
while($record = mysql_fetch_assoc($data))
{
   $id = $record['id'];
   $name2 = $record['name'];
    $picture = $record['picture'];
    $rating = $record['rating'];
    $desc = $record['desc'];

echo "$id, $name2, $picture, $rating, $desc";

}
?>
   <font class="header">Cape Town Beaches</font>

      

         <?php
$sql = "SELECT * FROM shops";
$data = mysql_query($sql);
while($rec = mysql_fetch_assoc($data))
            {
   $id = $rec['id'];
   $name2 = $rec['name'];
   

         echo "<a href='beaches.php?view=$id&name=$name2'><$name2>
[/url]";
}
         ?>

[illuz1on]

Still getting the same error

 

Parse error: parse error, unexpected $ in /home/capetown/public_html/beaches.php on line 37

[JasonLewis]

try this:

 

<?php
require_once('db.php');

if (isset($_GET['view']))
{
$sql = "SELECT * FROM beaches";
$data = mysql_query($sql);
while($record = mysql_fetch_assoc($data))
{
   $id = $record['id'];
   $name2 = $record['name'];
    $picture = $record['picture'];
    $rating = $record['rating'];
    $desc = $record['desc'];

echo "$id, $name2, $picture, $rating, $desc";

}
?>
   <font class="header">Cape Town Beaches</font>

      

         <?php
$sql = "SELECT * FROM shops";
$data = mysql_query($sql);
while($rec = mysql_fetch_assoc($data))
            {
   $id = $rec['id'];
   $name2 = $rec['name'];
   

         echo "<a href='beaches.php?view=$id&name=$name2'><$name2>
[/url]";
}
}
         ?>

[legohead6]

this

 

<?php
require_once('db.php');

if (isset($_GET['view']))
{
$sql = "SELECT * FROM beaches";
$data = mysql_query($sql);
while($record = mysql_fetch_assoc($data))
{
   $id = $record['id'];
   $name2 = $record['name'];
    $picture = $record['picture'];
    $rating = $record['rating'];
    $desc = $record['desc'];

echo "$id, $name2, $picture, $rating, $desc";

}
}
?>