Re: [PHP-DB] problems with require...

2001-02-15 Thread Joe Brown
Try using the full path to your include or require file... see if that works. inlude("D:\Inetpub\paulberry\press.inc"); The include_path is a list of directories where php should expect to find files. Yours appears to be empty. Edit your php.ini to change this. I don't remember if the curren

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

2001-02-22 Thread Joe Brown
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] ORA-12154: TNS:could not resolve service name in XXX

2001-02-22 Thread Joe Brown
$[EMAIL PROTECTED]">news:000c01c09cf2$c00a8ef0$[EMAIL PROTECTED]... > 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. Krawe

Re: [PHP-DB] OCI 8 and rowid cause SIGSEGV

2001-02-23 Thread Joe Brown
I suppose the authors never concieved a replacement parameter for select specification. try: > $sql = "select foo, bar, rid from masterdata WHERE rid=:rid" You need to loose the colon ":" or place it to the right of a where clause. <[EMAIL PROTECTED]> wrote in message F114C0EF28F3D211B7E8400061

Re: [PHP-DB] OCI 8 and rowid cause SIGSEGV

2001-02-24 Thread Joe Brown
The the colon has special meaning. Look up the OCI man page, specifically - look up the OCIBindByName function. http://www.php.net/manual/en/ref.oci8.php It may give you a hint for the use of the colon and it's use in positioning bound variables. -- Without knowing your table structure and how

Re: [PHP-DB] deleting carts

2001-02-24 Thread Joe Brown
Although it is probably easiest for you to manage this with php, It makes more sense to me to write a script that is managed by cron (php if you really want) that is executed on a regular basis w/out affecting any users browser latency. If each customer has to wait a little longer, you're going t

Re: [PHP-DB] Server side or client side?

2001-02-24 Thread Joe Brown
Don't complicate it... Just enclose your list entries in ${entry} and use another page if you want... Or loop back to the same page and check if(empty($id)) {show the first list... ${entry} ...} else { show the second list} ""Sridhar Ranganathan"" <[EMAIL PROTECTED]> wrote in message [EMAIL P

Re: [PHP-DB] Oracle 8i questions

2001-02-26 Thread Joe Brown
":body" in sql isn't the same as ":bodytext" in the bindbyname statement, after that, you're in deeper than myself... HTH, -Joe ""Chris Murtland"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I apologize for my cross-post, but since I received no response on

Re: [PHP-DB] Fatal error: Call to undefined function: () in add2.php on line 11

2001-02-26 Thread Joe Brown
back to the drawing board... Re-compile php --with-mysql ""jim and lois flaherty"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > help , I have this problem > >I have redhat 7.0 >mysql 3.23 >and php-mysql rpm installed > > my code > > > >

Re: [PHP-DB] md5

2001-02-27 Thread Joe Brown
You are aware that md5() generates a 32 byte character string? Working on the 10 digit password request, have you alotted enough space in your database columns to cater to a 32 byte string (64 for multibyte)? BTW: md5 has eaten everything I've thrown at it ;-) ""bryan"" <[EMAIL PROTECTED]> wrot

Re: [PHP-DB] Resolution detect and redirect

2001-02-27 Thread Joe Brown
This feat will require a java script (not appropriate for php/db). I saw something on a javascript site, perhaps www.webreference.com gl ""Matthew Cothier"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > >Why not just create a table that will resize to any r

Re: [PHP-DB] MySQL join problem

