Help with Error Message

cmccomas

Getting this error:

Parse error: parse error, expecting ','' or';'' in /hsphere/local/home/mccomas/dariuswatts.com/dw/index.php on line 67

From this code (bolded the code that is line 67):

 <? 
// includes 
include("conf.php"); 

// open database connection 
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 

// select database 
mysql_select_db($db) or die ("Unable to select database!"); 

// generate and execute query 
$query = "SELECT id, headline, story FROM news ORDER BY id DESC LIMIT 0, 10"; 
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error()); 

// get resultset as object 
$row = mysql_fetch_object($result); 

// print details 
if ($row) 
{ 
?> 

[b]<font class="headlineText"><? echo row->headline; ?></font>[/b] 
<br> 
<font class="storyText"><? echo row->story; ?></font> 


<? 
} 
else 
{ 
?> 
    <p> 
    <font class="storyText">This story could not be located in our database.</font> 
<? 
} 

// close database connection 
mysql_close($connection); 
?>

therealchuckles

Heh, I'm alright at PHP, nothing special, but I'll try to help.

Ok, replace this

<font class="headlineText"><? echo row->headline; ?></font> 
<br> 
<font class="storyText"><? echo row->story; ?></font>

with this:

<font class="headlineText"><? echo $row->headline; ?></font> 
<br> 
<font class="storyText"><? echo $row->story; ?></font>

Since $row is a variable, I would imagine you would need to prefix row with a $ when echoing it.
Ok, good luck.

cmccomas

Thanks, now I have this line of code:

$query = "SELECT id, headline, story FROM news ORDER BY id DESC LIMIT 0, 10";

I want it to show the ten most recent entries based on id, is this line of code correct then?

therealchuckles

According to the mySQL documentation, this code will return the first 10 items.

SELECT name FROM customers LIMIT 10

cmccomas

Trying to get the php to return the 10 most recent stories and display them, what am I doing wrong? Right now, it's only showing the single most recent.

 <? 
// includes 
include("conf.php"); 

// open database connection 
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 

// select database 
mysql_select_db($db) or die ("Unable to select database!"); 

// generate and execute query 
$query = "SELECT id, headline, story, timestamp FROM news ORDER BY timestamp LIMIT 10"; 
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error()); 

// get resultset as object 
$row = mysql_fetch_object($result); 

// print details 
if ($row) 
{ 
?>
      <font class="headlineText"><? echo $row->headline; ?></font> <br> <font class="storyText"><? echo $row->story; ?></font> <br><br>
      <? 
} 
else 
{ 
?>
      <p> <font class="storyText">This story could not be located in our database.</font> 
        <? 
} 

// close database connection 
mysql_close($connection); 
?>

laserlight

you need to loop through the result set.