Ver Mensaje Individual
  #3 (permalink)  
Antiguo 20/11/2009, 05:20
edugilc
 
Fecha de Ingreso: octubre-2009
Mensajes: 154
Antigüedad: 14 años, 6 meses
Puntos: 0
Respuesta: sacar informacion varias veces por pantalla

el progrmaa llama a esta funcion cuando el nombre corresponde






function Insertion_Search($scriptname)

{


global $HTTP_POST_VARS;

global $MySQL;



$firstname = $HTTP_POST_VARS[firstname_html];


$lastname = $HTTP_POST_VARS[lastname_html];





$tpl = new FastTemplate(".");

$tpl->define(array("main" => $scriptname));


if (empty($firstname))
{
$sql = "select firstname, surname, company, address, postcode, tel, mobile_phone, fax, email, country

from customers

where (surname = '$lastname')";


$result = send_sql($MySQL->db1, $sql);
}
elseif (empty($lastname))
{
$sql = "select firstname, surname, company, address, postcode, tel, mobile_phone, fax, email, country

from customers

where (firstname = '$firstname')";
$result = send_sql($MySQL->db1, $sql);
}
else
{
$sql = "select firstname, surname, company, address, postcode, tel, mobile_phone, fax, email, country

from customers

where (firstname = '$firstname') and (surname = '$lastname')";



$result = send_sql($MySQL->db1, $sql);
}

//if($row=mysql_fetch_array($result))

if (!$result)

{

die ("Database Error");
}


while ($value=mysql_fetch_array($result))

{

$tpl->assign(FIRST_VALUE, $value["firstname"]);
$tpl->assign(LAST_VALUE, $value["surname"]);
$tpl->assign(COMPANY_VALUE, $value["company"]);
$tpl->assign(ADDRESS_VALUE, $value["address"]);
$tpl->assign(POSTCODE_VALUE, $value["postcode"]);
$tpl->assign(TEL_VALUE, $value["tel"]);
//$tpl->assign(MOBIL_PHONE_VALUE, $value["mobile_phone"]);
$tpl->assign(FAX_VALUE, $value["fax"]);
$tpl->assign(EMAIL_VALUE, $value["email"]);
$tpl->assign(COUNTRY_VALUE, $value["country"]);

}


$tpl->parse(result, "main");

$tpl->FastPrint(result);



}





el problema es cuando hay dos clientes con el mismo nombre solo me muestra un cuadro en el template pero yo kiero un cuadro para cada uno de mis clientes..