Hi another, slightly annoying PHP question..
Right i've gone through the tutorial and its helped alot and ive been able to create my own CMS backend which is working nice. Im wanting to do something abit different (I know it wont be the best method of doing this, but its just how i want it to go) with the front end. If it's at all possible. I think i'll need an image to go with it to explain it properly tbh so here it is..
Ignore the design of it, its along way off from being finished 😃 I've 3 tables in my database "Pages" "Subjects" and "users" (users is pretty irrelevant here) . Pages and subjects are linked with each other. "Pages" hold all of the content that is updated in the CMS and that is displayed for the public. Basically what I want is where it says "news" on the index page to display the content thats in the "pages" table, but only a certain field - Highlighted below :
So i want to use the data thats inserted into the content field of "pages" but only whats in id1. If that makes any sense at all? I know im most likely going to have to write a query any help would be great. I know i have to to use SELECT * FROM pages etc etc but am i able to select something from that one field of that one row?
Does that make any sense at all? Im learning php and mysql all the time but i always manage to confuse myself, as well as you probably 😃 I really hope that makes some sense ..
