[PHP-DB] PHP/MySQL to DBF

Hello all, I'm looking for a PHP tool that would take the results of a MySQL query and send them to a client browser in DBF format. I wrote an output tool that sends a query result as CSV to the browser, but DBFs are much more handy in this particular case. Does this exist?

Re: [PHP-DB] Php4 and Interbase 6 on linux

Hi, You need to recompile PHP with support for Interbase. I would recommend reading the instructions on linux PHP installations on the PHP website. I imagine the conifgure option is something like --with-interbase=path_to_interbase but definately don't quote me on that. Cheers, db Paulu

[Fwd: [PHP-DB] A local file copy question]

oops. -- -- Dan Barton Terrestrial Program Biologist Asst. Data Manager Point Reyes Bird Observatory http://www.prbo.org [EMAIL PROTECTED] [EMAIL PROTECTED] ---BeginMessage--- Hi, There are several PHP-Apache environment variables that may do what you're interested in. (I'm not

Re: [PHP-DB] ADDING DATES

with ... but i am getting lazy, I get a bit peeved. The implication is Do my work for me. It's different when the context is I want to do this ... tried this ... results aren't right ... please help. Miles At 06:04 PM 1/13/2002 -0800, Daniel Barton wrote: Miles, Hmm... RTFM

Re: [PHP-DB] The New Guy

. - Original Message - From: Daniel Barton [EMAIL PROTECTED] To: Christopher J. Crane [EMAIL PROTECTED] Sent: Sunday, January 13, 2002 9:10 PM Subject: Re: [PHP-DB] The New Guy MySQL is free and open source. Support from MySQL AB is not free, but that shouldn't be an issue. Check out

Re: [PHP-DB] The New Guy

prefer the company of others, please do take Dan's advice. Your experience is contrary to my own, and is NOT supported by the majority as evidenced by the volume of list transactions. =dn - Original Message - From: Daniel Barton [EMAIL PROTECTED] To: Christopher J. Crane [EMAIL

Re: [PHP-DB] The New Guy

Paul, Just a clarification: I wasn't the original poster. Christopher J. Crane was the original asker of the CSV/flat file database question. I do have a db to use. Cheers, db Paul Burney wrote: on 1/14/02 2:12 PM, Daniel Barton at [EMAIL PROTECTED] appended the following bits to my mbox

Re: [PHP-DB] ADDING DATES

Miles, Hmm... RTFM! .. That's a pretty unproductive post. Pedro, There are two PHP functions that will suffice. date() and mktime(). I've cut and pasted this from the PHP manual: $tomorrow = mktime (0,0,0,date(m) ,date(d)+1,date(Y)); $lastmonth = mktime (0,0,0,date(m)-1,date(d), date(Y));

[PHP-DB] PHP/MySQL Library Catalog System

Hi all, I've noted that a least a couple of people on this list work with library catalog systems - I'm interested in finding out whether any of these systems are open-source or are available for a nominal fee. I'm familiar enough with PHP/MySQL to make one, but I'd also like to avoid

Re: [PHP-DB] PHP/MySQL Library Catalog System

