|
# Error_Reporting(255/*1+2+4*/);
$DBName="latintraderu";
$HostName="mysql.caravan.ru";
$UserName="latintraderu";
$Port="3306";
$Password="dy5ccw";
$link=mysql_connect($HostName,$UserName,$Password);
if(!$link)
{ echo "îÅ ÍÏÇÕ ÓÏÅÄÉÎÉÔØÓÑ Ó ÂÁÚÏÊ".$DBName."! "; exit; }
$r=mysql_select_db($DBName,$link);
if ($Cat!= "")
$r1=mysql_query("select catname from category_es where id like '$Cat'",$link);
$f1=mysql_fetch_array($r1);
$c=$f1[catname];
{
$r=mysql_query("select * from clear_es where cat like '$Cat'",$link);
if ($r < 0)
{ # error occured
echo "ERROR: $phperrmsg";
exit;
}
$num = mysql_numrows($r);
# echo "$num Records found !
";
$r1=mysql_query("create table list(iden int, id int, cat text, markprod text,
prod text, firm text, person text, addr text, city text, post text, area text,
state text, phone text, fax text, mail text, url text, date text, com text)",$link);
$r1=mysql_query("delete from list",$link);
for($i=0; $i";
echo "$f[firm] | ";
echo "$a | ";
echo "Producto | ";
echo "$f[prod] | ";
echo "Representante | ";
echo "$f[person] | ";
echo "Dirección | ";
echo "$f[addr] | ";
echo "País | ";
echo "$f[state] | ";
echo "Descripción | ";
echo "$f[com] | ";
echo "e-mail/Página Web | ";
echo "$f[mail] $f[url] | |