Skip the empty value from mysqli selects query. Use: name != ''
Database
Result:1. Dhaka 2. London Here skips 2 number rows which was empty |
See the example.
Example:
MYSQLI
$sql = "SELECT * FROM data WHERE name != '' ORDER BY id asc LIMIT 10";
ddd |
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 |
How to skip Empty Value from selecting mysqli | Mysqli 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 |