Horje
How to exlude empty value from selecting mysqli row

Skip the empty value from mysqli selects query.

Use: name != ''

 

Database

id name country
1 Dhaka Bangladesh
2    
3 London England

Result:

1. Dhaka

2. London

Here skips 2 number rows which was empty


How to skip Empty Value from selecting mysqli

See the example.

index.php
Example: MYSQLI
$sql = "SELECT * FROM data WHERE name != '' ORDER BY id asc LIMIT 10";

Output should be:

How to skip Empty Value from selecting mysqli




ddd

Related Articles
How to exclude a specific row from mysqli select record Mysqli Select Tutorial
How to exlude empty value from selecting mysqli row Mysqli Select Tutorial
How to Check if exist in database mysqli_num_rows Mysqli Select Tutorial

Single Articles
How to skip Empty Value from selecting mysqliMysqli Select Tutorial

Read Full:
Mysqli Select Tutorial
Type:
Develop
Category:
Web Tutorial
Sub Category:
Mysqli Select Tutorial
Uploaded:
1 month ago
Uploaded by:
Admin
Views:
13
Tested on:
PHP 7.4



Share on: