the code is showing too much...

GoSharks

<html>
<head>
<basefont face="Verdana">
</head>

<body>
<?

include("conf.php");

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

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

$query = "SELECT AIM_body.content, AIM_body.timestamp, AIM.id, AIM.title, AIM.timestamp2 FROM AIM_body, AIM WHERE AIM_body.id = '1' ORDER BY timestamp2 DESC";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
if (mysql_num_rows($result) > 0)

{
while($row = mysql_fetch_object($result))
{
?>
<? echo $row->content; ?> 
<? echo $row->timestamp; ?> (Central time)

<li><a href="entry.php?id=<? echo $row->id; ?>"><? echo $row->title; ?></a>
<? echo $row->timestamp2; ?> (Central time)
<?
}
}
else
{
?>
No articles currently available
<?
}

mysql_close($connection);
?>
 
 
<a href=admin/index.php>Admin</a>

</body>
</html>

could someone enlighten me on why this is outputting the AIM_body stuff more than once? it is putting it after the each AIM table stuff, except for the first one. :mad:

example - http://www.wilcoxhs.org/gosharks/aim/example.php

i am trying to see the AIM_body stuff only at the top of the page.

also how can i format the time? i have gone over the date stuff in the manual, but i cant seem to get it to format the timestamp(s) that i have, it only formats the current time.

thanks

GoSharks

bump.. anybody?

diego25

I'm not sure what your problem is, but is it possible that your tag is in the wrong place?

Diego

Weedpacket

First of all, the timestamp; my guess is that if you're storing this in a MySQL date/time type field, you'll be wanting to use MySQL's date formatting functions. If it's a MySQL-style timestamp, the same applies. If it's a Unix-style timestamp, then really, [man]date[/man] will do exactly what you want.

As for the repeated AIM_body; well, I don't know what you're using it for or where it's supposed to be or anything like that, but if you don't want it repeated at all, then you shouldn't put the code to display it inside the loop.

PS. I hate people who go "bump" - all it tells me is that you didn't have a single idea of your own about the problem in nearly nine hours.

GoSharks

Originally posted by Weedpacket
As for the repeated AIM_body; well, I don't know what you're using it for or where it's supposed to be or anything like that, but if you don't want it repeated at all, then you shouldn't put the code to display it inside the loop.

PS. I hate people who go "bump" - all it tells me is that you didn't have a single idea of your own about the problem in nearly nine hours.

i am not sure i follow what you mean by not putting it in a loop, i have been following a model from another website and this is probably the most advanced thing i have ever attempted, putting two seperate things into one page.

i want the AIM_body stuff to be at the top of the page and to be shown only once. there will only be one entry in the table and im trying to show that. have you ever used AIM and heard of a subprofile (lots of ads)? basically im trying to make my own, as my version of aim does not allow for links to be opened in the profile window, and i am unwilling to upgrade.

(and sorry if it bugs you when people bump things, just that i have been staring at this for hours even before i posted it here, this is last resort)