need some advice on retrieving table data

germanjulian

man I am new to PHP and especially ODBC. Hate it.

i have a table with various fields and especially a few date fields.

basically I need to retrieve all data from the table but using "ODBC_RESULTS" only gets the first row not various rows?

how do I get more then one row into different variables.

my table has these colums
Provider -- Invoice No -- Account -- Ic Date -- Total -- End Date

also another problem is that that the dates returned are in this format even though In access I said use short date?
xx/xx/xxxx xx:xx

I really dont want the time which is 00:00 anyway.

and then I am supposed to put the results in a table from january to december according to the end Date? no ideal how to do that either. I think I need to learn PHP for a year before I can do this. or a lot of example code

Grisu

Hi Julian,

I used Access before, too and I understand that you get frustrated with ODBC, while PHP is a great language in my opinion. I sometimes get an error from Access using an ODBC-command while the same command works with mySQL. And this is just with simple INSERT-commands.

To get all the results you will probably use an array. The best way is to make two for()-loops and get the results one by one with odbc_fetch_row() and odbc_result().

The reason for the wrong date-format is that the Access-setting makes only the appearance in access. The date-value is a number which is formatted for output. If you want to make the same format in PHP you can use:

$datestyle = "d.m.Y";
$enddate = date($datestyle, strtotime($field))

The last part of your question I do not understand.

Grisu

germanjulian

thank you for the great help.

the date thing works niceley now I gonna do the loop.

gotta say I learned more in 3 days then I would learn in 2 weeks at university

UPDATE:
UPDATE! this is what I am struggeling on

I am supposed to put the results from a DB table in an HTML (PHP) table. the table should have culums from january to december.
There is a date field in my DB table and according to the date field e.g 12/06/03 the results from this row are supposed to be entered into the June table field.

so -- May -- June -- July----
-- -- data ---- ---
--- ---- data--- ------

I use this fetch array function

function odbc_fetch_array($result, $rownumber=-1) { 
    if (PHP_VERSION > "4.1") { 
        if ($rownumber < 0) { 
            odbc_fetch_into($result, $rs); 
        } else { 
            odbc_fetch_into($result, $rs, $rownumber); 
        } 
    } else { 
        odbc_fetch_into($result, $rownumber, $rs); 
    } 

$rs_assoc = Array(); 

foreach ($rs as $key => $value) { 
    $rs_assoc[odbc_field_name($result, $key+1)] = $value; 
} 
return $rs_assoc; 
}

and I use your code to format the date.