[PHP-DB] reading files instead of using tables

2001-01-11 Thread sarahana
Hi, I seem to be having some problem with the general php list, so I'm sending this question here - please do not get annoyed :-) I want to read a directory and count all the files in it so that i can store each file name into an array... please help.. I want to list the images in a dir this way

Re: [PHP-DB] sql: LIKE

2001-01-11 Thread CC Zona
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] wrote: > "SELECT bar FROM foo WHERE bar LIKE '%foo%'" should return something like > the order > > bar > --- > 'foo' (exact match) > 'the foo is a foo is a foo' (3 matches) > 'have you seen the foo?' (1 match) What DBMS?

Re: [PHP-DB] Ora_Bind problem

2001-01-11 Thread Thies C. Arntzen
On Wed, Jan 10, 2001 at 01:37:17PM +0100, David Díaz wrote: > Hello!! > > I've got a problem using Oracle 7 functions. When I'm trying to execute this >commands: > > Ora_Logon("jajejijoju@pixies","doolittle"); > $cur = Ora_Open($conn); > Ora_Parse($cur,"SELECT empresa,sedeprov,codigo,pe

Re: [PHP-DB] IBM DB2 and DSN

2001-01-11 Thread Yasuhide OMORI
Hi. On Thu, Jan 04, 2001 at 12:17:50PM -0800, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > I failed twice so I just added another entry to the catalog. If you > > know how to delete an entry in the catalog please tell me. The manual > > was to hard to lookup for the solution. > > You can "d

Re: [PHP-DB] Query Access DB by date

2001-01-11 Thread Bob Hall
>When I try to query an Acess database for a particular date I get ODBC >errors indicating I'm screwing up the call. Can anyone give me an example of >a select on a date field. Quotes make it think it is a string. No quotes >make it think it is a number. The pound sign just says it doesn't know wh

Re: [PHP-DB] reading files instead of using tables

2001-01-11 Thread Miles Thompson
http://www.php.net/manual/function.readdir.php complete with example. Miles At 03:24 PM 01/11/2001 +0530, sarahana wrote: >Hi, >I seem to be having some problem with the general php list, so I'm sending >this question here - please do not get annoyed :-) > >I want to read a directory and count

[PHP-DB] Problem with writing to database. Possibly a CLOB error...

2001-01-11 Thread simon
Hi, I get the following error when I try and write to the database on only some of the items in $res. The majority go in fine. When I enter the ones causing an error, individually, they go in without a problem. Is it because I'm using a loop to enter the data? Can anyone help please? Thanks in

Re: [PHP-DB] Easy MySQL question

2001-01-11 Thread simon
Julie Meloni wrote: > Paulson, Joseph V. \"Jay\" wrote: > > > Hello everyone-- > > I've got a easy question that I can't seem to answer for myself. I'm > > running a query in MySQL and want to know how many entries are in a table > > and then echo that out onto a page. I thought this would be e

Re: [PHP-DB] Easy MySQL question

2001-01-11 Thread Julie Meloni
simon wrote: > Julie Meloni wrote: > > >> Paulson, Joseph V. \"Jay\" wrote: >> >> >>> Hello everyone-- >>> I've got a easy question that I can't seem to answer for myself. I'm >>> running a query in MySQL and want to know how many entries are in a table >>> and then echo that out onto a page

Re: [PHP-DB] Easy MySQL question

2001-01-11 Thread simon
Julie Meloni wrote: > simon wrote: > > > Julie Meloni wrote: > > > > > >> Paulson, Joseph V. \"Jay\" wrote: > >> > >> > >>> Hello everyone-- > >>> I've got a easy question that I can't seem to answer for myself. I'm > >>> running a query in MySQL and want to know how many entries are in a table

[PHP-DB] Re-using a result set

2001-01-11 Thread TopFive
Hello, everyone -- I'm new to the list, and to PHP. I own a very large, very active original humor website which currently consists of over 2000 HTML documents, and I'm converting it to a database-driven model which should reduce that amount to less than 100. I'm from an old school dBase/C

Re: [PHP-DB] Re-using a result set

2001-01-11 Thread joe
Sure, just do: mysql_data_seek($sql_result,0); before you get to your while() the second time. Hope this helps, Joe TopFive wrote: > Hello, everyone -- I'm new to the list, and to PHP. > > I own a very large, very active original humor website which > currently consists of over 2000 HTML do

RE: [PHP-DB] Re-using a result set

2001-01-11 Thread Finkel, Sean
Try calling: mysql_data_seek($connection, 0); then looping through again. This should reset the row pointer to the first row so that you can go through again :) Sean -Original Message- From: TopFive [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 3:02 PM To: [EMAIL PROTECTE

Re: [PHP-DB] Autonomous Mass Mail List System (Broadcast Email)

2001-01-11 Thread JJeffman
I've never used it but php has functions to deal with "flat file databases" like this one. There is an example on "PHP Professional Programming", a book of Wrox. HTH. Jayme. http://www.conex.com.br/jjeffman -Mensagem Original- De: Jason Beebe <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTE

[PHP-DB] Access 2000 to PostgreSQL

2001-01-11 Thread Julio Cuz, Jr.
Hi-- Does anyone have a tutorial or sample commands on how to EXPORT data FROM MS ACCESS 2000 to POSTGRESQL? Thanks! Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comma

Re: [PHP-DB] Access 2000 to PostgreSQL

2001-01-11 Thread Larry Rivera
I belive that Acceess can export to a comma delimited file, so you can do that then dump it into you new database ;) - Original Message - From: "Julio Cuz, Jr." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 11, 2001 3:33 PM Subject: [PHP-DB] Acce

[PHP-DB] Re: [PHP] Access 2000 to PostgreSQL

2001-01-11 Thread Louis Bertrand
A bit off topic for the PHP list? If this is just a one-time deal, from the Win environment, open the Access file and then link the postgreSQL tables and use one of the Update Queries in Access to copy from one to the other. The odbc driver works (tried it on Win98/Access2000/pgsql7). Ciao --Lo

[PHP-DB] Date Control Problem

2001-01-11 Thread Ian
Dear Sir / Madam, Case 1: My database, Table name -> Test. Field name -> due_date. Let say, due_date = 2001-01-01. Now, I would like to display all data from Test table where my due_date is before the current date. I tried the below SQL statement but it didn't work, SELECT * fro

Re: [PHP-DB] Date Control Problem

2001-01-11 Thread Leonard Tambunan
What is the Database Engine? > Dear Sir / Madam, > > Case 1: > My database, > Table name -> Test. > Field name -> due_date. > > Let say, > due_date = 2001-01-01. > > Now, I would like to display all data from Test table where my due_date is > before the current date. I tried the belo

Re: [PHP-DB] Date Control Problem

2001-01-11 Thread Ian
MYSQL Leonard Tambunan <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > What is the Database Engine? > > > Dear Sir / Madam, > > > > Case 1: > > My database, > > Table name -> Test. > > Field name -> due_date. > > > > Let say, > > due_date = 2001-0

[PHP-DB] Text Control.

2001-01-11 Thread Ian
Dear Sir / Madam, Problem :- Data from HTML is likes, This is a testing messages:- 1. MSG A. 2. MSG B. 3. MSG C. So, I insert $test into MYSQL database. After that, I login into MYSQL and select the test field, the display is same as above. But, when I used PHP codin

[PHP-DB] Re: [PHP] Cannot send session cache limiter - headers already sent Cannot send session cookie - headers already sent by

2001-01-11 Thread Teodor Cimpoesu
Hi JB! On Wed, 10 Jan 2001, JB wrote: > actually.. still give me the same error after i fixed that. new code as > follows along with the error: > > if (!session_is_registered('cart')) { > $cart = array(); > session_register('cart'); > } > else { > session_start(); > } > > any other ideas? =)

