Resolved trying to get only one row [Archive]

Rockonmetal

10-04-2008, 10:12 PM

Now that the time is all fixed I am having a problem with displaying the info. This system is similar to myspace's and facebook's one.
I only want to display one row
i developed this system but it isn't working...

<?php
}
mysql_select_db("markmon_getaband_feeds", $con);

$result = mysql_query("SELECT * FROM status WHERE user_id='$id'");

while($row = mysql_fetch_array($result))
$i=0;
{
if($i<1){
echo $row['message'];
echo " ";
$time = $row['time'];
$current = time();
$passed = $current-$time;
if($passed<=10){
echo "a few seconds ago...";
}
if($passed>10 && $passed<60){
echo $passed . " seconds ago";
}
if($passed>=60 && $passed<=120){
echo round($passed/60) . " minute ago";
}
if($passed>=121 && $passed<599){
echo round($passed/60) . " minutes ago";
}
if($passed>600){
echo round($passed/600) . " hours ago";
}
if($passed>86400 && $passed<172800){
echo "yesterday.";
}
if($passed>172800){
echo " On " . $row[weekday];
}
$i=40;
}

else{
}
}
?>

i get this result "24832729 hours ago On"
thanks up front

Nile

10-05-2008, 01:17 AM

Here:

<?php
}
mysql_select_db("markmon_getaband_feeds", $con);

$result = mysql_query("SELECT * FROM status WHERE user_id='$id'");
$xa = 0;

while($row = mysql_fetch_array($result) && $xa<=1)
$i=0; $xa+=1;
{
if($i<1){
echo $row['message'];
echo " ";
$time = $row['time'];
$current = time();
$passed = $current-$time;
if($passed<=10){
echo "a few seconds ago...";
}
if($passed>10 && $passed<60){
echo $passed . " seconds ago";
}
if($passed>=60 && $passed<=120){
echo round($passed/60) . " minute ago";
}
if($passed>=121 && $passed<599){
echo round($passed/60) . " minutes ago";
}
if($passed>600){
echo round($passed/600) . " hours ago";
}
if($passed>86400 && $passed<172800){
echo "yesterday.";
}
if($passed>172800){
echo " On " . $row[weekday];
}
$i=40;
}

else{
}
}
?>

Rockonmetal

10-08-2008, 06:53 PM

It still doesn't work... here is the code now:

<?php session_start();?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<link href="../css/menu.css" media="screen" rel="stylesheet" type="text/css" />
<link href="../css/main.css" media="screen" rel="stylesheet" type="text/css" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Getaband.net: Get out there and play!</title>
</head>
<body>
<?php
$email = $_SESSION[''];
$password = $_SESSION[''];
$id = $_SESSION[''];
$con = mysql_connect("localhost","","");
if(!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("markmon_getaband_users", $con);

$result = mysql_query("SELECT * FROM users WHERE id='$id'");

while($row = mysql_fetch_array($result))
{
?>
<center>
<table align="center" width="750">
<tr>
<td colspan="2" align="center">
<img src="../media/banner.png" /></td>
</tr>
<tr>
<td height="196" width="180" valign="top">
<div class="arrowgreen">
<ul>
<li><a href="index.php" title="Home">Home</a></li>
<li><a href="../blog.php" title="Team Blog">Team Blog</a></li>
<li><a href="../musicianscp/tour.php" title="Tour Getaband.net">Take a tour</a></li>
</ul>
</div>
<br />
<div class="arrowgreen">
<ul>
<li><a href="edit.php?edit=profile" title="Edit your profile">Edit your profile</a></li>
<li><a href="edit.php?edit=pictures" title="Edit your pictures">Edit your pictures</a></li>
<li><a href="edit.php?edit=media" title="Edit your media">Edit your media</a></li>
<li><a href="edit.php?edit=settings" title="Edit your settings">Edit your settings</a></li>
<li><a href="edit.php?edit=account" title="Edit your account">Edit your account</a></li>
<li><a href="edit.php?edit=blog" title="Edit your blog">Edit your blog</a></li>
<li><a href="inbox.php?display=home" title="Your Inbox">Your Inbox</a></li>
<li><a href="requests.php?display=home" title="Your Requests">Your Requests</a></li>

</ul>
</div>
<br />
</td>
<td align="left" valign="top">
<div class="profilebox">
<fieldset>
<span class="subheader">What are you doing right now?</span>
<br /><span class="status" id="status">
<?php

}
mysql_select_db("markmon_getaband_feeds", $con);

$result = mysql_query("SELECT * FROM status WHERE user_id='$id'");
$xa = 0;

while($row = mysql_fetch_array($result) && $xa<=1)
{
$a1 = $row['time'];
$current = time();
$passed = $current-$a1;
if($passed<=10 && $passed>0){
echo "a few seconds ago...";
}
if($passed>=11 && $passed<=59){
echo $passed . " seconds ago";
}
if($passed>=60 && $passed<=120){
echo round($passed/60) . " minute ago";
}
if($passed>=121 && $passed<599){
echo round($passed/60) . " minutes ago";
}
if($passed>=600){
echo round($passed/600) . " hours ago";
}
if($passed>86400 && $passed<1727999){
echo "yesterday.";
}
if($passed>=172800){
echo " On " . $row[weekday];
}
else{
echo "Error Getting Time";
}
$xa=1;
}
?>
<br />
<form action="../forms/update_status.php" method="post">
<input type="text" name="status" size="50" value="What are you doing right now?" onFocus="if(this.value=='What are you doing right now?')this.value='';">
<input type="submit" value="Update" class="button"/>
</form>
</fieldset>
<br /><span class="status"><b>Friend's Name</b> is currently doing this.
<a href="../forms/comment_updates.php?id=1&ref=home">Comment</a></span>
<br />
<span class="status"><b>Friend's Name</b> is currently doing this.
<a href="../forms/comment_updates.php?id=2&ref=home&for=status">Comment</a></span></div>
<p> </p></td>
</table>
</center>

<div>

</div>

</body>
</html>

I still get: "2039153 hours ago On "
I also cleared out the rows and added a new one... Though i still get this message...

Rockonmetal

10-08-2008, 07:17 PM

script now works I had to change a couple of things though...
Instead of the old while, I now have this:

while(($row = mysql_fetch_array($result)) && $xa<=1)

Then

if($passed>=600 && $passed<=86400){

and then took out the error message...