Format Data from SQL table

TobyRT

This might be a basic question, but I can't see anything on the forums for it!

I'm creating a small jobs database where our coordinator can input data from employers - company, job role, job description etc.

I've got it looking how I want pretty much, but the job spec/person spec needs to be more flexible.

Is there anything I can do to make the data extracted look the same as the way it's typed in (like in this box for example!) eg. when the user enters a new line it automatically displays the new line as opposed to a continuous string of text.

Any suggestions please?

Thanks!

leatherback

use nl2br

TobyRT

Thanks for that, I'm just not sure how I'd implement it into my code (see below). I'm afraid I'm a bit of a coding newbie!

echo '<p><span class="heading">'.$row['publisher'].'</span><br>';
echo '<span class="subheading">'.$row['role'].'</span><br>';
echo '<span class="smalltext">Job added:&nbsp'.$row['dateadded'].'</span></p>';
echo '<p>'.$row['intro'].'</p>';
echo '<p>'.$row['responsibilities'].'</p>';
echo '<p>'.$row['personspec'].'</p>';
echo '<p><b>How to apply:&nbsp</b><br>'.$row['contact'].'<br>';
echo 'or email:&nbsp<a href=mailto:'.$row['contactemail'].'>'.$row['contactemail'].'</a></p>';
echo '<p>Closing date:&nbsp'.$row['closingdate'].'</p><hr>';

Could I have some more guidance please?!

liquorvicar

echo '<p><span class="heading">'.$row['publisher'].'</span><br>';
echo '<span class="subheading">'.$row['role'].'</span><br>';
echo '<span class="smalltext">Job added:&nbsp'.$row['dateadded'].'</span></p>';
echo '<p>'.nl2br($row['intro']).'</p>';
echo '<p>'.nl2br($row['responsibilities']).'</p>';
echo '<p>'.$row['personspec'].'</p>';
echo '<p><b>How to apply:&nbsp</b><br>'.$row['contact'].'<br>';
echo 'or email:&nbsp<a href=mailto:'.$row['contactemail'].'>'.$row['contactemail'].'</a></p>';
echo '<p>Closing date:&nbsp'.$row['closingdate'].'</p><hr>';

that should format 'intro' and 'responsibilities' with line breaks to give you an idea.

TobyRT

That worked a treat - thank you!