[RESOLVED] Not getting the complete string

[tjbarr]

ON PAGE 1 I HAVE A LIST BOX AND I CHOOSE "ONE TWO" FROM THE LISTBOX.

<?php

/
Create your SQL statement
/

$sql="SELECT sv_type from tbl_objtype ORDER by sv_type;";
$result_set = pg_Exec ($conn, $sql);
$rows = pg_NumRows($result_set);

if ((!$result_set) || ($rows < 1)) {
//No connection or no rows returned, so print an error
echo "<H1>ERROR - no rows returned</H1><P>";
exit; //exit the script
}

for ($j=0; $j < $rows; $j++) {
echo "<option value=".pg_result($result_set, $j, "sv_type")."> ".pg_result($result_set, $j, "sv_type")."</option>";
}

?>
</select>

ON PAGE 2 I AM ONLY GETTING "ONE"

if(isset($POST['cbo_objtype']))
{
$objtype_ch=$POST['cbo_objtype'];
$strWhereSet = "Yes";
$strWHERE="Where sv_type= '".$objtype_ch."'";
}

[NogDog]

You need quotes around the value of the value attribute:

echo "<option value='".pg_result($result_set, $j, "sv_type")."'> ".pg_result($result_set, $j, "sv_type")."</option>";

[tjbarr]

I am still only getting the first word in the obj_type?

for ($j=0; $j < $rows; $j++) {
echo "<option value='".pg_result($result_set, $j, "sv_type")."'> ".pg_result($result_set, $j, '"sv_type"')."'</option>";

}

[B_man]

Using pg_result twice in a single loop will (I assume) go through two records. If you only want to use one record per loop, get the result into a variable and then use the variable instead.

[tjbarr]

Thanks this works

for ($j=0; $j < $rows; $j++) {
echo "<option value='".pg_result($result_set, $j, "sv_type")."'> ".pg_result($result_set, $j, '"sv_type"')."</option>";

}