Re: [PHP-DB] Creating a ranking

2001-01-18 Thread Stas Trefilov
Hello, "Fabio Ottolini (EDB! You wrote: > user mpontos > UserA 1532 > James Brown 1349 > UserB 1229 > > The most important part is that it cannot be any user > with more or less = > points than James Brown. It must be exactly the users > with the smallest = > differe

Re: [PHP-DB] avoid cached html pages

2001-01-18 Thread Koos van den Hout
Quoting Lisa Elita who wrote on Thu, Jan 18, 2001 at 01:29:49PM +0700: > Can you tell me how to avoid cached HTML pages from showing up? How to set > expiry time to an HTML page? So far, 2 different ways have been mentioned: in the http headers and in the head of the html page. I want to urge y

Re: [PHP-DB]OCI ORA-12154 error

2001-01-18 Thread R Maier
Hi Richard, hola David, even so my php4 is running on the server where the database is installed, I tried your putenv to all of the oracle variables. It did not change any. All these variables are usually set by the root profile where oracle and apache start: K10oracle K20apache I had the OCIInte

Re: [PHP-DB] HELP! Manage MySQL

2001-01-18 Thread Rosen
Thanks! But when I try to connect to server I get message "Can't connect to MySQL server on (10060 )! Please Help! "David Tod Sigafoos" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello Rosen, > > Wednesday, January 17, 2001, 9:54:28 AM, you wrote: >

[PHP-DB] Connection to MySQL

2001-01-18 Thread Rosen
Hi, When I try to connect to server I get message "Can't connect to MySQL server on "host" (10060 )! Please Help! Thanks Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact th

Re: [PHP-DB]OCI ORA-12154 error

2001-01-18 Thread Andreas Karajannis
> even so my php4 is running on the server where the database is installed, > > I tried your putenv to all of the oracle variables. putenv won't help. The Oracle client libraries are initialized during server startup, so they won't see the environment set via putenv in a PHP script. This applie

[PHP-DB] where to get php-mssql70.dll

2001-01-18 Thread karuna moorthy
Dear support, I have problem while connecting to MSSQL. Error : "call to undefined function mssql_connect()" I think i need to have the dll file php_mssql70.dll. can you tell me where to get this file. Awaiting for your reply regards karuna __

RE: [PHP-DB] Wrong kinda dump

2001-01-18 Thread Cal Evans
FWIW, I get a core dump anytime I use -d try --database= Cal http://www.calevans.com -Original Message- From: Lynn Siprelle [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 1:01 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Wrong kinda dump I feel like saying "Nothin' up my s

Re: [PHP-DB] Connection to MySQL

2001-01-18 Thread miso
you should probably start mysqld :)) miso ""Rosen"" <[EMAIL PROTECTED]> wrote in message 946i6f$889$[EMAIL PROTECTED]">news:946i6f$889$[EMAIL PROTECTED]... > Hi, > When I try to connect to server I get message "Can't connect to MySQL server > on "host" (10060 )! > > Please Help! > Thanks > Rose

[PHP-DB] Spørgsmål vedr. print af $row[]

2001-01-18 Thread Thomas Secher
Jeg sidder med et php-dokument som benytter echo $row[] fuktionen. I enkelte $row output vil jeg gerne begrænse antallet af viste karakterer. Findes der en direkte echo/$row funktion eller har du en anden fix idé ? Thomas. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-m

Re: [PHP-DB] Connection to MySQL

