[TheWern]

Hi All,
I have set up a MySql table with 15 cols of various data. Each row then represents a single transaction. There would be up to 25 rows max. The first col will be no's from 0-up to 25, but there may only be eg. 4 rows in the table at the time when they're viewed.

I've tried to create code with loops to retrieve line by line to output to a page with a table built into it. It goes into never-ending loops and I cant seem to find a way to retrieve 'as many' lines are there. I'm sure there is a simple-ish way to do this, but I cant find a working example to study.

Any ideas? ? ?

[Advertisements]

How are you accessing the data in the mysql database.

I am going to assume that you are using php.

This will give you a place to start.
http://www.thescript...ases/index.html

[ditto]

How are you accessing the data in the mysql database.

I am going to assume that you are using php.

This will give you a place to start.
http://www.thescript...ases/index.html

[Michael]

I normally do something like this, it is a bit different that that shown in ditto's link

$result = mysql_query("SELECT col FROM table") or die(mysql_error());
while($row = mysql_fetch_array($result)) {
	$col = $row['col'];
	//do something with $col
}

[TheWern]

Thanks for that Guys - I have it sorted now.