order by date..

[corillo181]

shouldn't this display pictures by date

[code]
<?php
          $query=mysql_query("SELECT * FROM pictures ORDER BY datetime") or die(mysql_error());           $result = mysql_num_rows($query);
          while($pic=mysql_fetch_array($result)){
          echo '<a href=clubsparty/pictures.php'.$pic['name'].'>'.'<img border=0 height=150 width=110 src="clubsparty/3-11-06/'.$pic['name'].'"></a>';
}
          ?>
[/code]

[redarrow]

<?php

$query=mysql_query"SELECT * FROM pictures limit 1" or die("mysql errow");
$result = mysql_num_rows($query);
while($pic=mysql_fetch_array($result)){
echo '<a href=clubsparty/pictures.php'.$pic['name'].'>'.'<img border=0 height=150 width=110 src="clubsparty/3-11-06/'.$pic['name'].'"></a>';
}
?>

[corillo181]

mm ok makin that in to a variable how is that going to help?

[corillo181]

also i notice that if i keep it like that everytime i upload a pic is going to display it..

all i want to do is display a single picture.. the last one uploaded..

[corillo181]

alright all had to do was limit 1 but still i can't get the last pic uploaded to show up..

[corillo181]

ahh forget the time date all i had to do was add ASC to make the last row appear.. come on ppl i keep answering my self :|