Hi,
How can I select all the fields from table x? what is the sql sentence for that?
Many thanks, Assaf
SELECT * FROM table
sorry I know that, I ment the names of the fields.
and another small question: how can I select the records that start with 'A'?
Assaf
php: mysql_list_fields($database, $tablename); http://www.php.net/manual/en/function.mysql-list-fields.php
or mysql: SHOW COLUMNS FROM tablename http://www.mysql.com/doc/en/SHOW.html
and for the second question: SELECT * FROM tablename WHERE column LIKE 'a%'
