$servername = "localhost"; $username = "momotanisp"; $password = "Aceshigh-6969"; $dbname = "ispcompare"; // Create connection $conn = mysqli_connect($servername, $username,$password, $dbname); // Check connection if (!$conn) { die("Database connection couldn't be eatablish: " . mysqli_connect_error()); } if(isset($_GET['states'])){ $ispstates=$_GET['states']; $full=$_GET['statename']; $fullname=trim($full,'.php'); // $full=$_GET['full']; $ispdata = "SELECT * FROM ispdata INNER JOIN plans ON plans.name = ispdata.`DBA Name` WHERE Consumer = 1 AND ispdata.`State` = '$ispstates' GROUP BY ispdata.`DBA Name` ORDER BY plans.priority DESC"; $ispresult = mysqli_query($conn, $ispdata) or die(mysqli_error($conn)) ; } ?>