Michael (and list) --
I've made the adjustment suggested the scripts are below.
What I'm trying todo is pass the "uid" and "mid" to the sales.php script.
It works the first time!! But if I reload sales.html the next record( w/
same uid) isn't added or if I login in as a different id the records aren't
added?
Scripts: login.php and sales.php.
Thanks for your time and knowledge,
David Jackson
----- login.php -----------
<?php
// start session
session_start();
session_register("Uid");
session_register("Umid");
// Connect to db
include("/home/sites/www.pickledbeans.com/web/connect.php");
// insert new user
$result = mysql_query("SELECT id,mid,name,perms FROM staff
WHERE name = '$frm_name'");
if (mysql_num_rows($result)!=1) {
echo "Dis ain't good !!\n";
echo "<html><body>";
echo "<meta http-equiv=\"refresh\" content=\"5;
url=http://backoffice.pickledbeans.com/index.html\";>";
echo "</body></html>";
mysql_free_result ($result);
mysql_close($link);
} else {
echo "We have winner:\n";
// parse out query output and resign to session vars
list($id,$mid,$name) = mysql_fetch_row($result);
echo "<p>$id</p>";
echo "<p>$name</p>";
$Uid = $id;
$Umid = $mid;
$Uname = $name;
// redirect to main menu page
mysql_free_result ($result);
mysql_close($link);
echo "<html><body>";
echo "<meta http-equiv=\"refresh\" content=\"5;
url=http://backoffice.pickledbeans.com/sales.html\";>";
echo "</body></html>";
}
?>
---------- sales.php ---------------
<?php
// If sesssion vars don't exist, goto login form
// else display sales data entry form
session_start();
// if(!session_is_registered("Uid")) {
// echo "<p>We need to goto login screen!!</p>";
// } else {
echo "<p>Session uid set to:$Uid</p>\n";
echo "<p>Session uid set to:$Umid</p>\n";
echo "<p>Session date: $frm_date</p>\n";
echo "<p>Session amount set to: $frm_amount</p>\n";
//
include("/home/sites/www.pickledbeans.com/web/connect.php");
// Insert Sales data into sales table
mysql_query("INSERT INTO sales(id,mid,date,amount)
VALUES('$Uid','$Umid','$frm_date','$frm_amount')") ;
mysql_close($link);
echo "<html><body>";
echo "<meta http-equiv=\"refresh\" content=\"5;
url=http://backoffice.pickledbeans.com/sales.html\";>";
echo "</body></html>";
?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
