[PHP-DB] Re: [Newbie] Can't get MySQL working with PHP 4 under Apache 2

2002-11-07 Thread Tjoumaidis
I had the same problem until i found out that the distribution itself did not installed the required package php-mysql.rpm. Find it in one of the cd's and install it. Matt Symes wrote: Hello, I've got PHP 4 working under Apache 2 on Linux Redhat 8 using the packages that came with the Redhat 8 i

[PHP-DB] Re: How do I list Oracle table names

2002-11-07 Thread Philippe Saladin
<[EMAIL PROTECTED]> a écrit dans le message news: [EMAIL PROTECTED] > I'm very new at this. Is there a way I can list all table names in an Oracle database? I thinl you know how to connect to Oracle via php (simple tutorial : http://www.thickbook.com/extra/php_oracle.phtml) To obtain a list of t

Re: [PHP-DB] Polls?

2002-11-07 Thread Leif K-Brooks
Thanks, but my problem is how to efficiently display a page with all of the polls with results. Also, I need a variable number of questions, which that tutorial doesn't provide. Thanks, though. Ignatius Reilly wrote: One possibility: table questions( questionID, question_text, ...) PRIMARY K

Re: [PHP-DB] Polls?

2002-11-07 Thread Ignatius Reilly
One possibility: table questions( questionID, question_text, ...) PRIMARY KEY( questionID) table answers( FK_questionID, individualID, answer_code, ...) PRIMARY KEY( FK_questionID, individualID) For very simple online polls, there is a nice tutorial in Devshed: http://www.devshed.com/Server_Side

[PHP-DB] Polls?

2002-11-07 Thread Leif K-Brooks
I'm working on a polling system, and I'm having a bit of a problem. I'm not sure how to store the questions. Storing them in a seperate table would require a query for each poll displayed - not good. I've also thought of storing them as a serialized array. Any thoughts on this? -- The above

Re: [PHP-DB] OCIBindByName with Oracle 8i17 problem ?!

2002-11-07 Thread Fabien JOSEPH
Thies C. Arntzen wrote: On Mon, Nov 04, 2002 at 06:16:04PM +0100, Fabien JOSEPH wrote: I discovered recently that it was impossible to bind an output placeholder plsql (an input work only). Configuration 1 : Suse + Oracle 8i17 + oci (oracle) + PHP4.2.3 Configuration 2 : HPUX11 + Oracle 8i17 +

Re: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutorialrequest

2002-11-07 Thread Peter Beckman
1. learn how to do a file upload in PHP: http://www.php.net/manual/en/features.file-upload.php 2. Process the CSV file line by line in a loop. Not posting your CSV file format, I can only guess that it will be in proper form. If so: for loop { $csvline = '"column1","column2","column3

RE: [PHP-DB] addition to uploading

2002-11-07 Thread Peter Beckman
Yep. http://www.php.net/manual/en/function.mail.php mail("[EMAIL PROTECTED]","Subject goes Here","Body of message and all that"); Peter On Thu, 7 Nov 2002, Ryan Holowaychuk wrote: > How can I get the php page to email me after it has done and upload > successfully. > > Do I use the mail()?? >

RE: [PHP-DB] addition to uploading

2002-11-07 Thread Ryan Holowaychuk
How can I get the php page to email me after it has done and upload successfully. Do I use the mail()?? any thoughts Thanks [Ryan Holowaychuk] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How to list Oracle table names

2002-11-07 Thread smdief
I'm very new at this. Can I list all the table names in an Oracle database? Sign Up for Juno Platinum Internet Access Today Only $9.95 per month! Visit www.juno.com -- PHP Database Mailing List (http://www.php.net/) To unsu

[PHP-DB] How do I list Oracle table names

2002-11-07 Thread smdief
I'm very new at this. Is there a way I can list all table names in an Oracle database? Sign Up for Juno Platinum Internet Access Today Only $9.95 per month! Visit www.juno.com -- PHP Database Mailing List (http://www.php.ne

Re: [PHP-DB] Argh!!!! Help with something o-f-f-t-o-p-i-c

