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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by devnull22
-
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...
