Sorry, I may of forgetten to give you this:
$result = pg_query($dbconn, "select id,address from ip");
This is right before the:
$options=pg_fetch_array($result_ip);
so, my $results is really all the ip addresses ($rows after I perform the pg_fetch_array).
I will add the var_dump to see it (never done it before, I will do some googling :) )
On 12/3/06, Chris <
dmagick@xxxxxxxxx> wrote:
Mag Gam wrote:
> Randy + Chris:
>
> Thx for the quick replies!
>
> Chris:
>
> $rows contain ip addresses (postgresql inet) type (example: 192.168.0.1
> <http://192.168.0.1>)
> $options contain ip addresses (postgresql inet0 type (example: 127.0.0.1
> <http://127.0.0.1>)
> (keep in mind) they are both arrays. $rows contact all ips, and $options
> contact the ip addresses that were selected
>
> Randy:
> I am not sure what you mean. The variables look right. I am getting no
> errors! Just the logic is messed up.
I think Randy's right.
At the top you have:
//The values that need to be selected
$result_ip=pg_query($dbconn,$test_query);
^^^^^^^^^
but you are doing this:
while ($row = pg_fetch_array($result)) {
$result_ip at the top, $result in the second bit.
If you don't see errors, turn up error reporting & display errors:
error_reporting(E_ALL);
ini_set('display_errors', true);
Also that's not what I meant. I meant add a var_dump or print_r at each
stage to see what you are *really* getting from the code.
--
Postgresql & php tutorials
http://www.designmagick.com/
