$sql="Select id,client from client";
$results=pg_exec($conn,$sql);
if ($results)
{
$numrows = pg_numrows($results);
echo "<b><u>Client Information</b></u><br>\n";
for ($row = 0; $row < $numrows; $row++)
{
$id = pg_result($results,$row,'ID'). " ";
$client = pg_result($results,$row,'Client')." ";
echo "Client ID : $id";
echo "Client Name : $client<br>\n";
}}
else
{echo ('No connection to the table!');exit;}
?>
<form>
<p>
Client ID:<input type="text" size="2" value="<? echo $id; ?>">  
Client Name:<input type="text" size="10" value="<? echo $client;?>">
</form>
</html>
What this code does is, it returns all the values/records from the database.
So what I need to do is, get specific results.
Like if I need to select one name or client ID only to display.
Say I have a login script for client ID:1 I want to display information on this specific client
nd not everything..
