[PHP-DB] Apache HTTP Server has encountered a problem and needs to close

2008-11-12 Thread S, Murgesan (GE, Corporate, consultant)
Hi, I have posted an error in http://bugs.php.net/?id=46519 Please help me to resolve it. Thanks Regards, Murugesan.S, TCS Consultant, GE Corporate DC:0809-0246 Mobile:+91-9920185048

[PHP-DB] ? SELECT TABLE Command

2007-09-10 Thread Alec S.
Hi, I've got a PHP program I wrote a year or so ago with the oddest line of code. I know I didn't come up with it myself; I must have adapted it from a book or something, but I have checked all the books it could have come from and could not find it in any of them, nor can I find any such

[PHP-DB] Assertion failed: LDAP_VALID( ld ), file getentry.c

2007-06-14 Thread Sujay S A
*** DISCLAIMER: This email and any files transmitted with it are privileged and confidential information and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, please notify the sender by e-mail and delete the original

[PHP-DB] PHP and DBISAM

2007-02-14 Thread Markus S�lkner
Hi! Is there a possibility to use php with a dbisam db? We use a programm based on a dbisam db and we have to use php to enter data in to this db. Best regards markus sölkner :mediasoft kurz kg au 16 a-8783 gaishorn am see fax.: +43 (0) 3617/2691-2 mobil: +43 (0) 676/84 21 65 205 e-mail:

[PHP-DB] X Tiger 10.4.5 + phpBB2 + MySQL 5 + Can't Connect Issue!

2006-03-06 Thread m i l e s
? Anyone ? Buehler ? Buehler Thanks ahead of time M i l e s. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] X Tiger 10.4.5 + phpBB2 + MySQL 5 + Can't Connect Issue! - SOLVED!

2006-03-06 Thread m i l e s
Hi, Figured it out: Apple wiped out the location of the socket. they wanted '/var/mysql/mysql.sock' it should be: '/tmp/mysql.sock' Problem solved. M i l e s. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] novice on table design

2005-05-14 Thread Tony S. Wu
depending on which type an entry is. but with this approach, you can easily associate with an address table. Tony S. Wu [EMAIL PROTECTED] On May 14, 2005, at 4:49 AM, tony yau wrote: Hi Miguel, Thanks for the reply. the non-customer is actually a Shop, so Employee, Customer and Shop

[PHP-DB] How to process a query form with CHECKBOX Please help

2004-12-27 Thread S Kumar
Dear group, I am a novice programmer started doing php to process a query form of my patients. I have a database and one table in it deals with my patient information. Depending on their condition I divided their age groups into 3 categories. In my database a table patient_data has a column

Re: [PHP-DB] Filling Drop-Down Box.

2004-12-25 Thread Mike S.
at: http://www.netmask.com/php-db/sample-dropdown.html Good luck! :Mike S. :Austin TX USA -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] what is wrong with my code.. please help

2004-12-25 Thread S Kumar
Dear group, I am trying to query my db and print the results. when i execute my script, i am not getting any result except a blank page. can any one please help me what is going wrong with my script. Script: $conn = pg_connect(user = $user dbname = $dbname host = $host password = $pass); if

Re: [PHP-DB] data is not entering in created database

2004-12-24 Thread Mike S.
saying. Good luck. :Mike S. :Austin TX USA -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP on an Windows intranet with MSOffice-like templates

2004-11-17 Thread Ricardo J. S. Oliveira
You're welcome... Best regards, Ricardo Oliveira ---Original Message--- From: [EMAIL PROTECTED] Date: 11/17/04 00:02:48 To: Ricardo J. S. Oliveira Subject: Re: [PHP-DB] PHP on an Windows intranet with MSOffice-like templates You're my hero. Thanks! -P Quoting "Ricardo

[PHP-DB] -14 Days Ago