2001-01-18 Thread Rosen
What is mysqld ?? Rosen Marinov ""miso"" <[EMAIL PROTECTED]> wrote in message 946qqn$sbr$[EMAIL PROTECTED]">news:946qqn$sbr$[EMAIL PROTECTED]... > you should probably start mysqld :)) > > miso > > ""Rosen"" <[EMAIL PROTECTED]> wrote in message > 946i6f$889$[EMAIL PROTECTED]">news:946i6f$889$[EM

[PHP-DB] PHP 4.04 install binary Win32 and MSQL 7.0

2001-01-18 Thread Come Italia s.r.l. - Webmaster
I've installed and correctly configured (I suppose) the binary version of PHP 4.04 on a Win NT server with Microsoft IIS. I'm using CGI version of IIS. when I try to connect my script with Microsoft SQL 7.0 DB I get this error "Fatal error: Call to undefined function: sybase_pconnect() in ./db/

Re: [PHP-DB]OCI ORA-12154 error

2001-01-18 Thread R Maier
Hallo Andreas, hi Richard, hola David, with your help I now found the problem. when I checked with echo phpinfo(INFO_ENVIRONMENT); I saw that ORACLE_HOME was not set anymore and LD_LIBRARY_PATH was set wrong. I first tried to set these variables with putenv("ORACLE_HOME=/opt/oracle/product.

[PHP-DB] SQL not working !

2001-01-18 Thread TV Karthick Kumar
Hi I am working with PHP / Oracle 8 I am a newbie to Oracle and complicated SQL's too. This is a simple query I wrote and it's not working : select first_name from member where (home_email1 && home_email2) like '%tvk%'; I dont' get any specific errors also !. I think the c

RE: [PHP-DB] SQL not working !

2001-01-18 Thread Andrew Hill
Try, select first_name from member where home_email1 like '%tvk%' and home_email2 like '%tvk%'; Best regards, Andrew Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technol

Re: [PHP-DB] SQL not working !

2001-01-18 Thread Darryl Friesen
> select first_name from member where (home_email1 && home_email2) >like '%tvk%'; I think this needs to be something like: select first_name from member where (home_email1 like V) AND (home_email2 like '%tvk%') - Darryl

Re: [PHP-DB] SQL not working !

2001-01-18 Thread Darryl Friesen
> select first_name from member where (home_email1 like V) AND >(home_email2 like '%tvk%') Sorry; cut and pasted that wrong. I meant: select first_name from member where (home_email1 like '%tvk%') AND home_email2 like '%tvk%') - Darryl

RE: [PHP-DB] Wrong kinda dump

2001-01-18 Thread Lynn Siprelle
At 6:54 AM -0600 1/18/01, Cal Evans wrote: >FWIW, I get a core dump anytime I use -d try --database= This worked, thanks! Lynn -- Lynn Siprelle, Siprelle & Associates: Web Construction and Publishing Chief Assoc. Josephine b. 9/9/97 * New Assoc. Louisa due 5/1/01 Business: lynn@siprelle com |

Re: [PHP-DB] PHP 4.04 install binary Win32 and MSQL 7.0

2001-01-18 Thread ryan . sinn
In the php.ini there's a section with database configuration for each type of SQL Server. You can uncomment as many as you want [they don't conflict]. I know this doesn't apply to this question, per se, but a php.ini configuration change occured between PHP 4.0.3 and 4.0.4 -- In PHP 4.0.3 the

AW: [PHP-DB] PHP 4.04 install binary Win32 and MSQL 7.0

2001-01-18 Thread Stefan Siefert
I'm not 100 % sure (cause we don't use the win binaries) but I think I can remember that you have to uncomment some lines in the php.ini file. There should be a section with database modules like oracle odbc or somethink like this. try to uncomment the sybase module. Hope this works, Greetings

[PHP-DB] Cookies on a Macintosh

2001-01-18 Thread Noodles Grizzly
G'day, I'm using the setcookie function with the follwing. setcookie("randint", "$ran3", time()+9000); This sets a cookie for me to check against the database and works wonderfully well in netscape on the macintosh, but not Internet Explorer! Which really I don't mind because I use windows 200

[PHP-DB] selecting values from column without repeating

2001-01-18 Thread sarahana
Hello, I was wondering if it would be possible to select values from a column (lets say the column "year") so that each value gets retrieved only once... for example, there are multiple rows in a table - some with '2001' as the value for the year column, and some with '2000'. Now, what I wanted

Re: [PHP-DB] selecting values from column without repeating

2001-01-18 Thread Toby Butzon
I've done this before; some databases allow for a UNIQUE specifier in the query (see your documentation). Alternatively (and more resource & time consuming), you can store results in a regular PHP array (not a result resource, etc.) and use array_unique (see php.net/array_unique) to create an arra

Re: [PHP-DB] selecting values from column without repeating

2001-01-18 Thread JJeffman
You can avoid record repetition using the "distinct" keyword in the "select" command : "select distinct * from table where " Remember that all the table fields you put in the select query will be present in all fetched records. If you do not want to show some field in every line you must build a p

[PHP-DB] Child tables in MySQL

2001-01-18 Thread John Starkey
Can anyone tell me how to create child tables in MySQL? I'm creating User Prefs and need to store bookmarks, and unlimited number. So adding columns is out of the question. Any other suggestions? Thank in advance, John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mai

RE: [PHP-DB] Child tables in MySQL

2001-01-18 Thread John Starkey
Forgive me.. newbie alert :} I'm trying to make a user homepage with prefs. But I've set it up for each user as a row. I think this may be a dumb question but I want a column to have an attached table per row. Is that possible? If not and I create a table for each user then I'm thinking of havin

RE: [PHP-DB] Child tables in MySQL

2001-01-18 Thread Alarion
Lol, no problem. =) No, that is not the correct syntax. You might try something like this: Create table users( u_id integer auto_increment not null, u_handle varchar(25), u_email varchar(50), u_password varchar(25), primary key(users_id)); Create table users_prefs( up_u_id integer not null, up_i

[PHP-DB] Tokenizing memo field

2001-01-18 Thread Jarek Zgoda
I maitain a database of pascal code snippets in text blob. It is inserted from object. I would like to add some syntax - coloring to display, but i have problem with strtok function - it does not allow using CR+LF (or LF) as string tokenizer. Is there any way to get the contents of this field int

[PHP-DB] odbc_columns() and DB2

2001-01-18 Thread szii
Okay, here's the problemo. I make a connection to the DB2 database, and run an odbc_tables() call on it. No problem. I run an odbc_columns() on it just fine. Now I call a SECOND odbc_columns() (on a different table) and get a SIGSEGV and a core dump. *blink* I cracked open php_odbc.c and p