2002-11-07 Thread .: B i g D o g :.
You need to get the element by name and then do the confirmation... On Thu, 2002-11-07 at 21:23, Aaron Wolski wrote: > Sorry for the OT post y'all.. but I can't find this answer - well not > without major major code information that I can't figure out! > > Basic? > > I have a series of check

Re: [PHP-DB] Argh!!!! Help with something o-f-f-t-o-p-i-c

2002-11-07 Thread Marco Tabini
Can you not filter the checkboxes by name? Just add one more condition to the if statement: if (el.type == 'checkbox' && el.checked && el.name != 'theothercheckbox') etc. Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to

RE: [PHP-DB] Argh!!!! Help with something o-f-f-t-o-p-i-c

2002-11-07 Thread Josh Johnson
Check out www.devguru.com, they have a great javascript refrence Otherwise I have no idea :) -- Josh -Original Message- From: Aaron Wolski [mailto:aaronjw@;martekbiz.com] Sent: Thursday, November 07, 2002 4:23 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Argh Help with something o-f-f-

[PHP-DB] Argh!!!! Help with something o-f-f-t-o-p-i-c

2002-11-07 Thread Aaron Wolski
Sorry for the OT post y'all.. but I can't find this answer - well not without major major code information that I can't figure out! Basic? I have a series of checkbox arrays like: These are for different records in my DB. Now... I want to check (javascript - this is the off topic part

Re: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria

2002-11-07 Thread Chris Boget
> Is Load-Data possible in mssql? I'm unsure but the original poster was asking about mysql. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria

2002-11-07 Thread Anderson, Jerrad
Is Load-Data possible in mssql? -Original Message- From: Chris Boget [mailto:chris@;wild.net] Sent: Thursday, November 07, 2002 2:48 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: kristina; [EMAIL PROTECTED] Subject: Re: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria > Bas

Re: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria

2002-11-07 Thread Chris Boget
> Basically, you would have to receive a CSV data to then pass it to the > mysql via command prompt, just as if you would do it via shell. You > should be using mysqlimport in shell. So, in PHP you'd get to use system > command to accomplish this all automatically. Be aware of some security > issue

Re: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria

2002-11-07 Thread Maxim Maletsky
Basically, you would have to receive a CSV data to then pass it to the mysql via command prompt, just as if you would do it via shell. You should be using mysqlimport in shell. So, in PHP you'd get to use system command to accomplish this all automatically. Be aware of some security issues. -- Ma

Re: [PHP-DB] session variables

2002-11-07 Thread Maxim Maletsky
"kevin myers" <[EMAIL PROTECTED]> wrote... : > I have a question: > I have a site, http://www.darkrpg.ionichost.com, and > htp://www.mail.ionichost.com. I'm trying to find a way of passing the > session varible from darkrpg to mail that way they need not log in again. > Is it possiable with

Re: [PHP-DB] Structure Question...

2002-11-07 Thread Brent Baisley
You would want 2 & 3. You should create 3 tables, one for products, one for categories and one to relate the two. You should only store ID numbers that relate to products and categories. On Thursday, November 7, 2002, at 01:51 PM, Doug Coning wrote: Hi everyone, I'd like to know how you would

RE: [PHP-DB] Warning message