2004-10-08 Thread Cole S. Ashcraft
I am trying to see whether a data in an array pulled from a MySQL DB (YEARMONTHDATE) is older than 14 days ago. I am trying to do this in PHP. My code looks like: if($array['due'] = $today - 14) { echo h5Assignment In Void:/h5brh4Assignments in the void are read-only; require('footer.php');

Re: [PHP-DB] -14 Days Ago

2004-10-08 Thread Cole S. Ashcraft
I needto do it in PHP, though. Cole Wendell Frohwein wrote: You can trying using the MySQL DATE_ADD() , DATE_SUB , and NOW() functions. -wendell frohwein -Original Message- From: Cole S. Ashcraft [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 11:36 AM To: [EMAIL PROTECTED

Re: [PHP-DB] -14 Days Ago

2004-10-08 Thread Cole S. Ashcraft
- From: Cole S. Ashcraft [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 2:36 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] -14 Days Ago I am trying to see whether a data in an array pulled from a MySQL DB (YEARMONTHDATE) is older than 14 days ago. I am trying to do this in PHP. My code

Re: [PHP-DB] Error with addition of second

2004-09-18 Thread Cole S. Ashcraft
It doesn't like the }; On Sat, 2004-09-18 at 19:04, Mark wrote: --- [EMAIL PROTECTED] wrote: Dear friends, With 4 radio buttons and php snippet, it gives desired output, however when I add second question in the html form and variable for the same like $variable =$_POST['q'] in

[PHP-DB] select query across multiple tables

2004-08-26 Thread Cole S. Ashcraft
I'm trying to pull all the records from the table class where classID is not equal to the value of classID in the table assignment. Currently, I have 'select class.classID, class.classDesc from class, assignment where assignment.classID = class.classID and assignment.assignmentID=$assidn'.

Re: [PHP-DB] select query across multiple tables

2004-08-26 Thread Cole S. Ashcraft
Thanks! It works Cole On Thu, 2004-08-26 at 16:45, [EMAIL PROTECTED] wrote: I'm trying to pull all the records from the table class where classID is not equal to the value of classID in the table assignment. Currently, I have 'select class.classID, class.classDesc from class,

[PHP-DB] Bogus List Messages

2004-07-19 Thread Cole S. Ashcraft
Are the messages with the subject line IMPORTANT: Please Verify Your Message bogus? They do not come from the ezmlm mailer at lists.php.net. They do not have the [PHP-DB] prefix. Have the owners of the list requested this? Cole -- This message has been scanned for viruses and dangerous content

[PHP-DB] Not Like

2004-07-18 Thread Cole S. Ashcraft
I am trying to figure out how to display something where the condition is not like im a MySQL query. The query is select * from class where classID like '_00'order by classID; How would I make the like into a not like (aka negating it. The ! does not work)? I couldn't find anything in the MySQL

Re: [PHP-DB] Mysql 5.0 Redhat

2004-07-02 Thread Cole S. Ashcraft
You need to compile PHP with MySQL support. There is a php-mysql.rpm package, but I'm not sure if it will work with MySQL 5. You might just have to recompile PHP (but probably not). Cole Iain Wiseman wrote: Cole S. Ashcraft wrote: They are at http://dev.mysql.com/downloads/mysql/5.0.html. Iain

Re: [PHP-DB] How to take Backup ?

2004-07-01 Thread Cole S. Ashcraft
Try the mysqldump command zareef ahmed wrote: Hi, If you have phpmyadmin on your system you can export all your data in sql format which can be restore again by running that sql script. make sure to check complete insert checkbox at time of export operations. Revert Back with any comment or

Re: [PHP-DB] Call to undefined function mysql_connect()

2004-06-30 Thread Cole S. Ashcraft
Rinku's Response: I may be missing something, but hows that related? The phpinfo() function generates a page that shows what is installed. See if the configure string has --with-mysql or something like it. There also should be a section called mysql. Take a look at

Re: [PHP-DB] Call to undefined function mysql_connect()

2004-06-27 Thread Cole S. Ashcraft
Create a page called phpinfo.php. In it put ?php phpinfo() ?. Search for MySQL. You probably don't have MySQL support in your installation. Cole Leandro de Oliveira wrote: Hi! I want test MySQL with PHP, for that I wrote this: html headtitleTest MySQL/title/head body ?php $con =

Re: [PHP-DB] SSL with MySQL 4.0

2004-06-24 Thread Cole S. Ashcraft
Is there such thing as SSL connections to MySQL? Edgar Hassler wrote: Does PHP support SSL connections to MySQL? If no, does anyone have an idea how to make an SSL conncetion to MySQL using PHP? Thanks, Edgar Hassler -- This message has been scanned for viruses and dangerous content by

Re: [PHP-DB] Re: problem....

2004-06-23 Thread Cole S. Ashcraft
Kim, Won't redefining the variable destroy the MySQL Resource, resulting in a resource invalid error, like he has? $pic = mysql_query($sql,$connection); //Defines variable $pic //Redefining variable, dumps old contents = //calling on an invalid MySQL Resource, because it doesn't exist

Re: [PHP-DB] problem....

2004-06-22 Thread Cole S. Ashcraft
Just from looking at it, it seems to be because you are redefining a variable, which destroys it, then calling for a mysql resource that has been destroyed. What is the error? I can't gaurantee that that is what is happening. Cole why doesn't this work: $pic=mysql_query('SELECT Rune,

Re: [PHP-DB] problem....

2004-06-22 Thread Cole S. Ashcraft
The error he is getting means that his MySQL resource (in this case the results of the query) does not exist. Try $pic1=mysql_fetch_array($pic); Also, can you give the exact text of the error (line number and all) and line numbers for the entire passage? Cole Shahmat Bin Dahlan wrote: Your SQL

Re: [PHP-DB] problem....

2004-06-22 Thread Cole S. Ashcraft
I need the exact error message. Copy Paste it from the browser. I also need line numbers. Cole water_foul wrote: i fixed those things and it didn't fix it :( :( :( :( :( :( :( :( :( is there a icq chatroom for php?) Shahmat Bin Dahlan [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]

Re: [PHP-DB] content managment systems

2004-06-20 Thread Cole S. Ashcraft
I really like Mambo Open Source- mamboserver.com or mosforge.net. They are about (hopefully ;)) going to release version 4.6 real soon. 4.5 is great too, but 4.6 promises to be way better, Cole Kim Steinhaug wrote: I love that site, really the best way to get familiar with the common systems

Re: SV: [PHP-DB] Drawing table by while

2004-05-26 Thread Mike S.
not checked the specific code above for spelling or other typographic errors. The example code posted earlier (see below) had a small error in that the counter was incremented twice if it was the first column, therefore only printing 4 columns. :Mike S. :Austin TX USA Something like

Re: [PHP-DB] question on select

2004-05-12 Thread Tony S . Wu
sounds like a job for JavaScript. Tony S. Wu [EMAIL PROTECTED] Look into the right places, you can find some good offerings. http://homepage.mac.com/tonyswu/stw- The perfect business. http://homepage.mac.com/tonyswu/tonyswu- My web page

[PHP-DB] PostgreSQL lib and character case

2004-04-28 Thread Tumurbaatar S.
I use pg_fetch_array() to get a record content. But it seems that to access elements of the returned associative array, I should use lowercase field names. Is there any way to use case-insensitive field names? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Anybody using PostgreSQL?

2004-04-14 Thread Tumurbaatar S.
In PHP5 manual, it says that when using large objects functions of PostgreSQL, a program should manually begin/end transaction. But what about other query/exec functions? Do I need to control transactions or every function call implicitly wrapped with transaction block? What if a command consists

[PHP-DB] Re: postgresql

2004-04-14 Thread Jason S Motes
if i remember correctly you have to do this su su postgres createuser your-user-id Adam Williams wrote: Hi, I know this isn't PHP related but I have a quick question about postgresql. I come from a mysql enviroment so I'm a little clueless, even after reading the postgresql docs. I

[PHP-DB] Accessing MS SQL from Linux

2004-03-12 Thread S K Rana
My domain is hosting through a hosting company on Linux with PHP 4.3.4. Hosting company is not open to re-compile PHP for using FreeTDS or any other application. If I can not use FreeTDS, what other options do I have? a) Can Pear be used? It is 4.3.4. I tried ?php required_once(DB.php) ?

[PHP-DB] Re: Form doesnt write to database

2004-02-07 Thread Mike S.
/mysql-error-codes.html or, if you prefer a flat, text file: http://web.netmask.com/2004/02/mysql-error-codes.txt Good luck! :Mike S. :Austin TX --- Sent: February 7, 2004, 6:48 pm -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Associated popup menu (php/mysql)

2004-02-05 Thread Mike S.
for this type of popups yet, but I have a project coming up soon that probably will. If I get a chance to code up a sample, I'll make it available. Good luck. :Mike S. :Austin TX On Thu February 5 2004 7:33pm, Micah Stevens wrote: Javascript is client side programming, PHP is server side and unable

Re: [PHP-DB] i want to unsubscribe

2004-01-18 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear Thomas J. Rudd , See To unsubscribe, visit: http://www.php.net/unsub.php This sucks, I have tried to unsubscribed 10 times with out any success -- Regards, Vishal Kashyap ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~* I Know you believe my words so logon to Jabber.org and add

RE: [PHP-DB] transaction locking

2003-12-05 Thread Opec Kemp [ q u a s a r z ]
Hi, Aleks Kalynovych wrote: I have a couple forms that generate a unique ID based on taking the highest number in the ID column adding 1 to its value. The problem is that I dont save that number until the form is submitted. If 2 or more persons fill out the form at the same time they all

Re: [PHP-DB] how to deal with this (hack) attack?

2003-11-09 Thread Jordan S. Jones
) and tighten your security. Peter. -- I am nothing but a poor boy. Please Donate.. https://www.paypal.com/xclick/business=list%40racistnames.comitem_name=Jordan+S.+Jones -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP - Mysql privileges

2003-10-26 Thread Karina S
I use php with mysql database. User can insert, update, delete, view table data from indexed tables. What kind of privileges do I have to add for a mysql user? Insert/Update/Delete/Select are enough or I have to add more such as Index too? Thanks! -- PHP Database Mailing List

[PHP-DB] Re: Using PHP to print using LP on Linux

2003-10-24 Thread Jason S Motes
This is what i use: exec (lpr -P $PrinterName $PostscriptFile,$printOut , $printReturn); Paul Fitz wrote: Hi Guys, I suppose this isn't a database specific question, but it is the only PHP mailing list I am subscribed to. Trying to trigger a printer in the office hooked up to a Mandrake

[PHP-DB] PHP-Mysql speed

2003-10-12 Thread Karina S
Hello, I use PostNuke witm Mysql 4 on my php site and I have about 6000 visitors pro day. The server is a 2,4Ghz P4 with 1Gb RAM. My problem is that the server run on 40-45%. As I know PostNuke use ADO connection. Are the normal Mysql php function faster than the ADO variant? How big is the

Re: [PHP-DB] Hyperlinking to a new page

2003-10-09 Thread Jordan S. Jones
a href=/location/to/page.php?city_id=2342343City Name/a Shiloh Madsen wrote: Ok, I know this should be easy, but im just blanking on how to do it. I have a webpage where you put in a city name, and it queries a database of all the cities in the US and brings back all cities matching that name.

Re: [PHP-DB] Hyperlinking to a new page

2003-10-09 Thread Jordan S. Jones
Yes.. J Shiloh Madsen wrote: actually theres a problem with this, the page returned usually has several returns in it, so i cant hand code the id in there, will it work to do page.php?city_id=$city_id? - Original Message - From: Jordan S. Jones [EMAIL PROTECTED] To: Shiloh Madsen

[PHP-DB] how many rows updated

2003-09-11 Thread Jason S Motes
When updating or deleting a table is there anyway to find out how many rows where affected using php?? I am using Postgresql 7.2 and php 4.2 using pgsql from the the command line I enter this query update teststock set item_num ='something' where item_num ='something'; and it returns UPDATE

Re: [PHP-DB] how many rows updated

2003-09-11 Thread Jason S Motes
Thanks, i could not find that function in the book i was using. sorry for the inconvenience. John W. Holmes wrote: Jason S Motes wrote: When updating or deleting a table is there anyway to find out how many rows where affected using php?? I don't even use PG, but it took me 5 seconds to find

[PHP-DB] Using fopen() for internet URL

2003-06-08 Thread Tony S . Wu
? just want to speed things up a bit :P thanks. Tony S. Wu [EMAIL PROTECTED] The world doesn't give us hope - it gives us chance. http://homepage.mac.com/tonyswu/tonyswu- My web page. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Using fopen() for internet URL

2003-06-08 Thread Tony S . Wu
Thanks, i think i got the description mixed up :D Tony S. Wu [EMAIL PROTECTED] The world doesn't give us hope - it gives us chance. http://homepage.mac.com/tonyswu/tonyswu- My web page. On Sunday, June 8, 2003, at 04:29 PM, Tony S. Wu wrote: I have an auto-update script to gather some

[PHP-DB] fopen() question and auto update question

2003-06-08 Thread Tony S . Wu
going to have to abandon the idea by using fopen() to gather information. can anyone suggest an alternative way, which won't cost me too much time to get to it? there will be around 200 data to be updated each time. thanks a lot. Tony S. Wu [EMAIL PROTECTED] The world doesn't give us hope

[PHP-DB] Mail() on OS X

2003-06-02 Thread Tony S. Wu
hi all, i am trying to use mail() on Mac OS X 10.2 WITHOUT sendmail. I have php.ini file in my usr/local/lib directory, with SMTP set to my desire smtp server. But it just doesn't work. Does anyone here know how to use mail() on OS X? Thanks a lot. Tony S. Wu [EMAIL PROTECTED] The world doesn't

[PHP-DB] Re: sending a form feed to a printer

2003-04-02 Thread Jason S Motes
form feeds don't work in html. It is interpreted as a space. Arthur Chevalier wrote: Hello, I am having problems getting the \f (form feed) expression to work. After a certain amount of lines print I want to start printing the next line on a new sheet of paper. Any ideas of what I could be

Re: [PHP-DB] Catalogue system? there was : Mysql compress text field?

2003-03-06 Thread Patricio Vera S.
with my boss and get more disk... :-) pd.: sorry about the size of the mail i try to be more cleary possible. Regards, Patricio. - Original Message - From: 1LT John W. Holmes [EMAIL PROTECTED] To: Patricio Vera S. [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 2:45 PM

[PHP-DB] Mysql compress text field?

2003-03-04 Thread Patricio Vera S.
the user request one report, I query the database and return the report. But if MySql don't compress the text field, that way is not practicable (HDD is limited). Any ideas or suggestions? Saludos, Patricio Vera S. ___ Yahoo! Móviles

[PHP-DB] Access querys to a csv

2003-02-16 Thread Donald S. Booth
Hi all, I am trying to dump an Access db query and form it into a comma delimited file. I get the query ok. I can get it into a table with odbc_result_all. If I print the variable, it shows the first value from the first row... Any hints on the path I should take? Thanks, D -- PHP Database

[PHP-DB] Secure variable transport (newbie)

2003-01-22 Thread Karina S
Hi, I have read, that use global variables on php site is not a good idea. I'm newbie in PHP and maybe a stupid question: If I make an array and register it in a session and after I use it all of my pages as $HTTP_SESSION_VARS['variable'] and register_globals is off. In this case is

[PHP-DB] [NB] Mail() question

2003-01-18 Thread Tony S . Wu
got the email. So I was wondering if Mail() request any send mail program to work. Can anyone tell me? Thanks. Tony S. Wu [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] [NB] Mail() question

2003-01-18 Thread Tony S . Wu
to figure out why it's not working fast... Thanks to your help. Tony S. Wu [EMAIL PROTECTED] It takes a smart man to be stupid. ~Tony On Saturday, January 18, 2003, at 01:47 PM, Micah Stevens wrote: The mail() function returns true if it functions, i.e. if you have all the parameters correct

Re: [PHP-DB] [NB] Mail() question

2003-01-18 Thread Tony S . Wu
to figure out why it's not working fast... Thanks to your help. Tony S. Wu [EMAIL PROTECTED] On Saturday, January 18, 2003, at 01:47 PM, Micah Stevens wrote: The mail() function returns true if it functions, i.e. if you have all the parameters correct, and that sort of thing. If the SMTP server

Re: [PHP-DB] [NB] Mail() question

2003-01-18 Thread Tony S . Wu
Ah, that must be it. I am running a Mac OS X server, which is Darwin based. Guess I should go with sendmail. Thanks a lot. Tony S. Wu [EMAIL PROTECTED] On Saturday, January 18, 2003, at 02:27 PM, Jason Wong wrote: On Sunday 19 January 2003 04:48, Tony S. Wu wrote: I need to send myself

RE: [PHP-DB] Re: crosstab for MS SQL

2002-12-28 Thread Opec Kemp [ q u a s a r z ]
Hi, I don't think you can do that with MS SQL, it doesn't support TRASFORN, I think that's strictly Access syntax. MS SQL 7 and up does have ROLLUP etc but that's part of the OLAP service, which you will only get if you have Enterprise edition (read $$ :)). The easiest way to get out of this

