Retriving a Guide from MYSQL Database - Text/Image Layour Question :)

[laura21london]

Hello, thanks for reading, can you help a girl in distress 😛..

I am trying to build a website which provides various tutorials guides and articles, now these guides for sure will contain pictures. What I dont know is how to layout and pull this information from the database correctly, now since starting this I have had an idea and would like to know if it is a good and correct way of doing it.

First I am thinking of having a table called Guides and Articles

Guides

Guide_ID - Guide_Name - Written_By - Date_Written - Word_Count - Paragraph1 - Paragraph2 - P3 - P4 and maybe 10 Paragraphs in total - Image1 - Image2 - Image3
-4,5,6,7,8 You get my idea right?

So I was thinking The first query would show this information

Select Guide_Name, Written_By, Date_Written, Word_Count from Guides where Guide_ID = 1

This would be put into the first table (4 Columns going across)

Then I would have an Intro Text which would be Paragraph1 so Maybe I could rename that to Intro_Text before I move onto paragraphs. So it would be

select Intro_Text FROM Guides where Guide_ID = 1

This would come into one table of course below the first query

I would then start the Guide with step1 (Paragraph1)

select Paragraph1 FROM Guides where Guide_ID = 1

Then I would have a picture to show what I was talking about, so another table below this would be

select Image1 FROM Guides where Guide_ID = 1, I think you now understand what I am getting at and how I want it to look on the page, I just dont know if this is a stupid way of doing it and if there is a much simpler way of doing it (Less queries etc)

Thanks for your help so Much!
Laura 🙂