2002-11-07 Thread Anderson, Jerrad
Logging them may work better. Thank you -Original Message- From: Pierre-Alain Joye [mailto:paj@;pearfr.org] Sent: Thursday, November 07, 2002 1:41 PM To: Anderson, Jerrad Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Warning message On Thu, 7 Nov 2002 13:37:49 -0500 "Anderson, Jerrad" <[EM

[PHP-DB] session variables

2002-11-07 Thread kevin myers
I have a question: I have a site, http://www.darkrpg.ionichost.com, and htp://www.mail.ionichost.com. I'm trying to find a way of passing the session varible from darkrpg to mail that way they need not log in again. Is it possiable with out cookies? And another question i have is on http://w

Re: [PHP-DB] Warning message

2002-11-07 Thread Pierre-Alain Joye
On Thu, 7 Nov 2002 13:37:49 -0500 "Anderson, Jerrad" <[EMAIL PROTECTED]> wrote: > I'm using PHP on apache that's sitting on a Windows 2k server. When I > don't define a variable i'm getting a warning message on the screen.. > anyway to suppress these errors? > > > Warning: Undefined variable: ya

RE: [PHP-DB] Warning message

2002-11-07 Thread Anderson, Jerrad
I'm using PHP on apache that's sitting on a Windows 2k server. When I don't define a variable i'm getting a warning message on the screen.. anyway to suppress these errors? Warning: Undefined variable: yaddayaddaydaadda thanks for any info jerrad -- PHP Database Mailing List (http://www.php.n

Re: [PHP-DB] Structure Question...

2002-11-07 Thread Miles Thompson
Third choice, definitely. And aren't you glad your data is sufficiently normalized that this is a no-brainer! Cheers - Miles Thompson At 12:51 PM 11/7/2002 -0600, Doug Coning wrote: Hi everyone, I'd like to know how you would set up the following: I've set up a MySQL database with 600 products

Re: [PHP-DB] Structure Question...

2002-11-07 Thread Ignatius Reilly
You have to create a table: CREATE TABLE product_categ ( FK_productID , FK_categID ) and list all relationships "productID belongs to categID" Ignatius - Original Message - From: "Doug Coning" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: T

[PHP-DB] Structure Question...

2002-11-07 Thread Doug Coning
Hi everyone, I'd like to know how you would set up the following: I've set up a MySQL database with 600 products. I set it up where each product belongs to a category. However, now we want to take it further where different products can now belong to more than 1 category. How would you create

Re: [PHP-DB] oci function

2002-11-07 Thread Maxim Maletsky
you need to compile it with oci8 extension: http://uk.php.net/manual/it/ref.oci8.php -- Maxim Maletsky [EMAIL PROTECTED] "Maziar" <[EMAIL PROTECTED]> wrote... : > Hi everybody > > What should I do for useing OCI functions of oracle 9i in PHP4. I think I > should recompile PHP with somthing

Re: [PHP-DB] first Array value duplicating..

2002-11-07 Thread Adam Voigt
Ok, here's how I do it: =) Delete checkbox's (assuming this is being called recursively, once for each row in the db): And on submition: foreach($_POST[delete] AS $row) mysql_query("DELETE FROM tablename WHERE id = '$row';"); Adam Voigt [EMAIL PROTECTED] > > Hi All, > > > > > > In a

Re: [PHP-DB] first Array value duplicating..

2002-11-07 Thread Terry Romine
An "Real World" example of how I do a similar thing might help: My list with checkboxes (since this is dynamic, I don't know what numbers are assigned) $itemID is the id of the record from the mysql table, so the check box name is 'chk_12' for id=12. $checkAll is a flag if the user selected the

RE: [PHP-DB] calling sql script

2002-11-07 Thread Adam Voigt
Well, either use PHPMyAdmin, or if this is a recursive thing like, you need to have this done one the fly, and you have shell (SSH) access to your host, connect your host and do "which mysql" in the console and this will probably give you the path. Adam Voigt [EMAIL PROTECTED] On Thu, 2002-11-07

RE: [PHP-DB] calling sql script

2002-11-07 Thread Edward Peloke
But I am not sure where my hosting companies mysql is so I do not know the path -Original Message- From: Marco Tabini [mailto:marcot@;inicode.com] Sent: Thursday, November 07, 2002 11:31 AM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] calling sql script You can use e

Re: [PHP-DB] calling sql script

2002-11-07 Thread Marco Tabini
You can use exec http://ca.php.net/manual/en/ref.exec.php You will probably need to call the mysql shell like so: /path_to_mysql/mysql -u user -p password [-h host] -D database -e \\. filename Marco -- php|architect - The magazine for PHP Professionals The first monthly worldwide

RE: [PHP-DB] calling sql script

2002-11-07 Thread Anderson, Jerrad
http://www.phpbuilder.com/manual/function.exec.php -Original Message- From: Edward Peloke [mailto:epeloke@;echoman.com] Sent: Thursday, November 07, 2002 12:02 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] calling sql script I need to use a php page to run an .sql script against a mysql db.

RE: [PHP-DB] calling sql script

2002-11-07 Thread Anderson, Jerrad
There is a shell command I remember reading on phpbuilder.com. do a quick search. .. I believe it is exec -Original Message- From: Edward Peloke [mailto:epeloke@;echoman.com] Sent: Thursday, November 07, 2002 12:02 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] calling sql script I need to

[PHP-DB] calling sql script

2002-11-07 Thread Edward Peloke
I need to use a php page to run an .sql script against a mysql db. How do I simply call the script from php? I can take parts of it and execute the statements but I would like to just call the entire script. Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visi

Re: [PHP-DB] first Array value duplicating..

2002-11-07 Thread .: B i g D o g :.
I would suggest doing a var_dump of $order_index and see what is in there. Plus, you should take out the values in the form arrays... Just do: name="order_index[]" On Thu, 2002-11-07 at 15:24, Aaron Wolski wrote: > Hi All, > > > In a form I have checkboxes associated with order records. The

Re: [PHP-DB] oci functions

2002-11-07 Thread .: B i g D o g :.
Compile php with the OCI configuration option. That will work with oracle9i. On Thu, 2002-11-07 at 08:32, Maziar wrote: > Hi everybody > > What should I do for useing OCI functions of oracle 9i in PHP4. I think I > should recompile PHP with somthing but I don't know with what and how should > I

[PHP-DB] regular expression and exact word search...

2002-11-07 Thread BAROILLER Pierre-Emmanuel
Hi! does someone know how to find an exact word in a content with html tags ? I'm using a regexp like this : $searchRegEx = "'\b".$word_search."\b'msi"; to get boundary word results, but... if the searched word is like 'word or word. or anything else, the regular expression doesn't work.. if I

[PHP-DB] first Array value duplicating..

2002-11-07 Thread Aaron Wolski
Hi All, In a form I have checkboxes associated with order records. The checkboxes are for deleting order records (should a client choose to do so). It looks like this: Now.. when the process button is pressed the information is carried off to the

[PHP-DB] [Newbie] Can't get MySQL working with PHP 4 under Apache 2

2002-11-07 Thread Matt Symes
Hello, I've got PHP 4 working under Apache 2 on Linux Redhat 8 using the packages that came with the Redhat 8 installation. I can't get PHP to work with MySQL however. myphpadmin says that it cannot load the MySQL extension. When I check my PHP settings with phpinfo I see that it was compiled wit

Re: [PHP-DB] MySQL password protection?

2002-11-07 Thread Adam Voigt
Make the include file (or wherever your page with the pass is) encrypted, see ioncube.com they charge by the amount of code you incrypt, for a simple database include file, I think it would be $1 or less. On Wed, 2002-11-06 at 16:04, William Trappeniers wrote: > Hi all > > I was wondering if it i

RE: [PHP-DB] sort by date

2002-11-07 Thread Josh Johnson
It's also a matter of time, I think a lot of people try to be the first to answer something, or are answering from work on a busy day... they just don't have time to write explanations, or to RTFM themselves to verify (I'm guilty of this one), but they want to help. This is especially frustrating w

RE: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria

2002-11-07 Thread Ruprecht Helms
Hi kristina, >[...] I can see that phpMyAdmin does this, > which is great but I > need it for joe public to be able to > use. so I don't > want them using phpMyAdmin. If you can't use phpMyAdmin try to make it with SQL-Import or a similar function. For mysql you have documentation under

RE: [PHP-DB] Archiving A Database

2002-11-07 Thread Josh Johnson
Thanks Peter! It turns out the people I work for don't care at all about this data, they were only using it to push clients to buy bigger packages and for bragging rights, so grand totals/totals per client/per period are all they need, the extra data I was logging *just in case* is totally useless

[PHP-DB] [Newbie Q] csv file upload via php to mysql tutorial request

2002-11-07 Thread kristina
Hello listers I am a complete newbie at this and I have searched for anything that could help me understand this, but I've had no luck. My reason for emailing is this - I want to know how to upload a csv file via php to a mysql database. I have found a few examples but they are all m

[PHP-DB] oci functions

2002-11-07 Thread Maziar
Hi everybody What should I do for useing OCI functions of oracle 9i in PHP4. I think I should recompile PHP with somthing but I don't know with what and how should I do this. I installed oracle 9i on SUSE linux 8.0. Best Regards Maizar -- PHP Database Mailing List (http://www.php.net/) To un