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!
Search results for query: *
- Users: PCHomepage
- Order by date
-
What has happened here to Tek-Tips??
I haven't used Tek-Tips in over a decade but have also recently started getting messages out of the blue, some of which seem like junk or are on topics to which I've never subscribed for programming languages that I do not recognize. In any event, this appears to be a Microsoft Office group of...- PCHomepage
- Post #12
- Forum: Microsoft: Office
-
Show Single Row in Foreach
Sounds good and makes perfect sense, thank you! I'll give it a try when I'm back home but if possible I would like to try to make it be self-contained within the function as it's being used in several different scripts.- PCHomepage
- Post #10
- Forum: PHP
-
Show Single Row in Foreach
This document is nearly 800 pages long so the data is grouped by some other value in such a way that the starting page of a given group can be anything, and each group is relatively short making it very manageable. The very first page of the first group is 1 but after that it changes based on...- PCHomepage
- Post #8
- Forum: PHP
-
Show Single Row in Foreach
Yes, PageNo comes from the database row which I had tried to say in my original question but perhaps wasn't too clear and yes, I want to show the HTML when the page number changes. That is exactly what I was trying to do but I wasn't sure what to use for comparison. $PageNoToCompare =...- PCHomepage
- Post #6
- Forum: PHP
-
Show Single Row in Foreach
It's not the solution I was looking for but I did find a work-around that does the job. By feeding the ID field into the function, then checking which row has the last page number before it changes, it then shows the information from the function in the proper places. In the meantime, I am open...- PCHomepage
- Post #4
- Forum: PHP
-
Show Single Row in Foreach
I don't know in advance how many rows there will be on any given page and used 41 only as an example of one of the data sets. $PageNo is a value from a field in the database and the foreach loop is below with the function being called toward the end of it. I did not show the database connections...- PCHomepage
- Post #3
- Forum: PHP
-
Show Single Row in Foreach
I wrote a function to put the page number at the bottom of each page and I understand in general why it's not working but cannot work out the logistics to make it work. This is being run inside a foreach loop after the rest of the content is written to the screen. $PageNo (and $RevDate) are...- PCHomepage
- Thread
- Replies: 9
- Forum: PHP
-
Query For Range Values Without Table
As this seems an impossibility, thank you all who answered and I'll now move on to Plan B of doing it in PHP and modifying the function to also accept an array in addition to accepting the query. (Chris, I've always liked the quotes in your signature!)- PCHomepage
- Post #8
- Forum: MySQL
-
Query For Range Values Without Table
Unfortunately, there is no relationship whatsoever between the ID and the year. In fact, every time the form is submitted, the starting ID will change but the years will not. I have never seen this type of query before so am unsure how to proceed or even if it's possible. The whole point is that...- PCHomepage
- Post #5
- Forum: MySQL
-
Query For Range Values Without Table
Thank you for replying, Olaf. No, I don't want the ID to be the year as the ID needs to start incrementing at a specific value which is being generated by the PHP and is independent of the year. Also, the year needs to be within a range of probably 1899 to 1996. Ideally it shouldn't use a table...- PCHomepage
- Post #3
- Forum: MySQL
-
Query For Range Values Without Table
I'm trying to come up with a query that will give me a range of years from a specific start to specific end, and then to auto-increment the list starting at another specific value. So far I've succeeded partially by getting the year values from an existing table but it does not have the full...- PCHomepage
- Thread
- Replies: 7
- Forum: MySQL
-
Get Row Number in MySQLi
Thank you, that is exactly what I was looking for!- PCHomepage
- Post #6
- Forum: PHP
-
Get Row Number in MySQLi
That's what I thought. I'm trying to create a function to provide the row number when run inside a loop so how would I do it? I'm not sure where to begin.- PCHomepage
- Post #3
- Forum: PHP
-
Get Row Number in MySQLi
How can I get the row number in a list of entries? It's not the number of rows in the result that I need: it is a line by line count of each one.- PCHomepage
- Thread
- Replies: 5
- Forum: PHP
-
Regular Expressions
...is the main issue here. When I first wrote the function it used a pattern something like: $pattern = '/^([^ ]+) ([^ ]+) ([^ ]+) (\[[^\]]+\]) "(.*) (.*) (.*)" ([0-9\-]+) ([0-9\-]+) "(.*)" "(.*)"$/'; and to assign variables, it was using: list($whole_match, $remote_host, $logname, $user...- PCHomepage
- Post #3
- Forum: PHP
-
Regular Expressions
...$pattern .= '([^\s]+) '; // User $pattern .= '\[(\d+)\/(\w+)\/(\d+):(\d{1,2}:\d{1,2}:\d{1,2} '; // Datetime WORKS SO-SO $pattern .= '?[\+\-]?\d*)\] "(.*)/'; // Remainder if (is_readable($path)) : $fh = fopen($path,'r') or die($php_errormsg); while (!feof($fh)) : $s = fgets($fh)...- PCHomepage
- Thread
- Replies: 2
- Forum: PHP
-
Access.log to MySQL
I created a function to emulate the Apache access.log in MySQL and it is working but there are several things with which I need help. Any thoughts on the following? The first is $status for which I created the GetStatus() function but when it is used, the server times out. Using the same code...- PCHomepage
- Thread
- Replies: 0
- Forum: PHP
-
Parse Apache access.log Eliminate Spiders and Bots
Yes, the logs are there but only as compressed .gz files and are compressed by month. Because it's a shared server with other clients, the actual logs are not available any other way which is why the hosting company offered to send me a copy. I suppose I could write a script to extract them to a...- PCHomepage
- Post #3
- Forum: PHP
-
Parse Apache access.log Eliminate Spiders and Bots
...function: function ParseToDatabase($path) { // Parses the NCSA Combined Log Format lines: $pattern = '/^([^ ]+) ([^ ]+) ([^ ]+) (\[[^\]]+\]) "(.*) (.*) (.*)" ([0-9\-]+) ([0-9\-]+) "(.*)" "(.*)"$/'; global $output; if (is_readable($path)) : $fh = fopen($path,'r') or die($php_errormsg)...- PCHomepage
- Thread
- Replies: 3
- Forum: PHP
-
Google API Result Inconsistency
I'm working on what should be a simple function to get the name of one of two California counties. However, on the line highlighted below, address_components[3] for one county gives the proper value but for other it needs to use address_components[4] to get the proper value. That is, for one of...- PCHomepage
- Thread
- Replies: 0
- Forum: PHP
