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