[RESOLVED] Help with Formatting Query Output

AHoward007

Hello! I'm new to php and need some ideas about how to spruce up this output data with html.

The following php script produces some sample output as shown below.

How do I get database output like the type below to show up in say different formats i.e. color, properly spaced and aligned, etc. so that it looks presentable on a web page?

$englishinput=mysql_real_escape_string($_POST['englishinput']);
$query="SELECT monolingua, COUNT(monolingua) AS monolingua_count FROM dictionary WHERE english='$englishinput' GROUP BY monolingua ORDER BY monolingua_count DESC LIMIT 5";
$result=mysql_query($query) or exit(mysql_error());
while ($row=mysql_fetch_assoc($result))
{
    echo $row['monolingua_count'] . ' ' . $row['monolingua'] . '<br>';
}

Output data:

The word in English:Hello

Hello Top 5 Suggestions

11 ALOHA
10 HOLA
6 ALO
4 HELLO
2 CIAO

Weedpacket

By using HTML and CSS, probably in a table.

AHoward007

The code below is trying to create a dynamic html table accomplishing the same task as the php script in my first posted msg. This code produces the table headers but the recordset data doesn't list out.

I'm not getting any error msgs though. I'm having trouble following this code can anyone suggest a clearer way to write this script?

<html>
<body>
<?php

//Beginning of dynamic html table coding.
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    

    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
$maxRows_Recordset1 = 5;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

$colname_Recordset1 = "-1";
if (isset($_POST['english'])) {
  $colname_Recordset1 = $_POST['english'];
}
mysql_select_db("monoling_dictionary", $con);
$query_Recordset1 = sprintf("SELECT * FROM `dictionary` WHERE english = %s ORDER BY english ASC", GetSQLValueString($colname_Recordset1, "text"));
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $con) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>
<table border="1">
  <tr>
    <td>Greetings Top 5 List</td>
  </tr>
  <?php do { ?>
    <tr>
      <td><?php echo $row_Recordset1['monolingua']; ?></td>
    </tr>
    <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
</body>
</html>
<?php mysql_close($con)
?>

AHoward007

This is the original PHP script which works perfectly:

//This script pulls monolingua data out and lists the top 5 suggestions.	
$englishinput=mysql_real_escape_string($_POST['englishinput']);
$query="SELECT monolingua, COUNT(monolingua) AS monolingua_count FROM dictionary WHERE english='$englishinput' GROUP BY monolingua ORDER BY monolingua_count DESC LIMIT 5";
$result=mysql_query($query) or exit(mysql_error());
while ($row=mysql_fetch_assoc($result))
{
    echo $row['monolingua_count'] . ' ' . $row['monolingua'] . '<br>';
}

The output looks like this:

23 ALO
20 ALOHA
12 HOLA
9 HELLO
7 CIAO

I am trying to replicate the above php script in an html table to add additional formatting like color, resizing, etc. to the output. My new script I wrote is listed below:

<table width="300" height="100" border="1">
  <tr>
    <td>Count</td>
    <td>MONOLINGUA</td>
  </tr>
<?php
//This script queries greetings data and lists the top 5.	
$englishinput=mysql_real_escape_string($_POST['englishinput']);
$query="SELECT monolingua, COUNT(monolingua) AS monolingua_count FROM dictionary WHERE english='$englishinput' GROUP BY monolingua ORDER BY monolingua_count DESC LIMIT 5";
$result=mysql_query($query) or exit(mysql_error());
while ($row = mysql_fetch_assoc($result)); ?>
    <tr>
      <td><?php echo $row['monolingua_count']; ?></td>
      <td><?php echo $row['monolingua']; ?></td>
    </tr>

</table>

For some reason the title headers appear in the table but the data doesn't list at all. I'm not getting any error msgs just not getting any data either just a blank table.

dagon

your while loop is wrong

while ($row = mysql_fetch_assoc($result)) {
        echo '<tr><td>'. $row['monolingua_count'].'</td><td>'. $row['monolingua'].'</td></tr>.'
}    

echo '</table>';

AHoward007

Thanks that works!

I got a parse error the first time. The script required a ; at the beginning of the third line before the }. Once entered, the program worked fine.