Another idea of mine:
You could start sessions and register a variable...
and everytime a new user wants to request a page you can find
out whether its a new user or not if you check the variable ...
If it is new, then do the stuff below ... elso don´t ...
Cheers,
Marcel
> -Original
Hi Paul (both of you),
Thanks for your suggestions:
Paul DuBois wrote:
SELECT publisherID, COUNT(*) FROM WLPpublisher GROUP BY publisherID
Paul Burney wrote:
SELECT COUNT(bibID) FROM bookDB WHERE publisherID='$your_publisher_id';
And the final code that did the trick was actually a combination
in a simple way, yes.
if you really want unique users, you can setup a table and insert the IP
addresses in their and query it everytime.
the PHP variable that keeps track of the user'a IP address can also be
checked by storing it in a variable and re-checked each time the page is
loaded.
Shahm
also, make sure you have selected a db to work on onece connected to the
mysql server
mysql_select_db or something like that
beau
// -Original Message-
// From: leo g. divinagracia iii [mailto:[EMAIL PROTECTED]]
// Sent: Tuesday, 24 July 2001 12:21 PM
// Cc: [EMAIL PROTECTED]
// Subject
Darrell wrote:
>
> I got mysql installed on my win2000 machine, and have apache running with
> php 4 all working correctly.
>
> but I can't get php to work with the db...
>
> I'm pretty sure I can connect with mysql_connect(...) because it doesn't die
> at that spot. rather, when I try to do
on 7/23/01 6:53 PM, Mike Gifford at [EMAIL PROTECTED] wrote:
> I'd like a simple query to determine how MANY books in a database are released
> by A publisher. This shouldn't be a big deal, but I've looked at a number of
> solutions and am coming up short. MySQL is being accessed via phplib, bu
If I do the below, like you stated, that means the counter will update
everytime a visitor refreshes the content.
Would it be possible for the counter script not to increase the value by 1
when a visitor merely refreshes. Is it possible to let the script increase the
value by only by one, only if
Hello All,
I'd like a simple query to determine how MANY books in a database are released
by A publisher. This shouldn't be a big deal, but I've looked at a number of
solutions and am coming up short. MySQL is being accessed via phplib, but I'm
sure that it's just how I'm expressing the gene
i use ...
SELECT *, UPPER(name) AS testfield FROM testtable ORDER BY testfield
hope it helps.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL P
Those emails he's sending might be caused by a virus. I've received about 30
weird emails over the last couple days all from the same person. So have a
few other people in our office. Fortunately our server's been deleting the
virus attachments.
It was the "W32/SirCam@MM" virus. I don't know any
in pseudo-code:
make a text file - associate it a URL
when a user comes along, have a PHP script on top of the web page to
1. open the text file
2. counter = counter +1
3. write update
3.5 print number of hits somewhere on webpage
4. close file...
Shahmat Dahlan wrote:
>
> I'd like to do a
How do I add new line characters to a text field in mySQL ?
i.e. i need to manually insert "returns" into my text ...
thanks in advance,
KennM
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To con
Yes, ODBC - If you are using unix, i recommend the openlink MT drivers
(www.openlinksw.com) There is no native mode interface available for
PROGRESS.
> -Original Message-
> From: André [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 23, 2001 11:42 AM
> To: [EMAIL PROTECTED]
> Subject: [PH
How I can access a Progress database? ODBC?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
What was all that about~??
-Original Message-
From: Christian St-Pierre [mailto:[EMAIL PROTECTED]]
Sent: 23 July 2001 16:02
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: [PHP-DB] cancel <[EMAIL PROTECTED]>
This message was cancelled from within Mozilla.
--
PHP D
I see in the PHP 4.0.6 release notes that mysql_error() and mysql_errno()
have been fixed so that you can get error information from them when
a connect call fails. (Previously they worked only after successfully
establishing a connection, so that you had to use $php_errormsg with
track_errors tur
THX to everyone for the help!!!
"Steve Brett" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> pull it out then use stripslashes() as you display it ...
>
> Steve
>
> "Andrew" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
pull it out then use stripslashes() as you display it ...
Steve
"Andrew" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi, I'm having trouble getting special characters out of MySQL using php
> 4.06.
>
> I add a field like "McDonald's" from PHP and in mysql
Hi, I'm having trouble getting special characters out of MySQL using php
4.06.
I add a field like "McDonald's" from PHP and in mysql client I can see the
entry (McDonald's) is put into the database correctly. However the problem
arises when I query it and it prints out (McDonald\'s). Is there any
Thanks for the response, but that is exaclty what I am doing. Here's an example:
I input the following into a varchar field:
This is the first line of text.
This is the second line of text.
This is some text with a link
This is the next line.
This is the last line.
There are two cases possible:
1. Store already HTML-formatted text in db. Then you do nothing
before sending it to the screen; never use nl2br() here!
2. Store plain text, may be with a simpliest tags like b, i, u,
ol, ul, li, a, img. Then put it through the nl2br() function
before outp
Hi,
I'm getting a problem when I pull text from a mySQL database. The text is froma
varchar field and contains some HTML tags. New lines are translated to , but
when the field is outputted, anything coming after an HTML tag loses its formatting
(ie. no line breaks converted to ).
Can anyone s
I have a Linux Server, with Apache 1.3.19 + PHP 4.0.6 and MySQL 3.23.37, and
i have a trouble with Transactions in PHP code:
When i write a transaction, and some error (PHP lang error) occurs, the
transaction are autocommited, and only part of the querys are made, with the
inconsistence of data,
Hi Christian,
What most sites do is to keep track of the latest time that a user requested
a page (ie when a page is requested store the current time).
Then a definitiion of "logged-in" is made usually this is "has requested
a page in the last 30 minutes" so the query to count the users who
With Interbase functions I have to make 2 select.
"SELECT count(*).. to count valid record
and
"SELECT * .. to extract the records
There is a simple solutions to have unique Select ?
I use Pgsql too but here I Have the pg_numrows variable.
--
PHP Database Mailing List (http://www.php.net/)
php is not compiled with postgresql support.
Steve
"Sean McCoy" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> When I execute a pg_connect() in a .php file, I get an error indicating
that
> the function is not defined...
>
> That's because, in the Apache erro
Hello again everyone...
I am doing some research for a project of mine and i was wondering if
someone is familliar with the match () against () function of mysql?
I know it returns a number etc 1.4343434 like a similarity number but how
can i convert this string to percentage like all the big se
I'd like to do a counter with PHP, how do you do this? I thought maybe I
could either use cookie or session or session? Which should I use ?
regards and thanks is adnved
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail
Hi,
I'm writing a bbs/messageboard system and am trying to figure out how to tell
what other users are logged on.
I know I could store the info in a table in my login code but then how do I
find out if people are logged out
with out making them actually use a logout button or the like.
I was g
29 matches
Mail list logo