Re: [PHP-DB] Web host offering beta versions?

PHP5: www.ovh.com MySQL 4.1 probably nobody. First beta (4.1.3) was released only a few days ago _ - Original Message - From: "Jensen, Kimberlee" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 08, 2004 11:28 PM Subject: [PHP-DB] Web host offering

[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

[PHP-DB] Column help needed (Table)

Hi there everyone, I need my MySQL query to be displayed in a table, which is no problem, but I only want 2 results per row to be displayed - so if I had 10 returned results from my Database, it would display 2 per column on 5 rows. How can I do this dynamically? Any help would be really a

Re: [PHP-DB] Table locking

Rosen wrote: And if I perform "LOCK tables ..." nobody can;t write on these tables, until I don't perform "UNLOCK TABLES" ? If something happens ( I mean if some my queryes fails) ? I have a feeling it would be very very good if you'd state why you feel you need to LOCK these tables. There are g

Re: [PHP-DB] Table locking

And if I perform "LOCK tables ..." nobody can;t write on these tables, until I don't perform "UNLOCK TABLES" ? If something happens ( I mean if some my queryes fails) ? "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Friday 09 July 2004 07:24, Rosen wrote: > > Thank

Re: [PHP-DB] Table locking

On Friday 09 July 2004 07:24, Rosen wrote: > Thanks, but can you give me a sample PHP script with MySQL database, whitch > do this? Don't have any examples handy. Basically instead of performing your usual single query, you sandwich it between two extra queries: LOCK tables ... your usual qu

Re: [PHP-DB] Table locking

Thanks, but can you give me a sample PHP script with MySQL database, whitch do this? Thanks "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Friday 09 July 2004 07:09, Rosen wrote: > > Is thath mean, thath, when one user is addind records to table, and lock > > it - w

Re: [PHP-DB] Table locking

On Friday 09 July 2004 07:09, Rosen wrote: > Is thath mean, thath, when one user is addind records to table, and lock > it - when another user is trying to get the max field value for some field, > the script will waiting the first user to unlock table and then to see the > max value of some field

Re: [PHP-DB] Table locking

Is thath mean, thath, when one user is addind records to table, and lock it - when another user is trying to get the max field value for some field, the script will waiting the first user to unlock table and then to see the max value of some field in a table ? "John W. Holmes" <[EMAIL PROTECTED]>

Re: [PHP-DB] Table locking

Rosen wrote: I have the following situation: I have to prevent users to write at the same time in one table in PHP script. Is there a way the PHP to "understand", thath another user is filling table, and to wait before begin to fill data? Most databases have a LOCK command that you can issue. The o

[PHP-DB] Table locking

Hi, I have the following situation: I have to prevent users to write at the same time in one table in PHP script. Is there a way the PHP to "understand", thath another user is filling table, and to wait before begin to fill data? Thanks in advance! -- PHP Database Mailing List (http://www.php.n

Re: [PHP-DB] fetch row DISTINCT

>"Lars Hilsebein" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >Sorry, but it's not truly what I am searching for: >The result is not unique. >What I mean is: every entry in the distinct_col should only be delivered >once. >As it would happen when I do the query "SELECT DISTINCT dist

[PHP-DB] Web host offering beta versions?

Does anyone know of a free/low cost Web host that lets you play with PHP 5 and MySQL 4.1? Thanks

[PHP-DB] Re: Storing Date in mysql

In article <[EMAIL PROTECTED]>, Michael Gale wrote: > Hello, > > I need to store the date of record / entry in the mysql database, so I have > the following table create statement: > `token_date` varchar(100) NOT NULL default '', Why don't you use a date format that your database support

AW: [PHP-DB] fetch row DISTINCT

Sorry, but it's not truly what I am searching for: The result is not unique. What I mean is: every entry in the distinct_col should only be delivered once. As it would happen when I do the query "SELECT DISTINCT distinct_col FROM table". But I need to fetch the whole row. Lars -Ursprüngliche

[PHP-DB] Query: Top 3 Results grouped by Category

Hi all, I am working on a search result query in which the user types a keyword and the top 3 results for each category are displayed with 24 or so total results on the page. The database is large (8 GB) and the table in which the fulltext search occurs has 3 million rows. Tables: product categ

Re: [PHP-DB] fetch row DISTINCT

> I'm using PHP with mySQL since a long time. > But now I got a question: > I need to generate a SQL-Statement to fetch rows with one DISTINCT criteria. > To make things clear: I don't want to fetch a single DISTINCT column, I want > to fetch the whole row, where one column is DISTINCT. > Ca

Re: [PHP-DB] Storing Date in mysql

Thanks ... I can't believe I missed that in the docs ... now I feel like knob. Michael. On Thu, 8 Jul 2004 14:17:38 -0300 "Pablo M. Rivas" <[EMAIL PROTECTED]> wrote: > Hello Michael, > token_date must be a DATE FIELD... > > http://dev.mysql.com/doc/mysql/en/Column_types.html > >

[PHP-DB] fetch row DISTINCT

I'm using PHP with mySQL since a long time. But now I got a question: I need to generate a SQL-Statement to fetch rows with one DISTINCT criteria. To make things clear: I don't want to fetch a single DISTINCT column, I want to fetch the whole row, where one column is DISTINCT. Can someone expl

Re: [PHP-DB] Storing Date in mysql

Hello Michael, token_date must be a DATE FIELD... http://dev.mysql.com/doc/mysql/en/Column_types.html MG> Hello, MG> I need to store the date of record / entry in the mysql database, so I have the following table create statement: MG> CREATE TABLE `token_table` ( MG> `to

Re: [PHP-DB] ODBC avec PHP

The latest version of ADODb supports odbtp. You can get it at http://odbtp.sourceforge.net. There are 2 versions of the ADODb driver: odbtp and odbtp_unicode. The problem you are having is caused by the inability of the ODBC driver to provide what the desired information. The FreeTDS ODBC driver

[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

Re: [PHP-DB] ODBC avec PHP

Hi Thanks for your answer but : What is odbtp extension I don't find it on www.php.net ??? I use ADOdb to database abstraction and I can't change all the ADOdb code. Do you know why the function "odbc_field_type" don't give me the good result ? Is is a PHP error, an unixODBC error or a free

Re: [PHP-DB] ODBC avec PHP

You will have much better results if you use the odbtp extension instead of the odbc extenstion, especially on Linux. The odbtp_field_type() function will give you the correct type name. Also, you could use the mssql extension. However, mssql_field_type() returns type names that are not exact. For

[PHP-DB] ODBC avec PHP

hi I want to use the function "odbc_field_type" on a linux mandrake 10 with PHP 4.3.7 with unixODBC et freeTDS This function never give me a good answer : Example of an answer : Xÿ¿p [EMAIL PROTECTED] [EMAIL PROTECTED]@[EMAIL PROTECTED]@ Someone can help me ? Jeff -- PHP Database Mailing L