Click on ListBox...Show a Picture

nicoboy
08:13:11
I am new at programming but I managed to populate my "dvdtitle" listbox with all the movie titles in my MysqL database table "dvd". All I want to be able to next is click any title from the listbox and a picture of the movie would appear in a div id picture lets say. Also I would like to show catagory,rated,releasedate,actors and plot into their respective textarea.

I was told to use ajax, but I dont know how. A simple code would be appreciated. I will study ajax from these beginnings. Thanks

<?php
.
.
.
mysql_select_db("myschoolproject", $con);
$result = mysql_query("SELECT id,title,catagory,rated,release_date,actors,plot FROM dvd ORDER BY title");
?>



My working listbox populated with PHP.....

<?php

echo "<select name=dvdtitle size='10' value='' class=movies>Choose movie</option>";

while($row = mysql_fetch_array($result)) {
echo "<option value=$row[id]>$row[title]</option>";
}

echo "</select>";// Closing of list box

//mysql_close($con);
?>
cabalsdemon
06-09-2012
so from your dropdown box you want to make it so when you click it it goes to a page that shows the picture of it
Please Login to post your reply or start a new topic