[SOLVED] script problem

[mishuk]

Hi

I am working on a piece of code that basis the rows returned from a select query on the username of a session.

I have got this far and it works for all users who do not have a usergrp of 1 however people with a usergrp of one do not get any results back from the query.  I think my problem lies with the if statement that checks if the value of $res == 1 but i am stuck for ideas

 

<?php $user = ($_SESSION['username']);
    $usercheck = mysql_query("SELECT usergrp FROM tbl_authuser WHERE username = '$user'");
    $result = mysql_fetch_array($usercheck);
    $res = $result['usergrp'];

    $usercheck = mysql_query("SELECT auth_id FROM tbl_authuser WHERE username = '$user'");
    $result = mysql_fetch_array($usercheck);
    $sch = $result['auth_id'];

    if ($res == 1) {
$final = mysql_query("select schoolname from tbl_school Order by schoolname");
	}
$final = mysql_query("select schoolname from tbl_school where auth_id = '$sch' Order by schoolname");

echo'<select name="school">';
     	    if(mysql_num_rows($final)==0)
	echo "No Data";
    else
	echo"<option>Select:</option>";
	for($i=0;$i<mysql_num_rows($final);$i++)
		{
		$row=mysql_fetch_assoc($final);
		echo"<option>$row[schoolname]</option>";
		}
	echo'</select>';
?>

 

Cheers

[jscix]

I'm not very good with scripting yet. I'm still learning but maybe use a Switch statement instead of If?

 

switch ($res) {

    case "1":

// do something

        break;

    case "2":

  // do something else     

        break;

 

}

 

I think that's right. just tryin' to help.

 

[mishuk]

Cheers mate.  that seems to have done the trick

ta