HELP DATE_FORMAT (date, '% d /% m /% Y') NOT RUNNING

[impperio]

COMAND LINE
$rs = mysql_query("select date_format(datnasb,'%d/%m/%Y'),nomalub,endalub,telalub,emaalub,
   sql_rowid from tab_cadalu limit $offset,$rows");      

I appreciate any information anticipating many thanks
Imperio - Sao Paulo - Brazil

   

[stworthy]

1. Use 'as' keyword to rename the date field.

Code:

$rs = mysql_query("select date_format(datnasb,'%d/%m/%Y') as datnasb,nomalub,endalub,telalub,emaalub,
   sql_rowid from tab_cadalu limit $offset,$rows");

2. Make sure the date column of datagrid is binded to 'datnasb' field.

Code:

{field:'datnasb',title:'dados',width:100}

[impperio]

Thank you for your attention, and so put date_format (field) that the field is not displayed if no data
follows the code used below

 <table id="dg" title="My Users" class="easyui-datagrid" style="width:900px;height:450px"
         url="get_users.php"
         toolbar="#toolbar" pagination="true"
         rownumbers="true" fitColumns="true" singleSelect="true">
      <thead>
         <tr>                   
                <th field="nomalub" width="50" sortable="true" align="left">Nome</th>
            <th field="endalub" width="50" align="right">Sobrenome</th>
            <th field="telalub" width="50" align="right">Telefone</th>
            <th field="emaalub" width="50">E-mail</th>                                     
                <th field="datnasb" width="50">Data</th>
           
            </tr>
</thead>

[impperio]

many, many thanks for your help I'm even show the ball