echo array into two columns.

[denoteone]

Trying to get array from database and print into two columns. Can anyone see what I am doing wrong?

 

				<?php
				$sql  = "SELECT * FROM node WHERE field_page_list = Goverenment";
				$result = mysql_query($sql);
				echo 'test';
                                    $total = mysql_num_rows($result);
                                    $per_row = ceil($total / 2);
                                    $r = 1;
                                    echo '<ul style="float:left;">';
                                    while($row = mysql_fetch_assoc($result)){
                                    
                                    echo '<li>'.$row['column'].'</li>';
                                    
                                    if($r == $per_row){
                                    
                                    echo '</ul><ul style="float:left;">';
                                    
                                    }
                                    $r++;
                                    }
                                    echo '</ul>';
                                    ?>

 

I am getting the following errors:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

[Philip]

When you get "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource" it means your query failed. You can see why using mysql_error() but I have a sneaky suspicion you just need single quotes around your value..

$sql  = "SELECT * FROM node WHERE field_page_list = 'Goverenment'";