2001-02-27 Thread Joe Brown
I doubt that a few thousand records would be more than mysql is capable of handeling. However my ignorance of Mysql is abundant. Does it use the /tmp directory and is your /tmp or root partition small? (guessing linux here). Does mysql use the /tmp directory for temporary tables? (Answer in Read

Re: [PHP-DB] Can't connect to local MySQL server error

2001-02-27 Thread Joe Brown
Heh, hate this gotcha... The file permissions are good... ok, now check each directory up to mysql.loc /var /var/lib /var/lib/mysql Does the world have read and execute perms on all of the above (hehe made a funny)? Without read and execute perms on the parent directories, the world cannot see t

Re: [PHP-DB] How would you have liked to have invested in Yahoo when it was still a year old?

2001-03-01 Thread Joe Brown
Excuse me for my lack of understanding, but what does this have to do with php or databases? "Jess Ragaza" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > or eBay? Well, I missed it too. Now we all have the > great opportunity not only to relive it but also to

Re: [PHP-DB] php 3 vs. 4

2001-03-02 Thread Joe Brown
Nope, session management was added in php4. The phplib project among other things, provides a session management mechanisim. ""Free Beachler"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > is there any support for session mgmt in php3? > > my client is tryin

[PHP-DB] Javascript diabled? (was Re: [PHP-DB] onMouseOver & onMouseOut)

2001-03-02 Thread Joe Brown
Curious. I disabled javascript in IE 5.5 Out of the limited scripting I use on my site, the navigate to first entry field nolonger works, but the onchange() event seems to be firing still... Go figure. "Ron Brogden" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]

Re: [PHP-DB] Oracle Function Calls

2001-03-07 Thread Joe Brown
this chunk of code comes out of http://www.php.net/manual/en/function.ocinewcursor.php Hope that helps, I havn't gone there (yet). ""Richard S. Crawford"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Ah! My bad! I sent this question out with the wrong s

Re: [PHP-DB] Oracle connection

2001-03-12 Thread Joe Brown
You need to acquire the oracle network drivers for linux, from Oracle. I'm only aware of the ones that come with Oracle for linux, though they may have them bundled seperately. Fight your way through the inconcievably difficult installation process. After defining some environment variables (th

Re: [PHP-DB] broken page

2001-03-12 Thread Joe Brown
I've experienced this behaviour also. My first guess is that there are broken connections to oracle server. Cleaning up the code so that all resources are properly freed seems to have helped. Restart apache to clear the defunct OCIPLogin(s). If it happens again, you're probably not freeing a $s

Re: [PHP-DB] Connecting to Oracle

2001-03-13 Thread Joe Brown
I'm not looking forward to this... Due to circumstances beyond my control, I will be forced into a similar configuration soon. Try putenv("ORACLE_SID=WKDS.world"); If your sqlnet.ora does does not specify .world as the default domain, then that may be the problem. Was your TNSNAMES.ORA file ftp

Re: [PHP-DB] Re: Connecting to Oracle

2001-03-13 Thread Joe Brown
Brian, Thanks for the solution, that is a good one. I imagine you can set the environment variable oracle_sid this way also. ORACLE_SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.68.10.1)(PORT=1521) )(CONNECT_DATA=(SID=TEST))) re: TNSNAMES.ORA It seems to be a fairly common occurence where

Re: [PHP-DB] Javascript and PHP

2001-03-14 Thread Joe Brown
Well, No and Yes. If the form is posted, whichever page that it was posted too will have $HTTP_POST_VARS["text1"] set to whatever was in the textbox. $text1 may also be a global variable, depending on your php.ini settings for register_globals and also variable_order. It took me a while to feel

Re: [PHP-DB] Variable variables ! - help

2001-03-14 Thread Joe Brown
Seems like you need to try curly braces. ${art_nr}_${i} ""Keith Whyman"" <[EMAIL PROTECTED]> wrote in message 024d01c0ac8f$1a6373c0$0b64a8c0@server">news:024d01c0ac8f$1a6373c0$0b64a8c0@server... > > driving me up the bloody wall ! > I'm sure it's something simple ! > This works fine > > > for ($i

Re: [PHP-DB] PHP how to compare?

2001-03-15 Thread Joe Brown
No, two is a more accurate comparison. !== Although for most cases != is sufficient. ""Richard S. Crawford"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > use just one = sign. So, > > if ($PASS != $PASSNOG) {... > > > At 01:41 AM 3/15/01 +0100, Duky wrote: >

Re: [PHP-DB] Retrieving names from second table from id number

2001-03-16 Thread Joe Brown
Hehe, sounds tricky. There's prossibly a more elegant solution, but this one may work, aliasing the master table a few times with different names: SELECT s.*, r1.name, r2.name, r3.name FROM schedule s, ref_master r1, ref_master r2, ref_master r3 WHERE s.ref1_id=r1.id AND s.ref2_id=r2.id AND

