Tricky query

joe_C_nice

Can someone help me understand this.

What I want to do is compare two columns against one another. Both columns are in the same table. I would then like to return the result of this compare.

Whats a simple way to do this.

devinemke

how do you want to compare them? are they integers and you want see which one is bigger? are they strings and you want to see which one is longer? what is your comparison criteria?

joe_C_nice

Both are integers.

Here's how it looks

Column one - user id
Column two - refer_user_id

Now user_id is my Primary Key and refer_user_id corresponds to the user_id who referred member to the site.

Here's how entires in this table look.

user_id |   refer_user_id | username
1       |     0           |  Admin
-------------------------------------
2       |     0           | any_user
--------------------------------------
3       |     1           | any referred user
--------------------------------------

When I click on a user I would like to see who referred them by comparing user_id against refer_user_id.

devinemke

assuming mySQL:

<?php
// connect to db first

if (!isset($_GET['user_id']))
{
	$result = mysql_query('SELECT user_id FROM table');
	echo 'click on a user_id to see which user refered them:<br>';
	while ($row = mysql_fetch_assoc($result))
	{
		echo '<a href="' . $_SERVER['PHP_SELF'] . '?user_id=' . $row['user_id'] . '">' . $row['user_id'] . '</a><br>';
	}	
}
else
{
	$result = mysql_query('SELECT refer_user_id FROM table WHERE user_id = ' . $_GET['user_id']);
	echo 'user_id #' . $_GET['user_id'] . ' was refered by user_id #' . mysql_result($result, 0);
}
?>

joe_C_nice

Thank you.

This thread has almost the same requirements:
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10299508