|
|
|
|
 |
";
echo mysql_error();
exit;
}
mysql_select_db("jdrugs-m_jdrugsmdrugs"); // - название базы!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
/////////////////////////////////////////////////////////////////
// - popular medications
$result = mysql_query("(select name from freedom_new where popular=1) union all (select name from rxpharmacy where popular=1) order by name" );
while($row = mysql_fetch_object($result))
{
echo " ╗ name).".shtml\">$row->name
";
}
mysql_close();
?>
|
|
|
|
| List of drugs A-Z sorted by name |
|
";
echo mysql_error();
exit;
}
mysql_select_db("jdrugs-m_jdrugsmdrugs"); // - название базы!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
$result = mysql_query("select name,replace(name,' ','_') as htmlname from npdlist order by name LIMIT 0, 3500" );
$letter=$n;
$m_i=0;
echo "| $letter | ";
while($row = mysql_fetch_object($result))
{
if ($letter!=substr($row->name,0,1))
{
if (($m_i>0) && ($m_i<3))
{
do
{
$m_i=$m_i+1;
echo " | \n";
}
while ($m_i<3);
echo "\n";
}
$m_i=0;
$letter=substr($row->name,0,1);
echo "| $letter | ";
}
if ($m_i==0)
{
echo "\n";
}
$m_i=$m_i+1;
echo "| htmlname.shtml\" title=\"Order $row->name online\">$row->name | \n";
if ($m_i==3)
{
$m_i=0;
echo " \n";
}
}
if (($m_i>0) && ($m_i<3))
{
do
{
$m_i=$m_i+1;
echo " | \n";
}
while ($m_i<3);
echo "\n";
}
?>
|
|
|
