";
$sql1="select * from arveres.arveres_tetel where binary tetel_szam='$tetel_szam'";
$result1=mysqli_query($link, $sql1);
while ($row1 = mysqli_fetch_assoc($result1)){
$state=$row1['aktiv'];
if ($state==0){
$state='Eladva: ';
}
// $state=$row1['aktiv'];
if ($state==3){
$state='Visszavásárolva: ';
}
// $state=$row1['aktiv'];
if ($state==1){
$state='';
}
if ($state==5){
$state='';
}
$sql="select * from arveres.arveres_ajanlat where tetel_szam='$tetel_szam' order by ajanlat desc limit 1";
$result=mysqli_query($link, $sql);
while ($row = mysqli_fetch_assoc($result)){
//$tetel_sz=$row['tetel_szam'];
$ajanlat=$row['ajanlat'];
$usera=$row['user'];
$userb=$row['user'];
// $usera='sanyi';
if ($usera=='alap')
{
$usera='';
} else $usera='';
// $time_s=$row['time_stamp'];
// $time1=explode('-',$time_s);
// $time2=explode(':',$time1[2]);
// echo "$time1[1]-$time2[0]:$time2[1]";
if ($state=='Eladva: ' or $state=='Visszavásárolva: ' or $state==''){
// if (1=1){
$sql15="select * from arveres.arveres_fhnev where user='$userb'";
$result15=mysqli_query($link, $sql15);
while ($row15 = mysqli_fetch_assoc($result15)){
$usera=$row15['user_nev'];
// $arr=array('tarcsa1','tarcsa2');
}
if ($userb=='tarcsa1' or $userb=='tarcsa2' or $userb=='tarcsa3' or $userb=='tarcsa4' or $userb=='tarcsa5' or $userb=='tarcsa6' or $userb=='tarcsa7' or $userb=='tarcsa8' or $userb=='tarcsa9' or $userb=='tarcsa10'
or $userb=='tarcsa11' or $userb=='tarcsa12' or $userb=='tarcsa13' or $userb=='tarcsa14' or $userb=='tarcsa15' or $userb=='tarcsa16' or $userb=='tarcsa17' or $userb=='tarcsa18' or $userb=='tarcsa19' or $userb=='tarcsa20'
or $userb=='tarcsa21' or $userb=='tarcsa22' or $userb=='tarcsa23' or $userb=='tarcsa24' or $userb=='tarcsa25' or $userb=='tarcsa26' or $userb=='tarcsa27' or $userb=='tarcsa28' or $userb=='tarcsa29' or $userb=='tarcsa30'){
$sql25="select * from arveres.tarcsa where tarcsa='$userb'";
$result25=mysqli_query($link, $sql25);
while ($row25 = mysqli_fetch_assoc($result25)){
$usera=$row25['tarcsa_alias'];
}
// $usera='jo';
}
}
// echo "
$state ".number_format($ajanlat, 0, ',',' ')." Ft $usera