Re: [PHP-DB] Automatic logoff

2010-01-28 Thread Richard Quadling
On 27 January 2010 17:20, listread listr...@cze.com wrote: Richard, I think I need to learn about semaphores!  Any suggestions for a good tutorial? One of the things we want to do is exclude locked records from a query.  Will semaphores provide for that? Thanks! - Ron On 1/27/2010

Re: [PHP-DB] FW: Oracle Finalizes Acquisition of Sun

2010-01-28 Thread Bastien Koert
[snip] [/snip] PS We will now proceed to fire some 20,000 employees as they will no longer be needed. -- Bastien Cat, the other other white meat -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Automatic logoff

2010-01-28 Thread listread
Great explanation, Richard! I think I understand the concept now. I'll study it a little and try to implement it. Thanks! - Ron On 1/28/2010 5:47 AM, Richard Quadling wrote: On 27 January 2010 17:20, listreadlistr...@cze.com wrote: Richard, I think I need to learn about semaphores!

Re: [PHP-DB] Automatic logoff

2010-01-28 Thread listread
Richard, One more question (for now): Are there advantages to using a separate table for locking, rather than specifying a lock column in the table you want to lock the row in? - Ron On 1/28/2010 5:47 AM, Richard Quadling wrote: On 27 January 2010 17:20, listreadlistr...@cze.com wrote:

Re: [PHP-DB] Automatic logoff

2010-01-28 Thread Richard Quadling
On 28 January 2010 20:29, listread listr...@cze.com wrote: Richard, One more question (for now):   Are there advantages to using a separate table for locking, rather than specifying a lock column in the table you want to lock the row in? - Ron On 1/28/2010 5:47 AM, Richard Quadling wrote:

Re: [PHP-DB] FW: semaphores WAS: [PHP-DB] Automatic logoff

2010-01-28 Thread Richard Quadling
On 28 January 2010 21:38, Daevid Vincent dae...@daevid.com wrote: An intersting synopsis of Semaphores. I've done similar things in the past, but never knew this is what I was doing. LOL. Just like I've built an uber XML parser/editor and didn't know that I actually built a Factory. Ahhh...

[PHP-DB] Need Help

2010-01-28 Thread nagendra prasad
Hi, I have a database of MP3 and I have designed a PHP-Mysql search engine. I want to break it down in pages like Google dose. What I mean is when I search for a song it will show me some 100 song list but I want 20 songs per page. So, is their any trick to do it? Best, -- Guru Prasad Ubuntu

Re: [PHP-DB] FW: Oracle Finalizes Acquisition of Sun

2010-01-28 Thread Eric Lee
hmm, that' true now !! Shall the mysql db become paid software !! Regards, Eric, On Thu, Jan 28, 2010 at 11:44 PM, Bastien Koert phps...@gmail.com wrote: [snip] [/snip] PS We will now proceed to fire some 20,000 employees as they will no longer be needed. -- Bastien Cat, the other

Re: [PHP-DB] Need Help

2010-01-28 Thread Udhaya Kumar
Hi There This is what you are looking for. http://phpsense.com/php/php-pagination-script.html Regards udhay On Fri, Jan 29, 2010 at 6:01 AM, nagendra prasad nagendra802...@gmail.comwrote: Hi, I have a database of MP3 and I have designed a PHP-Mysql search engine. I want to break it down in

[PHP-DB] PHP Help with pagination

2010-01-28 Thread Karl DeSaulniers
Hey nagendra, I tried to post this a while ago, but it may be too long for the list. ?php if ($Submit) { // perform search only if correct form was entered. $db = mysql_connect ($Host, $User, $Password); mysql_select_db ($DBName) or die (Cannot connect to database); //check if the