[PHP-DB] Re: [PHP] Easy MySQL question

2001-01-11 Thread Nicolas Windpassinger - Sun
Joseph, here it is: Number of manpages in db: hope that's what you were looking for, Nicolas. "Paulson, Joseph V. \"Jay\"" wrote: > > Hello everyone-- > I've got a easy question that I can't seem to answer for myself. I'm > running a query in MySQL and want to know how m

Re: [PHP-DB] Cannot send session cache limiter - headers already sent Cannot send session cookie - headers already sent by

2001-01-11 Thread JJeffman
Look for empty lines, html tags,"echoes" or "prints" before the cookie session is tried, even in include files and clear them. Jayme. http://www.conex.com.br/jjeffman -Mensagem Original- De: JB <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Enviada em: quarta-feira

[PHP-DB] Easy MySQL question

2001-01-11 Thread Paulson, Joseph V. \"Jay\"
Hello everyone-- I've got a easy question that I can't seem to answer for myself. I'm running a query in MySQL and want to know how many entries are in a table and then echo that out onto a page. I thought this would be easy but I don't know why it's not working. Anyway, here's what I am doing:

Re: [PHP-DB] Easy MySQL question

2001-01-11 Thread Julie Meloni
Paulson, Joseph V. \"Jay\" wrote: > Hello everyone-- > I've got a easy question that I can't seem to answer for myself. I'm > running a query in MySQL and want to know how many entries are in a table > and then echo that out onto a page. I thought this would be easy but I > don't know why it's