[PHP-DB] PHP && MySQL: temporary table problem

Hi. I got a task to program a search engine for a site which is all around based on sessions and persistent connections to MySQL. The problem is that I first have to select a subset of those data and then I have to join them all around and output results. I'm using temporary tables for this but

Re: [PHP-DB] Array trouble

On Friday 24 January 2003 14:18, Tyler Whitesides wrote: > I have been having a lot of trouble getting an array into the MySQL table > like I want it. This is supposed to take the current maintenance tasks > from a table in the database on apple.php each of these is given a name > $item[autoNo] w

RE: [PHP-DB] PHP && MySQL: temporary table problem

I would like to know, if there is any change to export/import data from SQL/EXCEL/SQL with php??? It?s very important. So if someone knows a way please help me. Thanks. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: Damir Dezeljin [mailto:[EMAIL PROTECTED]] Sent: s

[PHP-DB] Import and export data from php/mysql

I would like to know, if there is any change to export/import data from MySQL/EXCEL/MySQL with php??? It's very important. So if someone knows a way please help me. Thanks. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: ht

Re: [PHP-DB] Where can I get an extention to connect to PostgeSQLDB on Unix?

I will give you some tips: * With phpinfo verify that you have included the module in the configuration. Something like --with-pgsql=shared * In php.ini enable extension=pgsql.so * In php.ini, search extension_dir, and in that location (normaly /usr/lib/php4) copy the module (archive) pgsql.so.

Re: [PHP-DB] Import and export data from php/mysql

What is your problem exactly? Have you investigated the MySQL manual under: LOAD DATA INFILE SELECT ... INTO OUTFILE ? Ignatius - Original Message - From: "Bruno Pereira" <[EMAIL PROTECTED]> To: "PHP-db list" <[EMAIL PROTECTED]> Sent: Friday, J

RE: [PHP-DB] PHP && MySQL: temporary table problem

Hi. > I would like to know, if there is any change to export/import data from > SQL/EXCEL/SQL with php??? It?s very important. So if someone knows a way > please help me. HeHe ... I don't know how this is related to my question, but. To import directly in Excel from MySQL, you can use MyODBC (I s

Re: [PHP-DB] Where can I get an extention to connect to PostgeSQL DB on Unix?

Where can I get thid module - pgsql.so??? "Alberto grájeda c." <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I will give you some tips: > * With phpinfo verify that you have included the module in the > configuration. Something like --with-pgsql=shared > * I

RE: [PHP-DB] ms sql limit equivalence

Thanks! I was going to write and say that I have been using ADODB but was unable to make the SelectLimit function work using MS SQL, but I decided to take a look at my setup one more time. I have setup my own abstraction layer on top of ADODB so that I can override some of the default functions an

Re: [PHP-DB] Where can I get an extention to connect to PostgeSQLDB on Unix?

Search internet the module for your architecture. You have the name of the archive and you know the architecture running php. On Fri, 24 Jan 2003, Yurij Nykon wrote: > Where can I get thid module - pgsql.so??? > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] function needed

Hey I'm looking and wondering for a function, as i'm trying to do something, and here it is. I'm using the SSI call : . to get the domain name I am on. this will output www.domain.com. I would like to use PHP in order to take this string, the output, and cut the "www." and the ".com" from it,

RE: [PHP-DB] function needed

