[PHP-DB] recommendation needed for dedicated server hosting

2002-12-18 Thread Taek Kwon
Hi, I recently went through a horrendous experience with two different hosting providers. I'd like some recommendations on excellent hosting providers if anybody has some. My key priorities in order are: 1) around-the-clock, technically competent TELEPHONE support (webchat support, message boards

[PHP-DB] picture into mysql (file address)

2002-12-18 Thread Seabird
Hi everyone, I have been struggeling with this for some time know and don't know where it goes wrong. I want to upload pictures into a folder AND store their path into MySQL. I used a joe's auto tutorial but can't get it to work. All the information is put in correctly but not the picture. Please

[PHP-DB] Re: FW: Oracle connectivity question...

2002-12-18 Thread John 'zariok' Draughn
You'll need to verify that you have the tnsnames.ora file in $ORACLE_HOME/network/admin setup correctly. Example: /opt/oracle/product/9.2.0/network/admin/tnsnames.ora Some versions want 'SID' instead of 'SERVICE_NAME' in the 'CONNECT_DATA' Example: DB1 = (DESCRIPTION = (ADDRESS_LIST =

Re: [PHP-DB] How can I use PHP to duplicate a mysql templatedatabase? [hack] bug

2002-12-18 Thread Paul Burney
on 12/17/02 6:20 PM, Daevid Vincent at [EMAIL PROTECTED] appended the following bits to my mbox: > This method copies the data, but doesn't copy 'Extra' stuff like > "auto_increment". I've used the following before: SHOW CREATE TABLE $tablename You could probably do something like this. 1) Pic

RE: [PHP-DB] keyword search a mysql database.

2002-12-18 Thread John W. Holmes
FULL TEXT index? http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html #Fulltext_Search ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ > -Original Message- > From: mike karthauser [mailto:[EM

RE: [PHP-DB] random rows...what about tables

2002-12-18 Thread Matthew Moldvan
to get all the table names, then return a random table name, try the following: dont forget, when you use a mysql_query(), it returns a result set with more than one value for each row returned. ie, $array[$i] could be anything from the table name to its size to its whatever ... Regards, Ma

RE: [PHP-DB] pictures into MySQL

2002-12-18 Thread Matthew Moldvan
I'm not completely sure of the implementation details, but look into the BLOB data type. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#BLO B Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc http://

Re: [PHP-DB] keyword search a mysql database.

2002-12-18 Thread Adam Voigt
$searchstring = $_POST[searchfor]; $searchstring = str_replace(" ","%",$searchstring); mssql_query("SELECT id FROM table WHERE field LIKE '$searchstring';"); This will give you a looser search where all search terms have to be there, but not necessarily next to each other, if you want a

[PHP-DB] keyword search a mysql database.

2002-12-18 Thread mike karthauser
I'm looking for tips and tricks in how to approach building a keyword search over an number of fields in a courses database. I know how i can search for one word at a time, but i am not sure on how i would approach searching via a defined string. Anyone got any good pointers for doing this/ or so

Re: [PHP-DB] Now not selecting enough

2002-12-18 Thread Alex Francis
That was quick - Works alright now thank you "Jason Selph" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Try putting this: > echo ("$meetingdate"); > > in your while loop. Right now it is just popping out the last record. > > Cheers > Jason > > > -Original

RE: [PHP-DB] FW: Oracle connectivity question...

2002-12-18 Thread Ryan Jameson (USA)
Yeah, on the server you should be able to type tnsping and your tnsname to make sure it is configured correctly. <>< Ryan -Original Message- From: Andrey Hristov [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:05 AM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: R

Re: [PHP-DB] FW: Oracle connectivity question...

2002-12-18 Thread Andrey Hristov
Hey, A friend of mine told me that : kalo 19:02: trjanbva ti tnsping vdb.masq kalo 19:02: uf.. ne znam kak ce nastrojva tnslistaner-a..;( kalo 19:03: ima si programa s kojato se pipat nastraojkite na TNSListener-a kalo 19:03: ina4e ne mozesh ada se zaka4ish.. Translared to english : 19:02

RE: [PHP-DB] Now not selecting enough

2002-12-18 Thread SELPH,JASON (HP-Richardson,ex1)
Try putting this: echo ("$meetingdate"); in your while loop. Right now it is just popping out the last record. Cheers Jason -Original Message- From: Alex Francis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:00 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Now not selec

RE: [PHP-DB] Now not selecting enough

2002-12-18 Thread Ryan Jameson (USA)
Your echo needs to be in the while loop... <>< Ryan -Original Message- From: Alex Francis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:00 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Now not selecting enough I am using the following script which I have used with minor v

[PHP-DB] Now not selecting enough

2002-12-18 Thread Alex Francis
I am using the following script which I have used with minor variations, several times before without any trouble. I have 3 items in my database but the script only returns 1. I can change which one by leaving off the order by filter, but can't get all three. Where am I going wrong. (PHP and MySQL)

[PHP-DB] FW: Oracle connectivity question...

2002-12-18 Thread NIPP, SCOTT V (SBCSI)
More information on the problem... I tried including the SID in the OCILogon function and think that I may have gotten a bit further, but still not a successful logon. Here is the error I am now receiving with the SID: Warning: _oci_open_server: ORA-12154: TNS:could not resolve service n

[PHP-DB] Oracle connectivity question...

2002-12-18 Thread NIPP, SCOTT V (SBCSI)
OK. I think I now have Oracle support built into PHP/Apache. The biggest hiccup for HP-UX seems to be that once you add Oracle support to PHP, you CANNOT built PHP as a DSO, PHP MUST be compiled into Apache. Once again, I think this is the case, I am still not completely sure at this poi

[PHP-DB] Help with connecting PHP/MySQL to MS Outlook

2002-12-18 Thread Chris Streeter
Does anyone know of a way to retrieve MS Outlook data via PHP? I am creating an intrant for my company and want to grab data from the MS Oulook contact list on the server to using in my PHP/MySQL intranet project. Any help would be most appreciated. Thank you! Chris Streeter Bethlehem, PA USA

[PHP-DB] Re: problem with PHP+flash programming

2002-12-18 Thread Radovan Radic
"Hermanto Kurniawan" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > i have a problem with this flash actionscript : > loadVariablesNum > ("GuestBook.php?NumLow="+NumLow+"&NumHigh="+NumHigh+"&R="+random(999), 0); > > when i run this script i got an error message

RE: [PHP-DB] My question in precise reg PHP and relational tables.

2002-12-18 Thread SELPH,JASON (HP-Richardson,ex1)
Yes, you can do something like this: // setup connection variables to access your database $connection = mysql_connect(HOST, USER, PASS); //select your database mysql_select_db(DB); //prep query to get all the categories $sql = "SELECT * FROM category ORDER BY number ASC"; // prep your array $s

[PHP-DB] Connect Time with Interbase

2002-12-18 Thread Andreas Steibl
Is it possible to minimize the time which PHP needs to connect to the Interbase server ? The problem is that for every page which need the Database, it needs about 1-2 seconds for connecting to the interbase (i use allready pconnect) But everytime the script ends, the connection is closed to the DB