2007. 04. 25, szerda keltezéssel 17.03-kor Dan Shirah ezt írta:
> Okay, print_r($result_record) for the query result.
$result_record is a resource identifier. you are not interested in that
too, I think... ;)
if you want all records, then stuff them into an array and use that:
while ($row_record = mssql_fetch_array($result_record)) {
$id_record[] = $row_record['id'];
}
print_r ($id_record);
greets
Zoltán Németh
>
> But I still don't know why it's only returning the last record of the
> query instead of all the results.
>
> On 4/25/07, Zoltán Németh <znemeth@xxxxxxxxxxxxxx> wrote:
> 2007. 04. 25, szerda keltezéssel 16.56-kor Dan Shirah ezt
> írta:
> > Any ideas why my query only returns the very last record
> that matches the
> > criteria specified??
> >
> > $sql_record ="SELECT * FROM payment_request WHERE
> status_code = 'P'";
> > $result_record = mssql_query($sql_record) or
> die(mssql_error());
> > if(!empty($result_record)) {
> > while ($row_record = mssql_fetch_array($result_record)) {
> > $id_record = $row_record['id'];
> > }
> > }
> > print_r ($sql_record);
>
> in the above line you are printing out the query. I think
> that's not
> what you want...
>
> greets
> Zoltán Németh
>
> >
> > The result of the print_r displays only the last record that
> matches the
> > query criteria. I tried a foreach instead of a while with
> no luck.
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
