Good morning developers, i have a website in form of nairaland. , please how can i update the front page with links automatically without creating it manually again using the <a> tag manually ? Thanks

Guy explain yrself well

trytillmake:
Guy explain yrself well

How can i push topics from their different sections to my front page like nairaland.
Do i av to create another link to d topic on my front page?
Do i get it

trytillmake:
Guy explain yrself well

Pls dnt mind my write up., i dnt knw a way of explaining it.

How can i push topics from their different sections to my front page like nairaland.
Do i av to create another link to d topic on my front page?
Do u get it

You could create a push to front page button or link for admins and moderators and on ur sql for fetching posts to ur front-page there should be a where clause like select * from forums where front_page = '1' and when u or d moderators click on d button u created on each post it updates d table and set front_page on ur table to 1 for that particular post...

*Jenifa*

Jenifa123:
You could create a push to front page button or link for admins and moderators and on ur sql for fetching posts to ur front-page there should be a where clause like select * from forums where front_page = '1' and when u or d moderators click on d button u created on each post it updates d table and set front_page on ur table to 1 for that particular post...

*Jenifa*

Babes that Code I like and respect: ok back to OP just to support what @Jenifa has said u can

1. create a column on topics table called frontpage
2. add a checkbox called "to front" as topics as listed
3. each one u tick adds a number to frontpage column
4. frontage now selects from table where frontpage is not null; using c#
(var front = (from e in db.topics where frontpage == 1 select e).tolist;

u get the point

Jenifa123:
You could create a push to front page button or link for admins and moderators and on ur sql for fetching posts to ur front-page there should be a where clause like select * from forums where front_page = '1' and when u or d moderators click on d button u created on each post it updates d table and set front_page on ur table to 1 for that particular post...

*Jenifa*

Thanks for this..God bless u..will update u

trytillmake:


Babes that Code I like and respect: ok back to OP just to support what @Jenifa has said u can

1. create a column on topics table called frontpage
2. add a checkbox called "to front" as topics as listed
3. each one u tick adds a number to frontpage column
4. frontage now selects from table where frontpage is not null; using c#
(var front = (from e in db.topics where frontpage == 1 select e).tolist;

u get the point

Thanks for this logic..but how can i make the latest topic i pushed to frontpage appear at the top of the list, since the front page sql code will be selecting all d topics with checkedbox at the same time?
Thanks.

AllyPolly:

Thanks for this logic..but how can i make the latest topic i pushed to frontpage appear at the top of the list, since the front page sql code will be selecting all d topics with checkedbox at the same time?
Thanks.

That should be pretty simple
Once u click on d checkbox it not only sets a variable for front-page it should also update d time it was clicked so there should be a column called click_time or whatever you choose to name it...

So when you fetch it should be ordered by d click_time variable

*Jenifa*

Jenifa123:

That should be pretty simple
Once u click on d checkbox it not only sets a variable for front-page it should also update d time it was clicked so there should be a column called click_time or whatever you choose to name it...

So when you fetch it should be ordered by d click_time variable

*Jenifa*

Wow ! Thank you !

AllyPolly:

Wow ! Thank you !

Welcome i guess

*Jenifa*

Jenifa123:

Welcome i guess

*Jenifa*

Hello good morning.
I have been avin a tough time updating the frontpage status to "1" in my database, any code i attempt to use changes everything to 1, instead of the topic i specified using the "where" clause.
Please what can i do about this as all my efforts is nt working.
Pls can i contact u? Or i leave my detail here

Drop your WhatsApp let's look at it together

ademakanak:
Drop your WhatsApp let's look at it together

0816four3820seven5, thanks bro

AllyPolly:

Hello good morning.
I have been avin a tough time updating the frontpage status to "1" in my database, any code i attempt to use changes everything to 1, instead of the topic i specified using the "where" clause.
Please what can i do about this as all my efforts is nt working.
Pls can i contact u? Or i leave my detail here

Sorry for the late response I hardly have time since i've been working on my website...

Well it's pretty obvious the whole table updates due to an error in ur query...
If it's quite hard to rectify do this..
Click on d post to open

Then on a particular post let d form be there to push dat particular topic to front-page

Jenifa123:

Sorry for the late response I hardly have time since i've been working on my website...

Well it's pretty obvious the whole table updates due to an error in ur query...
If it's quite hard to rectify do this..
Click on d post to open

Then on a particular post let d form be there to push dat particular topic to front-page

Ok, i will try this out. Tnks

Modified : it is now working., there was an error im d query i overlooked, i got the previous one working also.
Tnk u

I'm not a programmer or web developer but I believe I can solve this issues using Google, that is what I have been using to cheat most developers, now let me give you a clue, install a phpbb forum script on your system or server, there is this plugin called recent topic, it does exactly what you are looking for, find and install it and take a look of how it was written and how it works so that you can implement same on your site.

ncpat:
I'm not a programmer or web developer but I believe I can solve this issues using Google, that is what I have been using to cheat most developers, now let me give you a clue, install a phpbb forum script on your system or server, there is this plugin called recent topic, it does exactly what you are looking for, find and install it and take a look of how it was written and how it works so that you can implement same on your site.

Tnks bro .. Will check it out,