# Problem getting data back from MySQL
**URL:** https://forums.percona.com/t/problem-getting-data-back-from-mysql/500
**Category:** Other MySQL® Questions
**Created:** [October 23, 2007, 8:37am UTC](https://forums.percona.com/t/problem-getting-data-back-from-mysql/500 "2007-10-23T08:37:17Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@drsmith57](https://forums.percona.com/u/drsmith57)
#### Post date: [October 23, 2007, 8:37am UTC](https://forums.percona.com/t/problem-getting-data-back-from-mysql/500/1 "2007-10-23T08:37:17Z")
Maybe I will stumble upon my problem again today but I am pretty stumped on this one. I have a series of “textareas” that writes fine to my DB…but it fails to display in my .php file. Here is a snippet of code:
if($row[‘Collab’] == “”){echo"
Collaboration:
“;
}else{
$Collab[$i] = $row[‘Collab’];echo”
Collaboration:
";
}
And the from the \_db file:
$EXT = $\_POST[EXT];
$Collab = $\_POST[Collab];
$WSR = $\_POST[WSR];
$AWIPS = $\_POST[AWIPS];
$Other = $\_POST[Other];
$Misc = $\_POST[Misc];
$Backup = $\_POST[Backup];
$dateString = $year.“-”.$month.“-”.$day;
$dbhost=$\_SERVER[‘DB\_HOST’];
$strConn=@mysql\_connect($dbhost,“\ ***“,”** ”);
mysql\_select\_db(“shift\_duties”,$strConn);
$table=“A\_shift\_duties”;
mysql\_query(“UPDATE $table SET `month`=‘$month’,`day`=‘$day’,`year`=‘$year’,`LT`=‘$LT’,`ST` =‘$ST’,`HMT`=‘$HMT’,`Sick`=‘$Sick’,`Annual`=‘$Annual’,`Comp` =‘$Comp’,`OT`=‘$OT’,`AFD`=‘$AFD’,`CCF`=‘$CCF’,`ZFP`=‘$ZFP’,` ZON`=‘$ZON’,`PFM`=‘$PFM’,`AFM`=‘$AFM’,`HWO`=‘$HWO’,`FWF`=‘$F WF’,`FWL`=‘$FWL’,`RFI`=‘$RFI’,`RFD`=‘$RFD’,`WXStory`=‘$WXSto ry’,`RWSKS`=‘$RWSKS’,`SendNDFD`=‘$SendNDFD’,`EXT`=‘$EXT’,`Co llab`=‘$Collab’,`WSR`=‘$WSR’,`AWIPS`=‘$AWIPS’,`Other`=‘$Othe r’,`Misc`=‘$Misc’,`Backup`=‘$Backup’ WHERE `date`=‘$dateString’”) or die (mysql\_error());
?\>
I have several other “text” boxes that work fine.
Any help would be appreciated.
DS
---
### Author:  [@drsmith57](https://forums.percona.com/u/drsmith57)
#### Post date: [October 23, 2007, 10:48am UTC](https://forums.percona.com/t/problem-getting-data-back-from-mysql/500/2 "2007-10-23T10:48:06Z")
Problem solved. Had to rearrange some things in my html/php code.