[PHP-DB] Re: Search

2007-03-13 Thread Haydar Tuna
Hello, I wrote a thesis search engine in my university. You can try this search engine from http://www.fbe.gazi.edu.tr/tezara/ web address. In my application, I seperated keyword of any thesis with quote and then I inserted this keyword to the thesis table. In this table I also inserted

[PHP-DB] Re: howto: mktime() function

2007-03-13 Thread zerof
bedul escreveu: i wonder how i can get value from mktime. my friend want to build mktime using asp but he wonder how to have the value.. what he have are the function same as date() on asp. if someone have time to build the same function but only use date.. plz post here thx in advance

[PHP-DB] Caching query results in html pages

2007-03-13 Thread Vincent
Hi all, I'm trying to improve the performance for visitors, and I want to know if there is some way to store the mySQL results of .php scripts in webpages. So, in example, when requesting http://www.mydomain.com/script.php?id=110 , it can be redirected to his cached version

RE: [PHP-DB] Caching query results in html pages

2007-03-13 Thread Bastien Koert
you can write an html page on the fly and save that to the hard drive have a look at fopen/fwrite etc bastien From: Vincent [EMAIL PROTECTED] Reply-To: Vicente [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Caching query results in html pages Date: Tue, 13 Mar 2007 14:20:58

Re[2]: [PHP-DB] Caching query results in html pages

2007-03-13 Thread Vincent
Bastien wrote: BK you can write an html page on the fly and save that to the hard drive BK have a look at fopen/fwrite etc And a more elaborated thing?. Some source development? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: Re[2]: [PHP-DB] Caching query results in html pages

2007-03-13 Thread Bastien Koert
http://www.weberdev.com/get_example-4082.html From: Vincent [EMAIL PROTECTED] Reply-To: Vincent [EMAIL PROTECTED] To: php-db@lists.php.net Subject: Re[2]: [PHP-DB] Caching query results in html pages Date: Tue, 13 Mar 2007 18:41:42 +0100 Bastien wrote: BK you can write an html page on the

[PHP-DB] MySQL sort stopped working

2007-03-13 Thread Tony Grimes
I have this page that lists artists alphabetically: http://www.wallacegalleries.com/artists.php At least it did until today. Nobody made any changes to the files, but the database stopped sorting by artist_id. The list shown is just the default order that mysql spits out if the SORT BY clause is

RE: [PHP-DB] MySQL sort stopped working

2007-03-13 Thread Bastien Koert
too small a sort space on the server? have you checked the server config? Bastien From: Tony Grimes [EMAIL PROTECTED] To: PHP-DB php-db@lists.php.net Subject: [PHP-DB] MySQL sort stopped working Date: Tue, 13 Mar 2007 13:22:25 -0600 I have this page that lists artists alphabetically:

[PHP-DB] do not display dublicated entries

2007-03-13 Thread septic
Hello all, I have created a simple webtracer for my website and I save some info on mysql database. table = tracker FIELDS ip day month year session_id browser of visitor page that was visited What I would like to do next, is simple to create an output of that database with the last time

Re: [PHP-DB] Caching query results in html pages

2007-03-13 Thread Micah Stevens
This may work, although I just made it up. I can see already that you'd have some problems with multiple scripts running at once. If a script opens the cache, then a second script saves new cache information before the first script saves it's data, the first script would overwrite the second

Re: [PHP-DB] MySQL sort stopped working

2007-03-13 Thread Chris
Tony Grimes wrote: I have this page that lists artists alphabetically: http://www.wallacegalleries.com/artists.php At least it did until today. Nobody made any changes to the files, but the database stopped sorting by artist_id. The list shown is just the default order that mysql spits out if