[PHP-DB] who's logged on / how to I find out about other sessions

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

[PHP-DB] Access counter

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,

[PHP-DB] Match () Against () with mysql php..

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

[PHP-DB] Re: PHP, Apache PostgreSQL

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 error log

[PHP-DB] INTERBASE PHP

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/)

Re: [PHP-DB] who's logged on / how to I find out about other sessions

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 whose

[PHP-DB] Problem with BDB ,can anybody help me!!!

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,

[PHP-DB] HTML tags destory formatting?

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 BR, but when the field is outputted, anything coming after an HTML tag loses its formatting (ie. no line breaks converted to BR). Can

Re: [PHP-DB] HTML tags destory formatting?

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

Re: [PHP-DB] HTML tags destory formatting?

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 a href=link.phplink/a This is the next line. This

[PHP-DB] retrieving special characters from 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

[PHP-DB] Re: retrieving special characters from MySQL

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 client I

[PHP-DB] Re: retrieving special characters from MySQL

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]... Hi, I'm

[PHP-DB] mysql_[p]connect() and mysql_error()/mysql_errno()

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

RE: [PHP-DB] cancel 20010723135436.90722.qmail@pb1.pair.com

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

[PHP-DB] PHP x Progress

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]

RE: [PHP-DB] PHP x Progress

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:

Re: [PHP-DB] Access counter

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

RE: [PHP-DB] cancel 20010723135436.90722.qmail@pb1.pair.com

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

Re: [PHP-DB] case-insensitive select?

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

[PHP-DB] Counting Number of Instances in a One2Many Relationships

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

Re: [PHP-DB] Access counter

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

Re: [PHP-DB] Counting Number of Instances in a One2ManyRelationships

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, but

Re: [PHP-DB] config php w/ mysql

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 the

RE: [PHP-DB] config php w/ mysql

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] //