Re: [PHP-DB] mysql results with limit

Excellent ... thanks that is exactly what I wanted. Michael. On Sat, 04 Sep 2004 20:21:46 -0600 Doug Thompson [EMAIL PROTECTED] wrote: Michael Gale wrote: Hello, Right now I have a mysql select statement with the LIMIT option of 500. Is there a way to find what the total

[PHP-DB] mysql results with limit

AWAY from the computer, your geek rights have been revoked !!! Michael Gale Slackware user :) Bluesuperman.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Intellectual property rights

do anything? Thanks, Vinny -- Michael Gale Network Administrator Utilitran Corporation -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysql auto increment

, -- Michael Gale Network Administrator Utilitran Corporation -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] table locking ... not required ?

Jul 2004 15:31:07 +0200 Torsten Roehr [EMAIL PROTECTED] wrote: John W. Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Michael Gale wrote: For the UPDATES ... what would have it in theory two people hit the UPDATE button at the exact same time ? Would one just over

[PHP-DB] Storing Date in mysql

Hello, I need to store the date of record / entry in the mysql database, so I have the following table create statement: CREATE TABLE `token_table` ( `token_id` int(11) NOT NULL auto_increment, `token_utuser_id` int(11) NOT NULL default '0', `token_name` varchar(100) NOT NULL

Re: [PHP-DB] Storing Date in mysql

this be easy to select MG against ? MG Michael. -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Michael Gale Network Administrator Utilitran Corporation -- PHP Database Mailing List

[PHP-DB] DB connections ?

Hello, I am designing a web that will require access to a specific database. I am also using sessions and am storing the session data in the database. So on every page that loads there will be a connection to the mysql server (local) to access the session db and tables and the web app

Re: [PHP-DB] How to take Backup ?

Hello, Have a look at mysqldump .. it is used for backing up tables and database. Example mysqldump --add-drop-table -c testdatabase -h 127.0.0.1 -u mysqlbk --password=mysqlbk testdatabase.bk Michael On Thu, 1 Jul 2004 21:26:27 -0700 (PDT) Rinku [EMAIL PROTECTED] wrote: I want to

[PHP-DB] perfornance with POST or db check ??

Hello, I have form that a user updates, it contains 5 html select boxes. The page loads and dynamically populates the select boxes with data from the database. Now the user can change any value of any select and hit Update now all the changes are applied to the database to reflect that

[PHP-DB] mysql and indexes

Hello, I know this question is more mysql related then PHP with mysql .. but If I do a SHOW INDEX from table_name I see what appears to be two index for the same column ? table_name 0 PRIMARY 1 columnname A NULLNULLNULL table_name 0 columnname

Re: [PHP-DB] MySQL persistent connections

Hello, I am no expert but I believe more information is required, like what would be the average return of a mysql operation ? How many different DB's are you accessing ? How many different usernames and passwords for mysql are you using ?? I believe persistent connections are only