[PHP-DB] Sending HTML output from MySQL query to Excel

2003-02-20 Thread Lisi
I searched the archives and read the postings about using header(Content-Type: application/vnd.ms-excel); to send tables dynamically constructed from a MySQL query to an excel spreadsheet, but when I tried it (using IE 6) all I got was a picture icon in the top left corner of the screen and no

RE: [PHP-DB] Final Date Question :-)

2003-02-20 Thread Ford, Mike [LSS]
-Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: 20 February 2003 01:52 OK here is a final date question. It's complex (Atleast to me :-( but i'm totally stumped. Here's what I need to do. Say September is Summer and October is winter, now getting the

[PHP-DB] TimeStamp format to date

2003-02-20 Thread Bruno Pereira
Good afternoon, Houston i have a problem. :-) Just to play a while. Is like this i have a field in MySql TIME_STAMP int(11) and he has a time stamp value (ex: 1045738710) and i want to make show it like a date format in the web. Can anyone help me on this...? Cumprimentos Bruno Pereira

Re: [PHP-DB] TimeStamp format to date

2003-02-20 Thread 1LT John W. Holmes
Is like this i have a field in MySql TIME_STAMP int(11) and he has a time stamp value (ex: 1045738710) and i want to make show it like a date format in the web. Can anyone help me on this...? Just SELECT it out and run it through the PHP date() function to format it. www.php.net/date

RE: [PHP-DB] TimeStamp format to date

2003-02-20 Thread Hutchins, Richard
Cumprimentos What'd you call me? Sometimes it's the simple things that make you laugh the hardest. Thanks, John. -Original Message- From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 10:37 AM To: Bruno Pereira; [EMAIL PROTECTED] Subject: Re:

[PHP-DB] Unable to load dynamic library - Access is denied.

2003-02-20 Thread Leonard Rutkowski
Hi, I am trying to get php version 4.3.0 to work with sybase. I am using Apache 2.0 on Win NT 4.0, service pack 6. I have been able to get PHP to work with the server, but not with Sybase. When I bring the server up, I get this message: PHP Warning: Unknown(): Unable to load dynamic library

[PHP-DB] Install Question

2003-02-20 Thread Robert J. Hanson
Has anyone used this option for compiling PHP with custom ODBC drivers. I am trying to use a Teradata ODBC driver and have not had any luck using iODBC. --with-custom-odbc[=DIR] Include a user defined ODBC support. The DIR is ODBC install base directory, which

[PHP-DB] Receiving ARRAY from Forms

2003-02-20 Thread Squirrel User
I tried the following code but all I get back is Array. I'm trying to pass a huge array. ? if( isset( $submit ) ) { echo array list:br; print_r( $eList ); $submit = ; } else { $mList = array(); $mList[0] = 1. hello; $mList[1] = 2. there;

[PHP-DB] Re: question in ADODB

2003-02-20 Thread pei_world
yes, but can you tell me how? I have read the manual, but they didn't tell how to do so! -- Sincerely your; pei_world ( .::IT::. ) Philippe Saladin [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I found the following code on the internet. I'd like to know

RE: [PHP-DB] Receiving ARRAY from Forms

2003-02-20 Thread Kelly Protsko
You could use sessions to pass the array to the next page easily. $_SESSION[arraylist] = $mList; Then just grab it back from the other form. If you haven't used sessions before you can get a quick overview here. http://www.theoutersphere.com/php/sessions.php Kelly -Original Message-

Re: [PHP-DB] Receiving ARRAY from Forms

2003-02-20 Thread 1LT John W. Holmes
I tried the following code but all I get back is Array. I'm trying to pass a huge array. You need to serialize the array... ? if( isset( $submit ) ) { echo array list:br; print_r( $eList ); $submit = ; } else { $mList = array(); $mList[0] = 1. hello; $mList[1] = 2. there;

Re: [PHP-DB] TimeStamp format to date

2003-02-20 Thread Mark
--- 1LT John W. Holmes [EMAIL PROTECTED] wrote: Cumprimentos What'd you call me? I think he's offering you a free minty freshmaker. = Mark Weinstock [EMAIL PROTECTED] *** You can't demand something as a right unless you are willing to fight to

RE: [PHP-DB] TimeStamp format to date

2003-02-20 Thread Hutchins, Richard
Dude, you just topped John! That was laugh-out-loud hilarious. Sorry this has gotten off-topic, but c'mon. A freshmaker? Classic, just classic. Rich -Original Message- From: Mark [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 12:09 PM To: [EMAIL PROTECTED] Subject: Re:

