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 |