I need a basic script that will pull information from a MySQL database and dynamically create a webpage based on that information.
I have the following MySQL server installed and populated with data:
password: (input "XXXXX" for now and I can change later)
Inside the database are two tables, and we will need to access the "feedItems" table. The field "itemID" - int(11) - is the primary key to access all field-related data.
Once the record is located, the fillowing fields of data will need to be accessed:
itemID - int(11) - primary key
ItemTitle - text - the string of text actually being displayed on the webpage
ItemLink - varchar(250) - the hyperlink that needs to be tied to the ItemTitle.
ItemPubDate_t - datetime - this will be used to sort the results in descending order of time (most recent first etc).
These items need to be scripted so that they produce links in an HTML page that can be modified by the master CSS sheet for the page. Each record should display the ItemTitle information, have the ItemLink attached as a hyperlink and the whole results section formatted to return the most recent entries at the top.
From there, I will also need the ability to display the links in blocks of 50 with my own custom code inserted between blocks of results.
We would like to get this done ASAP. Please pm with any other questions. Thanks!