garydedub
|
Posted: 03/19/2003, 7:00 AM |
|
I have a users table with fields called "password", "username" and "custref"
I have a jobs table with similarly named fields
In the "Before Insert" event of a form which inserts a record into the jobs
file I have the following code to query the users table...
$db->query("SELECT password, username, custref FROM users WHERE id=".
get_session("UserID"));
$db->next_record();
$fldpassword = "$password";
$fldusername = "$username";
$fldcustref = "$custref";
The values don't get transferred. I'm either not querying the users file
correctly or the assignments are not correct.
Any ideas?
TIA
Gary
|
|
|
|