Changeset 4546


Ignore:
Timestamp:
Jan 8, 2004, 10:01:04 PM (16 years ago)
Author:
matt
Message:

Sync with the original version (use id instead of timestamp)

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/www/fr/includes/functions.inc

    r4054 r4546  
    11<?php
    22
    3 # $Id: functions.inc,v 1.3 2003/11/25 02:35:05 matt Exp $
     3# $Id: functions.inc,v 1.4 2004/01/08 22:01:04 matt Exp $
    44# Copyright (c) 2003, OpenDarwin
    55
     
    1919  global $DOCUMENT_ROOT, $connect;
    2020
    21   $query = "SELECT id, title, news FROM headlines ORDER BY timestamp DESC LIMIT 10";
     21  $query = "SELECT id, title, news FROM headlines ORDER BY id DESC LIMIT 10";
    2222  $result = mysql_query($query) or die("Error: $query.");
    2323  if(!$result) {
     
    7777  global $connect;
    7878
    79   $query = "SELECT id, DATE_FORMAT(timestamp, '%e %b %Y, %l:%i %p') AS f_timestamp, title, news FROM headlines ORDER BY timestamp DESC LIMIT 5";
     79  $query = "SELECT id, DATE_FORMAT(timestamp, '%e %b %Y, %l:%i %p') AS f_timestamp, title, news FROM headlines ORDER BY id DESC LIMIT 5";
    8080  $result = mysql_query($query) or die("Error: $query.");
    8181  if(!$result) {
     
    239239  echo "<p>Voici ci-dessous la liste de toutes les d&eacute;p&ecirc;ches existantes. Elles peuvent &ecirc;tre visualis&eacute;es, &eacute;dit&eacute;es, ou effac&eacute;es depuis cette interface. Vous pouvez &eacute;galement <a href=\"add.php\">ajouter une d&eacute;p&ecirc;che</a>.</p>\n\n";
    240240
    241   $query = "SELECT id, title, DATE_FORMAT(timestamp, '%e %b %Y, %l:%i %p') AS f_timestamp FROM headlines ORDER BY timestamp DESC";
     241  $query = "SELECT id, title, DATE_FORMAT(timestamp, '%e %b %Y, %l:%i %p') AS f_timestamp FROM headlines ORDER BY id DESC";
    242242  $result = mysql_query($query) or die("Error: $query.");
    243243  if(!$result) {
Note: See TracChangeset for help on using the changeset viewer.