Hi again everyone, Alnisa Allgood wrote: You may want to check HotScripts, or the PHP Resource Index (http://www.hotscripts.com) and (http://php.resourceindex.com). These locations will most likely have an array of free or low-cost library solutions. Thanks all for the HotScripts etc.

Re: [PHP-DB] MySQL Result Resource

Andrew: Don't put quotes around your MySQL function call. i.e. PASSWORD($password) not 'PASSWORD($password)' p.s. Looking at this thread, it seems like most of the errors you're encountering have nothing to do with md5() or password(), but with syntax, like placement of quotes, or whether

Re: [PHP-DB] query and count

Hi, I hate to simply refer to other sources in a response, but cross-tabulations are a large and rich subject which are too large for the time I have to write this email. I would suggest reading this article: http://www.devshed.com/Server_Side/MySQL/MySQLWiz which is a pretty good source

Re: [PHP-DB] count query

Hi, SELECT SUM(IF(id = '2',1,0)) AS field_name FROM table Versatile command - you can use it for quite a lot of things. Barry Rumsey wrote: Is it posible to do a count(*) on a tabe where id=2 and count just those that id = 2 -- -- Dan Barton Terrestrial Program Biologist Asst.

Re: Fwd: Re: [PHP-DB] How to querry two db in a single statement?

Hi all: AFAIK, it is possible in a bunch of database software to query multiple DBs through joining. I have a Foxpro background (so most of what I say is therefore, b.s.) but you can define your query tables using this notation: database.table Which allows you to query multiple DBs. You should

Re: [PHP-DB] newbie: MySQL Problem or severe ignorance..

Hello: I would actually disagree with [EMAIL PROTECTED] The mysql_query() function does not require both database and query as arguments, only query. The mysql_db_query() function does, thus the function name. Using mysql_query() with database as a parameter would actually be incorrect. (See

Re: [PHP-DB] Dynamically populating a dropdown box

Chris - You're getting already getting plenty of answers to this question - I only have one suggestion, which is that if you're not doing it already, just write a function or create an object that makes a dropdown box. I have a function and a class that I use for creating dropdowns. Well,

Re: [PHP-DB] Dumb Question??

Russ - Why not (MySQL) extract the field always, and code into your (php) generic mechanism whether or not a particular field under that name appears? Using mysql_fetch_assoc() you could exclude 'modified' from your generic mechanism under particular circumstances. This avoids coding it

Re: [PHP-DB] Re: Dumb Question??

Don't think that was the question...? Ian Ferger wrote: $table = some_junk; $resultset=mysql_query(select blah ,blah from $table); Russ Michell [EMAIL PROTECTED] wrote in message news:SIMEON.10112131209.A@k1c. anglia.ac.uk... Hi there everyone: I have a genericphp/MySQL

Re: [PHP-DB] :: Problems With Interbase :: Please Help ::

Vins, Have you tried sticking the path of the database relative to the server root in there? like: /home/vins/interbase_data/NAMES.GDB or: /var/interbase_date/NAMES.GDB etc. ? -db Vins wrote: Hi. I need help with Interbase. Here is my script...

Re: [PHP-DB] parse error

Rob - I think I see what you're doing: you're concatenating $message with something else (the HTML output following line 357?). Problem is, you're just stating the right hand side of what should be an assignment. The concatenation should be: $variable = $variable .= 'HTML output'; and it looks

Re: [PHP-DB] Use php to plot graph.

There are a few ways to go about this: You could: 1) Use little image blocks to dynamically build bar graphs. It's not too hard with PHP. Make some little square (or round or whatever) gifs (with transparent edges), and then position them on a background JPEG or gif using DIV tags. Make an

[PHP-DB] Awkward query - simpler method?

Hi, I can't seem to nail down the simplest way to do this. I've got 10-15 lines of code right now to do something that should take less. The following code extracts the names of all the fields in a table, prints them across a table row in their own cells, and then extracts each record and

Re: [PHP-DB] Help with mail notifying via file upload

Are you positive fileupload.php is passing $userfile to the mail() script? A blank result would seem to indicate that it's not getting passed. You could try passing it through the URL if they're seperate scripts. Or, you could just include the mail() script in fileupload.php, eliminating the

Re: [PHP-DB] How to install gdlibrary on windows 2000?

I volunteer to be a patient with some patience. Sorry to spam a little humor. -db Frank M. Kromann wrote: You can download binaries (from latest cvs) from http://kromann.info/php4.php I'm not compiling all binaries at this point, but this page is updated every morning at 4am. If you want

Re: [PHP-DB] Converting MySOL query results into form elements.

Hi, I hope this is of some help. Programmatically, the idea is: (html) begin a select input type (php) connect_to_db --- query --- add options (one at a time, in a loop) (html) end the select input type The follwing code works for a table named projects with a field named project. Apply it

Re: [PHP-DB] query + loop problem

Try using mysql_query to describe the table in question (describe $table), and use the output as a list of field names (and types). I wrote a generic script to do this for an app... can provide if needed (although it sure looks a little hacked right now, hmmm) -db Russ Michell wrote: Hi

[Fwd: [PHP-DB] JOIN - Not working.]

-- -- Dan Barton Terrestrial Program Biologist Asst. Data Manager Point Reyes Bird Observatory http://www.prbo.org [EMAIL PROTECTED] [EMAIL PROTECTED] ---BeginMessage--- Try: select sum(if(whatever=whatever,1,0)) as whatever from wherever where whatever=whatever; This is a pretty

Re: [PHP-DB] JOIN - Not working.

- From: Daniel Barton [mailto:[EMAIL PROTECTED]] Sent: 28 November 2001 4:14 PM To: Martin E. Koss Subject: Re: [PHP-DB] JOIN - Not working. Try: select sum(if(whatever=whatever,1,0)) as whatever from wherever where whatever=whatever; This is a pretty fast command for simple cross

Re: [PHP-DB] any extra work need to make php mysql function available?

Hi, PHP and MySQL are not talking to each other. Numerous tutorials available on the web for getting MySQL, PHP, and Apache to work together... depending on how you installed PHP and MySQL, the method varies. If PHP is compiled with support for MySQL, it may be as simple as uncommenting or

Re: [PHP-DB] Recurse thru dir into DB

I would suggest perhaps a different way (slightly larger use of disk space, but only one script and only one query, although a moderately complex query): 1) Subscriber's emails are stored in table 'A' with their associated category as a data field. 2) A unix_timestamp field is added to table

Re: [PHP-DB] php/mySQL config

Hello, How are you able to connect to MySQL - through PHP or through your (XP?) user account? Does PHP connect to MySQL? If you can connect through PHP, then who is privileged to use the database you're trying to use? Have you tried connecting as the MySQL root user through a PHP script?