heavily modifying but need help on 1 part

[Daron]

i think i know away to get things right but i need to be able to stop the whole accept or decline feature. so it needs to be able to automatically make u the persons student once u type in their id #. so anybody know how to remove it so it automatically makes you student without having having to accept????

[lucky3809]

You should make a new table call it students

then add...

userid

student_one

student_two

student_three

student_count ....

Much easier then the way your doing it... then add the queries where they need to be.

[rulerofzu]

$q = mysql_query("SELECT userid, username FROM users WHERE sensei = {$r['userid']}");

$students = "Students:";

$sep = 0;

if(!mysql_num_rows($q))

{

$students .= " N/A";

Of course it will return 1

Look at your query your not asking about students your asking if there is a userid with your userid result = 1

[Daron]

how would i fix it???? i thought that had sounded right.

[Analog]

@rulerofzu - if it is a default viewuser.php file then $r is the result of the query ran to pull that players info for the profile, $ir is the player signed in looking at the profile

@Daron - change sensei = to student =

[rulerofzu]

Fair enough Analog but its still wrong.

[Daron]

it still returns a N/A as the result hmmmmmm.

[lucky3809]

Here dont know if this is what your aiming for or what but in viewuser under the query that grabs all the user info place

$s=$db->query("SELECT userid, username FROM users WHERE userid={$r['sensei']}");

$stud=$db->fetch_row($s);

if($r['sensei'] != 0){$stu= "<a href='viewuser.php?u={$stud['userid']}'>".$stud['username']."</a>";}

else {$stu= "<font color=red>Single</font>";}

 

and in user profile under the name: stuff add

Students : $stu

Edited April 23, 2011 by lucky3809