not a valid MySQL result resource

stu2001

Not sure what's wrong:

I keep getting:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/bloodpac/public_html/components/com_forum/extension.inc on line 33

<?php
/***************************************************************************
* extension.inc
* -------------------
* begin : Saturday, Feb 13, 2001
* copyright : (C) 2001 The phpBB Group
* email : [email]support@phpbb.com[/email]
*
* $Id: extension.inc,v 1.1 2005/02/14 04:03:08 websmurf Exp $
***************************************************************************/
if ( !defined('IN_PHPBB') )
{
die("Hacking attempt");
}
$version = "v1.2.4 RC6";
//
// Change this if your extension is not .php!
//
$phpEx = "php";
global $run_as_component; 

$link = mysql_connect('localhost', 'bloodpac_guest', 'guest');
if (!$link) {
die('Not connected : ' . mysql_error());
}
// make foo the current db
$db_selected = mysql_select_db('bloodpac_joom2', $link);
if (!$db_selected) {
die ('Can\'t use foo : ' . mysql_error());
}

$result = mysql_query("SELECT * FROM" . $mosConfig_dbprefix . "menu WHERE link = 'index.php?option=com_forum'"); 
while($data = mysql_fetch_array($result)) { 
$id = $data['id'];
}
if($run_as_component){
define("basefile", "index.php?option=com_forum&Itemid=" . $id . "&");
}
else{
define("basefile", "index2.php?option=com_forum&Itemid=" . $id . "&");
}
$starttime = 0;
?>

I'm kind of new to this and not sure what my mistake is

laserlight

Kindly place your PHP code snippets in [php][/php] forum bbcode tags.

My guess is that after you print out the actual SQL statement, you will see that there is a lack of adequate spacing.

Roger_Ramjet

PS the error message means that your query did not work so you got no results, which is why laserlight is pointing you to a syntax error in your query.

Best practice is to always code queries like this

$sql = "SELECT col FROM table";
$result = mysql_query($sql) or die (mysql_error() . '<br />' . $sql);

Doing it that way will mean that when a query fails you will get the associated error message and a printout of your query string so you can see what was actually sent to the db and failed.