[PHP-DB] Re: Combining 2 queries into 1?

2004-05-31 Thread Alexey Kupershtokh
Kim Steinhaug [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] After crawling through the MySql reference I finally found the function I was looking for, the sollution for combining theese two queries would be : SELECT count( * ) AS online_anonymous, sum( sign( uid ) ) AS

[PHP-DB] $_Session vs $_Cookie

2004-05-31 Thread Ng Hwee Hwee
Hi all, I have a problem: my $_SESSION variables and $_COOKIE variables get destroyed very often, even though my clients are actively browsing the site (that means, the variables should not be garbage collected). Our guess is that the network connections are weak. My server is in Singapore but

[PHP-DB] CSV update Mysql feature

2004-05-31 Thread Kenny
hi all, What I am trying to achieve to no avail is the following I export values from a Mysql db into CSV format for quick updates and that works fine.. http://www.xarex.com/jantar/admin/pick_csv.php www.xarex.com/jantar/admin/pick_csv.php But as you can see from the page you can select the

[PHP-DB] Re: $_Session vs $_Cookie

2004-05-31 Thread Torsten Roehr
Ng Hwee Hwee [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi all, I have a problem: my $_SESSION variables and $_COOKIE variables get destroyed very often, even though my clients are actively browsing the site (that means, the variables should not be garbage collected). Our

Re: [PHP-DB] Re: $_Session vs $_Cookie

2004-05-31 Thread Ng Hwee Hwee
hi.. the situation is like this: my clients' $_SESSION gets destroyed even after only a few seconds of inactivity! so, with my current setting for gc_maxlifetime (1440), it should be more than enough to have their sessions registered for the few minutes, right? thus, i deduce that the solution

Re: [PHP-DB] Re: $_Session vs $_Cookie

2004-05-31 Thread Torsten Roehr
Ng Hwee Hwee [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] hi.. the situation is like this: my clients' $_SESSION gets destroyed even after only a few seconds of inactivity! so, with my current setting for gc_maxlifetime (1440), it should be more than enough to have their sessions

[PHP-DB] Question about undices for inversed LIKE statesments.

2004-05-31 Thread Alexey Kupershtokh
Hello. I have a question about behaviour of indices in queries with inversed LIKE in MySQL. I mean something like this: select foo from bar where '$some_string' LIKE some_field where in the `some_field` I have a strings like 'symbols%' :) Do you have some ideas? WBR, Wicked -- PHP Database

Re: [PHP-DB] Re: $_Session vs $_Cookie

2004-05-31 Thread Ng Hwee Hwee
i do not really experience this problem.. i can click through the links easily.. hmm.. your question sets me thinking.. do you think it has to do with some VPN thing? my system is an intranet system and the users log on to it through a VPN.. do you think it will cut my sessions?! by the way, I

Re: [PHP-DB] Re: $_Session vs $_Cookie

2004-05-31 Thread Torsten Roehr
Ng Hwee Hwee [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] i do not really experience this problem.. i can click through the links easily.. hmm.. your question sets me thinking.. do you think it has to do with some VPN thing? my system is an intranet system and the users log on to

[PHP-DB] Re: Re: $_Session vs $_Cookie

2004-05-31 Thread Alexey Kupershtokh
Hi. Is your server running on Windows? Have you tried using a database as your session container? Hmm... that's something new for me :) How to implement it ? Manually ? Or it is available in php config file? Or another question: where I can read about this ? :) -- PHP Database Mailing List

[PHP-DB] Re: Re: $_Session vs $_Cookie

2004-05-31 Thread Torsten Roehr
Alexey Kupershtokh [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi. Is your server running on Windows? Have you tried using a database as your session container? Hmm... that's something new for me :) How to implement it ? Manually ? Or it is available in php config file? Or

Re: [PHP-DB] Question about undices for inversed LIKE statesments.

2004-05-31 Thread Daniel Clark
The index should still work normally. Hello. I have a question about behaviour of indices in queries with inversed LIKE in MySQL. I mean something like this: select foo from bar where '$some_string' LIKE some_field where in the `some_field` I have a strings like 'symbols%' :) Do you have some

[PHP-DB] Re: Create subdomain using php in a linux machine

2004-05-31 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Dhanya philip wrote: Hi, I like to know how to create subdomain using php in a linux machine. Thank You Dhanya Yahoo! India Matrimony: Find your partner online. Did you ever find a solution for this problem?? I'm interested in doing the same. JG -- PHP Database Mailing List

RE: [PHP-DB] Re: Create subdomain using php in a linux machine

2004-05-31 Thread Sunmaia
Hi Assuming you are using BIND. You need to edit the zone file using php. This means giving php write access to the file. If you can do this then. open the file for writing using fopen add the domain record to the end write the file to disk.

Re: [PHP-DB] Re: $_Session vs $_Cookie

2004-05-31 Thread Ng Hwee Hwee
Hi Sukanto, I'm glad I'm not alone. :o) I'm working on an intranet, thus i can ask my staff to enable their cookies.. but this is really not the best way. Right now, I am trying to convert all my sessions to cookies because this is a faster solution to solve my urgent problem. But I think as

[PHP-DB] Re: CSV update Mysql feature

2004-05-31 Thread Uzi Klein
It's kinda clear. What isn't clear is what the problem? Kenny [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] hi all, What I am trying to achieve to no avail is the following I export values from a Mysql db into CSV format for quick updates and that works fine..