I wounder what mysql syntax i use to get last/first row printed that haves a timstamp

Chrysanthus

If i have a first row registerd with a value and the same with the last value how do i put that in a code sow i can print it on the web page in a simpel way!.

i have made it possible sow it registers a timstamp when a value is registerd!

any exampel should do great!!!

mrhappiness

ORDER BY timestampcloumn LIMIT 1
or
ORDER BY timestampcloumn DESC LIMIT 1

should do the job

(in case i understand correctly)

Chrysanthus

Like this or is it wrong??

<?php include ("../management/mysqlcondbrr.php");

$result = mysql_query("SELECT * FROM reg_info ORDER BY LIMIT 1",$starta);

$num_rows = mysql_num_rows($result);

echo "$num_rows \n"; ?>

The thing is that i wanna get the first user register and the last registerd user printed on the web page.... sow how do i management to make to querys at the same time ??

mrhappiness

you have to do two queries

<?phpp
include ("../management/mysqlcondbrr.php");
$result = mysql_query("SELECT * FROM reg_info ORDER BY name_of_column_containing_the_timestamp LIMIT 1",$starta);
$user['first']=mysql_fetch_assoc($result);
$result = mysql_query("SELECT * FROM reg_info ORDER BY name_of_column_containing_the_timestamp  DESC LIMIT 1",$starta);
$user['last']=mysql_fetch_assoc($result);
echo '<pre>';
print_r($user);
echo '</pre>';

Chrysanthus

Thanks man it works but i have only one thing more..

How dow i only print the usernams not the hole value

look i made this changes from your script!

 <?php
include ("./management/mysqlcondbrr.php"); 
$result = mysql_query("SELECT username FROM reg_info ORDER BY regdate LIMIT 1",$starta);

$user['first']=mysql_fetch_assoc($result); 
$result = mysql_query("SELECT username FROM reg_info ORDER BY regdate DESC LIMIT 1",$starta);

$user['last']=mysql_fetch_assoc($result); 
echo '<pre>'; 
print_r($user); 
echo '</pre>'; 

?>

mrhappiness

echo $user['first']['username'];
echo $user['last']['username'];

hth