Search results for query: *

I have a table with several columns, including one ID field containing a unique key. What I want to do is select all duplicate records from the table based on one of the columns, say the Item number field. Is there a simple way to do that? I know using unique can give me the non-dupe records...

Can someone show me a simple way to calculate dates? What I'm trying to do is get a future or past date based on today's date. Example, if I want to know what the date is 3 weeks from now. thanks! PETERV Syracuse, NY & Boston, MA

I have a web page (see code below) where I want to display the date & time below the submit button, after skipping one blank line. No matter what I've tried, the date & time keep coming out in the lower right next to the submit button. (You can view the page at...

In the query below, I'm selecting all records in a table, in the future, I may be only selecting a few record from th table. Is there a way to get the count of records returned by the query, so that I can base what I do next on that count? Thanks! $query ="select * from usersTable"; $result =...

I'm new to PHP, and I'm having problems with getting error messages to display on multiple lines. My syntax must be wrong, but I haven't been able to figure out the problem. I've tried: $query ="INSERT INTO usersTable VALUES ('0','karen','$encrypted_password')"; $result =...

Is there a way to use CSS to create a "footer" for a web page? I want to print the output from the bold red lines below at the bottom of my web page. The other problem involves the page's background image. Is there a way to make the background image expand & contract depending on how the user...

I want to run the sql command DESC from within a php script. I'm new to this, and am not sure that this is possible. My attempt below runs with no errors, but gives no output. Can someone help me out with this? Any help is gratefully appreciated! PV <?php // Thursday, August 14, 2008...

I'm running a query to display the number of rows returned from a select statement. (I know, it's simple, but I'm trying to learn this stuff from a book.) I get the desired message, but I also get the following message: Record added As far as I know, I shouldn't get that message when...

I'm attempting to connect to a version 4 MySQL database that my ISP set up for me. I'm using the following script: <?php $link = mysql_connect('localhost', 'userid', 'passwd'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link); ?>...

I'm using the following PHP code to put a timestamp on my web page: <?php $today = date("l F dS, Y h:i A T"); ?> The problem is, the computer that's hosting my PHP server is the ISP's machine in the Central time zone, and I'm in the Eastern time zone. Is there any way programatically that I...

When I use the mail()function, the resulting email that is sent contains escape characters in front of apostrophes, etc. Example: I don\'t know why an apostrophe causes escape backslashes to appear in the message being sent. I'm new to PHP, so I'd really appreciate it if someone would help me...

I'm used to using sed to change a range of lines in a file. I've found that I like to use Perl better, but I haven't been able to figure out a way to specify a range of lines to change. In sed I can do: sed -i '1,10 s/before/after' filename and that will change the text only on lines 1...

I'm a newbie to Ruby & OO programming, so please bear with me. searched the forum & didn't find anything relevant. I want to print the value of argv[0] to standard output, but I can't figure out the syntax. Below is one of the ways I tried, but it obviously doesn't work. I'd appreciate any...

A few weeks ago, I set up an ssh server on my Ubuntu machine. It worked perfectly. Unfortunately, I'm not an expert at this stuff, and I forgot how to start, stop, restart & check the status of the server from the command line. Can anyone help me out with the commands? Thanks.... PETERV...

I'm a Ruby Newbie, and I haven't been able to find any information on accessing a MySQL database using Ruby. Can anyone post some code that does that, or point me to some documentation that will show me what I need and how to connect to and use a MySQL database? All help will be greatly...

I'm trying to use a "package" subroutine to extract the filename of the calling script from the $0 variable. I pass the $0 variable to the subroutine, then parse it out using split. This works. Unfortunately, I can't figure out the correct syntax to pass that value back to the calling script...

Does anyone know if there is a way to pass parameters to a "package" file, and return values from it? I've been working through examples in a book and while it doesn't show any examples of passing parameters, it doesn't say that it can't be done. Thanks.... PETERV Syracuse, NY & Boston, MA

I'm trying to figure out how to use Perl to manipulate (read, update, add, delete, etc.) records in an Access 2000 or 2003 database. I've looked up the DBI package, but it's a little confusing, as I'm quite new to this. What I'm looking for is a simple example of a Perl script that uses DBI to...

Does anyone know if there is a way to create a variable name that includes the name of another variable? What I'm looking to do is create the name of a counter, that contains the name of what is being counted. Example: I have two messages whose message names are TR001 & XY002. I'm counting...

if ($part2 =~ (/A[BGIP]001/)|(/T[ER]001/)|(/CP002/)|(/MF00[12]/)| (/OS001/)|(/T[ER]001/)|(/SY001/)) { I'm using the regex above to find out if any of the listed message codes are in the current input line. What I need to know, is: If there is a match, is there any way to...