replace
if(mysqli_num_rows($query) > 0){
$row = mysqli_fetch_row($query);
with
while($row = mysqli_fetch_row($query)){
More Related Contents:
- If number have inside number string [closed]
- recurring system my sql query [closed]
- MySQL query won't update database [closed]
- Cannot modify header information [duplicate]
- Gather column name of a table from database [closed]
- PHP sending form data to the database
- inserting information and image in php and mysql
- CodeIgniter – foreach loop
- Insert form in MySQL with PDO [duplicate]
- How can I do ‘insert if not exists’ in MySQL?
- Running MySQL *.sql files in PHP
- MySQL datetime fields and daylight savings time — how do I reference the “extra” hour?
- Why doesn’t MySQL support millisecond / microsecond precision?
- Real escape string and PDO [duplicate]
- SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102 [closed]
- Run a mySQL query as a cron job?
- PHP PDO vs normal mysql_connect
- Can I create a database using PDO in PHP?
- MySQL PHP incompatibility
- PHP PDO and MySQLi [duplicate]
- SQLSTATE[HY000] [2002] A connection attempt failed.. – When attempting to connect from Local to remote server
- How to store an array into mysql?
- MySQL Error “Too many connections”
- Error 1148 MySQL The used command is not allowed with this MySQL version
- How can I debug why simplest MySQL query returns false?
- Connect to remote MySQL server with SSL from PHP
- How does {} affect a MySQL Query in PHP? [duplicate]
- When should I close a database connection in PHP?
- php connection pooling mysql [duplicate]
- Limit pagination page number