This is what I have.. I think it's along the same lines as what you are
asking.. If not, just ignore my drunken ramblings.. It isn't with oci stuff
but if it's similar to what you need then you should be able to convert it
over..
$result = $database->query( "SELECT * FROM contacts WHERE cartId='$cartId'
ORDER BY lastName, firstName" );
while( $data = $database->fetchRow( $result ) )
{
echo( "<tr><td>$data->lastName, $data->firstName</td><td><a
href=\"mailto:$data->emailAddress\">$data->emailAddress</a></td></tr>\n" );
}
Now from what I understand of your question, you could remove the while so
you had $data = $database->fetchRow( $result ); then use if() tests to
compare $data->varName values.. If you wanted to compare values in different
rows, then I guess you could leave the while loop and just replace the
echo() with your if() tests..
Sorry if I missed the point of your question.. I hope this helps though..
Later,
Bob Weaver
"Pusta" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am really new at this PHP stuff, so please go easy on me. I am trying
to
> query the database and then store the result of the query into a variable
to
> compare to another variable. This is for a login function so for example:
>
> $c1 = ociparse($db, "select ssn from schema.table where ssn = $password");
> ociexecute($c1);
>
> my question is how can I store what's in the field ssn into a variable?
>
> Thanks,
>
> Pusta
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
