mysql equivalent on odbc command

jaskillo

Can you tell me an equivalent of mysql_fetch_array on odbc?

thanks

junebug

odbc_fetch_row()

there is no odbc_fetch_array() as far as i can tell.

junebug

okay, i looked a little harder and there is a function:

odbc_fetch_array()

but there is not documentation on it yet. works in all versions of php4

jaskillo

Nope I've tried it but it says call to undefined function odbc_fetch_array()

junebug

okay, sorry about the last post. the function is only in php4.0.2 and later

Anon

I have a table CLIENT:

1st name
last name

I want to select all 1st name , but i like to see only one the same 1st names : example :

[1] Tom Lee Jones
[2] Tom Cruise
[3] Tom MacCarty
[4] Tom Fanny

[5] Joel Pillips

.
.
.
[19] Anny Dillan

I like to see this links :

TOM
JOEL
ANNY

Tanks .

Anon

To get only unique values for a specific field, this is the standard SQL approach:

SELECT DISTINCT <fieldname> FROM <table>

I haven't used MySQL enough to know if it supports DISTINCT, but it's about the only way I can think of that will get you what you want without jumping through hoops.

Robert

Anon

I'm working with php 4.0.5 and it doesn't works.
thanks

Anon

Yes, There are no odbc_fetch_array() function
included in PHP4.1.0, 4.0.6, 4.0.5, whatever.

Use these function to implement it.

function odbc_fetch_array($result)
{
if (odbc_fetch_row($result))
{
for ($i=0;$i<odbc_num_fields($result);++$i)
{
$rs[$i+1]=odbc_result($result,$i+1);
$rs[odbc_field_name($result,$i+1)]=odbc_result($result,$i+1);
}
return $rs;
}
return false;

}

and odbc_fetch_object is so on.
but I suggest you add the C function to PHP source before you compile. it will be faster than extern functions like this.