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 unknown modifyer
Hello,

Im trying to write a little script for my forums i need to get the reply from my forum

Creating XML with php
I need to creat an XML with php and have successfully produced a valid output.
The problem I hav

array help
Does anyone know how to require 10 text fields for individual grades and output class average? (10 p

Displaying image from database
Hi,

I've got a site where that's got a database behind it. Currently it has loads of items in

POST into Array problem
Hi Chaps,

I have a repeat region, displaying rows of data: jobid, fromtable, translatorcharge

Is STL important?
I'm just starting programming and I've made it until the Standart Template Library. But the chapter

random generation
hi

i need help with generating this

numbers from 1-12

i want to generate in ran

Adding to an Int row in db
Hi, i have a database which houses all of the users of my site. One of the columns is for points whi

Using real time in php
I'm very average at PHP and im looking to introduce time to something on my site.
Its a sports si

Deleting pointers froms vector?
Hi. I have a vector filled with pointers and I want to delete the pointers. I could do a loop and do