hey guys, I have this simple if else statement going and depending on a var
it executes a funtion, but for some reason its not running the function or
so I think...
heres code snippet :
--------------------
<?
function add_user() {
global $user_name;
global $pass;
global $full_name;
global $email;
global $age;
global $icq;
global $aim;
$date = gmdate("M d Y H:i:s");
$connection = mysql_connect("localhost", "mylog", "mypass") or die ("Could
not connect to database");
$db = mysql_select_db("nydma_cust", $connection);
//$sql = "INSERT INTO nydma_users (user_name, pass, full_name, email, age,
icq, aim, date) VALUES
(\"$user_name\",\"$pass\",\"$full_name\",\"$email\",\"$age\",\"$icq\",\"$aim
\",\"$date\")";
$sql = "INSERT INTO nydma_users SET user_name='$user_name', pass='$pass',
full_name='$full_name', email='$email', age='$age', icq='$icq', aim='$aim',
date='$date'";
$result = mysql_query($sql, $connection ) or die ("Couldnt run query");
session_start();
}
function log_user() {
global $user_name;
global $pass;
$date = gmdate("M d Y H:i:s");
$connection = mysql_connect("localhost", "mylog", "mypass") or die ("Could
not connect to database");
$db = mysql_select_db("nydma_cust", $connection);
$sql = "SELECT * FROM nydma_users WHERE user_name='$user_name' AND
pass='$pass'";
$user_result = mysql_query($sql, $connection) or die ("Couldnt run query");
while($row=mysql_fetch_array($user_result)){
$id =$row[0];
$user_name =$row[1];
$pass_w =$row[2];
$full_name =$row[3];
$email =$row[4];
$age =$row[5];
$icq =$row[6];
$aim =$row[7];
session_start();
}
if($l=="d") {
log_user();
} else if($r=="d") {
add_user();
} else {
$r ="y";
}
?>
-----------------
TIA
Andy
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
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]
