Querying info from one table based on info in another

Posted on 16th Feb 2014 07:03 pm by admin

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!

Your Answer:

Login to answer

Other forums

styling a RadioButtonList
HiI need to have a radio button and close to it, its lable, then a space then another set of those.

Price in PR
Dear Experts,
Why we have to enter the price in the PR, and why there is no free goods indicato

url- go to webpage
i have an input text field and submit button.

how do i make the url entered into the textfiel

Read from a text file after a specific word
Hi all.

I have a text file that looks like the one below.
I know how to open the text fi

curl javascript problem
Hi Experts.
I'm new curl and wanna to get some info from this http://www.amadeus.net/

when

error reporting
hey everyone

I have a production server in which I want error reporting but only on some page

SWF image using php?
Hello once again.

My latest en devour requires me to produce an image of a static .swf that i

ECC6 - Single sign-on
We are in the process of upgrading to ECC 6 which will support single sign on with user passwords al

PHP loop
Okay so I have several "articles" stored in a mysql database and am attempting to echo tho

reading partial code from external site
Hi,

I am trying to write a script for my website to get an article from an external website.