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 sizbut 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. sam8599

    body onload help

    Hi All, I have to scripts and am using 1. <body onLoad="begintimer()"> 2. <body onload="volchange(7); setTimeout(playitnow, 50);" onunload="DeInit();" > Not able to get both the scripts to work with one onLoad command. Please suggest how can I combine both of them TIA.
  2. sam8599

    How to delete records from Database if day passed

    Hi, Yes I am using MYSQL and with column details `item_code` varchar(25) default NULL the date is entered in format YYYYMMDD (22060526) Table Details CREATE TABLE `store_item` ( `item_id` int(11) NOT NULL auto_increment, `item_title` text, `item_desc` text, `item_subdesc` text, `item_code`...
  3. sam8599

    How to delete records from Database if day passed

    Hi, I am trying to learn is that compare the row 'item_exp' to the current time, if the time has passed, the record needs to be remove from the database. I will use cronjob to run it. $SQL = "Delete from $store_item where item_exp < UNIX_TIMESTAMP (date_sub(now() interval 1 day))"...
    • sam8599
    • Thread
    • Replies: 3
    • Forum: PHP
  4. sam8599

    timestamp not showing correctly

    Hi, I was able to get the code to work with modifications, I added (TO_DAYS(NOW()) - TO_DAYS(date_expire)) AS daysToExpiration in my Query to give the difference. $display_block = ""; //show categories first $get_cats = "SELECT item_id, sort_id...
  5. sam8599

    timestamp not showing correctly

    Hi Jpadie, I am trying to explore further and learn on the time stamp What I am trying to learn 1. Picks from Database expire time 2. Declares expire date 3. Compare to current time 4. Declares days left 5. Displays image expire if day passed, ending < 1 day, new >1 day 6. Add days if more...
  6. sam8599

    timestamp not showing correctly

    Thanks jpadie.... your code worked. Thanks for helping out. regards
  7. sam8599

    timestamp not showing correctly

    Please any help
  8. sam8599

    timestamp not showing correctly

    Vragabond, I have just started to learn php/MYsql. Lwearning curve is high. Appreciate if you can guide me through. I do pull timestamp in my MYSQL query. TIA. regards
  9. sam8599

    timestamp not showing correctly

    Hi All, I moved my server and SQL database and now getting errors showing timestamp old server the time stamp format was 20050316134117 with `time_stamp` timestamp(14) NOT NULL and the new server has 2006-04-21 15:27:11 with `time_stamp` timestamp NULL default CURRENT_TIMESTAMP, the...
    • sam8599
    • Thread
    • Replies: 8
    • Forum: PHP
  10. sam8599

    Call to undefined function: doerror() in php

    These are atleast 2 of the links where it ref to doError http://dev.nucleuscms.org/dev/phpXref/nav.html?_functions/index.html http://cvs.sakaiproject.org/release/2.1.1/javadoc/org/sakaiproject/portal/authn/AuthnPortal.html
  11. sam8599

    Call to undefined function: doerror() in php

    Hi All, I am getting errors when I call in the page Fatal error: Call to undefined function: doerror() in /home/u3/html/modules/Playlist/req.php on line 50 I am using php4 The php.ini file I am using is [PHP] ; This is the default PHP 4-style version of the php.ini settings file. ; It...
    • sam8599
    • Thread
    • Replies: 3
    • Forum: PHP
  12. sam8599

    Countdown time loops in 30secs

    I hope this time I did correct <script> function newWindow(thePage) { var w = 550; var h = 300; var winl = (screen.width - w) / 2; var wint = (screen.height - h) / 2; winprops =...
  13. sam8599

    Countdown time loops in 30secs

    Dan, Enclosed is the complete script for your ref; appreciate your time for help. I hope this is what you meant bythe client-side code. <? include("includes/config.php"); $SAMdb->open("SELECT songlist.*, historylist.listeners as listeners, historylist.requestID as requestID...
  14. sam8599

    Countdown time loops in 30secs

    Hi, I am using this customised script to display the countodwon of the songs. Using Linux server, SQL4.1 and php+java //tables in MYSQL `date_played` datetime NOT NULL default '0000-00-00 00:00:00', `duration` mediumint(9) NOT NULL default '0', //examples of data dateplayed...

Part and Inventory Search

Back
Top