Need help with syntax

[bmabma]

Hello all,

I have the path to a swf file loaded into a field in a table in a mysql db. Ineed to know how to get that path from the db and loaded into the browser.

When a user clicks on the link my code loads a seperate page and I know this is wrong. Here is what I have so far................

<?php
include ("../config/config.inc");
// start session and bring in session variables
session_start();
// forward to login page if the session is not valid
if(!isset($s_email))
{
        header("Location: logon.htm");     

        exit();
}
// get booths from database
@$link = mysql_connect(SYSTEM,USERNAME,PASSWORD);
if(!$link)
{
    echo "Database seems to be down";
    exit;
}
mysql_select_db(DATABASE) or die( "Unable to select database");
$query = "SELECT * FROM booth where email = '$email'";
$result = mysql_query($query);
if(!$result)
{
     echo "Error - Could not get booth information from database.";
     mysql_close();
    exit;   

}
$row = mysql_fetch_object($result);
echo"
$booth_color "
?>

booth_color is the table field that stores www.website.com/booth.php.

How do I get www.website.com/booth.php into the browser ??

I know it's a syntax problem and I have looked at so many tutorials that I am starting to see double !!

Any suggestions anyone ??

[ClarkF1]

You could try:

while ($row = mysql_fetch_object($result))
{
     $booth = $row->boothcolor;
     header("Location: $booth");
     exit();
}

[FatalError]

When you use mysql_fetch_object, it returns an object. And since you mad $row equal to that, $row is the object. So you'd need to do $row->booth_color, as in ClarkF1's script.