Help with multiple row reader

beyers

I urgently need someones help thats much smarter than me.

I have to create code that reads a field out of a database thats got 2900 clients, now each of them has completed a survey which has a question that requires them to list in order of preference 6 choices.

The database which I didnt create stores the values as follows, 5,3,4,6,1,2 per row. Now my predicament is that I have to read all those values out of the field into a form on which I have to report the most favoured value per "column" and get a percentage value in total and per grid code. Please pleae help. I only just started with PHP and can hardly count values. What do I do?

All that Ive tried ends up in endless loops, here is a small snippet of the code which is left, Ive deleted and started over so many times😕

$query = "SELECT trader_preferences FROM survey WHERE trader_preferences <> 0";
if (!$result = mysql_query($query))
die("Could not load survey information!." . mysql_error() . "$query");
//$result = mysql_num_rows($query);
//echo mysql_num_rows($result);
$totRecs = mysql_num_rows($result);

$details = mysql_fetch_array($result);
$num = 1;
//do {

$trader_pref1 = explode(",",$details['trader_preferences']);
//echo $totRecs;
for ($count=0;$count<$totRecs;$count++)
	for ($count=0;$count<count($trader_pref1);$count++)
		echo $trader_pref1[$count];

 //} while ( $num <= $totRecs);

freddd

if you post a print screen or the code of your tabase table, I might be able to help you.
But for now, I don't know how your database is . I just know that your code has a lot of mistakes.

beyers

Howzit, Here is a snippet of my database where the field lies where I need the info from. Like I previously mentioned, each field value reads a number between 1 and 6 like the following 1, 4, 6, 5, 2, 3. So I must basically read through every record(2963) get the value less commas, read in into an array so that I can be able to get a value thatll state the number used most per column. Its tricky and I know Ive gor a lot of errors in my code, thats why I need help. Every loop that I use to go through all the records ends in a endless loop. Please Help??!!

site_toilet INT(2),
site_water INT(2),
site_water_200 VARCHAR(20),
site_toilet_200 VARCHAR(20),
trader_permit VARCHAR(20),
site_provided VARCHAR(20),
trader_preferences VARCHAR(25),
trader_preferences2 VARCHAR(25),