Howdy yall!

For some reason, mysql won't order my News tables on my website.

PHP Code:

$sql_text = "SELECT * FROM ".$this->TABLES['news']." WHERE id = '".$id."' ORDER BY id DESC"; 


I'm assuming that the ORDER BY will order the sellected information from the database pull by highest id to lowest id.

For some reason it isnt wanting to

Also, I'm having trouble with Line breaks in my news forms. In the database it is showing the correct line breaks, but when displayed on website, its all one big line. http://www.operanonverba.com/index1.php?page=news

If you need anymore code please let me know. I don't know what im doing wrong with the order by.

Thankyou,
Greg

PHP Code:

...WHERE id = '".$id."' ORDER BY id... 


You're using the id to select the item, so it's the same for all selected items, so you can't really order them by that.

On the second issue.

You need to replace line breaks with <br>

Originally Posted by Orodreth

PHP Code:

...WHERE id = '".$id."' ORDER BY id... 


You're using the id to select the item, so it's the same for all selected items, so you can't really order them by that.

Thanks Orodreth, makes perfect sense. Dunno how i missed it

'chrishirst'

so,

PHP Code:

<?php

function nl2br_skip_html($string)
{
   // remove any carriage returns (mysql)
   $string = str_replace("\r", '', $string);

   // replace any newlines that aren't preceded by a > with a <br />
   $string = preg_replace('/(?<!>)\n/', "<br />\n", $string);

   return $string;
}

?>

I feed $string (or the stored typing) into the function, it formats the text and then spits it back?

Greg