In writing a query Function.. Appreciate you help

[wonderblunder]

Hello Everyone,

I am new to PHP, I am trying to write a small query function which would would send in one argument for the query such as "LASTNAME".

function getInfo($n)
{
	$sql = "SELECT `user_id`, `first_name`, `last_name`, `age`
			FROM `users`
			WHERE `last_name` = " . $n;
			$result = mysql_query($sql);

}

I am unable to send the argument via function. If I just run a query straight up, I am able to see the information. I would highly appreciate your help on this.

Thanks a lot

[Inigoesdr]

I'm assuming last_name is a string value, so you would want quotes around the value in the WHERE clause. By-the-by, if you have a primary key on user_id, and know the user_id to begin with, your query will run a lot faster if you use it for the lookup.

PHP Code:


function getInfo($n)
{
    $sql = "SELECT `user_id`, `first_name`, `last_name`, `age`
            FROM `users`
            WHERE `last_name` = '{$n}'";
            $result = mysql_query($sql);

} 


[JRM]

not only faster but think about all the SMITH's.

[hinch]

PHP Code:

function getInfo($n)
{
    $sql = "SELECT `user_id`, `first_name`, `last_name`, `age`
            FROM `users`
            WHERE `last_name` = '".$n."'";
            $result = mysql_query($sql);
             return mysql_fetch_row($result);
} 


then to call it

PHP Code:

$inforow = getInfo('LASTNAME'); 


then just handle $inforow as you normally would

[wonderblunder]

Thanks you guys so much, appreciate your help.