Ver Mensaje Individual
  #1 (permalink)  
Antiguo 23/11/2009, 14:15
edugilc
 
Fecha de Ingreso: octubre-2009
Mensajes: 154
Antigüedad: 14 años, 6 meses
Puntos: 0
Sacar por pantalla en un template varias tablas

Me podeis echar un ojo a este codigo?Lo que quiero hacer es que me inserte en una tabla los valores del customer.
Si tengo dos o mas customers con el mismo nombre quiero que me salgan tantas tablas como clientes,lo tengo asi pero solo me saca una tabla y arriba con el echo me saca la cuenta de los que son descendente,si hay4 :4 3 2 1

codigo de la funcion que coge los valores y los escribe en una tabla definida en un template:



function Insertion_Search($scriptname)
{

global $HTTP_POST_VARS;
global $MySQL;


$firstname = $HTTP_POST_VARS[firstname_html];

$lastname = $HTTP_POST_VARS[lastname_html];

$table_id = R4decrypt($HTTP_POST_VARS[custolist]);




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


if ((empty($firstname)) and (empty($lastname)) and ($table_id>0))

{
$sql = "select cus_id, firstname, surname, company, address, postcode, tel, mobile_phone, fax, email, country

from customers

where (cus_id = '$table_id')";

$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);
}

elseif (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);
}

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");
}

$num_user=(mysql_num_rows($result));
while ($num_user != 0)
{
echo($num_user);
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(MOBILE_PHONE_VALUE,$value["mobile_phone"]);
$tpl->assign(FAX_VALUE, $value["fax"]);
$tpl->assign(EMAIL_VALUE, $value["email"]);
$tpl->assign(COUNTRY_VALUE, $value["country"]);
}

$num_user--;
}

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

}