[PHP-DB] php/mysql

2002-12-26 Thread Martin S
no difference. Any suggestions? /Martin S. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php/mysql

2002-12-26 Thread Martin S
connect to database. I once desperately thought I had forgotten to configure php --with-mysql so I recompiled. No improvement. Are you sure you are using a valid login and password in your programs? Yes. I'll recheck though. /Martin S. -- PHP Database Mailing List (http://www.php.net

RE: [PHP-DB] How to solve T_STRING error?

2002-12-26 Thread Martin S
not as intended (which the db-routine is supposed to fix). I'll have another look though. /Martin S. * which is hell to debug, it's a 3500+ lines beastie. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php/mysql

2002-12-26 Thread Martin S
heard something like that as well, which is why I've compiled php and apache from source. Would compiling mysql from source as well help I wonder... /Martin S. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How to solve T_STRING error?

2002-12-25 Thread Martin S
]; } if($permissions)// This is line 43 { if(!$isStat) { and I can't see what ever is wrong! Probably have been looking too much at it. Anyone who can see an error in here somewhere? /Martin S. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] How to solve T_STRING error?

2002-12-25 Thread Martin S
Jason Wong wrote: On Wednesday 25 December 2002 21:44, Martin S wrote: Just one page still to do. And I'm stuck. I keep getting: Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /www/htdocs/dev/users/tracking-update.php on line 43 ON this code

