I am a php newbie and am hoping that someone may have a solution to a code issue I ran into.
I have a table with data from an SQL database and I'm using the following query:
$result = mysql_query("SELECT * FROM tableName ORDER BY id");
I have a simple for-loop that plugs in the data into a table row. The code below works just fine:
Code: Select all
$var = 'fieldName';
for ($i = 0; $i < 6; $i++) {
$number = mysql_result($result, $i, $var);
echo "<td";
if ($number < 0) {echo " class=\"negative\"";}
echo ">" . money_format("%= (n", $number) . "</td>";
}The code below does NOT work:
Code: Select all
function getData($var) {
for ($i = 0; $i < 6; $i++) {
$number = mysql_result($result, $i, $var);
echo "<td";
if ($number < 0) {echo " class=\"negative\"";}
echo ">" . money_format("%= (n", $number) . "</td>";
}
}
getData('fieldName');