define("HostName","localhost"); //////////
define("UserName","jdrugs-m");
define("Password","x23RpRe3"); ///////////////
if(!mysql_connect(HostName,UserName,Password)){
echo "Error connected MySQL! ";
echo mysql_error();
exit;
}
mysql_select_db("jdrugs-m_jdrugsmdrugs"); // - название базы!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
echo "\n";
echo " \n";
echo " \n";
echo " \n";
echo " ";
echo " \n";
echo " \n";
echo " | List of drugs A-Z sorted by name ";
echo " | \n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " | Brand Name/Manufactured | \n";
echo " Generic Name/Name Sold As | \n";
echo " \n";
$kol=0;
$result = mysql_query("select name,manuf,alternative,replace(name,' ','_') as htmlname from freedom_new union (select name,manuf,alternative,replace(name,' ','_') as htmlname from medsindia group by name ) order by name LIMIT 0, 900" );
while($row = mysql_fetch_object($result))
{
echo "";
echo " ";
echo " | ";
echo " ";
echo " \n";
echo " | \n";
$kol=$kol+1;
echo "htmlname.shtml\" title=\"Buy $row->name online\">$row->name\n";
echo " Manufactured by $row->manuf | \n";
echo " \n";
if (strlen($row->alternative) > 0)
{
$alt_name=rtrim($row->alternative);
$alt_name_l=$alt_name;
do
{
$posst=strpos($alt_name,',');
if ($posst)
{
$alt_name_l=substr($alt_name,0,$posst);
$nameurl=str_replace(' ','_',$alt_name_l);
echo "$alt_name_l, \n";
}
else
{
$nameurl=str_replace(' ','_',$alt_name_l);
echo "$alt_name_l \n";
break;
}
$alt_name=ltrim(rtrim(substr($alt_name,strpos($alt_name,',')+1,strlen($alt_name))));
$alt_name_l=$alt_name;
}
while (strlen($alt_name)<>0);
}
echo " | \n";
echo " \n";
}
echo "";
echo " | ";
echo "";
echo " ";
echo " | ";
echo " ";
echo " | ";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "| Currently viewing $kol drugs";
echo " | ";
echo " ";
echo "";
echo " ";
echo " | ";
echo " ";
echo "";
echo " ";
echo " | ";
echo "";
echo " ";
mysql_close();
?>
|