RE: [PHP-DB] MySQL connectiviy

2002-11-22 Thread Pedro M. S. Oliveira
Hi Jeremy, Probably you don't have all of php installed; you can pick it up in php.net and install the full php libs. Or in your php ini file, the php lib path can be incorrect, well these are just thoughts as I don't use red hat for some time (SuSE Forever). Hope you figure it out, Pedro

Re: [PHP-DB] Infinite Loop?

2002-11-02 Thread Tony S. Wu
I've seen no way to get out of the while loop. Tony S. Wu [EMAIL PROTECTED] Nope, this world ain't perfect. But at least I know it's not because of me. Graeme McLaren at [EMAIL PROTECTED] wrote: Greetings list members. I've written the code below as part of an automatic email script

[PHP-DB] Free shopping cart

2002-10-20 Thread Tony S. Wu
I need to write a shopping cart for my friend's website. I thought modifying a free one for my need would be easier. Sorry for asking question like this. But I've done the search on google and all I could find weren't free. Can anyone provide me some links? Thanks a lot. Tony S. Wu [EMAIL

Re: [PHP-DB] Free shopping cart

2002-10-20 Thread Tony S. Wu
Thanks a lot :D Tony S. Wu [EMAIL PROTECTED] Nope, this world ain't perfect. But at least I know it's not because of me. Jason Wong at [EMAIL PROTECTED] wrote: On Sunday 20 October 2002 23:17, Tony S. Wu wrote: I need to write a shopping cart for my friend's website. I thought modifying

