note 41658 deleted from function.mysql-fetch-array by irchtml
| From: | irchtml@php.net | Date: | Sun, 18 Apr 2004 21:06:35 +0000 |
| Subject: | note 41658 deleted from function.mysql-fetch-array by irchtml | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-68300@lists.php.net to get a copy of this message | ||
Note Submitter: danny@dcobbinah.co.uk
----
i am stuck as to how to display a table with 2 columns the contents of my mysql records. i have a
comma delimited text file that i have broaght into the mysql by the load data infile parameter.
CREATE TABLE profile (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
picture CHAR(30) NOT NULL,
PRIMARY KEY (id)
)
load data infile "c:/apache/htdocs/lojsite/database/profiletable1.txt" into table profile
fields terminated by ','
the content of the profiletable1.txt is as follows:
6, /pics/pics6.jpg, text 6 text 6 text 6 text 6
there are to be 6 rows and i want each row to take up the page ie to put infor in the 2 columns of
my table. how do i go about that