[RESOLVED] Populating a form from a database

[NiallThistle]

Someone please put me out of my misery.

I have used this exact same script to display a form containing fields from a database countless times before but for some reason the section relating to get_contracts_info wont display.

Any ideas?

<?php

$action = $_GET["action"];

if($action == "contract")
			{
                        echo"
			<h2>Edit/Update Contract</h2>
			<form action=\"edit.php?action=update_contract\" name=\"frmEdit\" method=\"post\">
			<table width=\"300\" border=\"0\">
			<tr><td width=\"100\" bgcolor=\"#CCCCCC\">Client </td><td width=\"200\">
			<select name=\"client\">
			";

		 	// Load the client list into the form

         	$get_clients = mysql_query("
         	SELECT DISTINCT client_name as clientname, client_id as clientid FROM val_clients
     	 	ORDER BY client_name ASC
         	",$objConnect);

		 	while($data = mysql_fetch_array($get_clients))
         	                {
			echo"<option value=\"$data[clientid]\">$data[clientname]</option>";
		 	}

		echo"</select></td></tr></table>";

			// Load the rest of the contract info

			$get_contract_info = mysql_query("
			SELECT contract_num as num,
			contract_desc as desc,
			contract_proman as proman,
			contract_forman as forman,
			contract_conman as conman,
			contract_siteaddr as siteaddr,
			contract_tel as tel
			FROM val_contracts
			WHERE contract_id = '".$_GET["id"]."'
			",$objConnect);

			while($data = mysql_fetch_array($get_contract_info))
			{						
			echo"
			<table width=\"300\" border=\"0\"><tr><td width=\"100\" bgcolor=\"#CCCCCC\">Job # </td><td width=\"200\">
			<input type=\"text\" name=\"num\" size=\"35\" value=\"$data[num]\"></td></tr>
			<tr><td bgcolor=\"#CCCCCC\">Job Name </td><td width=\"200\">
			<input type=\"text\" name=\"desc\" size=\"35\" value=\"$data[desc]\"></td></tr>
			<tr><td bgcolor=\"#CCCCCC\">Project Manager </td><td width=\"200\">
			<input type=\"text\" name=\"proman\" size=\"35\" value=\"$data[proman]\"></td></tr>
			<tr><td bgcolor=\"#CCCCCC\">Contract Manager </td><td width=\"200\">
			<input type=\"text\" name=\"conman\" size=\"35\" value=\"$data[conman]\"></td></tr>
			<tr><td bgcolor=\"#CCCCCC\">Foreman </td><td width=\"200\">
			<input type=\"text\" name=\"forman\" size=\"35\" value=\"$data[forman]\"></td></tr>
			<tr><td bgcolor=\"#CCCCCC\">Site Address </td><td width=\"200\">
			<input type=\"text\" name=\"siteaddr\" size=\"35\" value=\"$data[siteaddr]\"></td></tr>
			<tr><td bgcolor=\"#CCCCCC\">Site Office Tel.</td><td width=\"200\">
			<input type=\"text\" name=\"tel\" size=\"35\" value=\"$data[tel]\"></td></tr>
			";
			}
	   echo"</table><input type=\"submit\" name=\"submit\" value=\"Save Changes\">
			</form>";

               }

else
		   {
		   echo"";
		   }

?>
<?php mysql_close($objConnect); ?>

[NiallThistle]

This is driving me crazy now. I've written a slimmed down version to start from scratch and now even that isn't working.

There must be something seriously fundamentally wrong with what I'm doing. I can't even get an individual field to display. It displays the text saying "Client:" but not the client name I'm looking for.

FYI - the url ends with edit.php?action=contract&con=1

<?php include("conn.php"); ?>

<?php

$action = $_GET["action"];

// Amend a contract

if($action == "contract")

{
echo"Client:";

$get_client = mysql_query("
SELECT C.client_name as clientname
FROM val_clients C, val_contracts T
WHERE T.contract_id = '".$_GET["con"]."'
AND C.client_id = T.contracts_client
",$objConnect);

while($data = mysql_fetch_array($get_client))
{
echo"$data[clientname]";
}

}

else
	{
	echo"";
	}

?>

[Derokorian]

have you looked at var_dump($_GET); to see that its what you expect?

[NiallThistle]

Now resolved! Incorrectly labelled field name in my database :rolleyes: