如何在php/mssql查询中添加此检查


How to add this check in php/mssql query?

我得到了这个:

            'char_transfertime' => $data['TransferTime'], 

它从mssql列中获取日期:TransferTime,例如:2013-08-19 18:55:00,并将其显示在用户配置文件中。但如果TransferTimeNULL,它将在网站上显示NULL,我希望它是N/A

如何在上面添加一些内容,那么如果NULL=N/A

类似于以下内容: 'char_clan' => !isset($data['IDName']) ? "N/A" : '<a href="./?page=clan&id=' . $data['Knights'] . '">' . $data['IDName'] . '</a>');

以下是语法:

SELECT Class, Race, Strong, Sta, Dex, Intel, Cha, Points, 
isnull(TransferTime,'N/A')TransferTime FROM USERDATA

它必须是这样的:

'char_transfertime' => isset ( $data['TransferTime'] ) ? $data['TransferTime'] : 'N/A',

阅读此处关于三元运算符的内容:http://php.net/manual/en/language.operators.comparison.php