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 bkrike 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 perlTest

  1. perlTest

    Getting the mouse coordinates (X,Y),

    Thanks!
  2. perlTest

    Getting the mouse coordinates (X,Y),

    I need some help solving a problem I've encountered. I need to get the mouse coordinates (X,Y), (I do it by calling a function with &quot;onMouseMove&quot; that takes an event parameter. it looks like this: <html> <head> <script language=&quot;JavaScript&quot;> function show(event){ X =...
  3. perlTest

    Form Image

    Thank You.
  4. perlTest

    Form Image

    I have an image called 'search_button.gif' and I want that image to act like a form and redirect it to 'search.cgi' just like using a <form action>. Anybody know how I can treat an image like form buttons? Thanks for reading.
  5. perlTest

    taking year out of localtime function.

    Thanks Guys!
  6. perlTest

    taking year out of localtime function.

    Hi, I want to take out the year and print just the date. Like for an example, I want to print following: Sat Dec 21 17:38:24 Thank you for your reply!
  7. perlTest

    taking year out of localtime function.

    Hello, I have this for my local time, which generated by perl: Sat Dec 21 17:38:24 2002. How do I take out the year and leave the rest? Thanks if you can help.
  8. perlTest

    Selecting Random Quotes from mySQL :(

    What is the way you did? Following don't work: $sql = qq[select TextAd from TextAds ORDER BY RAND()]; my $sth = $dbh->prepare(&quot;$sql&quot;); $sth->execute or &head(&quot;Cannot execute statement!<br>&quot;.$sth->errstr); while(@row = $sth->fetchrow) { $random = $row[0]; } print $random;
  9. perlTest

    Selecting Random Quotes from mySQL :(

    Hello there, I've a mysql database which I want to select random quotes everytime. But I have no idea how to do that. My table is shown below: quotes: pid|text|link I wanna select randomly each time. I've tried the following, but no luck. $SQL = &quot;SELECT text from quotes ORDER BY...
  10. perlTest

    Checking if the user is online with time().

    Hi, I have a database where the user info are stored and when a user login, it stored the last time they logged in. The time is in seconds like: 1038798090. How do I check with the current time and the last logged in time to figure if the user is been active for the last 2 or 3 minutes?
  11. perlTest

    Updating ALL tables

    Thank You!
  12. perlTest

    Updating ALL tables

    Hi, Currently I have a table called 'software' and for the price column, it has the following: table: software; id | pid | price 910 1054 $475 911 1055 $501 How do I remove that &quot;$&quot; dollar sign? Thank You. -Matt
  13. perlTest

    Rounding

    Thanks guys!
  14. perlTest

    Rounding

    How do I round so that 4.6000 will turn into 5? Or anything before 4.5000 turn into the next number. Like 1.5000 will be 2.0000. Thank you for your help. -Matt

Part and Inventory Search

Back
Top