<?php // Include config file require_once "configs.php"; $sql="select * from dyna left join users on dyna.ownerid=users.id join fixa on fixa.id=dyna.packid group by dyna.packid,fixa.title"; $res = $db->query($sql); if ($res) { $i=0; while ($row = $res->fetchArray()) { echo "<br>"; $tlink="<a href=superuser_va.php?id=".$row['ownerid']."&username=".$row['username']."&guser=".$row['guser']."&packid=".$row['id']."&title=".urlencode($row['title'] ).">"; $mlink="<a href=zprog_listi.php?id=".$row['ownerid']."&username=".$row['username']."&guser=".$row['guser']."&packid=".$row['id']."&tas=".$row['tas']."&title=".urlencode($row['title'] ).">"; $loca="zprog_listi.php?packid=".$row['id']."&tas=".$row['tas']."&title=".urlencode($row['title'] ); echo "<tr onclick=window.location='".$loca."'>"; //echo "<td>".substr($row["title"],0,150)."(".$row["packid"].")"."</td>"; if ($_SESSION['lang']=="en") $title=$row['title']; else $title=$row['title_th']; //echo "<td>" . $title. "</td>"; echo "<td>".$mlink .$title."</a></td>"; echo "<td>".$row["tas"]."</td>"; $i++; } if ($i>0) { echo 'OK';} else {echo "NO";} $db->close(); } ?>
Edit file:zprog_list-20210911135240.php1639