Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12423
Latest: poseidon97
New This Month: 4
New This Week: 1
New Today: 0
Stats
Total Posts: 40023
Total Topics: 7044
Most Online Today: 97
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 2
Guests: 92
Total: 94

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

0 Members and 1 Guest are viewing this topic.

Offline shuban

  • Hero Member
  • *****
  • Posts: 653
    • 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: 15013
    • 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: 15013
    • 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: 653
    • 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
5821 Views
Last post August 19, 2008, 09:14:06 am
by gibbs
6 Replies
4881 Views
Last post February 09, 2009, 07:13:38 pm
by SMFHacks
6 Replies
5206 Views
Last post April 12, 2011, 03:31:19 pm
by bruno
4 Replies
2346 Views
Last post September 20, 2014, 12:57:03 am
by shuban
0 Replies
1448 Views
Last post June 01, 2015, 12:49:03 am
by shuban

+- Recent Topics

English British Translation file by HAL9000
Today at 05:44:28 pm

Characters dispayed as boxes by SMFHacks
January 16, 2020, 07:21:51 am

Multiple adds where one used to be? by SMFHacks
January 07, 2020, 08:20:38 am

Ribbon Theme Logo Position by slizzie1986
January 06, 2020, 08:52:31 pm

System enhancement? by SMFHacks
January 03, 2020, 09:22:45 am

Pretty Url Pro Is it compatible with 7.2? by Rock Lee
January 01, 2020, 08:53:50 pm

Order of photos by SMFHacks
December 29, 2019, 02:02:28 pm

SMF Cookie Change Compatibly by HDB
December 28, 2019, 03:33:49 pm

With SMF 2.0.16 being newly released is GDPR Pro a Better Tool? by HDB
December 28, 2019, 11:21:44 am

can the admin add banners manually? by MW
December 27, 2019, 04:08:39 pm

Powered by EzPortal