From 680c48ba6488905886e1877662621063a83aafd5 Mon Sep 17 00:00:00 2001
From: x2000habouzit <x2000habouzit>
Date: Tue, 12 Oct 2004 16:11:49 +0000
Subject: [PATCH] closes FS#90 :
 https://www.polytechnique.org/marketing/ins_confirmees.php
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

 page complètement buggée, le message d'erreur parle de lui-même :

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/web/prod/public/include/xorg.page.inc.php on line
---
 htdocs/marketing/ins_confirmees.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/htdocs/marketing/ins_confirmees.php b/htdocs/marketing/ins_confirmees.php
index c1a09a5..95986d3 100644
--- a/htdocs/marketing/ins_confirmees.php
+++ b/htdocs/marketing/ins_confirmees.php
@@ -18,7 +18,7 @@
  *  Foundation, Inc.,                                                      *
  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  ***************************************************************************
-        $Id: ins_confirmees.php,v 1.3 2004-09-02 23:57:48 x2000bedo Exp $
+        $Id: ins_confirmees.php,v 1.4 2004-10-12 16:11:49 x2000habouzit Exp $
  ***************************************************************************/
 
 require("auto.prepend.inc.php");
@@ -30,7 +30,7 @@ $sql = "SELECT a.alias AS forlife,u.date_ins,u.promo,u.nom,u.prenom
         FROM       ins_confirmees AS i
         INNER JOIN auth_user_md5  AS u ON i.id=u.user_id
         INNER JOIN aliases        AS a ON (u.user_id = a.id AND a.type='a_vie')
-        ORDER BY a.{$_GET['sort']} DESC";
+        ORDER BY u.{$_GET['sort']} DESC";
 $page->mysql_assign($sql, 'ins', 'nb_ins');
 
 $page->run();
-- 
2.1.4