Roland_D

I've been looking everywhere for the solution but I seem to be missing a little piece of something here.. I have 3 tables: pages, categories, menu PAGES ID | title 1 | Home 2 | About CATEGORIES ID | name 6 | Flowers 9 | Cats MENU ID | pID | cID 1 | 1 | 0 2 | 2 | 0 3 | 0 | 6 4 | 0 | 9 What I'm trying to do is this SELECT p.title AS mytitle, c.name AS mytitle, m.ID FROM menu m LEFT JOIN pages p ON p.ID=m.pID LEFT JOIN categories c ON c.ID=m.cID; What I get however is ID | mytitle | mytitle 1 | Home | NULL 2 | About | NULL 3 | NULL | Flowers 4 | NULL | Cats What I need is instead ID | mytitle 1 | Home 2 | About 3 | Flowers 4 | Cats Thank you guys!

Hello guys I've been trying to solve this for a while now I have this: <ul id="0" class="nestedsortable"> <li id="29"> <div class="itemrow">Home</div> <ul id="29"> </ul> </li> <li id="37"> <div class="itemrow">Page 1</div> <ul id="37"> <li id="30"> <div class="itemrow">Page 3</div> <ul id="30"></ul> </li> </ul> </li> <li id="36"> <div class="itemrow">Page 2</div> <ul id="36"></ul> </li> <li id="31"> <div class="itemrow">Page 4</div> <ul id="31"></ul> </li> </ul> And I'd like to get this: $item[0][0]=29; $item[0][1]=37; $item[0][2]=36; $item[0][3]=31; $item[37][0]=30; So the bottom line here is I have a nested unordered list that is treated almost like an XML... now I need to collect the ID's of each LI in an ordered fashion and group them by UL ID's... Now, does it make any sense? Probably the fact that is nested has nothing to do with the process cause each UL has it's own ID but the UL's are contained into the LI's... Any help is appreciated! Thanks!

Yes I saw... I currently use the last_action table to match the last post in the forum and update the last action when the user clicks on the thread... the problem as you can imagine is that when you go back to the thread list your last action's time is updated so you won't be able to see which post is new...

Thanks for the link... Well unfortunately all the solution provided are very 'heavy' on the database as they store user by user data on what they red or not... I needed some 'dirty trick' eheh to work around this problem..

Hello everybody, I have a question I've been striving with for a while and I was wondering if someone more experienced than me could have an answer or point me in the right direction. I'm building a website with an integrated forum what is the best system to detect and return which post is 'new', which one is 'hot' and which one hasn't changed from the user's last visit? In my user's table I store the last time the user logged in and the last time the user browsed a page... but it seems to be not enough to accurately return the information I need... Any suggestion is appreciated. Thanks.

thanks for the reply... yes I thought myself about the sloppy workaround but it's really... sloppy! I think I will have to work on the php file apparently... Even though it's weird I can't find a script or something that does something like that... Thanks again anyways.

Hello guys, I need help. I'm building a "simple" template function that grab an html file containing custom markups and string_replace them with the information it collects as for example title of the page, title of the website, etc... I'm stuck at the last markup which is {_PAGE:CONTENT_}. What happen is I parse the content of the page through a file_get_contents("page.html") and i put the resultant string in a variable i will call $pcontent then I string_replace the markup with $pcontent and voilat... this works great with an HTML page but of course I can't do it with a page.php cause the output needs to be processed server side first. My question is: is there a method I can parse the html code resulting from that php page and put it into a variable to replace it to the markup??? I'm sure I can somehow... HELP Thanks.

Sorry my bad... It works better than the other... as you said. Thanks very much for your precious help.

Ok so the first (better) one doesn't work...

You are the bomb! It works perfectly... Now just to be a real pain in the butt... What if I wanted to extract also the username from the USERS table... ?? Cause as it is I get 'only' the ID and the sum I originally needed..

Right... exactly what you wrote while I was replying... I will try it and post the result thanks a million!

I m guessing here... but maybe I should have to nest another query and first group all the pictures related to the same users and sum them then i would have to sum the total views of the set of pictures to the profile's views...

Ok so I used your exact code but the SUM result is still TOO HIGH. Maybe I've been unclear but what I'm trying to do is basically a chart of the most viewed users and this should include the views to their pictures as well... so practically I have to sum to their profile views their photos' views... I'm honestly new at mySQL but I study very hard

OK guys first of all THANK YOU VERY MUCH for your help... now I worked on your 2 solution and the first one is the closest to what I want to get. This is how I edited it to fit my needs SELECT users.views, users.user_id, users.username, SUM(users.views) as userview, SUM(pictures.views) as picview FROM pictures JOIN users ON pictures.pic_user_id=users.user_id GROUP BY users.views DESC LIMIT $limit; the issue now is the following... the assoc array i get from this query is this: Array ( [views] => 1627 [user_id] => 109 [username] => Roland [userview] => 24405 [picview] => 1351 ) I put only one line to better point out the problem... as you can see there is a HUMANGAS discrepancy between the user profile views the pictures views and the sum of the two......... How did it happen???

Hello guys, I need help with this query... I have 2 tables I m working on one has all my users with their info and their 'profile views' in it and the other one has all the info about the pictures uploaded by all the users with their views for each one... as follows TABLE USERS | user_id | username | views | | 1 | Roland | 100 | | 2 | Marylin | 300 | | 3 | Clint | 250 | TABLE PICTURES | pic_user_id | photo_name | views | | 2 | smiling.jpg | 850 | | 3 | cowboy.jpg | 340 | | 2 | wind_skirt.jpg | 920 | | 2 | laying.jpg | 560 | | 1 | cry.jpg | 23 | What I need to obtain is the sum of all the views related to the same user... Roland will have 123 views, Marylin 2630 and Clint 590... How do I sum the users' views to their pictures' views and order them? Thanks guys...