Trouble populating a table from My SQL

spoco · February 13, 2009

The table is showing up, but it is not being populated with data from the database.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<?php require_once('Connections/thinkingmaps.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $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;
}
}

mysql_select_db($database_thinkingmaps, $thinkingmaps);
$query_Totals = "SELECT sum(q1='y'), sum(q1='n'), sum(q1='w'), sum(q2='y'), sum(q2='n'), sum(q2='w'), sum(q3='y'), sum(q3='n'), sum(q3='w'), sum(q4='y'), sum(q4='n'), sum(q4='w'), sum(q5='y'), sum(q5='n'), sum(q5='w'), sum(q6='y'), sum(q6='n'), sum(q6='w'), sum(q7='y'), sum(q7='n'), sum(q7='w'), sum(q8='y'), sum(q8='n'), sum(q8='w'), sum(q9='y'), sum(q9='n'), sum(q9='w'), sum(q10='y'), sum(q10='n'), sum(q10='w'), sum(q11='y'), sum(q11='n'), sum(q11='w'), sum(q12='y'), sum(q12='n'), sum(q12='w'), sum(q13='y'), sum(q13='n'), sum(q13='w') FROM survey";
$Totals = mysql_query($query_Totals, $thinkingmaps) or die(mysql_error());
$row_Totals = mysql_fetch_assoc($Totals);
$totalRows_Totals = mysql_num_rows($Totals);
?>

<body>
<p align="center">Totals for Survey</p>
<table width="400" border="2" align="center" cellpadding="2" cellspacing="1">
  <tr>
    <td> </td>
    <td> </td>
    <td>y</td>
    <td>n</td>
    <td>w</td>
  </tr>
  <tr>
    <td width="41" align="right" valign="baseline" nowrap="nowrap" bordercolor="#000000" bgcolor="#CCCCCC"><div align="left"><span class="style1">1.</span></div></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td align="right" valign="baseline" nowrap="nowrap" bordercolor="#000000" bgcolor="#FFFFFF"><div align="left"><span class="style1">2.</span></div></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td align="right" valign="baseline" nowrap="nowrap" bordercolor="#000000" bgcolor="#CCCCCC"><div align="left"><span class="style1">3.</span></div></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td align="right" valign="baseline" nowrap="nowrap" bordercolor="#000000" bgcolor="#FFFFFF"><div align="left"><span class="style1">4.</span></div></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td align="right" valign="baseline" nowrap="nowrap" bordercolor="#000000" bgcolor="#CCCCCC"><div align="left"><span class="style1">5.</span></div></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td align="right" valign="baseline" nowrap="nowrap" bordercolor="#000000" bgcolor="#FFFFFF"><div align="left"><span class="style1">6. </span></div></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td align="right" valign="baseline" nowrap="nowrap" bordercolor="#000000" bgcolor="#CCCCCC"><div align="left"><span class="style1">7. </span></div></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td align="right" valign="baseline" nowrap="nowrap" bordercolor="#000000" bgcolor="#FFFFFF"><div align="left"><span class="style1">8.</span></div></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td align="right" valign="baseline" nowrap="nowrap" bordercolor="#000000" bgcolor="#CCCCCC"><div align="left"><span class="style1">9.</span></div></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td align="right" valign="baseline" nowrap="nowrap" bordercolor="#000000" bgcolor="#FFFFFF"><div align="left"><span class="style1">10. </span></div></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td align="right" valign="baseline" nowrap="nowrap" bordercolor="#000000" bgcolor="#CCCCCC"><div align="left"><span class="style1">11.</span></div></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td align="right" valign="baseline" nowrap="nowrap" bordercolor="#000000" bgcolor="#FFFFFF"><div align="left"><span class="style1">12.</span></div></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td align="right" valign="baseline" nowrap="nowrap" bordercolor="#000000" bgcolor="#FFFFFF"><div align="left"><span class="style1">13.</span></div></td>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
</table>
<p> </p>
</body>
</html>
<?php
mysql_free_result($Totals);
?>

Brian W · February 13, 2009

Thats because you aren't doing anything to even attempt to put the data into the table dude.

Dreamweaver is a good tool (imo), but if you want to learn PHP your going to need to use some tutorials and or/books and not just click around in Dreamweaver.

But, in Dreamweaver, go to Insert -> Data Objects -> Dynamic Data -> Dynamic Table

Select the record set and play with it for a while, read the code and good luck.

drisate · February 13, 2009

of course ... you need to loop your data in ...

//start the form

$sql = mysql_query("SELECT sum(q1='y'), sum(q1='n'), sum(q1='w'), sum(q2='y'), sum(q2='n'), sum(q2='w'), sum(q3='y'), sum(q3='n'), sum(q3='w'), sum(q4='y'), sum(q4='n'), sum(q4='w'), sum(q5='y'), sum(q5='n'), sum(q5='w'), sum(q6='y'), sum(q6='n'), sum(q6='w'), sum(q7='y'), sum(q7='n'), sum(q7='w'), sum(q8='y'), sum(q8='n'), sum(q8='w'), sum(q9='y'), sum(q9='n'), sum(q9='w'), sum(q10='y'), sum(q10='n'), sum(q10='w'), sum(q11='y'), sum(q11='n'), sum(q11='w'), sum(q12='y'), sum(q12='n'), sum(q12='w'), sum(q13='y'), sum(q13='n'), sum(q13='w') FROM survey") or die (mysql_error());
while($data= @mysql_fetch_array($sql )){

// put in your table row
// Data will output like this $data[y]

}

// close your table

by the way ... i am not even sur that sql query is gona work ...

sum(q2='y') is gona erase sum(q1='y') should be something like sum(q2=y+y) or something like it

Sign In

Trouble populating a table from My SQL

Recommended Posts

spoco

Link to comment

Share on other sites

Brian W

Link to comment

Share on other sites

drisate

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information