hi tedit, i think your way is too complicated if you wanna save an article with all the stuff (paragraph, picture, list etc). maybe you can make it far more simple by save those article in SINGLE field, yes just SINGLE field with TEXT TYPE (i assumed you use mysql). but you need to save the article in HTML syntax.You can utilize WYSIWYG editor like tinyMCE (http://tinymce.moxiecode.com/download.php) or fckeditor (http://www.fckeditor.net/download).
hope this can help. :D Tedit kap wrote: > > Hi, > New to php and mysql but I got a question: > > Lets say I am creating a database table with coulmns like in below for > a news portal website: > > story title > first paragraph > second paragraph > third paragraph > ... > ... > contact info > > I would want the title display in some format and paragraphs in > another format and the contact info another etc... > > My question is: > > If lets say there needs to be a list item in between two paragraphs > (but this wont be the case always), can I insert that list within the > paragraph text in the database within the paragraph such as > <ul> > <li>...</li> > <li>...</li> > </ul> > , and it will display as a list in the website? Or do I need to have a > seperate column in the table for a listed item? But the location and > size of list item (if any) will be different for each article. So I > thought I should not make a column for listed items, but insert in one > of the paragraph columns. So the question is will it display correctly > and how can I do that? > > How about inserting a picture to the article (again, only some > articles will have a pic), should I have a seperate column for picture > (display location can be fixed) so that column will be blank for an > article with no picture, but it will pull up the picture if there is > any. Is my thinking right? > > Thanks > > Matt > > __________________________________________________________ > > > . > > [Non-text portions of this message have been removed]
