[SOLVED] for statment

[the_oliver]

Hello,

 

Can someone tell me what im doing wrong hear?  The first value is printed but then just the spacer.  Eg. 937401 | | | | | |  when it should be 2345 | 234523 | 23452345 | and so on.

 

 

$query = "SELECT num FROM table WHERE id = '1'";
$result = pg_query($temp_pg_connection, $query);
$data = pg_fetch_array($result);
$entry_count = pg_num_rows($result);

$spacer = " | ";

if ($entry_count > 0)
                {
                for ($i=0; $i<$entry_count; $i++)
                        {
                        echo $data[$i];
                        echo $spacer;
                        }
                }                                                                               
                else
                {
                echo "no data apparently?";
                }

 

Many Thanks

[Jessica]

You select the first result, then try to access non existent rows in that result. You need to loop through the results using pg_fetch_array in a while loop - check the documentation page for pg_fetch_array, that will show you how to do this properly.

[the_oliver]

Ok, so i use something like:

 

while($query_data = pg_fetch_array($result)) {}

 

Would is still need the for() statment or just put

 

{

echo $data["num"];

echo $spacer;

}

 

 

?

[the_oliver]

Scrap that, got it!  Many Thanks