[RESOLVED] text box output

[tomsasse]

Hello all,

New to PHP and MYSQL.

Trying to get the output that has been entered into a text box to be formatted the same way it was entered. i.e.

Entered into text box as:

Facilities are required to provide a smoke free environment for their employees. Smoking will be permitted only in designated areas.

All employees are required by PL 104-134 to have payments made by Direct Deposit.

Part-time employment of 16 or fewer hours per week.

The text is stored in the MYSQL DB the same way. When I make the call frm PHP to display the code I get all the data with no space.

Code:

echo "

   <!--
        Printing job details
    -->
    <b>Vacancy Announcement Number:</b> $jcode
    <P>
    <b>Posted on:</b> $posted
    <p>
    <b>Opening Date:</b> $opening_date       
    <p>
    <b>Closing Date:</b> <font color=red>$closing_date</font>
    <p>
    <b>Designation:</b> $designation
    <p>
    <b>Series & Grade:</b> $series_grade
    <p>
    <b>Promotion Potential:</b> $promotion
    <p>
    <b>Salary:</b> $salary
    <p>
    <b>Location:</b> $location
    <br>
    <br>
    <br>
    <br>        
    <p>          
    <b>Who May Apply:</b>
    <br>
    <br> 
       $who_may_apply
    <br>
    <br>    
    <p>
    <br>
    <br>
    <b>Department:</b> 
    <br>
    <br>
       $department
    <p>
    <br>
    <br>        
    <b>Responsibilities:</b> 
    <br>
    <br>
        $description
    <p>
    <br>
    <br>
    <b>Qualifications:</b> 
    <br>
    <br>
        $qualification
    <p>
    <br>
    <br>
    <b>How Will You Be Evaluated</b> 
    <br>
    <br>
       $be_evaluated
    <p>
    <br>
    <br>
    <b>How To Apply</b> 
    <br>
    <br>
        $how_to_apply
    <p>
    <br>
    <br>
    <b>OtherImformation</b> 
    <br>
    <br>
        $other_information
    <p>
    <br>
    <br>
    <b>Reasonable Accommodation Statement</b> 
    <br>
    <br>
        $reasonable_accommodation
    <p>
    <br>
    <br>
    <b> EEO Statements: The Federal Government is an Equal Opportunity Employer.</b>

    <p>
    <br>
    <br>

<a href=?cmd=Apply&jcode=$jcode title='Apply online.'>Apply online</a> for this job, or <a href=?cmd=Upload&jcode=$jcode title='Must be a MS WORD document. The name of the word doc must be your name. i.e Thomas H Sasse.doc'>Upload a Resume for this job.</a> You can also <a href=?cmd=List title= 'Return to job listings.'>return to job listings</a>";[/COLOR]

[tomsasse]

Here is the code to get the listings from the DB

#####################

Listing open jobs

#####################

if ($cmd =="List"){

### Get List of Open Jobs ###
    $query = "SELECT DISTINCT id, department 
                from department, listing 
                WHERE department.id = listing.fk_department";
    $result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error());

### Check each department ###
    while(list($id, $department) = mysql_fetch_row($result))
    {
    ### Printing department ###
        echo "<b>Department:</b> $department";

    ### Look for jobs in each department and print as list ###
        $query2 = "SELECT jcode, designation 
                    from listing 
                    WHERE listing.fk_department = '$id'";
        $result2 = mysql_db_query($database, $query2, $connection) or die ("Error in query: $query2. " . mysql_error());

        echo "<ul>";
        while(list($jcode, $dsg) = mysql_fetch_row($result2))
        {
        echo "<li><a href=?cmd=Details&jcode=$jcode title= 'View this job posting.'>$dsg ($jcode)</a><br><br>";
        }
        echo "</ul>";
        echo "<p>";
        }

}[/COLOR]
#######################

Echoing job details

#######################

if($cmd == "Details"){
if (!$jcode || $jcode == "")
{
header("Location:?cmd=Error");
exit;
}
### Get job details ###
$query = "SELECT listing.jcode,
listing.posted,
listing.opening_date,
listing.closing_date,
listing.designation,
listing.series_grade,
listing.promotion,
listing.salary,
location.location,
listing.who_may_apply,
listing.aditional_duty_location,
listing.responsibilities,
listing.qualifications,
listing.be_evaluated,
listing.how_to_apply,
listing.other_information,
listing.reasonable_accommodation,
listing.eeo,
department.department,

listing.cname,
listing.cmail

from department,
listing,
location

WHERE department.id = listing.fk_department
AND location.id = listing.fk_location
AND listing.jcode = '$jcode'";

    $result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error());

[COLOR=PaleGreen]### Checking for errors ###[/COLOR]
    if (mysql_num_rows($result) <= 0)
    {
    header("Location:?cmd=Error");
    exit;
    }
    else
    {
[COLOR=PaleGreen]### Obtain data from query ###[/COLOR]
    list($jcode, $posted, $opening_date, $closing_date, $designation, $series_grade, $promotion, $salary, $location, $who_may_apply, $department, $description, $qualification, $be_evaluated, $how_to_apply, $other_information, $reasonable_accommodation, $eeo, $cmail, $cname) = mysql_fetch_row($result);[/COLOR]