Get url using provided SQL SELECT Command

Hello, I am using Joomla with 3rd party extension as content manager. I need to add Previous and Next articles navigation urls inside articles.

$next = "SELECT id, title FROM `#__js_records` WHERE published = 1 AND ctime > '$item->created' ORDER BY ctime ASC LIMIT 1";

$prev = "SELECT id, title FROM `#__js_records` WHERE published = 1 AND ctime < '$item->created' ORDER BY ctime DESC LIMIT 1";

Above code is Select to get table data for both urls from where it should be generated.

As I was told that once I get this data I can create urls using this short code

Потом получить ссылку URL::record($result);

More details will be provided if needed.

Kemahiran: Joomla, PHP, MySQL, SQL

Lihat lagi: create seo friendly url using mod rewrite php, paypal return url using, fake url using 301 redirect, projects clinic system using aspnet sql server, seo friendly url using mysql php, save image using java sql server 2005, software companies using asp sql server bangalore, upload sql database command prompt, using ajax sql reporting bids, online exam project using cnet sql server 2000, bcp using ssis sql 2005, open url using stream write file 1024 bytes, aspnet using oracle sql, using bcp sql server agent, inventory management system using php sql, calculate distances latitude longitude using decimal sql, how to get url using javascript, how to get json data from url using php, retrieving data using the sql select statement, php get data from url using curl

Tentang Majikan:
( 1 ulasan ) Zugdidi, Georgia

ID Projek: #30641713

7 pekerja bebas membida secara purata $34 untuk pekerjaan ini


Hello! I am looking forward to implement prev/next pagination feature to joomla site. Please contact me to start detailed discussion and implementation. Thanks

$45 USD dalam sehari
(121 Ulasan)

i will write the proper code for it. I am Joomla,PHP programmer having 8 years of experience. I am very good in wordpress,php,mysql,joomla. I have done highest projects here in Joomla.

$30 USD dalam sehari
(586 Ulasan)
(168 Ulasan)

I can do it right away. Why me? I only take one job at a time and work on the same till it's delivered. I believe in proactive communication and quality delivery. I assure you that I will satisfy with my work ⭐⭐⭐⭐⭐ (M Lagi

$30 USD dalam sehari
(61 Ulasan)

Hello, i've made a lot of customizations on Joomla, so i can make this job if you wish. Feel free to contact me, Regards, Luke

$50 USD dalam sehari
(62 Ulasan)

Hello, we are team of experienced and professional developers and designers. we believe in deliver best quality product to our clients. for more information visit our website [login to view URL]

$30 USD dalam sehari
(15 Ulasan)

Hey my skills match with your requirements. I have experience in SQL. I can definitely fulfil your requirements.

$10 USD dalam sehari
(1 Ulasan)