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!

Register Log in
  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. devnull22

    date field in MySQL interface

    try this : $year_select .= &quot;<option value=0000>0000</option>&quot;; $year_select .= &quot;<option value=0001>0001</option>&quot;; // well ... you get the idea now. for ($i=$start_year; $i<=$end_year; $i++){ $year_select .= &quot;<option value=\&quot;$i\&quot;&quot...
  2. devnull22

    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...
  3. devnull22

    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...
  4. 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...
  5. devnull22

    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...
  6. devnull22

    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...
  7. devnull22

    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...
  8. devnull22

    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...
  9. devnull22

    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...
  10. devnull22

    Deleting images off server using PHP

    use the int unlink (string filename) function. $file=&quot;/home/stuff/Copysendmail.jpg&quot;; if (file_exists($file)) { unlink(&quot;$file&quot;); print &quot;File deleted!&quot;; } else { print &quot;file doesn't exists!&quot;; } cheers devnull22 http://www.kbcenter.com...
  11. devnull22

    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...
  12. devnull22

    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 !
  13. devnull22

    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...
  14. devnull22

    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 !
  15. devnull22

    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...
  16. devnull22

    doubt in &quot;mysqlimport&quot; 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 --...
  17. devnull22

    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 &quot;flush privileges&quot; statement. cheers devnull22 http://www.photoflux.com http://www.clickEval.com -- Apparently if you play the Windows NT CD backwards you hear...
  18. devnull22

    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 &quot;okay&quot; for the most part. The major difference in mysql is inner selects which mysql doesn't support. for more info on compatiblity ...
  19. devnull22

    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 !
  20. devnull22

    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,&quot;r&quot;), filesize($image_file))); $SQL = &quot;INSERT INTO image_table (image,image_type,image_name) VALUES ('$image_data','$image_type','$image_name')&quot;; (3) for view'n...

Part and Inventory Search

Back
Top