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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
