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 TouchToneTommy 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... -
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)
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...