[PHP-DB] Help! Oracle help needed

2002-09-20 Thread Pedro M. S. Oliveira
Hi all the people here! well i've been working with php for quite some time now but i never used oracle databases before. well the situation is something like this. I've a mysql server running perfectly working with apache and php on linux, but in the other hand i also have an oracle server (6i)

[PHP-DB] SELECT statement problem

2002-08-15 Thread Evan S. Weiner
Hello all, I have this SQL statement I am trying to use and no matter what combination I use, I cannot get it to work. The start and end if clauses need to be grouped together. SELECT * FROM tickets_work WHERE employee_id = '$tech_id' ( start '$start' end '$end' ) ORDER BY start Anyone

RE: [PHP-DB] SELECT statement problem

2002-08-15 Thread Evan S. Weiner
' AND end '$end' ORDER BY start Which will select everything from tickets_work for a given employee between start and end. What is not working? Miles Thompson At 02:15 PM 8/15/2002 -0400, Evan S. Weiner wrote: Hello all, I have this SQL statement I am trying to use and no matter what

[PHP-DB] Using functions in SELECT statements

2002-05-02 Thread Robin S McKenzie
I'm trying perform a case-insensitive test for a name. These are stored like Association of ..., and I want to convert both the filter and the test data to lower- (or upper-) case. Why doesn't this work: ? SELECT * FROM [Organisation Membership] WHERE lower(organisation) LIKE

