Ok, I think you are misunderstanding the
process:
- first,
you are querying a database (I assume a postgres db) like this:
$result = pg_query($dbconn, “select…”) ,
so,
$result now is a “resource reference”
which contains the “result” of the query. However, now you need to tell php to
return the contents of that resource to you (you can return in either an
indexed, associative, or object array). So, to get your “array”, you now use
$result like this:
$myArray = pg_fetch_array($result);
Now $myArray is the actual “row/s” you
returned in $result.
Does that make sense?
So, when you first query, $result (or
$result_ip) = pg_query(conn, sql), you need to be consistent with your
variables. Either use $result_ip, or $result, but not both….My guess is that’s
your problem.
Hope that helps!
Randy
From:
pgsql-php-owner@xxxxxxxxxxxxxx [mailto:pgsql-php-owner@xxxxxxxxxxxxxx] On Behalf Of Mag Gam
Sent: Sunday, December 03, 2006
5:01 PM
To: Chris
Cc: Randy Moller;
pgsql-php@xxxxxxxxxxxxxx
Subject: Re: [PHP] HTML FORMS
selected question
Chris + Randy:
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/
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.15.6/565 - Release Date: 12/2/2006 9:39
PM