RE: [PHP-DB] TimeStamp format to date

2003-02-20 Thread Bruno Pereira
I'm portuguese, so i say bye in portuguese. If i want to call something you can be jure of one thing it wouldnt be cumprimentos. But i wouldnt do that, cause you help me :-) Cumprimentos(Till next time), is the same. Bruno Pereira [EMAIL PROTECTED] -Original Message- From: 1LT John

RE: [PHP-DB] TimeStamp format to date

2003-02-20 Thread Bruno Pereira
It's very good to see that a simple word cumprimentos can make a great discussion. :-) Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 20 de Fevereiro de 2003 17:09 To: [EMAIL PROTECTED] Subject:

[PHP-DB] Sybase timouts

2003-02-20 Thread Ryan Jameson (USA)
SQL error: [INTERSOLV][ODBC SQL Server driver][SQL Server]ct_connect(): user api layer: internal Client Library error: Read from the server has timed out., SQL state S1T00 in SQLConnect in Anyone had this problem? I cannot find anywhere that will allow me to change the timeout. Ryan Ryan

Re: [PHP-DB] Storing images in MySQL table

2003-02-20 Thread sumbry
The only disadvantage i've had of storing images in DB instead of Filesystem, is that when you use a PHP script to output the image to a client browser, MSIE doesn't always accept a suggested filename so it might try and save it as your-script.php?img=2. Other then that, keeping images in DB

RE: [PHP-DB] Sybase timouts

2003-02-20 Thread Ryan Jameson (USA)
Figured it out. it requires a default logon id on the connection tab on the odbc connection. Who knows why... Ryan -Original Message- From: Ryan Jameson (USA) Sent: Thursday, February 20, 2003 12:50 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Sybase timouts SQL error:

[PHP-DB] displaying hyperlinks in MySQL query results

2003-02-20 Thread Rick Tucker
I have some code that pulls data from a MySQL db and displays it in a 4-column HTML table. The headings are: Port # Transport Application Vendor URL The first 3 columns return perfectly. The Vendor URL data, on the other hand, is returned as text, rather than hyperlinks. I've tried tweaking

Re: [PHP-DB] LIMIT problem MSSQL

2003-02-20 Thread Matt Rogish
Also, since Sybase ASE uses a lot of the same T-SQL constructs, you can attempt some methods located here: http://www.isug.com/Sybase_FAQ/ASE/section6.2.html#6.2.12 -- Matt Noam Giladi [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... a solution offered i received

[PHP-DB] Re: displaying hyperlinks in MySQL query results

2003-02-20 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Rick Tucker) writes: [ snip ] The first 3 columns return perfectly. The Vendor URL data, on the other hand, is returned as text, rather than hyperlinks. I've tried tweaking the code several different ways with no success. The following code is what I started with. It

[PHP-DB] php/mysql query

2003-02-20 Thread Julie Keywell
Hi there! I am querying our database for 11,000 different zip codes and it seems to be overloading MySQL. However, common sense says it shouldn't. My question is: When needing to query 11,000 things, is it best to make 1 SQL statement that has 11,000 ors, or run through individual querys 11,000

RE: [PHP-DB] php/mysql query

2003-02-20 Thread Kelly Protsko
Well if the zip codes have something in common just do a pattern match for them or are you just picking random zip codes? This way you only need one one sql statement to bring everything back. Kelly -Original Message- From: Julie Keywell [mailto:[EMAIL PROTECTED]] Sent: February 20,

[PHP-DB] NotesSQL via ODBC in PHP

2003-02-20 Thread Stefan Haas
Has anybody tried to read/write a Lotus Notes Database via ODBC (NotesSQL)? I don't even get a valid connection with odbc_connect. With other tools (QTODBC) NotesSQL/ODBC is no problem at all. Anything wrong with the php ODBC driver in php 4.2.3 under Win2k? Are ther more reliable ODBC

[PHP-DB] Looking for a Junior PHP/mySQL programmer - Sydney.AU

2003-02-20 Thread Skeeve Stevens
Excuse the cross-post... We're looking for a Junior PHP/mySQL programmer in Seven Hills in Sydney.AU The position will be on a fulltime basis. We are a Broadband ISP dealing with Request Broadband and other providers. We are not looking for a super-qualified programmer as we are willing to