odbc_fetch_row is empty

[Anon]

Hi,

I have problems to get some data out of my database.
The output of odbc_num_fields and odbc_field_name is OK. But I can't get a result of the function odbc_fetch_row and odbc_result if I try the code without fetch_row.

...
while(odbc_fetch_row($result_id))
{
for($i=1;$i<=$num_fields;$i++)
{
$result[$num_rows][$field_name[$i-1]]=odbc_result($result_id,$i);
}
$num_rows++;
}
...

How can I get the records?

Please help and thanks in advance

[[deleted]]

Did you search the forum?

[yanyan]

$result_id=odbc_exec("SELECT * FROM TABLE");
while(odbc_fetch_row($result_id)) {
echo odbc_result$result_id,"FIELDNAME");
}
odbc_close($result_id);

that should do it..

Good Luck..
Brian

[Anon]

thanks, but it seems to be an other problem. I tried lots of variations of code but nothing works. I have no idea what to do.
Why are the fieldnames OK and not the result of odbc_fetch_row or odbc_fetch_into?

Thanks

Christof

[yanyan]

Look thoroughly on your coding again.. maybe the mistake is in logical side..

Brian..

[Anon]

Well, I can't find a mistake.

$sql="SELECT * FROM test";
if ($conn_id=odbc_connect("$dsn",$user,$password))
{
if($result_id=odbc_exec($conn_id, $sql))
{
echo "executing '$sql'<br><br>";
while(odbc_fetch_row($result_id))
{
echo"hello<br>";
echo odbc_result($result_id,1);
echo odbc_result($result_id,"test2");
}
echo "freeing result<br><br>";
odbc_free_result($result_id);
}
else
{
echo "can not execute '$sql'<BR><BR>";
}
echo "closing connection $conn_id";

odbc_close($conn_id);}

else
{
echo "can not connect to DSN: $dsn<br><br>";

}

I tried this code with odbc_fetch_row and odbc_fetch_into but the result is false so there is never displayed "hello".
If I try odbc_result without odbc_fetch_row, there is nothing (false).

Is the code correct?

Thanks,

Christof

[yanyan]

could you list your fields in your table?

brian :->

[Anon]

Yes, on the Sql Server the table is complete. I can also get the fields and everything else with ODBC from there. It's only the fields of the table I can't get from php.

Christof

[yanyan]

WELL YOU TRY THE ODBC_RESULT_ALL()? THEN LOOK AT YOUR CONNECTIONS SUCH AS DSN from the database...

[Anon]

hi Brian,

the problem was the rowcount from the sql server. I set the option "SET NOCOUNT ON" and everything works fine.

thanks for your help,

Christof