%s: Connect failed: %s

",__FILE__,mysqli_connect_error()); exit(); } $array=array('select distinct `DVD` from `movies` order by `DVD`'); $query=implode("",$array); if ($stmt = $mysqli1->prepare($query)) { $stmt->execute(); $stmt->bind_result($dvd); while($stmt->fetch()) { printf("%s
",$dvd,$dvd); } $stmt->close(); } $mysqli1->close(); ?>