SMF Query - Getting Data From Database

Smf Query Data Database - Computer Issues, Video Gaming - Posted: 26th Oct, 2019 - 1:38am

Register Login Text RPG Play Text RPG ?

Posts: 1 - Views: 85 Rating: 0/10 out of 0 Votes
Add Reply Q
smf discussion Simple Machines Forums Software
Post Date: 26th Oct, 2019 - 1:38am / Post ID: #


Admin + Architect
*******
[?] CPosts: 38,151
Posts: 48,360
Avg: 7.7 Post(s) / Day
Activity: 100%
[+] Gain: 4,603.39 FP
Charm: 346

SMF Query - Getting Data From Database

Sometimes you may need to insert your own code and / or retrieve info from SMF's DB. To do this you would do something like this:

Attached Image CODE

$result = $amFunc['db_query']('
SELECT m.id_comment,m.id_media,m.id_member, mem.id_member, mem.member_name
FROM {db_prefix}aeva_comments as m
LEFT JOIN {db_prefix}members AS mem ON (Mem.id_member = m.id_member)
WHERE m.id_comment ='.$theid.'',

Array(
'id_member' => 'id_member',
'member_name' => 'mem.member_name',
),__FILE__,__LINE__);
$row = $amFunc['db_fetch_assoc']($result);

$idmember = $row['id_member'];
$memname = $row['member_name'];

$amFunc['db_free_result']($result);

In this code, I am finding the last commentator's I'd from a defunct mod called "Aeva" and thus return his / her's name from the Membership table. I can then use $memname to display it.



Post Date: 13 November 2019 / Post ID: #

SMF Query - Getting Data From Database

, "SMF Query - Getting Data From Database" is a Computer Issues & Video Gaming Topic but its lacking your input! Be first to Reply to SMF Query - Getting Data From Database! You will then have 1 Posts and 1 Core Posts! International Comment Add Comment now or scroll down for [Fast Reply] box.

Post Date: Wed Nov 13 12:58:33 GMT 2019 / Post ID: #

Comment

SMF Query - Getting Data From Database


I was hoping for more on smf query getting data from database has only this many replies in a swift way to see and know and maybe get a better idea.

Sponsored Links:

Options Fast Reply Add Reply Add Poll


No Registration Required!

We welcome input from visitors:
Add Comment As A Guest
Guest, please be considerate by using the appropriate tags as well as checking your grammar before submitting or it will be deleted. See: Constructive Posting Policy.

Tip TIP: Press above button ONCE only. If you come back here via the [Back] button on your browser then you will need to click [More Options] button (below) first in order to re-enable your ability to Post.

> TOPIC: SMF Query - Getting Data From Database



Donate Compare Membership
International Discussions Coded by: BGID® ALL RIGHTS RESERVED Copyright © 1999-2019
Disclaimer Privacy Report Errors Credits
This site uses Cookies to dispense or record information with regards to your visit. By continuing to use this site you agree to the terms outlined in our Cookies used here: Privacy / Disclaimer,

Top 20 FP Owners

1. Krakyn - 20,660
2. Usabookworm - 12,979
3. ICon - 8,743
4. FairMaiden - 8,050
5. Kelic - 7,497
6. ScottI - 5,900
7. Felipe - 5,306
8. Play by post - 5,073
9. DianeC - 4,032
10. Canabusis - 3,146
Auto Updated: Every 31 minutes.
11. Susanshadow - 2,912
12. Brandon - 2,658
13. Buddha - 2,588
14. Kullgen - 2,550
15. Tiro - 2,540
16. Nitrixs - 2,526
17. Ridaxus - 2,513
18. Swedjan - 2,500
19. Kingowlbear - 2,476
20. Txtrpg - 2,457

Highlights

Ruler Of Kings 2 Text RPG General Discussion: Top  Ruler Kings 2 The Best Text Adventure You Will Ever Play! The official site: RulerOfKings.com By Krusten 28th Oct, 2019 - 5:37pm Discuss It!
Global Climate Change: Top  Global Climate Change World EcoSystem - Biodiversity Changes - Who is on board and who isn By News 27th Oct, 2019 - 12:54pm Discuss It!
Depression: Best of  Depression Treatment for Depression By Freshmack 12th Oct, 2019 - 2:38pm Discuss It!
Mouth Wash vs Warm Salt Water: Discuss  Mouth Wash Vs Warm Salt Water Mouthwash - Mouthrinse - Mouth Sores - Healing Infections - Gingivitis By Kaliet 7th Oct, 2019 - 5:53am Discuss It!
Directly Meeting With Aliens: Discuss  Directly Meeting With Aliens Why haven't we as a collective earth met with aliens yet? By Kaliet 7th Oct, 2019 - 5:43am Discuss It!
Difference Between Love & Lust: love How do I know if I am in love or in lust? By Kaliet 7th Oct, 2019 - 5:38am Discuss It!
Is Manipulating Someone An Evil Practice?: Manipulate By Kaliet 6th Oct, 2019 - 1:20pm Discuss It!
Are People Born Gay Or Gay By Choice?: Discuss  Are People Born Gay Gay By Choice Homosexual behavior stems from the mind or genetics? By Telly 9th Jul, 2019 - 12:15pm Discuss It!
ISIS - ISIL: Discuss  ISIS Ultra radical and violent Islamist group that even rivals Al Qaeda By News 22nd Dec, 2018 - 8:43pm Discuss It!
USA Teachers Carrying Guns: Top  USA Teachers Carrying Guns An idea to have teachers who want to carry guns to school undergo some level of police training will be left up to local school districts and police departments. By Swell 21st May, 2018 - 5:16am Discuss It!
The Media: Can they say anything they want without worrying about the effect? By Abnninja 16th Sep, 2017 - 4:17am Discuss It!