Simple function error.

[jcharnley]

What is wrong with this simple thing:

 
function GetAuthorNameFromID() {
 
	$author_query_name = "SELECT first_name FROM cms_users WHERE user_id = 2";
	$author_name = mysql_query($author_query_name, $con) or die(mysql_error());
 
	return $author_name;
 
}

I keep getting :

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /opt/lampp/htdocs/web/rss/index.php on line 33

[Ylang]

What is wrong with this simple thing:

 
function GetAuthorNameFromID() {
 
	$author_query_name = "SELECT first_name FROM cms_users WHERE user_id = 2";
	$author_name = mysql_query($author_query_name, $con) or die(mysql_error());
       $row = mysql_fetch_array($author_name);
	return $row['author_name'];
 
}

Maybe that? I'm a noob though, so...

[sysice]

$con is not a local variable. Add global $con to the top of the fucntion.

function GetAuthorNameFromID() {
    global $con;

    $author_query_name = "SELECT first_name FROM cms_users WHERE user_id = 2";
    $author_name = mysql_query($author_query_name, $con) or die(mysql_error());
 
    return $author_name; 

[crmalibu]

There $con variable does not exist.

Variables don't exist inside of a function automatically. You need to define them, or in some other way pass or import thier values in. Variables have a "scope", which means they only exist in certain contexts.

http://www.php.net/manual/en/languag...bles.scope.php

[Cups]

if GetAuthorNameFromID() is part of a larger class, containing other functions (methods) like this one, they you might try and change $con to:

$this->con