Re: [PHP-DB] Using functions in SELECT statements

2002-05-02 Thread Robin S McKenzie
software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Robin S McKenzie [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 14:34 To: [EMAIL PROTECTED] Subject: [PHP-DB] Using functions i

RE: [PHP-DB] Probably a stupid Array question

2002-03-30 Thread Demitrious S. Kelly
$words[0] would be the first word, $words[1] would be the second word... $words[10] would be the eleventh word, etc, etc -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 30, 2002 9:08 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Probably a stupid Array

[PHP-DB] Re: ODBC and images

2002-03-26 Thread Bruce S. Garlock
Although this article is more geared towards MySQL, the principles should apply to ODBC, and you should be able to translate the MySQL functions to ODBC functions rather easily. http://www.phpbuilder.com/columns/florian19991014.php3 David Juras wrote: Hi, I'm working with PHP and ODBC

Re: [PHP-DB] ODBC -- Setting ApplicationID

2002-03-26 Thread Bruce S. Garlock
-Original Message- From: Bruce S. Garlock [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 10:48 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] ODBC -- Setting ApplicationID Sure, I'm simply trying to have PHP pass an ApplicationID to the ODBC server. When

Re: [PHP-DB] ODBC -- Setting ApplicationID

2002-03-25 Thread Bruce S. Garlock
upgrade to 4.2 Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Bruce S. Garlock [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002

Re: [PHP-DB] ODBC -- Setting ApplicationID

2002-03-25 Thread Bruce S. Garlock
Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server -Original Message- From: Bruce S. Garlock [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 10:48 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] ODBC -- Setting ApplicationID

[PHP-DB] ODBC -- Setting ApplicationID

2002-03-21 Thread Bruce S. Garlock
I am trying to set the ApplicationID, when connecting to an ODBC datasource. I have tried: odbc_setoption ($conn, 1, 1053, PHPAPP); And get a: SQL error: [iODBC][Driver Manager]Option type out of range, SQL state S1092 in SetConnectOption Basically, I want my PHP script to pass the

[PHP-DB] Re: [PHP] Temporary MySQL Tables

2002-03-21 Thread John S. Huggins
On Thu, 21 Mar 2002, Georgie Casey wrote: -Hi, - -membership with the username and timestamp in the URL. The users clicks it, -and I run a SQL command that copies the row from tempmembers into the -members table. I assume you are building up all your fields as you move through the site. I would

[PHP-DB] oracle-mysql

2002-03-20 Thread Pedro M. S. Oliveira
hi all, i need to migrate an oracle database (+-1gb) to a mysql one, but i don't have a clue how to do this. i'm thinking in dumping the whole content of the oracle database to a txt file but i don't know if there is a better way any ideias on this one. btw the oracle machine is running on

RE: [PHP-DB] Random Selecting from mySQL

2002-03-13 Thread Demitrious S. Kelly
Pass along a hidden form which documents exactly what rows have already been shown input type=hidden name=seen value=1:4:3:9:10:5:27 then you could use $seen=explode(':', $seen); to break it into an array... after that use a foreach to add a 'and id != '.$seen into the sql query for every

Re: [PHP-DB] any php/Linux gurus out there?

2002-03-04 Thread Pedro M. S. Oliveira
you could complile the hole program instead of the rpm, just read README.install from the php source tar file. or you can install the other rpms that are lacking. or even so, not such a good ideia, but you can force the installationg using the command rpm -i --nodeps php or rpm -U --nodeps

Re: [PHP-DB] I'm really stuck!

2002-02-28 Thread Billy S Halsey
); $data = mysql_query($result,0,bin_data); $type = mysql_query($result,0,filetype); Header( Content-type: $type); echo $data; }; echo img src=\petdata.php?id=$id\; Thanks Jennifer Downey -- /-=[ BILLY S HALSEY ]=--\ | Member of Technical