Re: [PHP-DB] metabase documentation or samples

2001-03-17 Thread Joe Brown
http://phpclasses.upperdesign.com/browse.html/package/20 To my knowledge, this is the home page for metabase. Manuel has done a wonderful job putting together a documentation and a tutorial. ""Dean Hall"" <[EMAIL PROTECTED]> wrote in message 98usbh$li8$[EMAIL PROTECTED]">news:98usbh$li8$[EMAIL

Re: [PHP-DB] problem with num_rows (OCIRowCount)

2001-03-19 Thread Joe Brown
I believe OICrowcount() only returns the number of affected DML affected rows, ones affected by insert or update. Use two seperate queries, one for the count, then another for the data. "SELECT COUNT(*) FROM yourTable WHERE yourWhereClause" Or read all the records into an array and count 'em as

Re: [PHP-DB] How to display HTML code?

2001-03-19 Thread Joe Brown
try: Home"); ?> ""Osman Omar"" <[EMAIL PROTECTED]> wrote in message 00f901c0b0cf$c99e7da0$da604a2b@sony">news:00f901c0b0cf$c99e7da0$da604a2b@sony... > Hi, > > Suppose I want to display HTML code eg "Home" > > How can I do that in php? > > > -- > PHP Database Mailing List (http://www.php.net/) > To

Re: [PHP-DB] Line breaks in output

2001-03-19 Thread Joe Brown
Better yet, use "" for browsers. Or use Jeff's method but use nl2br function to convert new line to echo nl2br($result); ""JJeffman"" <[EMAIL PROTECTED]> wrote in message 007f01c0b0d8$212e97a0$5bd4d7c8@jjeffman">news:007f01c0b0d8$212e97a0$5bd4d7c8@jjeffman... > Create a variable to concatenate

Re: [PHP-DB] mail() headers

2001-03-19 Thread Joe Brown
I believe mail works completely different on unix. It probably doesn't suffer the same problems, because it's a direct call to an external process. Lookup "sendmail" ""Free Beachler"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Someone else has tested thi

Re: [PHP-DB] Transmitting Arrays

2001-03-21 Thread Joe Brown
hmm... looks like you're trying to use seralize(var_name); with out assigning a value to a holder variable. $holder=seralize($var_name); will probably get you further along. also, try: $var_name=unseralize($holder); for the return trip. same goes for urlencode/decode; though you can do two ste

Re: [PHP-DB] Indexing help

2001-03-27 Thread Joe Brown
Columns used in the WHERE clause is the good identifier for which columns to index. You don't want to index every column you select. Typically adding indexes decreases insert performance. The more indexes the slower inserts operate, because the indexes also must be updated. Adding an index to

Re: [PHP-DB] get_browser()

2001-03-27 Thread Joe Brown
Is it easier to update every web page you code with get_env("HTTP_USER_AGENT") ; or easier to grab a new browser.ini file? ""Simon R Jones"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > hi all > how does everyone feel about the get_browser function?? Is the

Re: [PHP-DB] metabase support

2001-04-02 Thread Joe Brown
I am a little less biased ;-) I think Manuel's Metabase is the bomb. Unfortunatly, so does Windows... Metabase provides some truely wonderful features. On Windows, Metabase with OCI8 my server keep performing illegeal instructions. I think this is a lack of PHP's maturity on Win32, not Metab

Re: [PHP-DB] Validating forms

2001-04-03 Thread Joe Brown
Do both, javascript and server side validation. Javascript can cut down on unnessary page refreshes. Serverside is the only way to guarentee the results, because of the reasons outlined here. Yes, it's more work, but it will provide a better experience for the end surfer. No? -Joe ""B. van O

Re: [PHP-DB] Oracle vs MS SQL vs MySQL

2001-04-04 Thread Joe Brown
hehe, cute question. I think for your purposes, MySql is probably most appropriate. After all, if you can get it to do what you need, you can't beat the price of it. Re: Which database is best? This is a very long and convaluted question for which you really need to identify many criteria from

Re: [PHP-DB] Is Sybase supported on Windows?

