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

[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 like this :

[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] 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

[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

RE: [PHP-DB] Now not selecting enough

2002-12-18 Thread SELPH,JASON (HP-Richardson,ex1)
Try putting this: echo (h5A HREF=\minutes_detail.php?id=$id\$meetingdate/A/h5); 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

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 (h5A HREF=\minutes_detail.php?id=$id\$meetingdate/A/h5); in your while loop. Right now it is just popping out the last record.

[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

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

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

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: ?php for($i=0;$result;$i++) $table_names[$i] = $result[0]; echo 'A random table name: '.array_rand($table_names); ? dont forget, when you use a mysql_query(), it returns a result set

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

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) Pick

[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 =

[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] 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