Applying a function to a row item from a query

[nelsons]

Attempting to format the text in rows returned in a query with paragraph breaks - line breaks.

$query = "SELECT * FROM $tblname WHERE fname LIKE '$sname%'";
$link = mysql_connect($host, $user, $pass);
$result = mysql_db_query($dbname, $query, $link);
while ($row = mysql_fetch_array($result)) {
print ("$row[fname]");
print (" ");
$row[article] = nl2br($row[article]);
print ("$row[article]");
print ("<p>");
}

It actually works sans the following error on each line returned.

NOTICE: Use of undefined constant article - assumed 'article' in ..... \searchform.php on line 20

Line 20 is blank

[nemonoman]

Try:
$row['article']

Also try <BR> instead of <P>

[ahundiak]

You should always use $row['article'] instead of $row[article]

If you happened to have defined a constant
define('article','something');
Then
$row[article] would actually return $row[something];

The warning is just to motivate you to upgrade your code. See the section on arrays in the manual for more details.

You may have observed that the line
print("$row[fname]")
did not generate a warning. Thats because constants are not evaluated inside of "s.

[nelsons]

You were both absolutely correct.

$row['article'] = nl2br($row['article']);

Gave the correct result.

Many thanks