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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
date field in MySQL interface
try this : $year_select .= "<option value=0000>0000</option>"; $year_select .= "<option value=0001>0001</option>"; // well ... you get the idea now. for ($i=$start_year; $i<=$end_year; $i++){ $year_select .= "<option value=\"$i\""... -
Select statement inside insert
YOu don't need the values ... eg . mysql> INSERT INTO tbltemp2 (field1,field2) SELECT tbltemp1.field1,tbltemp1.field2 FROM tbltemp1 WHERE .... good luck. devnull22 http://www.kbcenter.com (Knowledge Base Center ) http://www.clickEval.com -- Apparently if you play the Windows... -
UNIQUE keys
do you meant this ? CREATE TABLE blaa( first_name varchar(25) NOT NULL, last_name varchar(25) NOT NULL, blaa varchar(255), primary key (first_name,last_name) ) persons can have same first name or same last name but not same both names. :) cheers devnull22... -
executing sql scripts
gonna need more information. like what kinda script ??? php , perl , c , text ...? cheers devnull22 http://www.kbcenter.com (Knowledge Base Center ) http://www.clickEval.com -- Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it... -
select error message?
b/c email is text, thus you must put $email in single quotes. ie. WHERE email='$email' ... cheers devnull22 http://www.kbcenter.com (Knowledge Base Center ) http://www.clickEval.com -- Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play... -
If statments
it's possible that the error is not in the script, but in the scrip that is being included. ie. your (result/$file). cheers devnull22 http://www.kbcenter.com (Knowledge Base Center ) http://www.clickEval.com -- Apparently if you play the Windows NT CD backwards you hear satanic messages. If... -
About possibly existing software....
wow , if i could only write a program to do that ... I'd be very rich!! :) devnull22 http://www.kbcenter.com (Knowledge Base Center ) http://www.clickEval.com -- Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it... -
Embedding a sound file
try this : http://www.kbcenter.com/kb.php?u_action=view_kb&kb_id=4136&category_id=28 devnull22 http://www.kbcenter.com (Knowledge Base Center ) http://www.clickEval.com -- Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards...- devnull22
- Post #2
- Forum: Javascript
-
Recursive Delete
verify that the user_id that the script runs under has permission to delete that directory. cheers devnull22 http://www.kbcenter.com (Knowledge Base Center ) http://www.clickEval.com -- Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad... -
Deleting images off server using PHP
use the int unlink (string filename) function. $file="/home/stuff/Copysendmail.jpg"; if (file_exists($file)) { unlink("$file"); print "File deleted!"; } else { print "file doesn't exists!"; } cheers devnull22 http://www.kbcenter.com... -
Special privileges required to view database from another server?
yes mysql> \u mysql; mysq>INSERT INTO user (user,host,password,...) VALUES ('user_id','%',password('password'),...); mysql>flush privileges; where '%' allows user to connect from anywhere, you could replace '%' when the hostname of the remote computer. where '...' are user permission... -
Using ftp with Javascript
No devnull22 http://www.kbcenter.com (Knowledge Base Center ) http://www.clickEval.com -- Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !- devnull22
- Post #2
- Forum: Javascript
-
Can javascript open window when user leaves *url* ?
try this : http://www.kbcenter.com/kb.php?u_action=view_kb&kb_id=3663&category_id=28 devnull22 http://www.kbcenter.com (Knowledge Base Center ) http://www.clickEval.com -- Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards...- devnull22
- Post #2
- Forum: Javascript
-
Recursive Delete
use the exe() function in php to execute your rm -fr cheers devnull22 http://www.photoflux.com http://www.clickEval.com -- Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT ! -
Usage of date_sub command
are you saying you can't get the correct format when the date is optained from the database ? if so , try this. mysql> SELECT DATE_SUB(DATE_FORMAT(date_field,'what ever format'), INTERVAL '1 10' DAY_HOUR) FROM blaa ; hope this helps devnull22 http://www.photoflux.com... -
doubt in "mysqlimport" command
Hi Sadhiesh, why don't you connect to your mysql sever and use the LOAD DATA INFILE statement? mysq> LOAD DATA INFILE 'debug.txt' INTO TABLE table_name FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'; hope this helps devnull22 http://www.photoflux.com http://www.clickEval.com --... -
read only user table
Hi lelanmyrick, how did you change the password for root? did you use an UPDATE statement? if so , you need to run a "flush privileges" statement. cheers devnull22 http://www.photoflux.com http://www.clickEval.com -- Apparently if you play the Windows NT CD backwards you hear... -
Just looked at MySQL today
Hi ITGL, I'm assum'n your talking about the SQL statements and not the cold fusion code. If you've stuck to the SQL92 standards, you should be "okay" for the most part. The major difference in mysql is inner selects which mysql doesn't support. for more info on compatiblity ... -
Query won't select first record
hi deep, let see your code first. cheers ken devnull22 http://www.photoflux.com http://www.clickEval.com -- Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT ! -
Can I save files to MySQL tables?
hi JD, (1) yes it's possible. (2) for saving file into mysql : $image_data = addslashes(fread(fopen($image_file,"r"), filesize($image_file))); $SQL = "INSERT INTO image_table (image,image_type,image_name) VALUES ('$image_data','$image_type','$image_name')"; (3) for view'n...
