[PHP-DB] select and comparison of fields,

2003-08-21 Thread Dave [Hawk-Systems]
looking for a better way to query and cehck for overlapping timeframes. am selecting records for display that has 3 fields of importance; date_time (unix timestamp) session_time (in seconds) user_id (text field) Of all the sessions recorded, we are looking for a count

[PHP-DB] large csv text file import into postgresql via PHP

2003-09-25 Thread Dave [Hawk-Systems]
we have a number of csv dumps that occasionally have to be used to update tables in a postgres database... normally this is done by uploading the file and whomever running a php based parser which opens the file into an array, does a split on the comma, then executes an insert or update to the dat