timetomove Posted October 18, 2006 Share Posted October 18, 2006 Any help appreciated.I'm working within the framework of a object orientated login script using sessions.Basically, once a user is logged in I would like to list all of the books_titles and book_authors(for example) that are held in the database table: readinglist for that logged in user of the websiteplease bear with me...to do this is have called the function, getReadinglistInfo($username) which does the select query for that user.the session cookie is recognised by setting variables in a seperate file(session.php) like:var $readinglist = array();var $booktitle;var $bookauthor;in thecheckLoginfunction()i added:$this->readinginfo = $database->getReadinglistInfo($username);$this->booktitle = $this->readinginfo['book_title'];$this->bookauthor = $this->readinginfo['book_author'];.........and then on the actual web page i used:$req_user = trim($_GET['user']);/* Display requested garden information */$req_reading_info = $database->getReadinglistInfo($req_user);echo "Book Title: ".$req_reading_info['book_title']."";echo "Book Author: ".$req_reading_info['book_author']."";...........This then gives the FIRST book title and author for that user in my readinglist table.I havent put all the code here but I hope you get the idea.I probably havent copied it down here very accurately either but...It works GREAT on my website.....EXCEPT, it will only show the first record in the database (for that user).What I would like to do is loop through all the book titles and authors(for the user)I dont know if i need an array within an array?HuhIt would be great if someone who understands this could advise on how its best done.Thanks,Tim Quote Link to comment Share on other sites More sharing options...
redarrow Posted October 19, 2006 Share Posted October 19, 2006 afther 4 cups of coffe and 3 cigs i get it now.i think the reason wht your getting only the books that the user has submitted is becouse you ask the database to show all the boooks that the current user has got now to get also all the othere books you need not to use $user varable that way your see all books. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.