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

Preg_match question
I want to use preg_match to make sure a string is always 6 characters long and only contains 0-9 and

Read from forum
Haven't written anything forever and I would like to get back.
What I'm trying to do is getting t

How to sum these output values
Hi

I need sum the month totals
SELECT region_name, area_name ,SUM (CASE WHEN S

Sending CC Info by email
I am a little bit less knowledgable in the security area as most developers and I know I have a lot

MASS PM
Hello all, I'm trying to send mass private messages to users in my database but keep getting an erro

Searching keywords from array
Hello everyone, Im just wondering if someone could help me with another issue im having. Im still le

2 things: enter doesn't work in IE & empty form
i have this search form that works well except for 2 things.

1) on IE when i hit enter instea

Changing files over
Just thought I'd start with the new forums looking really nice .

Ok basically I've made this

Is it possible to view php source code??
Hi All

I was just wondering if it's possible to view a websites php source code?
I know

How to show next and prev records
Hi all,

Sorry if this is simple, i'm very new to php, well, any programming language actually