54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 





Access mysql with php...

1. Connect: $connection = mysql_connect(location,username,password)

2. Run the query: $result = mysql_query([sql statement],$connection)

3. Retrieve row: $row = mysql_fetch_row()

4. Process row using a while loop


gets:



     
1      Grosse Point Blank      1997      Comedy      Romance      Vice and Virtue      90      
2      Plains Trains and Automobiles      1987      Comedy      Odyssey      n      98      
3      Peewees Big Adventure      1985      Comedy      Odyssey      Bizzaro      96      
4      Back to the Future      1985      Comedy      Science Fiction      Adventure      97      
5      No Country For Old Men      2007      Thriller      Vice and Virtue      n      98      
6      Back to the Future Part II      1989      Comedy      Science Fiction      Adventure      90