Try searching www.phpclasses.org. I'm almost positive it's been written before and if it exists, this is a great place to start looking for it. > -Original Message- > From: Shahar Tal [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 24, 2003 12:45 PM > To: [EMAIL PROTECTED] > Subject: [P

Re: [PHP-DB] function needed

--- Shahar Tal <[EMAIL PROTECTED]> wrote: > Hey > > I'm looking and wondering for a function, as i'm trying to do > something, and > here it is. > > I'm using the SSI call : > . > to get the domain name I am on. this will output > > www.domain.com. > > I would like to use PHP in order to take

Re: [PHP-DB] function needed

Hi! I hope I understood you right... I would use PCREs: .ma Shahar Tal <[EMAIL PROTECTED]> [EMAIL PROTECTED] 18:44 Uhr: > Hey > > I'm looking and wondering for a function, as i'm trying to do something, and > here it is. > > I'm using the SSI call : > . > to get the domain name I am on. th

RE: [PHP-DB] function needed

There we go. This one also parses .co.uk, which frustrated me there for a minute, but oh well, I'm over it. I don't believe there are any others that will slip by this, but of course I can't be certain. Give it a shot, see if it does what you need. I tested it with: Print stripdomain("this.w

Re: [PHP-DB] function needed

You could also use this: function getdomainname($name) { $parts = explode('.',$name); return $parts[count($parts)-2]; } which will always return the second to last section when divided up by the periods. So it will return 'domain' for all of the following: www.domain.com www.subdomain.do

[PHP-DB] simple mail attachment with php?

hi you out there... i hope you're all fine :) has anybody an idea how to attach a simple text-file to the php mail()-function??? the scripts i found on the net are quite complicated, featuring different mime-types, more than one attachment,... i really would need just the absolute basic functiona

Re: [PHP-DB] function needed

But what about www.domain.co.uk, you ask? Well, it'll fail with this. :) Just filter out the 'co.' like the other function that was posted and this will still work. ---John Holmes... - Original Message - From: "1LT John W. Holmes" <[EMAIL PROTECTED]> To: "heilo" <[EMAIL PROTECTED]>; <[EM

RE: [PHP-DB] function needed

Well I lost the race as well, because I failed to account for .com.br, or .com.at, or any of those other rarely used ones. Bah... ___ Ryan Marrs Web Developer Sandler & Travis Trade Advisory Services, Inc. 248.474.7200 x 183 248.474.8500 (fax) www.strtrade.com --

[PHP-DB] Basic HTTP authentication

hi GUys Please this may sound too elementary but I need your help. How can I configure apache httpd.con file in order to support the use of Basic HTTP authentication. I am using apache 1.3.26 on windows. Thanks - Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affor

[PHP-DB] Basic HTTP authentication

hi GUys Please this may sound too elementary but I need your help. How can I configure apache httpd.con file in order to support the use of Basic HTTP authentication. I am using apache 1.3.26 on windows. Thanks - Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affor

[PHP-DB] SQL very fast here & very slow there

I have realized a php web page with this "heavy" SQL query, necessary to show a list of students: $sqlcom = "SELECT Alunni.Cod_Alunno, Nome, Cognome, Scritto, Orale, Assenze FROM Alunni, Scrutini, Iscritti WHERE Alunni.Cod_Alunno = Scrutini.Alunno AND Scrutini.Alunno = Iscritti.Cod_Alunno AND

Re: [PHP-DB] SQL very fast here & very slow there

I'm not sure how Paradox works, but it may be locking problems you are running into. I know Paradox used to have issues with data changing while a query was executing. On your home machine you are the only one accessing the DB, so there wouldn't be any contention. Your home DB probably hits the

[PHP-DB] Re: function needed

Hi! This shouid be good: short, nice and it's work good :) - Original Message - From: "Shahar Tal" <[EMAIL PROTECTED]> Newsgroups: php.db To: <[EMAIL PROTECTED]> Sent: Friday, January 24, 2003 6:44 PM Subject: function needed > Hey > > I'm looking and wondering for a function, as i'm

[PHP-DB] Uploading and displaying Jpeg images through Path reference /text from mysql

Hello There, I wondered if any one could help me with this problem. I am helping a friend with his web site which is a content management system. to tell you the truth i am a beginner in Php/Mysql and this is my first experience. The table is called REPORT and it has a Field for REPORT_Title anothe

Re: [PHP-DB] Basic HTTP authentication

On Fri, Jan 24, 2003 at 11:50:09AM -0800, web man wrote: >hi GUys >Please this may sound too elementary but >I need your help. >How can I configure apache httpd.con file in >order to support the use of Basic HTTP authentication. >I am using apache 1.3.26 on windows. Take a look at the Apache man

[PHP-DB] sql query links

i'm starting out in this whole thing, and i'm trying to program a zine that uses a sql database for content and calls the content into a template. what i am unclear on how to do is set up the links so that I can get the info from the database. anyone willing to help me out? -- PHP Database Ma

[PHP-DB] Calling functions recursively

Can functions / methods be called recursively? If so how can this be done? Comments much appreciated. Kevin Gordon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Calling functions recursively

Kevin, Have fun and be sure to guarantee the prevent never ending looping. Roberto Counting to ten: $aCounter\n"; $aCounter++; RecursiveFunction($aCounter); } } ?> - Original Message - From: "Kevin Gordon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 25, 2