SELECT `track`, `phone`, `status`,
to_days(IFNULL(`date_finish`, curdate())) - to_days(`date_add`) as `diff`
FROM `track_tabl` WHERE `id_user` = '$id_user'SELECT `track`, `phone`, `status`,
to_days(IF(`date_finish` = '', curdate(), `date_finish`)) - to_days(`date_add`) as `diff`
FROM `track_tabl` WHERE `id_user` = '$id_user'Set(CDR(userfield)=имя_файла)<table>
<thead>
<tr><th>Трек-код<th>Телефон<th>Статус<th>Время в пути
<tbody>
<tr><td>R417...<td>+7900...<td>Прибыло<td>11 дней
<tr><td>...<td>...<td>...<td>...
...
</table> char *escapeString(char *str) {
char *result, *temp;
int i;
temp = malloc(strlen(str)*2+1);
i = 0;
while (*str) {
switch(*str) {
case '\n':
temp[i++] = '\\';
temp[i++] = 'n';
break;
case '\r':
temp[i++] = '\\';
temp[i++] = 'r';
break;
case ':':
case '$':
case '\\':
temp[i++] = '\\';
default:
temp[i++] = *str;
}
str++;
}
temp[i] = 0;
result = malloc(i+1);
strcpy(result, temp);
free(temp);
return result;
}