[PHP] Re: php/mysql data display

2003-12-18 Thread rush
"Jlake" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have a small database that I want to display data from. in such a way that > it shows shows in a table with the table header being the department > category and the table cells being the categories for each department. I > have

RE: [PHP] mySQL Data Limits

2002-04-23 Thread John Holmes
TEXT has a limit of 65535 characters. BLOB TEXT A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1) characters. See section 6.5.3.1 Silent Column Specification Changes. See section 6.2.3.2 The BLOB and TEXT Types. MEDIUMBLOB MEDIUMTEXT A BLOB or TEXT column with a

RE: [PHP] MySQL data

2001-04-17 Thread Maxim Maletsky
nesday, April 18, 2001 10:48 AM To: Augusto Cesar Castoldi Cc: [EMAIL PROTECTED] Subject: Re: [PHP] MySQL data There are a few ways to do this... 1.) Copy the binary files over in the mysql data directory ... have to be root and normally at a shell. 2.) SELECT * FROM table and then while() yo

Re: [PHP] MySQL data

2001-04-17 Thread Joe Stump
There are a few ways to do this... 1.) Copy the binary files over in the mysql data directory ... have to be root and normally at a shell. 2.) SELECT * FROM table and then while() you have rows INSERT INTO other_table those values 3.) mysqldump can be used via PHP and used by most users

RE: [PHP] MySQL data

2001-04-17 Thread Grant Walters
> Can I get the data from a table in MySQL and copy/transfer all data to > other database to a table with the same name? > Assuming that both databases are on the same server and that you have created the empty table in the second database: mysql > INSERT INTO DATABASE2.TABLENAME SELECT * FRO

Re: [PHP] MySQL data

2001-04-17 Thread Seung-woo Nam
Hi: The easiest way to do it is using mysqldump. mysqldump creates a file that contains SQL statements to reconstruct a database, which you can easily execute on the other database. It will create tables with same names and all the records will be copied, too. Seung-woo Nam Augusto Cesar Castold

Re: [PHP] MySQL Data to a HTML-Form

2001-04-15 Thread Brian Clark
Hi Denis, @ 8:13:41 PM on 4/15/2001, Denis Mettler wrote: > I got Data from my Database, but how can I show them in a textfiled > within a html form? Any ideas? Show us some code? Assuming you've gotten the data into a $row->column, just echo it into the value of one of the form fields: -B