[PHP] field types

2001-01-23 Thread Jason Jacobs
Does anyone know a function to give me the mySql field types? I saw the function mysql_field_type, but that returns php types not mysql. What I wanna do is if the type of the field is "Text" then I wanna make a "textarea" to edit and add stuff. Thanks. Jason -- PHP General Mailing List

RE: [PHP] field types

2001-01-23 Thread Boget, Chris
Does anyone know a function to give me the mySql field types? I saw the function mysql_field_type, but that returns php types not mysql. What I wanna do is if the type of the field is "Text" then I wanna make a "textarea" to edit and add stuff. Thanks. If you have phpMySql, take a look

RE: [PHP] field types

2001-01-23 Thread Boget, Chris
If you have phpMySql, take a look at the file: /mysqladmin/tbl_properties.php That code is doing something to return the type of the field. It's a little hard to follow so I don't know exactly how he's doing it and unfortunately, didn't have the time to decipher. :p However, I'm sure if

RE: [PHP] field types

2001-01-23 Thread Joao Prado Maia
On Tue, 23 Jan 2001, Boget, Chris wrote: Never mind, I see how he did it. He runs the following query: "SELECT FIELDS FROM $tableName" Where '$tableName' is your table (obviously) and he parses the result to get all the information. Actually he did a "SHOW FIELDS FROM $tableName".