Re: [PHP] odbc msaccess php5 [Giving Up]

2008-07-06 Thread Peter Jackson
Peter Jackson wrote: well thats it Ive come to the conclusion that its a driver/lib issue. From what I can see mdbtools lib only reads and only does basic select. (eg Select * from table where col =thistext But not tex* % or date. Also looks like the project has died (think the last release

Re: [PHP] odbc msaccess php5

2008-07-05 Thread Peter Jackson
Bastien Koert wrote: On Sat, Jul 5, 2008 at 11:04 AM, Bastien Koert <[EMAIL PROTECTED]> wrote: On Sat, Jul 5, 2008 at 6:51 AM, Peter Jackson <[EMAIL PROTECTED]> wrote: $conn=odbc_connect("Database","",""); works $a = "abcd"; (this va

[PHP] Re: Trying to keep a dropdown selection sticky

2008-07-05 Thread Peter Jackson
} echo ''; echo ''; ?> If I'm reading this correctly you mean if the value has been selected before select it again? If so way I did it was by checking the database value eg echo " $value \n"; Peter Jackson -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] odbc msaccess php5

2008-07-05 Thread Peter Jackson
r) And before everyone shouts use mySQL postgresql etc that isnt an option at this point in time. I dont need to update the records I just need to be able to read them with php. Oh and whilst I'm here is it possible to read an ms-query via odbc? (eg select * from myquery). Just thinking that may fix one of my problems (Caps and spaces in table/column names aaarrgghh) Peter Jackson -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Printing Question

2008-01-26 Thread Peter Jackson
OK this is very general. Whats the best way to do formatted printing via php? In my case I have a postgre database that I connect to with a php(naturally seeing as this is the php list). My aim is to convert an Access db to php/postgre. In this access db there are several reports that requ

Re: [PHP] regex

2008-01-21 Thread Peter Jackson
Jim Lucas wrote: Peter wrote: I am trying to convert ms access sql to postgresql using php. I have a sql statement in the form ;- $sql = SELECT DISTINCT [Table Name].[Column.Name], [Table Name 1].[Column Name 2] etc. what I want to end up with is $sql = SELECT DISTINCT table_name.column_nam

Re: [PHP] regex

2008-01-21 Thread Peter Jackson
Jim Lucas wrote: Peter wrote: I am trying to convert ms access sql to postgresql using php. I have a sql statement in the form ;- $sql = SELECT DISTINCT [Table Name].[Column.Name], [Table Name 1].[Column Name 2] etc. what I want to end up with is $sql = SELECT DISTINCT table_name.column_nam

[PHP] PHP / LAMP Training

2005-10-04 Thread Peter Jackson
Has anyone been to good PHP and/or LAMP training? I was looking around and saw on a blog where they really liked the security aspects of this one: http://www.sans.org/ns2005/description.php?tid=249 Has anyone been to classes by sans.org? Thanks, Peter __ Free 3000MB