PHP - Need Some Database And Php Help Using Dreamweaver Cs4

hi I use dreamweaver cc and I make a recordset ,so I need to create a dynamic table but the data panel and data object panel not appear    can any one help me please

Im using dreamweaver, and I have a simple list menu that is linked to a dynamic source in my database. I cannot figure out how to create an action when they select something from the list menu. I suppose that it would have to be passed through the browser somehow. Im not very code fluent, but I try. If you know to accomplish this using dreamweaver cs4 or hard coding, I would appreciate it.

I want this: When you click on an item it will bring up all the data pertaining to that particular record.

My code:
Code: [Select]
     
<form id="form1" name="form1" method="post" action="">
        <label for="customerlist">Select your customers</label>
        <p><label for="customers"></label>
    <select name="customers" id="customers">
            <option value="None">None</option>
            <?php
do {  
?>
            <option value="<?php echo $row_Customers['name']?>"><?php echo $row_Customers['name']?></option>
            <?php
} while ($row_Customers = mysql_fetch_assoc($Customers));
  $rows = mysql_num_rows($Customers);
  if($rows > 0) {
      mysql_data_seek($Customers, 0);
  $row_Customers = mysql_fetch_assoc($Customers);
  }
?>
          </select>
          <input type="submit" name="Go" id="Go" value="Go" />

My learning curve to this point in using php with MySql databases is automatically generated code within Dreamweaver. However, I am sure that it is adding a lot more code than I actually need and I sometimes have 5 or more queries all on one page that are just all the same except that each one has a different ID to reference.
Presumably the best way to do this would be with one query with grouping but as that is still on my list of things to understand I am hoping to tidy things up myself first.
For example, two of the queries that I have on one page (http://www.margate-fc.com/content/1st_team/squad.php) are Code: [Select]
<?php
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;
}
}

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_Midfielders = 100;
$pageNum_Midfielders = 0;
if (isset($_GET['pageNum_Midfielders'])) {
  $pageNum_Midfielders = $_GET['pageNum_Midfielders'];
}
$startRow_Midfielders = $pageNum_Midfielders * $maxRows_Midfielders;

mysql_select_db($database_Test, $Test);$query_Midfielders = "SELECT * FROM player_season, players, player_positions WHERE 
player_season.season = '104' AND player_season.player = players.player_id AND player_positions.player_position_id = players.position AND players.position = '3' ORDER BY surname ASC";
$query_limit_Midfielders = sprintf("%s LIMIT %d, %d", $query_Midfielders, $startRow_Midfielders, $maxRows_Midfielders);
$Midfielders = mysql_query($query_limit_Midfielders, $Test) or die(mysql_error());
$row_Midfielders = mysql_fetch_assoc($Midfielders);

if (isset($_GET['totalRows_Midfielders'])) {
  $totalRows_Midfielders = $_GET['totalRows_Midfielders'];
} else {
  $all_Midfielders = mysql_query($query_Midfielders);
  $totalRows_Midfielders = mysql_num_rows($all_Midfielders);
}
$totalPages_Midfielders = ceil($totalRows_Midfielders/$maxRows_Midfielders)-1;

$queryString_Midfielders = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Midfielders") == false && 
        stristr($param, "totalRows_Midfielders") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Midfielders = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Midfielders = sprintf("&totalRows_Midfielders=%d%s", $totalRows_Midfielders, $queryString_Midfielders);

header('Content-Type: text/html; charset=ISO-8859-1', true);
?>
and Code: [Select]
<?php
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;
}
}

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_Forwards = 100;
$pageNum_Forwards = 0;
if (isset($_GET['pageNum_Forwards'])) {
  $pageNum_Forwards = $_GET['pageNum_Forwards'];
}
$startRow_Forwards = $pageNum_Forwards * $maxRows_Forwards;

mysql_select_db($database_Test, $Test);$query_Forwards = "SELECT * FROM player_season, players, player_positions WHERE date_left = '2011-07-01' AND
player_season.season = '104' AND player_season.player = players.player_id AND player_positions.player_position_id = players.position AND players.position = '4'  ORDER BY surname ASC";
$query_limit_Forwards = sprintf("%s LIMIT %d, %d", $query_Forwards, $startRow_Forwards, $maxRows_Forwards);
$Forwards = mysql_query($query_limit_Forwards, $Test) or die(mysql_error());
$row_Forwards = mysql_fetch_assoc($Forwards);

if (isset($_GET['totalRows_Forwards'])) {
  $totalRows_Forwards = $_GET['totalRows_Forwards'];
} else {
  $all_Forwards = mysql_query($query_Forwards);
  $totalRows_Forwards = mysql_num_rows($all_Forwards);
}
$totalPages_Forwards = ceil($totalRows_Forwards/$maxRows_Forwards)-1;

$queryString_Forwards = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Forwards") == false && 
        stristr($param, "totalRows_Forwards") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Forwards = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Forwards = sprintf("&totalRows_Forwards=%d%s", $totalRows_Forwards, $queryString_Forwards);

header('Content-Type: text/html; charset=ISO-8859-1', true);
?>
The only difference in the two queries are the query names and the WHERE players.position = 'XX'

The way that I see it is that everything below
Code: [Select]
$currentPage = $_SERVER["PHP_SELF"];is unique to each query but everything above is replicated.

Would it work to have all of it between one set of PHP tags with the duplicated code there just once? If so would it simply mean copying everything below '$currentPage = $_SERVER["PHP_SELF"];' in the second query and pasting it just before the '?>' in the first.
Also, if anyone is an expert with grouping, I would be more than open to suggestions about setting the page up that way. My head says that it would need a repeat region inside a repeat region to get the data separated the way I want it but my head doesn't often make sense!

Thanks in advance
Steve

im finding it hard to link PHP, MySQL and dreamweaver together.

when php document is alaunched within the localhost all the data in the database is present how ever

when the php coding is entered into the html file via dreamweaver no data is present which i think connection to the mysql database cannot be establish

why is this can someone help me please, the php document is attached with all the coding


[attachment deleted by admin]

This topic has been moved to Editor Help (Dreamweaver, Zend, etc).

http://www.phpfreaks.com/forums/index.php?topic=343605.0