9 replies to this topic

[Bioshox]

Hey guys!

Okay, what I need to do is check two db tables, the first to check if the user is 'following' somebody, the second the see what updates the person the user is following has made.

Here is the code I currently have

<?php

	$sql = "SELECT * FROM updates WHERE user = '".$userid."'";

	//Select everything from the users field where the Username is the same as the Cookie Variable

	$query = mysql_query($sql) or die(mysql_error());

	while($row = mysql_fetch_assoc($query)) { 

	

	if($row['gender'] == "Male"){


	echo $row['fullname']." ".$row['type']." ".$row['network']." on his profile";

	

	}else{

	

	echo $row['fullname']." ".$row['type']." ".$row['network']." on her profile";

	}


}

	

?>

As you can see all this is doing is checking the Update table and sorting it if they are male/female

But this will pull everything from the update table, and I need it to ONLY pull it for the users he is following.

My following table consists of 4 fields

linkto
linkfrom
fullnameto
fullnamefrom

I just don't know how to work the statements.

[WingedPanther]

First question: are you clearly capturing the information? I can't easily tell, from what you've listed. What are the table relationships involved? How do you define "Is following"?

[Bioshox]

Basically

The link to table has 4 fields, link to link from and there Full names

I need that coded to only pull the people from that table if the link from field is the name of the current user, which is the $userid variable

[WingedPanther]

You'll need to use a join.

[Bioshox]

Replys like that don't help :/

[WingedPanther]

What I mean is you'll need something like:

"SELECT * FROM updates INNER JOIN following ON (updates.??? = following.???) WHERE user = '".$userid."'" AND ???

It's hard to be more precise without understanding your database structure and usage better.

[Bioshox]

Okay.

Ever used Facebook or Twitter?

I'm designing a piece of software that allows users to follow other users, and when the user clicks the Follow button details are entered into the database table LINKS

Which is linkto, linkfrom, fullnameto, fullnamefrom

So, if I was to follow you on the site, the following details would be entered

wingedpantha, bishox, John Smith, Bill Gates

So there we go, now I'm following the user

But now I need on the index page recent activity of everyone I'm following which is stored in a different table, this data is inserted when the user changes something on his profile.

And i need an if statement to say, when the user is following that user, pull all the data from then updates table, but I can't get it to work.

Refer back to the first post now you understand what's going on :p

[WingedPanther]

OK, it sounds like you need a table (possibly your follow table) that either indicates when you last checked the user, or something similar. You also need to keep track of when each item being followed has been updated. Then you do a select on the two tables joined together and a where clause on the follow date less than the update date.

[Bioshox]

Hmm

I was looking at it more along the lines of

A MySQL Selection to select all the people who I am following

And then an IF statment to select them all from the other table

It just didnt work for me D:

[WingedPanther]

That's likely to result in a large amount of data being returned, much of which could be completely irrelevant to what you're doing.