Subject | RE: [firebird-php] php4-interbase and select with no result |
---|---|
Author | Alan McDonald |
Post date | 2004-08-08T12:04:19Z |
I just tried it - it's the *,
give it a proper list of fields and it works fine
Alan
$sqlstring = "SELECT * FROM ECC WHERE MCC = '92000000001001'";
[Alan McDonald]
there's actually more to it than that...
this syntax will only ever return the first field in the query.
I don't use the raw calls so I'm not up to the nuance here. but with EZSQL
you can use
get_results for a multi row result set, or get_row for a single row
resultset.
then you use $row->FIELDNAME to get that part of the array back
Alan
[Non-text portions of this message have been removed]
give it a proper list of fields and it works fine
Alan
$sqlstring = "SELECT * FROM ECC WHERE MCC = '92000000001001'";
[Alan McDonald]
there's actually more to it than that...
this syntax will only ever return the first field in the query.
I don't use the raw calls so I'm not up to the nuance here. but with EZSQL
you can use
get_results for a multi row result set, or get_row for a single row
resultset.
then you use $row->FIELDNAME to get that part of the array back
Alan
[Non-text portions of this message have been removed]