Sort of OT: mysql and select from two tables...?

[John Patten]

Hi Bob...

session_user() appears to give me something other than the current  
logged in user. It returns:   myaccount_nameofdatabase

This is what I did to test it out:

$result = mysql_query( "SELECT session_user() FROM teacher_user" )
or die("SELECT Error: ".mysql_error());

$num_rows = mysql_num_rows($result);

print "There are $num_rows records.<P>";

print "<table width=600 border=1>\n";
while ($get_info = mysql_fetch_row($result)){
print "<tr>\n";
foreach ($get_info as $field)
print "\t<td>$field</td>\n";
print "</tr>\n";
}
print "</table>\n";


I think even if I could return just the current user's profile (fields  
in their record) using the session_register command in mySQL I'd be  
making progress :-)

Any other ideas?

Thank you!

John Patten
SUSD

On Mar 16, 2011, at 1:24 PM, Bob Sneidar wrote:

> You can use "SELECT session_user()" to get the currently logged in  
> user. It's a synonym for "USER()". That help?
>
> Bob
>
>
> On Mar 16, 2011, at 12:15 PM, John Patten wrote:
>
>> Hi All...
>>
>> Thanks for the previous help on the on-rev php/mysql question. I  
>> have a question about the mysql select command, session_register,  
>> and selecting from two tables.
>>
>> I have one database with two tables. The tables are teacher_user  
>> and student_user.
>>
>> Each table has a unique teacher-id stored in a fields. So students  
>> with the teacher_id value of 0001 stored in their student_user  
>> record all belong to the same teacher.
>>
>>
>> Teacher_table        Student_table
>>
>> id - 0001                     teacher_id = 0001
>> first                               first
>> last                               last
>> title                               grade
>>
>>
>> I also have the teacher login with their username and password  
>> comparing what is stored in their db record for username and  
>> password. If they match, then their username and password is then  
>> session_register("username"); & session_register("password");  .
>>
>> What i would like to be able to do is query the database and return  
>> a list of students to the individual teacher based on some unique  
>> information about the teacher's record, say their username.
>>
>> is there some way I can get at the session_register("username") and  
>> use it in my select query?
>>
>> Something like:
>>
>> select "username" from teacher_table and put "id" of table  
>> teacher_table into tTeacher_id then
>> select tTeacher_id from student_table and loop through the student  
>> printing each record
>>
>> I suppose if the teacher new their id value I could just have them  
>> type that into a form and do a simple query the student_table and  
>> teacher_id field by that id value. But I was trying to make it a  
>> little more automatic and did not want teachers trying to guess  
>> other teachers' ids.
>>
>> Thanks in advance!
>>
>> John Patten
>> SUSD
>>
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your  
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode