|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
I reposted this due to the fact i broke the rules...sry
OK, first off, I stink at making any type of PHP, but i REALLY need this script for my site...so please give me a hand. It's for a game site of mine with reviews and codes and media, and I just can't find anything that could help me. Heres how I want it to work: -I want there to be a page with the letters #-Z (links) and then, about a line down, I want there to be somthing that says "Newly Added" and the 5 newest reviews (all links) to be listed under there (see EX. 1). Then, say somone clicks the letter B, they then should be taken to a page with all the reviews (there titles, all links) starting with B, and if they click one of them, they are taken to the review of that things title. (see EX. 2-3) -It all can be done with HTML (except displaying the 5 newest articles) I know, but theres a catch... -I want there to be a login page where staff members can login with a username and Password that I create and then they can be taken to a page where they can add Reviews, Codes or media (see EX. 4) Here they can just fill in custom feilds i make and click post and It would appear under the title of the first letter on the page (see EX. 5) -I would really apprcuate it if someone could help me, and I will dispaly a link to there site and/or there name if they wish. EX1 #|A|B|C|D|etc Newly added: Thing 1 Thing 2 etc. EX2 #|A|B|C|D|etc Thing with B 1 Thing with B 2 etc EX3 #|A|B|C|D|etc (Game tiltle) This game blah blah blah EX4 Username: Password: (link) Login Then they are taken to somthing like: Add Reviews Add Media Add Codes EX5 (for reviews) Game Starts with: (drop down box, so when it is posted, it goes under the correct letter) Game Title: (They fill in info here) Review: (They fill in info here) Finall score: (They fill in info here) ![]() Last edited by chuckfx : January 27th, 2003 at 05:56 PM. |
|
#2
|
|||
|
|||
|
Have a look at http://www.devarticles.com/art/1/163
Page 3 takes you through using a form for checking username and passwords stored in a MySQL database. While I couldn't get the scripts to work for me, trying to sort them out explained all I needed to know and I have now got a very good user login system running on several sites, all based on this article. As for retrieving the last five articles. One way would be to store the entry date along with the review, somthing like Code:
INSERT INTO reviews SET article_text='$text', date_added=NOW() You could then retrieve these by doing something like Code:
SELECT article_text FROM reviews ORDER BY date_added DESC LIMIT 5 I'm not certain if the above is 100% accurate but I'm sure you get the picture. And getting a list of all reviews beginning with a letter could be done with Code:
SELECT article_text FROM reviews WHERE article_TEXT LIKE 'A%' Again, check the details for the SELECT function but it should be close enough. Good luck with the project |
![]() |
| Viewing: Dev Articles Community Forums > Programming > General Programming Help > User(s) Login and Content Manegement |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|