3 replies to this topic

[dunnkers]

Hello.

I have made a php code which displays the data of a table in a html table.
Code:

	$sql = mysql_query('SELECT users, email, date_joined FROM users LIMIT 0 , 20');

	while ($row = mysql_fetch_row($sql)) {

		$output .= "<tr>";

		foreach ($row as $el) $output .= "<td>".$el."</td>";

		$output .= '</tr>';

	}

Now, How can i make a exception for the foreach statement?
I want to do a function with the column datejoined. I want to output this datejoined:
ti

meFormat($row['datejoined'])

But how can i do this?
All help is appreciated.

DuNnkers.

[Orjan]

something like this.

foreach ($row as $var => $el) {
  if ($var == 'datejoined') {
    $output .= meFormat($row['datejoined']);
  } else {
    $output .= "<td>".$el."</td>"; 
  }
}

[dunnkers]

Aha thanks.

[Orjan]

on the other hand, you shouldn't use $row inside the foreach if it's not really needed, it looks better (even though it works with it without a doubt), so I'd do this:

foreach ($row as $var => $el) {
  if ($var == 'datejoined') {
    $output .= meFormat($el);
  } else {
    $output .= "<td>".$el."</td>"; 
  }
}