dradcliffe21
07-31-2008, 11:40 PM
Hi everyone, I need a little bit of help. I am stepping away from htm/html and redoing my site from scratch in PHP and MySQL. I have learned how to do ASP, recently learned PHP and how to do MySQL, still a beginner though.
I am wanting to do a page for news, the page itself would be named /story.php the only problem is after searching Google the only thing I have found that has slightly helped me is a PHP news module, the only thing is it's not exactly what I am looking for. I know how to insert data, etc into the database, so I don't need the submit to database page in which it provides seeing how I already know how to do that myself, plus I don't want the stories to be displayed all on just one page, considering my site consist of really nothing but news, weather, sports, videos, games, etc. I want to be able to enter the information into the database with a pre-assigned ID, then beable to put that story on the index page or whatever page I feel it might correspond on and have it open in story.php after a user clicks on that story therefore I just need to create tables with the following info. The story itself, a photo that goes along with the news story, an e-mail to friend link, printer friendly version, S= (S standing for story) ID consisting of random numbers, so in the end I want it to display as follows site.com/folder/Story.php?S=12345
All I need is help with the table creation itself and the code I place on that page to open the database after the story is clicked on, displaying that information and then closing the database after it has pulled it.
Thank you!!
:)
I am wanting to do a page for news, the page itself would be named /story.php the only problem is after searching Google the only thing I have found that has slightly helped me is a PHP news module, the only thing is it's not exactly what I am looking for. I know how to insert data, etc into the database, so I don't need the submit to database page in which it provides seeing how I already know how to do that myself, plus I don't want the stories to be displayed all on just one page, considering my site consist of really nothing but news, weather, sports, videos, games, etc. I want to be able to enter the information into the database with a pre-assigned ID, then beable to put that story on the index page or whatever page I feel it might correspond on and have it open in story.php after a user clicks on that story therefore I just need to create tables with the following info. The story itself, a photo that goes along with the news story, an e-mail to friend link, printer friendly version, S= (S standing for story) ID consisting of random numbers, so in the end I want it to display as follows site.com/folder/Story.php?S=12345
All I need is help with the table creation itself and the code I place on that page to open the database after the story is clicked on, displaying that information and then closing the database after it has pulled it.
Thank you!!
:)