Need help with this query...

[shuban]

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,'';

[SMFHacks]

Change
echo 'The id message for this topic is: ',$row,'';
to

Code: [Select]

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


[SMFHacks]

Also
$row = mysql_fetch_assoc($request);
Should be
$row = mysql_fetch_assoc($result);

[shuban]

Yes

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'],'';