// LOAD e107 STUFF FOR PLUGIN ( NOT NEEDED FOR A MENU )

require_once("../../class2.php");


// DISPLAY COLUMN HEADINGS, THIS IS JUST PURE OUTPUT, FOR PLUGIN USE $text .= AND THEN TABLERENDER

echo "FIELDNAME1 - FIELDNAME2 - FIELDNAME3 - FIELDNAME4";


// PREPARE MYSQL QUERY, WHILE THIS COULD BE ON ONE LINE WITH THE RESULT, IT REDUCES THE NEED TO SCROLL SIDWAYS
// MPREFIX IS e107 SPECIFIC THAT GIVES YOU THE TABLE PREFIX ( DEFAULT BEING e107_ )
// tablename NEEDS TO BE CHANGED TO YOUR ACTUAL TABLENAME

$mysql_query = "SELECT * FROM ".MPREFIX."tablename";


// RUN THE PREPARED MYSQL QUERY AND DISPLAY AN ERROR MESSAGE IF THERE IS A PROBLEM

$mysql_result = mysql_query($mysql_query) or die(mysql_error());


// FIND OUT HOW MANY RESULTS ARE RETURNED

$mysql_result_size = mysql_num_rows($mysql_result);


// GO THROUGH 1 TO THE NUMBER OF RESULTS

for ($i=1; $i<=$mysql_result_size; $i++)
{


// GET THE DATA FOR THE CURRENT ROW, IT WILL AUTO INCREMENT THROUGH THE RESULTS EACH TIME THIS IS USED
// THERE ARE A COUPLE OF OTHER METHODS, BUT THIS ONE PUTS THE CURRENT ROW IN A EASY TO USE ARRAY

  $mysql_row = mysql_fetch_array($mysql_result);


// SHOW THE DATA FOR THE CURRENT ROW, THE NAMES IN THE BRACKETS WOULD MATCH YOUR MYSQL COLUMNS

  echo "$mysql_row[fn1data] - $mysql_row[fn2data] - $mysql_row[fn2data] - $mysql_row[fn2data]";

}