Re: [PHP-DB] Suggest Table Structure

2001-07-05 Thread Sandis Jerics
Hi! It's exactly what i'm doing right now - each article may have many pictures, many authors, belong to many categories(sections), can be translated in some languages, etc. :) Sorry, i havent much time to explain your example, just paste mine here.. Perhaps you'll got the idea! CREATE TABLE

Re: [PHP-DB] Re: Splitting Article Pages

2001-07-12 Thread Sandis Jerics
hello! exactly esterday i had the same problem ;) i did it like this, using wordwrap/explode functions: ... $CFG_max_page_length = 5000; ... if(@mysql_num_rows($rez) 0) { $text = nl2br(mysql_result($rez,0,text)); $text_length = strlen($text); if($text_length

Re: [PHP-DB] HTML tags destory formatting?

2001-07-23 Thread Sandis Jerics
There are two cases possible: 1. Store already HTML-formatted text in db. Then you do nothing before sending it to the screen; never use nl2br() here! 2. Store plain text, may be with a simpliest tags like b, i, u, ol, ul, li, a, img. Then put it through the nl2br() function before