Prob with displaying data from database
| From: | Sonya Davey / QDCEL | Date: | Fri, 10 Nov 2000 08:26:06 +0000 |
| Subject: | Prob with displaying data from database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-24632@lists.php.net to get a copy of this message | ||
Hi, I need some help with displaying data on a page from a database
How do I display the value of the field SPOUSESURNAME onto the pg?
This is what I have so far:
<?
$username="day";
$password="day";
$dbhost='localhost:C:\Systems\Rpi\test.gdb';
$connection = ibase_connect($dbhost,$username,$password)
or die ("Couldn't connect to server");
//$db=ibase_select_db("test.gdb",$connection);
$GetClientDetailQuery = "SELECT PERSAL, SPOUSESURNAME FROM CLIENT
WHERE PERSAL = 'ADM108'";
$GetClientDetailQuery_Result =
ibase_query($GetClientDetailQuery,$connection)
or die ("Couldn't execute query");
$row = ibase_fetch_row($GetClientDetailQuery_Result);
$SPOUSESURNAME= $row["SPOUSESURNAME"];
?>
<body>
<?$SPOUSESURNAME = "TESTING";?>
<? echo "This is hard coded - Spouse Surname".$SPOUSESURNAME;?>
<input type="text" name="SPOUSESURNAME" value=<?
$SPOUSESURNAME?>>
Thanks!