weemee500

Hi, I am currently trying to make a part for my user driven website where one user can subscribe to another and whoever they have subscribed to is echoed back on there profile page. my users table structure is: id username password and my subscription table is: id user_id follow_id i am currently trying to query the logged in users subscriptions with this sql_query $subsQuery = mysql_query("SELECT U.username FROM users AS U INNER JOIN subscription AS Sub.follow_id=U.id WHERE Sub.user_id=".$ID); $ID being the logged in users id. However when trying to echo this on the page using this bit of php: <? while ($subs = mysql_fetch_assoc($subsQuery)) { ?><br /><br /> <? echo $subs['username'] ?> <? } ?> it throws back this error: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/avince/public_html/users/user.php on line 53 Any help would be much appreciated!

Hi, I am currently trying to make a part for my user driven website where one user can subscribe to another and whoever they have subscribed to is echoed back on there profile page. my users table structure is: id username password and my subscription table is: id user_id follow_id i am currently trying to query the logged in users subscriptions with this sql_query $subsQuery = mysql_query("SELECT U.username FROM users AS U INNER JOIN subscription AS Sub.follow_id=U.id WHERE Sub.user_id=".$ID); $ID being the logged in users id. However when trying to echo this on the page using this bit of php: <? while ($subs = mysql_fetch_assoc($subsQuery)) { ?><br /><br /> <? echo $subs['username'] ?> <? } ?> it throws back this error: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/avince/public_html/users/user.php on line 53 Any help would be much appreciated!

Hi all, I have recently been building my own social networking site using PHP/MYSQL. I now have login functions, photo upload and comments and am currently working on a profile page wall/message system. But what I would really like to know is how to create a friends network sort of like Facebook, where the user can add/remove friends from a buddies list etc. Any help with this would be marvellous! Thank You!

Hi im building a quiz where the user answers 5 yes/no questions about issues in england at the moment. after completing the quiz depending on what they say yes or no too i would like to recommend a party for them to vote for out of a possible 3. How to i go about making this?