[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r4402 - phpcompta/trunk/include
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r4402 - phpcompta/trunk/include |
Date: |
Fri, 18 Nov 2011 14:46:05 +0100 (CET) |
Author: danydb
Date: 2011-11-18 14:46:04 +0100 (Fri, 18 Nov 2011)
New Revision: 4402
Modified:
phpcompta/trunk/include/ajax_auto_anc_card.php
Log:
0000462: Autocompletion po_name
Modified: phpcompta/trunk/include/ajax_auto_anc_card.php
===================================================================
--- phpcompta/trunk/include/ajax_auto_anc_card.php 2011-11-18 13:44:37 UTC
(rev 4401)
+++ phpcompta/trunk/include/ajax_auto_anc_card.php 2011-11-18 13:46:04 UTC
(rev 4402)
@@ -7,12 +7,12 @@
$user->check_dossier($_GET['gDossier']);
if ( isset($_REQUEST['pa_id']) )
{
- $res=$cn->exec_sql("select po_id,po_description from poste_analytique
where pa_id=$1 ~* and (po_description ~* $2 or po_id ~* $3 order by po_id limit
12",
+ $res=$cn->exec_sql("select po_id,po_description from poste_analytique
where pa_id=$1 ~* and (po_description ~* $2 or po_name ~* $3 order by po_id
limit 12",
array($_REQUEST['pa_id'],$_POST['anccard'],$_POST['anccard']));
}
else
{
- $res=$cn->exec_sql("select po_id,po_description from poste_analytique
where po_description ~* $1 or po_id ~* $2 order by po_id limit 12 ",
+ $res=$cn->exec_sql("select po_id,po_description from poste_analytique
where po_description ~* $1 or po_name ~* $2 order by po_id limit 12 ",
array($_POST['anccard'],$_POST['anccard']));
}
$nb=Database::num_row($res);
@@ -21,7 +21,7 @@
{
$row=Database::fetch_array($res,$i);
echo "<li>";
- echo $row['po_id'];
+ echo $row['po_name'];
echo '<span class="informal"> '.$row['po_description'].'</span></li>';
}
echo "</ul>";
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r4402 - phpcompta/trunk/include,
phpcompta-dev <=