Retrieving Data
I CAN NOT RETRIVE DATA INTO MY UPDATE FORM OF MY PHP PAGE FROM THE POSTGRES DATABASE. THE ONLY INFORMATION THAT IS RETRIEVED IS THE ONE WITH NO SPACES IN BETWEEN. THE FUNCTION I HAVE USED IS SIMILIAR TO THE ONE BELOW:
FUNCTION GET_DATA(){
$tbs=$GLOBALS[tabls];
$sn=$GLOBALS[snumbr];
$connection=pg_connect("dbname=students");
$query="select * from $tbs where student_number='$sn' ";
$results=pg_exec($connection,$query);
$row=pg_fetch_array($results,0);
$GLOBALS["stdnum "]=$row[student_number];
$GLOBALS["stdname"]=$row[first_names];
nb. First_names="Bheki Zwane" but the last row only returns Bheki.
Please help!!!!!!!!!!!!!!!!!!!!!!
|