[Resolved] [Resolved] [Resolved] [Resolved] A few questions about tables and more.

[cmccomas]

1. I have a table that I have the date and recent headlines. I'd like to display the 2nd-6th most recent entries.

ORDER BY timestamp DESC ???[.b]

2. The table is setup like the following, 5 rows, 3 columns. The columns are Date | blankspace | News Headline

Do I inlucde the <tr> tags inside the loop?

3. When I want to enter something in to the mySQL database as a link, say I enter www.phpbuilder.com, how do I get that to come out right? <a href="<?php echo $row->headline; ?>"><a/>

If that's wrong, how can I do this?

Thanks in advance

[Pig]

1) ...ORDER BY date LIMIT 1, 5

2) That completely depends on how you are structuring it, and we don't have enough information to know that. Put into the loop everything that you want to repeated.

3) echo("<a href=\"$row[link]\">$row[link]</a>");

[Pig]

for #3, if you entered just the www.domain.com, instead of the full URL, then you would want to do:
echo("<a href=\"http://$row[link]\">$row[link]</a>");

I prefer to have 2 columns, one for link url, and one for link text.
echo("<a href=\"$row[link_url]\">");
if( empty($row[link_text]) ) echo($row[link_url]);
else echo($row[link_text]);
echo("</a>");

[cmccomas]

Pig, thanks!

I enter the domains http://www.domain.com in the database.

In the database I have a field for sitename and address.

sitename would be My Site
address would be http://www.domain.com

I want the output to look like:

<a href="http://www.domain.com" class="link">My Site</a>

[cmccomas]

Also, is this right:

<a href="http://www.domain.com/story.php?id=<?php echo $row->id; ?>" class="storyLink">more...</a>

the link works it opens whatever, but the text displayed on story.php no matter what id is is the most recent entry.

[Pig]

Are you really using classes? If you are not, then it would be $row[id] not $row -> id.

I would really have to see the script to answer the rest of your question.

[cmccomas]

Here's the code.

	<? 
// 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, sitename, address FROM launches ORDER BY id DESC LIMIT 0, 2"; 
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error()); 

// if records present
if (mysql_num_rows($result) > 0)
{
	// iterate through resultset
	// print article titles
	while($row = mysql_fetch_object($result))
	{
	?>
	<a href="URL" class="storyLink"><?php echo $row->sitename; ?></a><br>
	<?
	}
}
// if no records present
// display message
else
{
?>
	<font class="storyText">No recent site launches.</font>
<?
}

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

[cmccomas]

Can anyone please help? It's really important!

[Pig]

2 things.

First, you need to use $row[column], not $row -> column
Second, you are only using "URL" for the link, not the address.

while($row = mysql_fetch_object($result))
{
echo("<a href='$row[address]' class='storyLink'>$row[sitename]</a><br> ");
}

[cmccomas]

Pig, thanks man!

Sorry to be s uch a bother.