2001-04-04 Thread Joe Brown
Does anyone else find this question quite funny? MS SQL Server is based on Sybase code purchased from Sybase. Kinda explains why Sybase and MS SQL server use the same extension. - ""Javier Boluda"" <[EMAIL PROTECTED]> wrote in message 00f801c0bcf8$c2cd0020$[EMAIL PROTECTED]">news:00f801c0bcf8$c2

Re: [PHP-DB] ocibindbyname: ORA-01008: not all variables bound

2001-04-05 Thread Joe Brown
Don't have a whole lot of practice with the OCIBindByName function, but I seem to be having success within a recursive select statement. I'm not useing the & operator in my implementation. Don't know if that's a good or a bad thing (yet), but it seems to be functioning properly. The third param

Re: [PHP-DB] Still not - Display data begin with "A"

2001-04-07 Thread Joe Brown
Put the percent symbol inside of the single quotes: $result = mysql_query("SELECT * FROM mydata WHERE name like '$begin%' ",$db); "Naga Sean" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > It still not working > I want to get the result of people with the fir

Re: [PHP-DB] date_format for Oracle

2001-04-11 Thread Joe Brown
Also consider the oracle sql ALTER SESSION SET NLS_DATE_FORMAT='-MM-DD HH24:MI:SS' or whichever format you prefer. This sets the default format returned when selecting a date column. -Joe "Steve Farmer" <[EMAIL PROTECTED]> wrote in message news:p04320402b6fa8a7ffc70@[203.28.219.179]... >

Re: [PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-19 Thread Joe Brown
My solution was almost as elegent... $query="select * from customers"; $queryand=false; if(!empty($f_Account)) { $query.=" WHERE upper(P.Account) like upper('$f_Account')"; $queryand=true; } if(!empty($f_First_Name)) { $query.=($queryand?" AND ":" WHERE ")."upper(p.First_Nam

Re: [PHP-DB] Intialize PHP Module on Windows98

2001-04-30 Thread Joe Brown
Looks like you've got different versions for php and your modules. Since php is the oldest, make sure you have the newer php4isapi.dll and php4ts.dll in the system directory, or wherever you installed them. ""Benny"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED].

Re: [PHP-DB] Executing a PL/SQL Function

2001-04-30 Thread Joe Brown
Does the database user your logging in as have execute permissions for that procedure? "Marcelo Dias de Toledo" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Here is the code: > > $stmt = OCIParse($conn,"BEGIN prontolog.pc_int.pedido(:p_cgc_lweb, > :p_id_clie

Re: [PHP-DB] PHP5 is NOT out yet, but 4.0.5 IS!

2001-05-01 Thread Joe Brown
4.0.5 went through many release candidates. As the bugs were found and corrected new ones and new features were added also. In order to cut a stable 4.0.5 version for general consumption, development was halted at one point, notes continued to be added, to document stuff. If it makes you feel a

Re: [PHP-DB] undefined index

2001-05-01 Thread Joe Brown
I don't think dropping the quotes is the best solution. One might consider dropping the warning level in php.ini, if it is a problem, or use numbered array like mysql_fetch_row() returns. -Joe ""Henning Kilset Pedersen"" <[EMAIL PROTECTED]> wrote in message 000f01c0d251$59b79000$a26547c1@peders

Re: [PHP-DB] Sessions ???

2001-05-02 Thread Joe Brown
For this operation there is dire need for session management. And remember the default variable order EGPCS may cause you trouble if you're sending a put variable across with the same name as a session variable. Session vars take presidence in the global scope. http://localhost/forums/view.php?

Re: [PHP-DB] Sessions ???

2001-05-02 Thread Joe Brown
Doh! I meant there is "NO dire need" ""Joe Brown"" <[EMAIL PROTECTED]> wrote in message 9cp3kv$3hj$[EMAIL PROTECTED]">news:9cp3kv$3hj$[EMAIL PROTECTED]... > For this operation there is dire need for session management. > > And remember the

Re: [PHP-DB] Passing Objects

2001-05-10 Thread Joe Brown
Nope. something like this may get you where you want to go though include("myObjectClassDeclaration"); $myInstance=new myObject; echo "http://blahblah.com/?passedClass=".urlencode(serialize($myInstance)); Then in subsequent pages this should work: include("myObjectClassDeclaration");