[PHP-DB] Re: [PHP] passing variables in javascript

Whooops ... sorry about that last post ... wrong list! n >H ... is there anyway to do this without requiring the page with >the link to use PHP? > >> >>You have to encode each part of the query string on the URL correctly: >> >>> . "&url=" . >>urlencode("http://www.domain.com/biz/pu

[PHP-DB] Re: [PHP] passing variables in javascript

H ... is there anyway to do this without requiring the page with the link to use PHP? > >You have to encode each part of the query string on the URL correctly: > > . "&url=" . >urlencode("http://www.domain.com/biz/pubs.html#antitrust"); >?>', 'email','width=410,height=435')">Emailthi

RE: [PHP-DB] Know any sites where a PHP programmer can find job?

Check out : http://www.weberdev.com/index.php3?GoTo=jobs/Jobs.php3 Sincerely berber Visit http://www.weberdev.com Today!!! To see where PHP might take you tomorrow. -Original Message- From: Grishick [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 7:37 AM To: [EMAIL

[PHP-DB] Re: sessions

This could be because cookies have been disabled. Can I find a way such that my code works even if cookies have been disabled ?? - Original Message - From: Pankaj Ahuja To: php-db list Sent: Friday, February 23, 2001 12:04 PM Subject: sessions I am trying to execute the following c

[PHP-DB] sessions

I am trying to execute the following code. It all works fine if the code is executed second time onwards. When the code is executed for the first time (a new session is created) the value of PHPSESSID is not assigned. Could this be because session.auto_start is assigned a value of 0 ? What could b

[PHP-DB] Know any sites where a PHP programmer can find job?

Anyone know any sites where a PHP programmer can find job? Specially in US. Thank you. Grigoriy Solovyev. [EMAIL PROTECTED] -- 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 admin

[PHP-DB] mysql_version or mysql_status($varname) for fast rand

I'd need one of those functions. I would want to use the much faster "SELECT ... ORDER BY RAND() LIMIT 1" but at least one server of mine doesn't support RAND(). I want to detect that dynamically. no way? for this old mysql I must use: $res = mysql_query("select xx from xx", $dbi);

RE: [PHP-DB] RedHat 7 vs. Windows 98

Thanks a bunch, (sorry that I'm an amateur at this.) How do I set the error level? -Original Message- From: Ron Brogden [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 5:46 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] RedHat 7 vs. Windows 98 At 05:23 PM 2/22/2001 -0700,

Re: [PHP-DB] RedHat 7 vs. Windows 98

At 05:23 PM 2/22/2001 -0700, you wrote: >I've resolved a similar error by using isset() for if ($id) but when I do >the same for if (!$id) I get a parse error. Sounds like you placed the ! in the wrong spot maybe? "if(!isset($foobar)) {}" is fine syntactically as far as I am aware. >Second err

[PHP-DB] RedHat 7 vs. Windows 98

This isn't an issue with RedHat Linux 7.0 but I'm getting a series of errors from Windows 98. First, I'm getting an undefined variable error on the following statement. (The database I'm using is MySQL.) if (!$id) { I've resolved a similar error by using isset() for if ($id) but when I do the

[PHP-DB] CLEAR screen command

Hi-- Is there a CLEAR SCREEN command in PHP? Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- 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:

Re: [PHP-DB] Most Occurring

Addressed to: Dale Frohman <[EMAIL PROTECTED]> [EMAIL PROTECTED] ** Reply to note from Dale Frohman <[EMAIL PROTECTED]> Thu, 22 Feb 2001 10:34:47 -0500 (EST) > > Is there anyway with a mysql query to find which item in a particular > field in a table occurs the most frequently? > >

AW: [PHP-DB] SELECT problem (2)

look at your produced HTML-Code. it may produce something like I#M not sure if this is what you wanted to produce echo(""); this would be more suitable -Ursprungliche Nachricht- Von: Julio Cuz, Jr. [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 22. Februar 2001 22:36 An: [EMAIL PR

[PHP-DB] Variables

Hi-- I know there is a tutorial out there that shows you how NOT TO LOSE any variable values if your browser does a refresh or a reload. Please assist. For example, if a user fills out fields 1, 2, and 3, but on field 4 the browser is forced to do a reload, data for fields 1-3 should be there

Re: [PHP-DB] How can I use Oracle V8 on PHP for Win NT version 4?

Was oci8 (interbase also) included when PHP was configured? I'm not sure for the windows version of PHP but on unix mysql is configured in by default but not oci8. You could try chcking what is configured by using the phpinfo() function. Wayne On Fri, 23 Feb 2001 07:01, KOM Justin wrote: > Hi

[PHP-DB] HELP - French Accent with OCI

Hi, I'm using OCI calls to connect on a Oracle 8 database on a Unix system. Whenever I send characters with accents in my SQL query they get converted to an other one. It would seems like the characters would get converted from a 8 bit to a 7 bit character set.. When I send SQL queries

RE: [PHP-DB] Redirect command?

if ( $x==true) { print "\n"; print "window.open('b.php','_self');\n"; print "\n"; die; } > -Original Message- > From: Julio Cuz, Jr. [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 22, 2001 3:23 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Redirect command? > >

RE: [PHP-DB] Redirect command?

header ("Location: http://www.php.net"); /* Redirect browser -Original Message- From: Julio Cuz, Jr. [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 4:23 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Redirect command? Hi-- I've been looking for a "redirect" command (basicall

[PHP-DB] Redirect command?

Hi-- I've been looking for a "redirect" command (basically redirect from page a to page b if something happens)... Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands

RE: [PHP-DB] SELECT problem (2)

You probably want this.options[this.selectedIndex].value > -Original Message- > From: Julio Cuz, Jr. [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 22, 2001 2:36 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] SELECT problem (2) > > > Hi-- > > Sorry, I forgot to finish the pr

[PHP-DB] SELECT problem (2)

Hi-- Sorry, I forgot to finish the previous e-mail: What's wrong with this line? echo(""); I'm trying to RELOAD the current page with the new value of "$campus" after the user selects a campus from a drop-down menu. But I can't get the "this.value" line to pass the value of "$campus" to the

[PHP-DB] SELECT problem

Hi-- What's wrong with this line of code? echo(""); Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED]

[PHP-DB] Re: All mysql.sock error help requests

I just made a php module with mysql support and had the couldn't connect to /var/lib/mysql/mysql.sock problem. Not looking at the basics as the RedHat 7 did the mysql install I figured it was more in mysql or php config. I checked out the archive for this list and found a fair number of people wit

[PHP-DB] How can I use Oracle V8 on PHP for Win NT version 4?

Hi, I've followed all the indications contained in section 10.51 of PHP official manual but I did not succeed. This is the message I have: Fatal error: Call to undefined function: ocilogon() in C:\InetPub\wwwroot\php\helloworld.php on line 24 In the mean time, every thing is going perfectly fo

Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX

Actually, if I had ftp'd the files I probably would have used ascii (*probably*). I used an SMB mount to copy the files. Never crossed my mind that CRLF would be an issue. Rarely is anymore, but... Wanted to let the world know there's an easy way to convert files with vi. Wish I know how to d

Re: [PHP-DB] next & previous record

I don't know about "Cursors" but I think you can use the same approach we discussed on navigate record by record, " retrieval of NEXT, PREV records" was the subject. If set an order by clause and search for the first record you can use a where clause like this : ... $current = $row["field"] ; //

[PHP-DB] HELP!!! Troubles with Oracle

Please, I´m having a big problem to bring cursor from Oracle. I have no troubles using statics queries, but when i use dynamic queries (dbms_sql) with array occurs the follow error mensage: Warning: failed to rollback outstanding transactions!: ORA-01041: internal error. hostdef extension

Re: [PHP-DB] next & previous record

Keep a counter of the rows you have fetched. so when you want to go back call mysql_data_seek ($Result, Counter-1); then mysql_fetch and you've got the previous row. Lennin Arriola [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [E

RE: Re: [PHP-DB] Most Occurring

BDY.RTF -- 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]

Re: [PHP-DB] Most Occurring

you mean the "mode". I'm afraid you'll have to do it by hand. Other databases do have functions for a couple of statistics measures( though not sure the mode is included), but MYSQL doesn't. Lennin Arriola [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX

If you ftp'ed your file as binary, then the CRLF would not work correctly. Try ftp'ing as ascii next time and you shouldn't have to go through the extra steps on unix. Peter J. Krawetzky -Original Message- From: Joe Brown <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date:

RE: [PHP-DB] next & previous record

You want to use Cursors, and I don't believe MySQL supports cursors yet, although I could be wrong. Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinksw.com > -Ori

Re: [PHP-DB] pgsql performance

Hi Cameron, One thing you may want to try is the -F tag on startup this disables disk syncs but is mostly benificial for writes, versus reads. Also remember that alot of PgSQL's speed benefits become aparent with large numbers of concurrent users. Jeff On Tue, 6 Feb 2001, Cameron wrote: > whi

Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX

I had a similar problem. Worked up a tnsnames.ora file on windoz machines. Thought it would be no big deal if it was copied over to linux and used. But there is a big deal.. Oracle can't handle the character sequence, in a unix environment. Go figure... There used to be a dos2unix program ly

Re: [PHP-DB] next & previous record

I was not refering pagination. suppossing there are these 3 records ABC DEF GHI LJK now a search is done by entering D, which using like & %, and limit would return the record DEF. The "next" would forward to GHI and "previous" would backward to ABC. any idea? thanks. - Original Message

FW: [PHP-DB] next & previous record

> Check this link out... > http://www.oreillynet.com/pub/a/php/2000/11/02/next_previous.html?page > =1 > > It's about Next/previous links... > > It does work, but I've yet to get to get it to work completely with > displaying the records (rows) and the links at the same time... > > It just take

[PHP-DB] MySQL execution order...

I sent this message to the "general" list yesterday, and have yet to get an answer (except for that Spanish "Snow White" virus attempt from Peru). I'm trying to download info from a table as a tab-delimted text file. This part works fine. (By disabling the UPDATE statement in the code sample belo

[PHP-DB] next & previous record

hi all, need to implement record scrolling, one at a time -either forward or backward, on MySQL. The key is a char (32) containing part numbers. anyone has done this before? thanks in advance. dreamvale -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTEC

[PHP-DB] Most Occurring

Is there anyway with a mysql query to find which item in a particular field in a table occurs the most frequently? ie: table things field morethings item1 item2 item1 item1 I would like a query that runs and pulls whatever occurs the most. In this case "item1" Thanks in advance -- PHP D

RE: [PHP-DB] MySQL database transfer

> and how would you move an entire database from a windows environment > to a linux environment? mysqldump db_name > c:/db.sql from the command prompt M@ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTE

Re: [PHP-DB] MySQL database transfer

and how would you move an entire database from a windows environment to a linux environment? I've tried copying my database to disk, from the data folder in windows, and then moved it to the var/lib/mysql folder in Linux, however mysql is unable to find the database tables, when I try to open up

RE: [PHP-DB] Can PHP read View in stead of Table?

Peter. It is not a bug in OpenLink's driver but in PHP - odbc_connect is setting a cursor by default when you connect. This is usually fine, but a cursor needs a primary key. If no primary key exists, there will be a problem. This of course will always be a problem with views, as running a curs

Re: [PHP-DB] php/mysql

On Wed, Feb 21, 2001 at 10:58:27PM +0100, Ramiro Radjiman wrote: > the following code repeats saying ERORR : cannot execute query. > if i delete the text IF NOT EXISTS al goes good. > I don't understand why. Check the version of mysql you are using. From the manual: In MySQL Version 3.23 or late

Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX

I appears that PHP does not know about the paths for Oracle. I am only guessing at this because I haven't installed Oracle on a Linux/Apache box but I think Apache is not aware of the Oracle paths that are required. You might need to recompile Apache with the appropriate configuration parameters

Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX

Hi All Oracle is installed on SCO UnixWare Client that I use to connect on Windows 98 env variables ORACLE_HOME, TNS_ADMIN for client is correctly defined by the way I created ODBC source for my ORACLE connection and tested it. Then I tryed to connect using PHP's odbc_connect and have the same pro

Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX

Make sure your tnsnames.ora file is setup correctly and that your environment variables are setup correctly. What OS are you using on the machine that Oracle is installed on? Peter J. Krawetzky -Original Message- From: Vlad <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Da

Re: [PHP-DB] authentication in a browsing directory

Ok .. Upon success, read the current directory and create links to each file on the fly "readdir()". That should even give the chance to customize your directory listing ..!! Baher -- >From: Helmut Tessarek <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: [PHP-DB] authent

[PHP-DB] ORA-12154: TNS:could not resolve service name in XXX

Hello All I have some problems connecting ORACLe from my php script. connection string: $conn = OCILogon("asu", "asu", "asu"); failed with ORA-12154: TNS:could not resolve service name in XXX Regards, Vlad e-mail: [EMAIL PROTECTED] IóQ: 1042225964 -- PHP Database Mailing List (http://www.

Re: [PHP-DB] nl2br()

Look for "nl2br()" on the php manual. There is more information there. Any way you can store text fields as the user has typed it in, when you are about to show them what they wrote you get text from database and apply the function on the result before put it in a html tag. select * ... ... $tex