Digital Product Management Director 

<div>
Dear Ryan,<br />
Thank you,
</div>


<div>
Try this<br />
<br />

<pre><code id="code-20-42964464-1">$mazeretim = empty($row[&quot;mazeret&quot;]) ? 'X' : 'Y';</code></pre>
</div>


Try this



$mazeretim = empty($row["mazeret"]) ? 'X' : 'Y';

<div>
BTW empty will return true for &quot;&quot;<br />
<br />
If this is not happening it is possible you have a space in which case you do this<br />
<br />

<pre><code id="code-20-42964466-1">$mazeretim = empty(trim($row[&quot;mazeret&quot;])) ? 'X' : 'Y';</code></pre>
Use trim to remove the spaces.
</div>


BTW empty will return true for ""

If this is not happening it is possible you have a space in which case you do this



$mazeretim = empty(trim($row["mazeret"])) ? 'X' : 'Y';

Use trim to remove the spaces.

Bernard Savonet

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
I use PHP and MYSQL<br />
<br />
I select data from database which has a column that has 3 diffrent kind of values. &nbsp;Some text, empty value and Null value.<br />
<br />
when I select that column from database like below<br />
<br />

<pre><code id="code-10-29161774-1">while($row = $result-&gt;fetch_assoc()) {
        	
	$mazeret= $row[&quot;mazeret&quot;];

if (empty($mazeret)) {$mazeretim=&quot;X&quot;; } else {$mazeretim=&quot;Y&quot;; }</code></pre>
<br />
The result is Y for empty and filled rows, &nbsp;only the NULL rows are X, however the empty rows must be X too.<br />
<br />
what do you suggest I should do? Thank you
</div>
</div>


Dear Experts,
I use PHP and MYSQL

I select data from database which has a column that has 3 diffrent kind of values.  Some text, empty value and Null value.

when I select that column from database like below

(CODE)

The result is Y for empty and filled rows,  only the NULL rows are X, however the empty rows must be X too.

what do you suggest I should do? Thank you

Php if empty condition

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.