PHP - Sms Without Frm And Msg Headings

I am trying to display entries from a database.  I would like to categorize the entries into specific headings when they print to the page.

For instance:
ID 1
Question:  What is your favorite color
Answer: Blue
Category: Favorites

ID 2
Question:  What is two plus two?
Answer:  Four
Category:  Math


I would like to display all "Favorites" under the heading "Favorites", and all "Math" under heading "Math".  There will be multiple entries for each.  I figure I need to do a loop for each category?  How do I do this without having to connect to the database multiple times?

Code: [Select]
<?php
$username="username";
$password="pass";
$database="database";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM ft_form_17 WHERE Include='Include'";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"question"); //Question
$f2=mysql_result($result,$i,"answer"); //Answer
$f3=mysql_result($result,$i,"submission_id"); //submission
$f4=mysql_result($result,$i,"category"); //category

?>

<strong><a name="<?php echo $f3; ?>"><?php echo $f1; ?></a></strong>
<?php echo $f2; ?>


<?php
$i++;
}
?>

Hi Guys quite new to php, but getting along roses. I am a big football fan and on my localhost I want to replicate the football fixtures for the week. Its really an learning exercise, but I need projects to learn - struggle to learn from books.
I want to copy this list into a table (eventually):
http://news.bbc.co.uk/sport1/hi/foot...es/default.stm

I have managed to understand how to grab the data, however I think my problem is in the for loops that display the data.
It displays the dates, and the tournament titles, but then it lists all the games - and doesnt get some quite right anyway (look at Stevenage). Then if you scroll down it then just displays the Tournaments.
I think its pretty close, but please can someone point out my mistakes.
Thanks guys:
Code: [Select]
<?Php
$file_string = file_get_contents('http://news.bbc.co.uk/sport1/hi/football/fixtures/default.stm');
preg_match_all('/<div class="mvb"><b>(.*)<\/b><\/div>/i', $file_string, $links);
preg_match_all('/<div class="pvtb"><b>(.*)<\/b><\/div>/i', $file_string, $games);
preg_match_all('/class="stats">(.*)<\/a>/i', $file_string, $teams);
echo '<ol>';
$l = 0;

for($i = 0; $i < count($links[1]); $i++) {
echo '<div>'  . $links[1][$i] . '</div><BR>';

for($j = 0; $j < count($games[1]); $j++) {
echo '<BR><B><U><div>'  . $games[1][$j] . '</div></U></B><BR>';

for($k = $l; $k < count($teams[1]); $k++) {
echo  strip_tags($teams[1][$k]) . '</a><BR>';
$l=$k;
}
}
}
echo '</ol>';
?>
I think the problem is that it doesnt know what order the stuff is supposed to be in. But Im not sure how to write the code to tell it the order. Should each type of preg_match_all be an array or something?

i've been able to load up a csv file and display it as a html table but what i'm having trouble with is sorting it out with headings a to z but what i am trying to do is have 4 columns like this.

Surgestions about how to do what im after i was hoping i could span the say A across all columns and centering them in the future also but thats not really the problem mainly the getting the array of the csv file and code right iguess. any help would be appreciated


Code: [Select]
<table>
  <tr>
    <th>A</th>
  </tr>
  <tr>
    <td>Apple1</td>
    <td>Apple2</td>
    <td>Apple3</td>
    <td>Apple4</td>
    <td>Apple5</td>
    <td>Apple6</td>

  </tr>
  <tr>
    <th>B</th>
  </tr>
    <td>Banana1</td>
    <td>Banana2</td>
    <td>Banana3</td>
    <td>Banana4</td>
    <td>Banana5</td>
    <td>Banana6</td>

  <tr>
    <th>C</th>
  </tr>
    <td>Cold1</td>
    <td>Cold2</td>
    <td>Cold3</td>
    <td>Cold4</td>
    <td>Cold5</td>
    <td>Cold6</td>
</table>

This is the code for inputting of the csv file i also have some other code i was wanting to use for the sorting of the array data from the csv file i'll past below....



