Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
datatype for 9 place decimal
Problem: inside php script need to multiply and find $a. $x, $y, and $z are all datatype float(11,9) inside the carv table. I connect to database and select these values from carv table. $x= 0.000182682 $y= 0.028863719 $z= 0.452137381 I do this multiplication inside my php script to find $a. $a... -
Problems: update and textarea
Two questions: 1)This code did not update after I made connection and successfully sent all the right side variables from form into this script.I am within php tags. Can you help. $sqla = "UPDATE faq SET f_ans='$f_ans',". "f_question = '$f_question',"... -
Problem: Foreign key and Referential Integrity
I am having trouble with mysql accepting FOREIGN KEY REFERENCES and the referential integrity ON DELETE CASCADE and ON DELETE RESTRICT.Can you help? Thank You CREATE TABLE user ( user_email varchar(50) NOT NULL, nf_num int(6), com_num int(6), f_num int(6), PRIMARY... -
Header(Location:otherpage.php?variable=data)
Thank you, but I tried no spaces and still does not work. header(“Location:comment_form.html?message=hello”); and register_globals is on. All good ideas, can someone help? -
date addition
Allowed to vote once per year.I have an attribute in a table called ung_sur_date that is a timestamp(12) datatype. I am using mysql database and php. My code: $oneDay = 86400; echo"seconds per day is $oneDay <br><br>"; $today = date( "U" )... -
timestamp arithmatic
A user can only vote once per year. $uvote is a timestamp(12) datatype. I was thinking $today=time();$uvote=$today; Does $nextyr=$uvote+1year? How do you handle this with code? -
Header(Location:otherpage.php?variable=data)
SCRIPT F <html> <head> <title>Welcome to UNF Comments Page</title> </head> <body> <?php //File:comment_form.html //Displays a comment form. ?> <form method="POST" action="comment.php"> The rest is the html code for text boxes, drop down boxes, radio buttons and closing the... -
Header(Location:otherpage.php?variable=data)
register globals is turned on. Thank you for the good thought and advise. Are there other ideas to solve the problem? Doesn't header(Location:place.php?var=data) move the var=data into the place script and not just listed in the url? -
Header(Location:otherpage.php?variable=data)
I have a 2 page script. F is the form script and V will validate the data that the form sends it and insert the data into mysql database. I use the Header(Location:) code to bring a variable called message(it is an error message) back to the F script. $message shows up in the URL and the monitor...
