Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 12369
Latest: r0sem4rie
New This Month: 5
New This Week: 0
New Today: 0
Stats
Total Posts: 39810
Total Topics: 7016
Most Online Today: 51
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 46
Total: 47

Author Topic: Need help with this query...  (Read 2070 times)

0 Members and 1 Guest are viewing this topic.

Offline shuban

  • Hero Member
  • *****
  • Posts: 649
    • View Profile
    • Homework Clinic - Your Academic Lifeline
Need help with this query...
« on: December 09, 2014, 12:20:06 pm »
Hello, for some reason this query won't display the id_msg (it displays everything but $row)... What am I doing wrong? :-\

Code: [Select]
global $db_prefix;

$result = db_query("
SELECT id_msg
FROM {$db_prefix}messages
WHERE topicSolved = 1 AND ID_TOPIC = 176113", __FILE__, __LINE__);

$row = mysql_fetch_assoc($request);

echo 'The id message for this topic is: ',$row,'';
« Last Edit: December 09, 2014, 12:27:47 pm by shuban »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14919
    • View Profile
Re: Need help with this query...
« Reply #1 on: December 09, 2014, 12:28:14 pm »
Change
echo 'The id message for this topic is: ',$row,'';
to
Code: [Select]
echo 'The id message for this topic is: ',$row['id_msg'],'';
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14919
    • View Profile
Re: Need help with this query...
« Reply #2 on: December 09, 2014, 12:33:49 pm »
Also
$row = mysql_fetch_assoc($request);
Should be
$row = mysql_fetch_assoc($result);
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline shuban

  • Hero Member
  • *****
  • Posts: 649
    • View Profile
    • Homework Clinic - Your Academic Lifeline
Re: Need help with this query...
« Reply #3 on: December 09, 2014, 12:35:39 pm »
Yes :D

This worked:

Code: [Select]
$result = db_query("
SELECT id_msg
FROM {$db_prefix}messages
WHERE topicSolved = 1 AND ID_TOPIC = 176113", __FILE__, __LINE__);

$row = mysql_fetch_assoc($result);

echo 'The id message for this topic is: ',$row['id_msg'],'';

 

Related Topics

  Subject / Started by Replies Last post
3 Replies
5705 Views
Last post August 19, 2008, 09:14:06 am
by gibbs
6 Replies
4768 Views
Last post February 09, 2009, 07:13:38 pm
by SMFHacks
6 Replies
5128 Views
Last post April 12, 2011, 03:31:19 pm
by bruno
4 Replies
2241 Views
Last post September 20, 2014, 12:57:03 am
by shuban
0 Replies
1402 Views
Last post June 01, 2015, 12:49:03 am
by shuban

+- Recent Topics

How to AVOID SEO Hit when Implementing PrettyURLs by SMFHacks
September 12, 2019, 08:50:42 pm

theme by SMFHacks
September 12, 2019, 07:10:51 am

Picture Edit by SMFHacks
August 27, 2019, 11:52:06 am

Getting an error while installing SMF Gallery Pro by SMFHacks
August 18, 2019, 06:54:37 pm

Hashtag Mod Install Error by SMFHacks
August 15, 2019, 08:17:45 am

Rotating Image URLs by SMFHacks
August 05, 2019, 04:26:57 pm

[Mod]Block Proxy VPN On Registration by SMFHacks
August 01, 2019, 10:42:37 pm

[Mod]Nofollow Signature Links by SMFHacks
July 30, 2019, 11:52:28 am

Thinking of getting Ad Seller Pro as well by ajac63
July 28, 2019, 04:46:34 am

Just some questions about Ad Management mod by ajac63
July 26, 2019, 12:12:26 pm

Powered by EzPortal