Quote

<?php
$file = "widgets.csv";
$delimiter = ",";
$enclosure = '"';
$column = array("", "", "", "");


@$fp = fopen($file, "r") or die("Could not open file for reading");
while (!feof($fp))
   {
    $tmpstr = fgets($fp, 100);
    $line[] = preg_replace("/r/", "", $tmpstr);
   }
for ($i=0; $i < count($line); $i++)
   {
    $line[$i] = explode($delimiter, $line[$i]);
   }
?>
<html>
<head>
    <title>Albert's Delimited Text to HTML Table Converter</title>
   <link href="css/style.css" rel="stylesheet" type="text/css" />

</head>
<body>
<table border="1" cellpadding="5" cellspacing="0">
    <tr>
<?php
        for ($i=0; $i<count($column); $i++)
            echo "<th>".$column[$i]."</th>";
?>
    </tr>
<?php
for ($i=0; $i < count($line); $i++)
{
    echo "<tr>";
    for ($j=0; $j < count($line[$i]); $j++)
    {
        echo "<td>".$line[$i][$j]."</td>";
    }
    echo "</tr>";
}
fclose($fp);
?>
</table>
</body>
</html>




Heres the code for the sorting of the table data from the array


Quote

<?php
echo "QUERY_STRING is ".$_SERVER['QUERY_STRING']."<p>";
$rev=1;
$sortby=0;
if(isset($_GET['sortby']))$sortby = $_GET['sortby'];
if(isset($_GET['rev']))$rev = $_GET['rev'];


//Open and read CSV file example has four columns
$i=-1;
$ff=fopen('widgets2.csv','r') or die("Can't open file");
while(!feof($ff)){
$i++;
$Data[$i]=fgetcsv($ff,1024);
}

//Make columns sortable for each sortable column
foreach ($Data as $key => $row) {
   $One[$key]  = $row[0]; // could be $row['Colname']
   $Two[$key] = $row[1]; //numeric example
   $Three[$key] = $row[2];
   $Four[$key] = $row[3];} //numeric example
   
 
 //Case Statements for Sorting
   switch ($sortby){
   case "0":
   if($rev=="1")array_multisort($One, SORT_NUMERIC, $Data); //SORT_NUMERIC optional
   else array_multisort($One, SORT_NUMERIC, SORT_DESC,$Data);
   $rev=$rev*-1;
   break;
   
   case "1":
   if($rev=="1")array_multisort($Two,  $Data);
   else array_multisort($Two, SORT_DESC, $Data);
   $rev=$rev*-1;
   break;
   
   case "2":
   if($rev=="1")array_multisort($Three, SORT_NUMERIC, $Data);
   else array_multisort($Three, SORT_NUMERIC, SORT_DESC,$Data);
   $rev=$rev*-1;
   break;
   
   case "3":
   if($rev=="1")array_multisort($Four,   $Data);
   else array_multisort($Four,  SORT_DESC, $Data);
   $rev=$rev*-1;
   break;}

echo ("<table border=2>");    //$rev is reverse variable   
echo ("<th><a href=\"SortTable.php?sortby=0&rev=$rev\" title=\"Click to Sort/Reverse sort\">One</a></th>");
echo ("<th><a href=\"SortTable.php?sortby=1&rev=$rev\" title=\"Click to Sort/Reverse sort\">Two</a></th>");
echo ("<th><a href=\"SortTable.php?sortby=2&rev=$rev\" title=\"Click to Sort/Reverse sort\">Three</a></th>");
echo ("<th><a href=\"SortTable.php?sortby=3&rev=$rev\" title=\"Click to Sort/Reverse sort\">Four</a></th>");

$i=0;
foreach($Data as $NewDat){
if($NewDat[0]!=""){ //error trap
$str="<tr>";
foreach($NewDat as $field)$str.="<td>$field</td>";
$str.="</td>\n";
echo $str;}}
fclose($ff);
echo "</table>";