Re: [PHP-DB] Changing from Windows to Linux

2002-04-29 Thread Marius Ursache
teoretical no, practical yes. Philip Yeo a écrit : > Hi there, > > I'm curious to find out whether changing one's php development OS from > Windows to Linux would affect the performance of the application? > > Philip > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visi

Re: [PHP-DB] Changing from Windows to Linux

2002-04-29 Thread Jason Wong
On Monday 29 April 2002 16:16, Marius Ursache wrote: > teoretical no, > practical yes. > > Philip Yeo a écrit : > > Hi there, > > > > I'm curious to find out whether changing one's php development OS from > > Windows to Linux would affect the performance of the application? If you're talking abou

[PHP-DB] UK based php/mysql programmers

2002-04-29 Thread Peter Lovatt
Hi I am bidding for a big project scheduled for the end of May. If it comes off I will need an extra pair of hands, or perhaps two. Some UK specific knowledge/content which is why UK based matters, no offence to anyone else :) Anybody interested in working for/with me? Rates and URLs to pjl_at_

[PHP-DB] upgrade to 4.2, now odbc cursor problem

2002-04-29 Thread Joop Marijne
Hi All, I am working with PHP for quite some time now. For this customer I am forced to use the windows version with a db2 database server. This has introduced some interesting problems. After the upgrade from 4.1.2 many query's on most (MOST) table's give this warning: Warning: SQL error: [M

RE: [PHP-DB] upgrade to 4.2, now odbc cursor problem

2002-04-29 Thread Ryan Jameson (USA)
Hi Joop, The ODBC guys know about this and several other issues with 4.2. Did you download the binary distribution or did you compile your own? One possibility concerning my issue is the options that were compiled into the binary distribution. It might be best to stay at 4.1.2 for now. I'm hav

[PHP-DB] FW: [PHP-DEV] odbc problems in 4.2

2002-04-29 Thread Ryan Jameson (USA)
Joop... Here's some more info: -Original Message- From: Andreas Karajannis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 5:16 PM To: Dan Kalowsky Cc: Ryan Jameson (USA); [EMAIL PROTECTED] Subject: Re: [PHP-DEV] odbc problems in 4.2 Dan Kalowsky wrote: > Hi Ryan, > > Okay d

[PHP-DB] Check Boxes

2002-04-29 Thread Julio Cuz, Jr.
Hi-- Does anyone have any suggestions, SAMPLES, or ideas on how to STORE, RETRIEVE, AND PROCESS values for "Check Boxes" w/PHP & Postgresql? Thanks! Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://

RE: [PHP-DB] Check Boxes

2002-04-29 Thread Cal Evans
I usually store the value as a 0 (unchecked) or a 1(checked) in a char(1) field. Then, in populating the form my input has something like There are other ways of doing it. (Warning, I'm not actually LOOKING at my code at the moment so YMMV.) HTH, =C= * * Cal Evans * Journeyman Programmer * Tec

[PHP-DB] Re: [PHP] Check Boxes

2002-04-29 Thread Surojit Niyogi
Julio, The way I see it checkboxes are just boolean graphical representations. Either a "yes" or "no" value if the box is checked or not, respectively. Hence, it would make sense for the field to be of type "bool". As far as storing goes, PHP sees a checked box of having a value of "on" an

[PHP-DB] Recommendation needed: a php/mySQL program to batch e-mail announcements

2002-04-29 Thread Al
Need: Users can register to receive announcements automatically. And unregister. Admin can generate simple messages and send to all on the registry [e.g., meeting planned for 5 May 2002 at Joe's house] Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http:

[PHP-DB] Not getting results if 0

2002-04-29 Thread Jennifer Downey
Hi all, I am wondering how to keep something from beind displayed if a price is set to 0? I have a store where the user looks up items, but it shows all items even if the price is 0. Is there a way to prevent the items set at 0 from being displayed? Thanks Jennifer -- The sleeper has awaken

RE: [PHP-DB] Not getting results if 0

2002-04-29 Thread Leotta, Natalie (NCI/IMS)
Are you looking it up in a database? If so you'd want to do something like where price > 0. Then it wouldn't return those results. -Natalie -Original Message- From: Jennifer Downey [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 2:01 PM To: [EMAIL PROTECTED] Subject: [PHP-DB]

Re: [PHP-DB] Not getting results if 0

2002-04-29 Thread Jennifer Downey
Wow, the only thing I can say for myself is DUH as I slap my forehead. I don't know why I didn't think of that. But thank you Natalie. "Natalie Leotta" <[EMAIL PROTECTED]> wrote in message 7546CB15C0A1D311BF0D0004AC4C4B0C024AC071@SSIMSEXCHNG">news:7546CB15C0A1D311BF0D0004AC4C4B0C024AC071@SSIMSE

RE: [PHP-DB] Not getting results if 0

2002-04-29 Thread Leotta, Natalie (NCI/IMS)
You're welcome. It's a Monday - no DUH necessary :-) -Original Message- From: Jennifer Downey [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 2:33 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Not getting results if 0 Wow, the only thing I can say for myself is DUH as I slap

[PHP-DB] How do I assign Oracle pakage variable's value to a php variable?

2002-04-29 Thread Prince
Hello, I have a package like the following one. creare or replace package my_pkg as my_pkg_var varchar(10) defalut 'myVal'; end my_pkg ; Now, I want to read this value into a php variable (say $my_php_var). How do I do this? in PL/SQL, I can easily do this as declare tmp varchar2(10);

[PHP-DB] ODBC problem in 4.2.0

2002-04-29 Thread Mihai Tache
i work on a website that runs on php with MSSQL through ODBC. until 4.2.0 everything was ok. but my hosting provider just upgraded to 4.2.0 the error message i get is : SQL error: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt, SQL state S1000 in SQLExecDire

[PHP-DB] Simple search engine gone bad

2002-04-29 Thread Jennifer Downey
Hi all, It's Monday, it's probably something stupid, but I have poured over this all day and cannot find the problem. This is a simple search engine based on one table. It is suppose to return the results of the search word. Instead it returns ALL records in the mysql table. If I type the letter

Re: [PHP-DB] Simple search engine gone bad

2002-04-29 Thread CK Raju
> > if($search) > { > $query = "SELECT iname, quantity, user, price FROM > {$config["prefix"]}_shop WHERE iname LIKE '%$searchword%' AND price > 0 Try putting $searchword within single quotes. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.

RE: [PHP-DB] Simple search engine gone bad

2002-04-29 Thread Gurhan Ozen
Jenn, Get rid of 'value=\"\"' in your code and give it a shot again... Gurhan -Original Message- From: Jennifer Downey [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 9:32 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Simple search engine gone bad Hi all, It's Monday, it's proba

RE: [PHP-DB] ODBC problem in 4.2.0

2002-04-29 Thread Ryan Jameson (USA)
I'd recommend finding a hosting service that would be more careful about making upgrades. There seems to be some problems with ODBC in 4.2 and I have yet to hear of a work around, especially not one you can implement if you don't handle your own server. I feel your pain man! Fortunately for me

RE: [PHP-DB] ODBC problem in 4.2.0

2002-04-29 Thread Ryan Jameson (USA)
BTW... I'd just like to point out that this kind of thing is bound to happen no matter what product you use. I'm certain the PHP guys will have this solved in no time and I'd bet even they would recommend a commercial hosting service be willing and able to step back if a problem like this occur

[PHP-DB] Can't Load Data into Mysql Using PHP

2002-04-29 Thread Jack
Dear all I had a problem to get the php to load a csv file into mysql. I had a csv file which located at my HDD, and i had tried to Import the data from this CSV file into mysql using MYCC which is a console program for mysql, it successfully load the data into mysql table. Now i try to setup my w

[PHP-DB] Re: Can't Load Data into Mysql Using PHP

2002-04-29 Thread Jennifer Downey
include 'phpstudy/constant.inc'; $link=mysql_pconnect(HOST,USER,PASSWD); mysql_select_db(DBNAME,$link) or die(mysql_error()); This will give you the errors if any. HTH Jennifer "Jack" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Dear all > I had a problem

[PHP-DB] Question about Load Data to mysql through php

2002-04-29 Thread Jack
Dear all i'm a newbie in mysql, but there is one question about LOAD Data command in mysql, let say if i had a CSV file in client side and i want to load this file's data into particular table , so do i need to copy this CSV file into Web server side where the Mysql is or i will be able to load it

Re: [PHP-DB] Question about Load Data to mysql through php

2002-04-29 Thread Jason Wong
On Tuesday 30 April 2002 14:33, Jack wrote: > Dear all > i'm a newbie in mysql, but there is one question about LOAD Data command in > mysql, let say if i had a CSV file in client side and i want to load this > file's data into particular table , so do i need to copy this CSV file into > Web serve