[PHP-DB] ocinewcollection recursive call

2003-10-28 Thread Ludnyi Levente
Hello I'm trying to use the OCINewCollection function, but if I don't specify the 'schema' parameter for this function, then I get the 'ocinewcollection(): OCI8 Recursive call!' error message, and the page never appears (I must restart IIS). If I give a typename, that does not exsits on the

[PHP-DB] can PHP give MySQL the missing relational properties?

2003-10-28 Thread Morten Gulbrandsen
MySQL as database for PHP, Hello Programmers, MySQL is performing very fast and runs rock stable under high load, But it is not ANSI SQL compatible. I have an interesting thread about this issue under Newsgroups: comp.databases.theory Subject: Re: Is mySQL a RDBMS? This also contains SQL code

Re: [PHP-DB] can PHP give MySQL the missing relational properties?

2003-10-28 Thread Rasmus Lerdorf
Your question makes very little sense to me. PHP is not a database obviously. Also, MySQL has foreign keys and triggers and it can do cascading actions. So I don't understand what you are talking about. -Rasmus On Tue, 28 Oct 2003, Morten Gulbrandsen wrote: MySQL as database for PHP,

Re: [PHP-DB] can PHP give MySQL the missing relational properties?

2003-10-28 Thread Morten Gulbrandsen
Dear Mr Lerdorf, ON DELETE SET DEFAULT is not implemented, According to my database textbook, The propagate (CASCADE) option for the referentiel triggered action should be specified on the foreign key in the relation corresponding to the multivalued attribute for both on update and on

Re: [PHP-DB] ocinewcollection recursive call

2003-10-28 Thread Christopher Jones
Ludnyi Levente wrote: Hello I'm trying to use the OCINewCollection function, but if I don't specify the 'schema' parameter for this function, then I get the 'ocinewcollection(): OCI8 Recursive call!' error message, and the page never appears (I must restart IIS). If I give a typename, that

[PHP-DB] show data from 2 tables

2003-10-28 Thread ddhull
I am attempting to pull data from 2 tables. My SELECT statement seems ok. But the next line: while ... etc. is giving me an error of Supplied argument is not a valid MySQL result resource.. But this is the way I usually show my data and it works fine when only 1 table is involved. Is there

Re: [PHP-DB] can PHP give MySQL the missing relational properties?

2003-10-28 Thread Tyler Lane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 www.postgresql.org Morten Gulbrandsen wrote: Dear Mr Lerdorf, ON DELETE SET DEFAULT is not implemented, According to my database textbook, The propagate (CASCADE) option for the referentiel triggered action should be specified on the foreign

[PHP-DB] RE: show data from 2 tables

2003-10-28 Thread Jeremy Shovan
Try rewriting your query. It looks to me that you probably have an error in your SQL statement and it only seems fine because you appended the @ to the beginning of the mysql_query() function. I would suggest using a join statement. If(!$result = mysql_query(SELECT orders.orderid,

[PHP-DB] Re: can PHP give MySQL the missing relational properties?

2003-10-28 Thread Justin Patrin
I've written a system which does the delete stuff at least. It deals with the foreign keys for you. (Note that you could easily use the functions in the program for your own uses, that's what it's for.) http://rdbedit.sf.net I ought to put up some screenshots and such, but I have such a hard

[PHP-DB] Help installing phpmysearch

2003-10-28 Thread Joseph Allard
I was trying to install phpmysearch but I get this error instead : On your system must have Curl compiled in PHP! - Please check www.php.net how you can do this. Set in your php.ini allow_call_time_pass_reference to On. Well, the problem is that it already says, ON! So, what is the actual

[PHP-DB] removing space ?

2003-10-28 Thread Larry Sandwick
When I select data from my data base I have spaces on the lead side for example the data that is stored is 33.jpg. Spaces included, exclude the quotes, quotes are example only to show the spaces. I would like to remove these spaces. Is there a way to do this? Can it be done in the

Re: [PHP-DB] removing space ?

2003-10-28 Thread Dan Brunner
Hello. Use ltrim(). $image = ltrim($data-JPG_Name); echo $image; Or use trim() Or http://www.php.net/manual/en/ref.strings.php Dan On Oct 28, 2003, at 4:11 PM, [EMAIL PROTECTED] wrote: When I select data from my data base I have spaces on the lead side for example the data that is

Re: [PHP-DB] removing space ?

2003-10-28 Thread Larry E . Ullman
When I select data from my data base I have spaces on the lead side for example the data that is stored is 33.jpg. Spaces included, exclude the quotes, quotes are example only to show the spaces. I would like to remove these spaces. Is there a way to do this? You can definitely do this and

Re: [PHP-DB] removing space ?

2003-10-28 Thread jeffrey_n_Dyke
there are trim functions in both mysql and php. both they are called the same...trim, ltrim and rtrim. trim takes off both sides, and the r and l take the right and left respectively, but yes, this is possible in the query. http://www.mysql.com/doc/en/String_functions.html php.net/trim

Re: [PHP-DB] removing space ?

2003-10-28 Thread jeffrey_n_Dyke
ahh, yes...but you didn't say mysql...sorrythey all have this function. [EMAIL PROTECTED]

Re: [PHP-DB] removing space ?

2003-10-28 Thread CPT John W. Holmes
From: Larry Sandwick [EMAIL PROTECTED] When I select data from my data base I have spaces on the lead side for example the data that is stored is 33.jpg. Spaces included, exclude the quotes, quotes are example only to show the spaces. I would like to remove these spaces. Is there a

[PHP-DB] PHP2 Forum Crashed

2003-10-28 Thread Joseph Allard
Now, I two seperate problems with two different websites. My PHP2 Forum crashed along with the rest of my website --www.dutchspecialops.com. I called GoDaddy.Com, my host provider and they said that the problem was with us not with their server. However, my web designer insist that it is a parse

Re: [PHP-DB] PHP2 Forum Crashed

2003-10-28 Thread Jim Hunter
Can't help you if you take the site down. It didn't do you any good to post the link if your code is no longer there. Jim ps- I tried to reply directly to you but it seem that Earthlink does not want to accept my e-mails because I am not an EarthLink user. How lame is that!? 550-EarthLink