Artyom Sokirko's movie database

&$value) { //if (substr($key,0,6) == 'movie_') if (array_key_exists('id', $_GET) and is_numeric($_GET['id'])) { //$id = substr($key,6); $id = $_GET['id']; $tockenresult = mysqli_query( $con,"SELECT * FROM movies where id = $id") or die(mysqli_error($con)); while($row = mysqli_fetch_array( $tockenresult )) { echo "

" . $row["Movie"] .''; if ($row["Location"]) echo "
Location " . $row["Location"] ; if ($row["Sys"]) echo "
System " . $row["S"] . $row["Sys"] ; if ($row["Sp"]) echo' ' .$row["Sp"] ; if ($row["NEW"]) echo "
Comment " . $row["NEW"]; if ($row["imdb"]) echo "
Director " . $row["Director"] ; if ($row["yea_"]) echo "
Year " . $row["yea_"] ; if ($row["imdb"]) echo "
IMDB"; if ($row["Rank"]) echo "
Rank " . $row["Rank"] ; echo "

"; } } $tockenresult = mysqli_query( $con,"SELECT Movie, ID FROM movies where Movie like '$search%' order by Movie") or die(mysqli_error($con)); ?>

Enter the first letter of the movie title

= '0' group by 1 order by 1" ) or die(mysqli_error($con)); while($row = mysqli_fetch_array( $initialresult )) { echo '' . $row['initiall'] . ' '; } mysqli_close($con); ?>