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

[PHP-DB] mysql results with limit

back 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

t refuses to run anything besides Win Servers using IIS. They > will not install PHP ( too many hacker problems they say). > > Did I just screw myself? Do I have any protection of my design? Can I 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

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

Hello, I have a web app that uses a mysql database, now lots of INSETS and UPDATES are done on a daily bases. Now I do not want to start locking tables. For the INSERTS it is just a plain insert with a auto incrementing primary key. So I am sure that multiple inserts would not have a problem is m

Re: [PHP-DB] Storing Date in mysql

e token_date field I am storing the date in the following format from > PHP: > > MG> date("d/m/Y") which creates the following entry "05/07/2004" (example). > > MG> I would like to know fro the list is ... is this the best way to store the date > ? Wo

[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 defau

[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 d

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

[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 useful