Searching one column in a table for a value...

[ExpendableDecoy]

Hi. 🙂

This is a very easy one but I'm having a brain dead moment...

I simply need to write a query to search one column in a table for a value.

This is what I have, which I know is not enough. :p

$sql = "SELECT leader_id FROM test_test";
	if ( !($result = $db->sql_query($sql)) ) 
{ 
	message_die(CRITICAL_ERROR, 'Error Getting leader name'); 
}
$leader = $db->sql_query($result);

if ( $leader['leader_id'] == $user_id )
{
	message_die(GENERAL_ERROR, 'Sorry, you can't do that at the moment' );
}

Thanks. 😉

[Mordecai]

Were you wanting to do this through PHP or through SQL? Through SQL is easier--just have it return rows where the columns match:
SELECT leader_id FROM test_test WHERE leader_id='$user_id'

[ExpendableDecoy]

Sorry, I didn't explain properly in my first post.

What I need it to do is for it to check the 'leader_id' column for the 'user_id' value specified in the php code.

If the 'user_id' value exists on any row in the 'leader_id' column, in the SQL query, then it should execute the IF statement.

Thanks. 🙂

[ExpendableDecoy]

Anyone?. I'm sure this is very easy.