Is it my code or the server?

cmccomas

Here's my code, it won't work, is it my code or the server?

<?
// 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)
{
?>

<font class="headlineText"><? echo $row->headline; ?></font>
<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);
?>

onyx

This will show a table of the results:


<?php

// 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 
?>
<table>
<?php
while($row = mysql_fetch_object($result)) 
{
// print details 
?> 
     <tr><td>
    <font class="headlineText"><?php echo $row->headline;?></font> </td>
    <td> 
    <font class="storyText"><?php echo $row->story; ?></font> </td>


<?php 
} 
?>
</table>

cmccomas

Thanks, but it's still not working, is it my code?

this is all that shows up when i go to the page:

headline; ?>
story; ?>
This story could not be located in our database.

onyx

I have just noticed I had a $ before the column names and I have changed this.

Give that code a try and explain exactly what it does.

cmccomas

<? echo $row->story; ?>

<? echo row->story; ?>

onyx

no, as I said I had corrected the script itself. Just copy and paste the script and see what the result is.

cmccomas

sorry, either way still not working.