Shenzi1985

forgot to mark as solved. done it the easy way rolled back to a previous version of php,yadmin that allows to import csv files/ excel files into database much easier

tried that i seem to get some error which i cant figure out why. #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"attribute_values__movie_info"' at line 1 any ideas?

i need to convert a database from sqlite to mysql but not sure how to do it. anyhelp appreciated

im having this issue as well i got the list working and submitting just cant get it to post another result that i need

i still dont understand how this helps? i have my drop down box that submits on selection. i now need to load another item from the database depending on the selection of the drop box. e.g i select avatar from the drop list. (it refreshes the page) now the page has the id number of the film in the addressbar as well but i now want it to load the summary of that film. how do i get it to carry the id number over so i can use that to find the data? im totally new to php and js

$result = mysql_query( "SELECT * FROM movie_info WHERE id = " (int) $_POST['field'] ." LIMIT 1"); it says theres an error on that line. and i cant spot it

thanks. but how do i get it to display for instance a summary of the film, when i select the film from the drop down menu? this is my main problem.

ok im back quicker than i thought.... i got my drop box sorted and i got it reloading the page. so it all works correctly. but how do i get the page to display information regarding the film i have selected in the drop box.? i have no code for this at the mo. also i would like the drop box to display the selected item at top of box when it refreshes code for drop box: <FORM> <?php $result = mysql_query( "SELECT * FROM movie_info ORDER BY title ASC ") ; echo "<select name= Film onChange='submit()' >film name</option>"; while ($nt=mysql_fetch_array($result)){ ?> <?php echo "<option value='$nt[id]'>$nt[title] </option>"; } ?> </select> </FORM> any help would be great

thanks for the quick answer worked great. reason i wanted it like this is so when i select a film name it brings up all the info on that film from the database. so gonna have a play with it now. no doubt i be back soon

im fairly new to php so tend to do trial and error..... more error than trial tbh. im wondering if it is possible to get a drop down menu to fill from a mysql database and to arrange it alphabetically. i have created the menu just dont know how to arrange it better. also how can i use the items id in drop menu to load other info from that row on the database. hope you can help me. <FORM> <?php $result = mysql_query( "SELECT * FROM movie_info" ) ; echo "<select name= film onChange='submit()' >film name</option>"; while ($nt=mysql_fetch_array($result)){ ?> <?php echo "<option value='$nt[id]'>$nt[title] </option>"; } ?> </select> </FORM>