Thanks.
Analog only does basic 'what files have people viewed?' type reports, which
offers some of the insight I am looking for, but not the path through the
site etc. Also the output confuses non techies. Any other thouhts?
TIA
Peter
---
Excellence
This should do the trick (untested):
SELECT ClientName, Count(*) FROM Clients LEFT JOIN Ratings ON Clients.ID =
Ratings.ClientID
GROUP BY ClientName
HAVING Ratings.Status = 2 OR Ratings.Status = 3
regards,
Peter
Software Engineer / Trainer
Vervoorn IT
- Original Message -
From: John
On Thursday 14 February 2002 07:29, Peter Lovatt wrote:
Hi
Excuse the cross post
I am thinking about building a logging tool to do visit analysis using SQL,
rather than doing log file analysis.
The aim is to analyse requests for dynamic pages called via php as well as
static pages.
i think i saw an article on phpbuilder.com regarding how to set up a good
thing for the path taken - something along the lines of storing IP vs time
vs page hit, then a good method for selecting from the db that shows the
path of the visitor
HTH
beau
// -Original Message-
// From:
On Thursday 14 February 2002 07:29, Peter Lovatt wrote:
Hi
Excuse the cross post
I am thinking about building a logging tool to do visit
analysis using SQL,
rather than doing log file analysis.
The aim is to analyse requests for dynamic pages called via php
as well as
static
You can use the GD module in PHP to accept and resize the images. Currently
(do to copyright restrictions) the GD libraries ONLY work with .jpg and .png
graphics. This form will only allow you to upload one image at a time, so
you'd have to 1) Make a script to accept and resize the files and
ummm i am currently using http://www.ezboo.com/ to look @ how it comes out
hea to http://lollan.qldgamers.com/
I like it.
Shooter
- Original Message -
From: Peter Lovatt [EMAIL PROTECTED]
To: Jason Wong [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, February 14, 2002 9:05 PM
OK, this time tested :)
SELECT Clients.ClientName, Ratings.Status, Count(*) FROM Clients LEFT JOIN
Ratings ON Clients.ID = Ratings.ClientID
GROUP BY ClientName, Ratings.Status
HAVING Ratings.Status = 2 OR Ratings.Status = 3
regards,
Peter
Software Engineer / Trainer
Vervoorn IT
- Original
Hi All,
I have this code creating a list in a select box.
All works ok, I get my list BUT and a NIG BUT.
When I select an item to delete it only ever deletes from the last
record to the top.
Err why ?
I think all my code is in the right order but obviously not.
Can anyone throw some
I have been looking on php.net for a function to disallow people to right
click to view source... anyone have a good idea of how to accomplish this
without using java-script?
Thanks in advance,
Jas
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
You can't do this using PHP, because PHP is server-side. You will need
JavaScript.
-Original Message-
From: jas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 12:18 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Disable Right click w/ php?
I have been looking on php.net for
No way. PHP is server-side. Javascript is mostly clientside.
Best regards,
Andrey Hristov
- Original Message -
From: jas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 14, 2002 8:17 AM
Subject: [PHP-DB] Disable Right click w/ php?
I have been looking on php.net for
it is called magic quotes and it can be enabled through the php.ini file.
Jim Lucas
- Original Message -
From: William Fong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 13, 2002 10:36 AM
Subject: Re: [PHP-DB] Passing form values with quotes, to itself
Doesn't PHP
Hi there. Got a bit of a snag. I'm migrating an ASP app to PHP with a
mssql7.0 backend. The snag is this, I have a 'starttime' field in my db
using the 'datetime' format ... looks like this 2/14/2002 12:21:28 PM.
Unfortuanely, I'm unable to convert this field to type integer at the
present
Try this
if ($submit)
{
if($search == )
{
$error1 = font color=redNo Records found. Please use at least 1
character in search box/font;
} else {
$srchsql = select * from $tbn where name like \%$search%\ ;
$srchresult = mysql_query($srchsql, $con);
?php
$t = date(m/d/Y h:i:s A, gettimeofday());
print $t;
?
-Original Message-
From: Lerp [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 12:45 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Time Question
Hi there. Got a bit of a snag. I'm migrating an ASP app to PHP with a
CORRECTION:
?php
$t = date(m/d/Y h:i:s A, time());
print $t;
?
--
C:\php -f a.php
02/14/2002 12:49:50 PM
-Original Message-
From: Lerp [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 12:45 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Time Question
Hi there.
Thx Rick :) Appreciate your help :)
Cheers, Joe
Rick Emery [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
?php
$t = date(m/d/Y h:i:s A, gettimeofday());
print $t;
?
-Original Message-
From: Lerp [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February
Use:
date(n/j/Y g:i:s A);
If you need any more help on what the letters mean, or you need to change
the layout visit:
http://www.php.net/manual/en/function.date.php
keTTle_drum.
Hi there. Got a bit of a snag. I'm migrating an ASP app to PHP with a
mssql7.0 backend. The
Neil,
My 2 cents :
In fact Todd has also been spouting ( moaning? g ) on the Windows/PHP
list too ;-)
Certainly, parsing Word docs is not necessarily a PHP-DB issue, but an
interesting problem or hack nonetheless.
IMHO M$ have set themselves up for 'illegal' hacking of their file formats
Anyone know of a good function to strip characters and stuff that would
cause mysql to crash from forms?
Jas
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
At a philosophical level, I don't think this should be done -- I don't want
people messing with my browser settings, because sure as shooting they will
not be restored when I leave the site.
What is so precious in the HTML that one can't view the source?
Miles
At 12:12 PM 2/14/2002 -0600,
addslashes() stripslashes()
Your question is vague...
-Original Message-
From: jas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 1:32 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Form Validation
Anyone know of a good function to strip characters and stuff that would
Hello all,
I'm looking for a PHP tool that would take the results of a MySQL
query and send them to a client browser in DBF format.
I wrote an output tool that sends a query result as CSV to the
browser, but DBFs are much more handy in this particular case.
Does this exist?
Does anyone know how to put a bitmap into an Image? I need to have a filled
circle in a graph. This shouldn't be a problem except we have an older
version of GD (and our network guy is overworked so it would take a few
weeks to get a newer version installed) and the graph has gridlines. If I
Hi
I don't think it is possible without javascript, and it does not always work
with javascript.
Anybody with any real knowledge can bypass it anyway simply by saving the
page and opening it in a text editor. So Javascript will stop casual right
clickers, and the others will do it anyway, if
Hi
I spent ages trying to get it to work. Echoing the always closes the text
area in an input box, so any data after the quotes isn't displayed. Its
fundamental to the HTML, so adding slashes is irrelevant.
What I did in the end was to swap double quotes for two single quotes ''
using
Hi - I actually got this to work for me - if you remember, I wasn't having
problems writing values w/ double or single quotes to the database - it was
passing the form values from page to page, inside text boxes, etc.
What I had to do was use:
input type=text name=Summary value=? echo
28 matches
Mail list logo