Re: [PHP-DB] Finding records with NULL values

2002-02-26 Thread Billy S Halsey
in responses. How can I do this? Regards, Robin -- /-=[ BILLY S HALSEY ]=--\ | Member of Technical Staff, Sun Microsystems, Inc. ESP Solaris SW | | All opinions and technical advice offered in this message are my | | own and not necessarily endorsed by my

Re: [PHP-DB] PHP IDE

2002-02-23 Thread Billy S Halsey
some nice editors from this list. Regards, /bsh/ -- /-=[ BILLY S HALSEY ]=--\ | Member of Technical Staff, Sun Microsystems, Inc. ESP Solaris SW | | All opinions and technical advice offered in this message are my | | own and not necessarily

Re: [PHP-DB] newbe: how to import a whole db from an .sql file

2002-02-21 Thread Billy S Halsey
handle multiple statements devided by the ';'... How can I import the whole file? tnx for any help! -- === Billy S Halsey Software Problem Resolution ESP Solaris Software Email [EMAIL PROTECTED

[PHP-DB] Do persistent dba_popen connections work ?

2002-01-29 Thread S A
I'm trying to use Berkeley DB db2 files with PHP persistent connection dba_popen. When I try persistent connections with dba_open then sometimes I don't get reads working I never get insert/replace working. Without persistent connections reading writing work fine. Has anyone else gotten

[PHP-DB] Re: [binarycloud-dev] Re: [PEAR-DEV] Re: [metabase-dev] RE:[PEAR-DEV] New Metabase Aniversary release

2002-01-25 Thread Stig S. Bakken
On Tue, 2002-01-22 at 22:17, Alex Black wrote: Template classes are also foundation components of modern applications. They are certainly important, but they do not prevent interoperability in the same way that different database abstraction packages do. application, using APIs that

[PHP-DB] Re: [PEAR-DEV] Re: [binarycloud-dev] Re: [PEAR-DEV] Re:[metabase-dev] RE: [PEAR-DEV] New Metabase Aniversary release

2002-01-25 Thread Stig S. Bakken
On Tue, 2002-01-22 at 22:24, Björn Schotte wrote: * Alex Black wrote: Of course, but no one forces you to do that. I, as a developer, can choose if I want to use PEAR::Metabase in my application or PEAR::DB. Yes, which is not a good idea. If you're tying to get people to use a common

[PHP-DB] ADDING DATES

2002-01-13 Thread Pedro M. S. Oliveira
Hi all, first of all i'm sorry to ask this but i am getting lazy and i bet you all can answer me in a couple of code lines. i want to add some days to the the result of the date php function. how can i had lets say 3 days? ex: (pseudo code) ? $date =date(,mm,dd); $date =date(,mm,dd) +

[PHP-DB] simultaneous dual table entry

2002-01-10 Thread Marc S. Bragg
Hi, Is there a process for entry from one form to -- Marc S. Bragg [EMAIL PROTECTED] Bialecki Bragg, PC p: 610-444-7508 f: 610-444-7548 http://www.chescolawyers.com/BB Legal Directory, Services Consumer Information for Chester County -- PHP Database Mailing List (http://www.php.net

[PHP-DB] simultaneous dual table entry

2002-01-10 Thread Marc S. Bragg
Hi, Is there a process / command for inserting information from one form one input into two separate tables in the same database? Anyone have the basic command statement? thanx mucho' Marc -- Marc S. Bragg [EMAIL PROTECTED] Bialecki Bragg, PC p: 610-444-7508 f: 610-444-7548 http

Re: [PHP-DB] mysql_num_rows

2002-01-06 Thread Richard S. Crawford
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] Sliante, Richard S. Crawford http://www.mossroot.com AIM: Buffalo2K ICQ: 11646404 Y

RE: [PHP-DB] mysql_num_rows

2002-01-06 Thread Richard S. Crawford
Sliante, Richard S. Crawford http://www.mossroot.com AIM: Buffalo2K ICQ: 11646404 Y!: rscrawford MSN: [EMAIL PROTECTED] It is only with the heart that we see rightly; what is essential is invisible to the eye. --Antoine de Saint Exupéry Push the button, Max! -- PHP Database Mailing List

Re: [PHP-DB] MySQL: Reverse Order by???

2001-12-19 Thread Richard S. Crawford
ORDER BY field DESC At 07:27 AM 12/19/2001, Brian Grayless wrote: How you do a reverse order by in SQL, kind of like ORDER BY field only reverse the order??? Sliante, Richard S. Crawford http://www.mossroot.com AIM: Buffalo2K ICQ: 11646404 Y!: rscrawford MSN: [EMAIL PROTECTED] It is only

  1   2   >