|
# 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 where id like '$Cat'",$link);
$f1=mysql_fetch_array($r1);
$c=$f1[catname];
{
$r=mysql_query("select * from clear 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 "Продукция | ";
echo "$f[prod] | ";
echo "Представитель | ";
echo "$f[person] | ";
echo "Адрес | ";
echo "$f[addr] | ";
echo "Страна | ";
echo "$f[state] | ";
echo "Описание | ";
echo "$f[com] | ";
echo "E-mail/Web-сайт | ";
echo "$f[mail] $f[url] | |