while loop inside function

[arunpatal]

function display_sql_list($table_name){
			
			$display = mysqli_query($this->connect,"SELECT * FROM $table_name") 
			or die (header("location:error1"));
			
			while ($result = mysqli_fetch_assoc($display)){
				
				$results[] = $result["name"];	
			
			}
			
			return $results;
		}

The code above returns error

Notice: Array to string conversion in pages\booking_list.php on line 5
Array

What  is wrong?

[Ch0cu3r]

The code for the function is fine, it returns an array of names.

 

The error is produced line 5 of booking_list.php. What are you doing on that line? Post the first  5 lines of code from that file.

Edited March 31, 2014 by Ch0cu3r

[arunpatal]

The code for the function is fine, it returns an array of names.

 

The error is produced line 5 of booking_list.php. What are you doing on that line? Post the first  5 lines of code from that file.

This is booking_list.php page

<?php
$mysql = new viks2007();
$design = new design();

echo $mysql->display_sql_list($bookpage_table_name);

?>

[arunpatal]

function display_sql_list($table_name){
            
            $display = mysqli_query($this->connect,"SELECT * FROM $table_name")
            or die (header("location:error1"));
            
            while ($result = mysqli_fetch_assoc($display)){
                
                echo $result["name"];    
            
            }
            
        }

Using like this work fine

[Ch0cu3r]

You cannot echo an array. Maybe use

$names = $mysql->display_sql_list($bookpage_table_name);

echo implode(',', $names);

// OR, echo names into a HTML list
echo '<ul><li>'  . implode('</li><li>', $names) . '</li></ul>';

[arunpatal]

 

You cannot echo an array. Maybe use

$names = $mysql->display_sql_list($bookpage_table_name);

echo implode(',', $names);

// OR, echo names into a HTML list
echo '<ul><li>'  . implode('</li><li>', $names) . '</li></ul>';

Worked

Thanks