If you are using a custom session handler by means of
session_set_save_handler() - the last arg to the function is the gc()
function, which is the actuall function that is used to clean up the expired
sessions from the database. You would set the value in your php ini file
unser the session gc dire
>A question on cleanup?
> example:
> 1. Connection via mysql_connect via the web.
> 2. Know that mysql_connect relinquishes the connection link upon the
> script ending.
> 3. User performs work and has several global variables stored in memory
> on the server.
> 4. User doesn't logout at the en
Hi:
I can run postgres under win98 (SE) only with cygwin (only client not server)
> Hi,
> I'm trying to use PostgreSQL on Windows98!
> Does anyone here succeded with it?
>
> Thanks
> Bruno (sorry.. my mistakes).
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
Hello,
A question on cleanup?
example:
1. Connection via mysql_connect via the web.
2. Know that mysql_connect relinquishes the connection link upon the
script ending.
3. User performs work and has several global variables stored in memory
on the server.
4. User doesn't logout at the end of the
As usual.
John knows best.
Thanks!
Aaron
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: July 25, 2003 3:05 PM
To: Aaron Wolski; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] query and display acting weird...
Probably need:
ORDER BY t.manufacturer, t.colourID
-
Probably need:
ORDER BY t.manufacturer, t.colourID
---John Holmes...
- Original Message -
From: "Aaron Wolski" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 25, 2003 2:58 PM
Subject: [PHP-DB] query and display acting weird...
> Hi Guys,
>
> Code:
>
> echo " style=
Hi Guys,
Code:
echo "\n";
$query = "select t.manufacturer, t.id, t.colour, t.colourID, t.type,
p.thread_index FROM kcs_threads t LEFT JOIN kcs_patternthreads p ON t.id
= p.thread_index WHERE p.pattern_index = '$id' OR p.pattern_index IS
NULL ORDER BY t.colourID";
$thread_manufacturer
I have tried the column as a varchar and timestamp but it does not work.
with the Timestamp setup and DATE_FORMAT() I get 00-00- at the moment
and I know that there are dates in there. The reason for this is the import
changes all the field to 00 which is the TimeStamp default.
I
There's a mistake try this:
$query2 = "select Title, date_format(Date,'%d-%m-%Y') as fDate, Artist,
Country,
RecordCompany, CatalogueNumber, Composer FROM recording where title regexp
'$keyword'";
-Messaggio originale-
Da: Morgan Bardon [mailto:[EMAIL PROTECTED]
Inviato: venerdì 25 lug
> Thanks for that, but I get a NULL entry in the field then for all the
dates.
What column type is the DATE column? Also, since DATE is a reserved word in
MySQL, naming a column DATE probably wasn't a good idea. If you know you
always want the first 11 characters, you can always do LEFT(Date,11) t
Thanks for that, but I get a NULL entry in the field then for all the dates.
- Original Message -
From: "Moreno Riccardi" <[EMAIL PROTECTED]>
To: "Morgan Bardon" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 25, 2003 4:34 PM
Subject: R: [PHP-DB] MYSQL and PHP cast() function
I have recently built PHP 4.3.2 using the --with-MySQL, but heard a
rumor that the PHP built in libraries to MySQL are old and not
completely compatible with MySQL 4. Does anyone out there know if this
is not a concern...does the built in MySQL interface in PHP 4.3.2 work
with MySQL or do I nee
Try
$query2 = "select Title, date_format(Date,'%d-%m-%Y) as Date, Artist,
Country,
RecordCompany, CatalogueNumber, Composer FROM recording where title regexp
'$keyword'";
Hi,
Moreno
-Messaggio originale-
Da: Morgan Bardon [mailto:[EMAIL PROTECTED]
Inviato: venerdì 25 luglio 2003 17.17
A: [
Hi there,
I have been trying to get a solution to this select query from all over the
web and have found no answer so I was hoping someone here could help out.
The date field of the database is imported from a text file with the date
format 'dd-mm- hh:mm:ss' and I only want to display the fir
Henrik,
It's possible that the database is interpreting your date as a couple of
subtraction operations. I always use quotes or single ticks around my
dates when refrencing them in SQL.
Example:
INSERT into some_table (date) values ("2003-07-25");
Give a sample of your code so that your proble
Hi,
I had this problem that was driving me crazy. I was trying to input a datetime to a
mssql table, formated the same way as I use in all my other tables i.e d-m-Y.
But no matter which variations of the basic format I tried, it didn't understand the
date correctly. In desperation I tried someth
Merlin wrote:
Hello ,
I have a sql problem which seems to be simple, but I am kind of stuck,
There are 2 tables with IDs. I would like to find out which ID from table
one is not in table 2.
My statement:
SELECT ap. *
FROM pictures p , album_pictures ap
WHERE ap.pic_id != p.pic_id
returns of cour
On Fri, 25 Jul 2003 02:31:39 -0600
Stephen March <[EMAIL PROTECTED]> wrote:
> Any database that supports nested queries (unfortunatly this excludes
> MySQL) ... you can do
>
Subselects are supported in MySQL 4.1 ... :-)
> select pic_id from pictures where pic_id not in (select pic_id
>
Any database that supports nested queries (unfortunatly this excludes
MySQL) ... you can do
select pic_id from pictures where pic_id not in (select pic_id from
album_pictures)
Otherwise you might have a harder time with MySQL ... something like set
difference if it supports it (I'm not s
Hello ,
I have a sql problem which seems to be simple, but I am kind of stuck,
There are 2 tables with IDs. I would like to find out which ID from table
one is not in table 2.
My statement:
SELECT ap. *
FROM pictures p , album_pictures ap
WHERE ap.pic_id != p.pic_id
returns of course all the id
20 matches
Mail list logo
