Posting to a form

[tjbarr]

I need to pull from a database and fill out the form based on the value selected.
Does this look reasonable?

<form action="sv_t5.php" method="post">

<?php 
   $inv_no=$_POST['inv_no'];
		   echo $inv_no;


   $query ="Select inv_no, sv_type, sv_name From tbl_vessel WHERE inv_no=$inv_no"; 		
   $result=pg_Exec ($conn, $query);   

?>

<table width="100%" border="0">
<tr>
<td width="17%">Inventory Number </td>
<td width="27%"><input name="inv_no" value="<?=$_POST['inv_no']?>" type="text" id="inv_no" maxlength="50"></td>
<tr>
<td>Sacred Vessel Type </td>
<td><input name="sv_type" type="text" id="sv_type"></td>
<tr>
<td>Sacred Vessel Name </td>
<td><input name="sv_name" type="text" id="sv_name"></td>
<td>Mark Description</td>
</tr>

[tomhath]

The form looks okay, but you never fetch the rows after you execute the query.

Try working through a couple of tutorials to get an idea how someone else did it.

[tjbarr]

<form action="sv_t5.php" method="post">

<?php 
 if (isset($_POST['cbovessel']))
 {
     $inv_ch=$_POST['cbovessel'];


 } 


   $query ="Select inv_no, sv_type, sv_name From tbl_vessel WHERE inv_no='$inv_ch'"; 		
   $result=pg_Exec ($conn, $query);   
	$rows = pg_NumRows($result_set);					 
          for($i=0;$i<$rows;$i++){
 	       $_POST['inv_no']=pg_result($result, $i,"inv_no"); 	
 	       $_POST['sv_type']=pg_result($result, $i,"sv_type"); 

	}

?>

<table width="100%" border="0">
<tr>
<td width="17%">Inventory Number </td>
<td width="27%"><input name="inv_no" value="<?=$_POST['inv_no'];?>" type="text" id="inv_no" maxlength="50"></td>
<td width="20%">Mark</td>
<td width="36%"><input name="sv_mark" type="text" id="sv_mark" maxlength="50"></td>
</tr>
<tr>
<td>Sacred Vessel Type </td>
<td><input name="sv_type" type="text" id="sv_type"></td>

[rincewind456]

I may be barking up the wrong tree, as I have no experience with Postgres sql, but looking in the PHP manual there is no function pg_result you would need to use one of the pg_fetch_??? funtions, they are:

pg_fetch_all_columns - Fetches all rows in a particular result column as an array
pg_fetch_all - Fetches all rows from a result as an array
pg_fetch_array - Fetch a row as an array
pg_fetch_assoc - Fetch a row as an associative array
pg_fetch_object - Fetch a row as an object
pg_fetch_result - Returns values from a result resource
pg_fetch_row - Get a row as an enumerated array

Then when you retrieve the result set, put the value into a variable and echo the variable like you have here

value="<?=$_POST['inv_no'];?>"