₦airaland Forum

Good day guys, am a newbie and I need your help. Am currently learning php and Mysql.

I have a database table titles 'threads' with four columns (Id, subject, body, postdate).

This is what I wanted to accomplish, I want to display all the subject column as a link so that when someone click on it, it will take you to a page where it will display the "post subject and the body". similar to nairand.

Please guys how do I go about this?
Am trying to create a simple forum just for learning sake. Thanks

can u post ur code

Aybee92:
Good day guys, am a newbie and I need your help. Am currently learning php and Mysql.

I have a database table titles 'threads' with four columns (Id, subject, body, postdate).

This is what I wanted to accomplish, I want to display all the subject column as a link so that when someone click on it, it will take you to a page where it will display the "post subject and the body". similar to nairand.

Please guys how do I go about this?
Am trying to create a simple forum just for learning sake. Thanks

Loop through them

Fetch subject from database using the normal way you use to fetch database result.

Loop through the result the Normal way you loop through your db result but in this case, you put your link in the HTML link tag.

To read contents, you can create a new page, say details.php and pass subject as a get variable.


For example::

Your links will look like

Website-url/details.php?first-subject

Website-url/details.php? Second-subject

In your php loop, it might just be:

Echo "<a href="details.php?$row[" Subject"]>$row[" subject" ]</a>


In your details.php file, use get to get the subject, and using where clause in your query, get the db row with that subject.

Ayemileto:
Fetch subject from database using the normal way you use to fetch database result.

Loop through the result the Normal way you loop through your db result but in this case, you put your link in the HTML link tag.

To read contents, you can create a new page, say details.php and pass subject as a get variable.


For example::

Your links will look like

Website-url/details.php?first-subject

Website-url/details.php? Second-subject

In your php loop, it might just be:

Echo "<a href="details.php?$row[" Subject"]>$row[" subject" ]</a>


In your details.php file, use get to get the subject, and using where clause in your query, get the db row with that subject.

waw thanks so much. this is really helpful.

Aybee92:
waw thanks so much. this is really helpful.

You are welcome bro.