Forums

Good morning,
I want to display only the data created by the registered user. I searched the forum and have done many tests, but can not.

Header
<table width="100%" border="0">
  <tr bgcolor="#CC0000">
    <td width="20%"><strong>Usuari:</strong></td>
    <td width="20%"><strong>Data:</strong></td>
    <td width="20%"><strong>Any:</strong></td>
    <td width="20%"><strong>Descripció:</strong></td>
  </tr>
</table>
<hr>

Body
<?php
$user =& JFactory::getUser();
?>

<table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="2">
      <tbody>
        <tr>
          <td style="width: 20%;">{cf_user_id}</td>
          <td style="width: 20%;">{select_1}</td>
          <td style="width: 20%;">{date_2}</td>
          <td style="width: 20%;">{select_30}</td>
          <td style="width: 20%;">{select_10}</td>
        </tr>
      </tbody>
    </table>

I know I need a piece of code, but after so many trials, I'm in a no through road.
Thanks.

In the end, it worked perfectly 😛

WHERE SQL:
<?php
$user = &JFactory::getUser();
echo " WHERE cf_user_id = ".$user->id
?>

Header:
{pagination}
<table width="100%" border="0">
  <tr bgcolor="#CC0000">
    <td width="20%"><strong>Usuari:</strong></td>
    <td width="20%"><strong>Data:</strong></td>
    <td width="20%"><strong>Any:</strong></td>
    <td width="20%"><strong>Descripció:</strong></td>
  </tr>
</table>
<hr>

Body:
<table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="2">
      <tbody>
        <tr>
          <td style="width: 20%;">{select_1}</td>
          <td style="width: 20%;">{date_2}</td>
          <td style="width: 20%;">{select_30}</td>
          <td style="width: 20%;">{select_10}</td>
        </tr>
      </tbody>
    </table>