[PHP-DB] FW: Get The Facts: MySQL Licensing & Pricing

[Daevid Vincent]

 

-Original Message-
From: Monica Kumar [mailto:monica.ku...@oracle.com] 
Sent: Wednesday, November 10, 2010 11:52 AM
To: annou...@lists.mysql.com
Subject: Get The Facts: MySQL Licensing & Pricing

We just posted the following blog entry on Oracle's MySQL Blog:
http://blogs.oracle.com/mysql/2010/11/get_the_facts_mysql_licensing_and_pri
cing.html

Sorry if you are getting a duplicate copy of this since I did post it on 
another email group as well. Want to make sure that everyone sees it.

Regards,
Monica

-- 
MySQL Announce Mailing List
For list archives: http://lists.mysql.com/announce



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] FW: Oracle Finalizes Acquisition of Sun

[Bruno Fajardo]

2010/1/29 listread :
> As an open source product, is the code in the public domain?
>
> If so, what's to prevent someone(s) from using it as a starting point and
> creating YourSQL?

Nothing, that's why some guys created MariaDB -
http://planetmariadb.org/ and
http://askmonty.org/wiki/index.php/MariaDB

Cheers

>
>
> On 1/28/2010 7:16 PM, Eric Lee wrote:
>>
>> hmm, that' true now !!
>>
>> Shall the mysql db become paid software !!
>>
>>
>>
>> Regards,
>> Eric,
>>
>>
>> On Thu, Jan 28, 2010 at 11:44 PM, Bastien Koert  wrote:
>>
>>
>>>
>>> [snip]
>>> [/snip]
>>>
>>> PS We will now proceed to fire some 20,000 employees as they will no
>>> longer be needed.
>>> --
>>>
>>> Bastien
>>>
>>> Cat, the other other white meat
>>>
>>> --
>>> PHP Database Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>>
>>>
>>
>>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] FW: semaphores WAS: [PHP-DB] Automatic logoff

[Richard Quadling]

On 29 January 2010 13:43, listread  wrote:
> Would this support the idea of putting a lock column in the table to be
> locked?  If an admin had cause to go into a table with  a DB gui tool, at
> least he would see the semaphore as a "warning".
>
> The same table would also simplify code and make the sb more portable.
>
> As for speed, you have to query that (those) records to be updated anyway at
> some point - a special lock table would require another query and if it that
> lock table was for ALL the other tables in the system, it would be getting
> more hits than any one table.
>
> This has been very educational for me - thanks for the discussion.
>


You could easily extend this to be table locking. Assuming that the
key is tableid/rowid, then you would need to include logic to handle
tableid/null to indicate the whole table.

Obviously, you can't put a table lock on if another user has a row or
table lock.

It does get a little more messy, but perfectly doable in a single SQL query.

Where you put the lock is pretty much up to you, but the extra columns
have no bearing on the table. They aren't data for that table.

A semaphore table would be small.

You can easily remove all the locks from all the tables/rows simply by
truncating the semaphore table.


The other way around all of this is to not do any locking at all.

Simply log when a row is saved and when you go to save the row include ...

where rows_last_edited_datetime =
the_datetime_I_read_when_I_started_editing_the_row

But I don't like that method. It is first saves wins, rather than locking.




-- 
-
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] FW: Oracle Finalizes Acquisition of Sun

[listread]

As an open source product, is the code in the public domain?

If so, what's to prevent someone(s) from using it as a starting point 
and creating YourSQL?



On 1/28/2010 7:16 PM, Eric Lee wrote:

hmm, that' true now !!

Shall the mysql db become paid software !!



Regards,
Eric,


On Thu, Jan 28, 2010 at 11:44 PM, Bastien Koert  wrote:

   

[snip]
[/snip]

PS We will now proceed to fire some 20,000 employees as they will no
longer be needed.
--

Bastien

Cat, the other other white meat

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


 
   



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] FW: semaphores WAS: [PHP-DB] Automatic logoff

[listread]

On 1/28/2010 3:57 PM, Richard Quadling wrote:

On 28 January 2010 21:38, Daevid Vincent  wrote:
   

An intersting synopsis of "Semaphores". I've done similar things in the
past, but never knew this is what I was doing. LOL. Just like I've built an
uber XML parser/editor and didn't know that I actually built a "Factory".
Ahhh... good old data structures -- they didn't teach these things when
I was in college (20+ years ago).

I particularly found this part interesting as I hadn't considered this,
"What you _DON'T_ do, is see if the lock is already there before trying to
write one. No need and provides the possibility for another user,
using the same code, to be interleaved."  I am assuming (and correct me if
I'm wrong) as you will get a race condition (on a sufficiently large
system) wherein, two users check "is there a directory lock", and the
system responds "No" to each, and then the code attempts to create a
directory. Then one of them gets a lock granted (i.e a directory) and since
'there can be only one' [highlander reference] the other one THINKS they
got the lock (too). Doh!
 

What happens in code depends upon the code.

If the code doesn't test the result of assigning the lock, then there
is no lock.

Every write will overwrite whatever was previously written if all
users use the same code.

And there is the major flaw of distributed or client initiated semaphoring.

It is entirely possible for you to open up your DB gui tool and amend
the data. Completely bypassing the semaphoring.
   

>>>
Would this support the idea of putting a lock column in the table to be 
locked?  If an admin had cause to go into a table with  a DB gui tool, 
at least he would see the semaphore as a "warning".


The same table would also simplify code and make the sb more portable.

As for speed, you have to query that (those) records to be updated 
anyway at some point - a special lock table would require another query 
and if it that lock table was for ALL the other tables in the system, it 
would be getting more hits than any one table.


This has been very educational for me - thanks for the discussion.

- Ron
>>>


So, whilst semaphoring is really useful for long edits, it isn't perfect.

But as long as all code use the same semaphoring logic, then it is fine.

   

The wiki page is also interesting and I'd always heard these terms, but
never really knew what they were in a practical sense: "A mutex is a binary
semaphore that usually incorporates extra features, such as ownership,
priority inversion protection or recursivity. The differences between
mutexes and semaphores are operating system dependent, though mutexes are
implemented by specialized and faster routines. Mutexes are meant to be
used for mutual exclusion (post/release operation is restricted to thread
which called pend/acquire) only and binary semaphores are meant to be used
for event notification (post-ability from any thread) and mutual exclusion.
Events are also sometimes called event semaphores and are used for event
notification."

And this also helped to clarify:
http://stackoverflow.com/questions/62814/difference-between-binary-semaphor
e-and-mutex

 

Ha! Toilets.



   



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] FW: Oracle Finalizes Acquisition of Sun

[Eric Lee]

hmm, that' true now !!

Shall the mysql db become paid software !!



Regards,
Eric,


On Thu, Jan 28, 2010 at 11:44 PM, Bastien Koert  wrote:

> [snip]
> [/snip]
>
> PS We will now proceed to fire some 20,000 employees as they will no
> longer be needed.
> --
>
> Bastien
>
> Cat, the other other white meat
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

Re: [PHP-DB] FW: semaphores WAS: [PHP-DB] Automatic logoff

[Richard Quadling]

On 28 January 2010 21:38, Daevid Vincent  wrote:
> An intersting synopsis of "Semaphores". I've done similar things in the
> past, but never knew this is what I was doing. LOL. Just like I've built an
> uber XML parser/editor and didn't know that I actually built a "Factory".
> Ahhh... good old data structures -- they didn't teach these things when
> I was in college (20+ years ago).
>
> I particularly found this part interesting as I hadn't considered this,
> "What you _DON'T_ do, is see if the lock is already there before trying to
> write one. No need and provides the possibility for another user,
> using the same code, to be interleaved."  I am assuming (and correct me if
> I'm wrong) as you will get a race condition (on a sufficiently large
> system) wherein, two users check "is there a directory lock", and the
> system responds "No" to each, and then the code attempts to create a
> directory. Then one of them gets a lock granted (i.e a directory) and since
> 'there can be only one' [highlander reference] the other one THINKS they
> got the lock (too). Doh!

What happens in code depends upon the code.

If the code doesn't test the result of assigning the lock, then there
is no lock.

Every write will overwrite whatever was previously written if all
users use the same code.

And there is the major flaw of distributed or client initiated semaphoring.

It is entirely possible for you to open up your DB gui tool and amend
the data. Completely bypassing the semaphoring.

So, whilst semaphoring is really useful for long edits, it isn't perfect.

But as long as all code use the same semaphoring logic, then it is fine.

> The wiki page is also interesting and I'd always heard these terms, but
> never really knew what they were in a practical sense: "A mutex is a binary
> semaphore that usually incorporates extra features, such as ownership,
> priority inversion protection or recursivity. The differences between
> mutexes and semaphores are operating system dependent, though mutexes are
> implemented by specialized and faster routines. Mutexes are meant to be
> used for mutual exclusion (post/release operation is restricted to thread
> which called pend/acquire) only and binary semaphores are meant to be used
> for event notification (post-ability from any thread) and mutual exclusion.
> Events are also sometimes called event semaphores and are used for event
> notification."
>
> And this also helped to clarify:
> http://stackoverflow.com/questions/62814/difference-between-binary-semaphor
> e-and-mutex
>

Ha! Toilets.



-- 
-
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW: semaphores WAS: [PHP-DB] Automatic logoff

[Daevid Vincent]

 

> -Original Message-
> From: Richard Quadling [mailto:rquadl...@googlemail.com] 
> Sent: Thursday, January 28, 2010 3:48 AM
> To: listread
> Cc: php-db@lists.php.net
> Subject: Re: [PHP-DB] Automatic logoff
> 
> On 27 January 2010 17:20, listread  wrote:
> > Richard,
> >
> > I think I need to learn about semaphores!  Any suggestions 
> for a good
> > tutorial?
> >
> > One of the things we want to do is exclude locked records 
> from a query.
> >  Will semaphores provide for that?
> >
> > Thanks!
> >
> > - Ron
> >
> >
> >
> >
> > On 1/27/2010 8:14 AM, Richard Quadling wrote:
> >>
> >> The technique I've used in the past is semaphore locking, where the
> >> semaphore contains the session and the expected expiry time.
> >>
> >> Follow this.
> >>
> >> User a starts the process of editing a record.
> >> Set the semaphore where there is :
> >>   a - no existing semaphore - no ongoing edits.
> >>   b - the semaphore's session is the same - repeat edits 
> by this user
> >> in the same session (expired or otherwise).
> >>   c - the semaphore has expired - the other user simply 
> took too long.
> >>
> >> If the semaphore cannot be set it will be because of :
> >>   d - Different non expired session - someone else is 
> editing the record.
> >>
> >> When a user saves the row, you just remove the semaphore.
> >>
> >> The semaphores could be in a separate table (rather than 
> on the record
> >> itself).
> >>
> >> Different tables have different number of columns so take different
> >> amounts of time to edit, so each table would have a 
> different amount
> >> of time from edit to expiry.
> >>
> >> An entry on a lookup table (just a description) should, in 
> the main,
> >> be completed within 30 seconds.
> >>
> >> But a detail line for a purchase order may take several minutes.
> >>
> >> You'll have to tune this to your own needs.
> >>
> >>
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> 
> A "semaphore" is just a flag. Nothing else. You can implement it in
> any way you like as long as _ALL_ code related to locking uses the
> semaphores.
> 
> A common technique for "locking" files is to create a folder 
> called filename.lck
> 
> A directory can only exist or not.
> 
> You try to create the directory. If you did, you got the lock. If not,
> someone else has.
> 
> The same approach should be used for DB locking in this manner.
> 
> You try to place the lock (with the conditions defined in the WHERE
> clause under which it should succeed). If the lock doesn't get
> written, then you don't have it.
> 
> What you _DON'T_ do, is see if the lock is already there before trying
> to write one. No need and provides the possibility for another user,
> using the same code, to be interleaved.
> 
> Also, no need for transactions at this stage too.
> 
> You put the lock on (if you are allowed to). Now you can edit and
> re-edit the row until you've finished.
> 
> This technique is described quite well in
> http://en.wikipedia.org/wiki/Semaphore_(programming)
> 
> One of the important aspects to using semaphores is that the process
> to set (and either succeed or fail) must not be interrupted, hence why
> you don't try to read the presence of the lock before setting it.
> 
> I hope that helps some.
> 
> I used to develop using an old DOS based 4GL called Sage Retrieve 4GL
> (prior to that it was called Sage Skybase). This uses a modified
> D-ISAM db structure and semaphores for locking. You'd try to lock a
> record and process the failure. Quite easy really.
> 
> By extending this concept to include an expiry time within the lock,
> you've got your auto-unlock feature written.
> 
> 
> -- 
> -
> Richard Quadling

An intersting synopsis of "Semaphores". I've done similar things in the
past, but never knew this is what I was doing. LOL. Just like I've built an
uber XML parser/editor and didn't know that I actually built a "Factory". 
Ahhh... good old data structures -- they didn't teach these things when 
I was in college (20+ years ago).

I particularly found this part interesting as I hadn't considered this,
"What you _DON'T_ do, is see if the lock is already there before trying to
write one. No need and provides the possibility for another user,
using the same code, to be interleaved."  I am assuming (and correct me if
I'm wrong) as you will get a race condition (on a sufficiently large
system) wherein, two users check "is there a directory lock", and the
system responds "No" to each, and then the code attempts to create a
directory. Then one of them gets a lock granted (i.e a directory) and since
'there can be only one' [highlander reference] the other one THINKS they
got the lock (too). Doh!

The wiki page is also interesting and I'd always heard these terms, but
never really knew what they were in a practical sense: "A mutex is a binary
semaphore that usually incorporates extra features, such as ownership,
priority inversion pr

Re: [PHP-DB] FW: Oracle Finalizes Acquisition of Sun

[Bastien Koert]

[snip]
[/snip]

PS We will now proceed to fire some 20,000 employees as they will no
longer be needed.
-- 

Bastien

Cat, the other other white meat

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW: Oracle Finalizes Acquisition of Sun

[Daevid Vincent]

To ensure delivery directly to your inbox please add
repl...@oracle-mail.com to your address book today.

 Oracle Corporation
  



    

We are pleased to announce that Oracle has completed its acquisition of Sun
Microsystems and Sun is now a wholly owned subsidiary of Oracle. With this
news, we want to reiterate our commitment to deliver complete, open and
integrated systems that help our customers improve the performance,
reliability and security of their IT infrastructure. We would also like to
thank the many customers that have supported us throughout the acquisition
process.

There is no doubt that this combination transforms the IT industry. With
the addition of servers, storage, SPARC processors, the Solaris operating
system, Java, and the MySQL database to Oracle's portfolio of database,
middleware, and business and industry applications, we plan to engineer and
deliver open and integrated systems - from applications to disk - where all
the pieces fit and work together out of the box. 

Performance levels will be unmatched. Oracle's software already runs faster
on Sun SPARC/Solaris than on any other server or operating system. With Sun
as a part of Oracle, each layer of the stack will be engineered to further
improve performance, reliability and manageability so that IT will be more
predictable, more supportable, and more secure. Customers will benefit as
their system performance goes up and their system integration and
management costs go down. 

In addition, our open standards-based technology will give customers
choice. Customers can purchase our fully integrated systems, or easily
integrate our best-of-breed technologies with their existing environments.
Our open technology also enables customers to take full advantage of third
party innovations. Oracle also plans to extend its partner specialization
program to include Sun technologies to better enable partners to deliver
differentiated and value-added solutions to customers.

As always, our primary goal is 100% customer satisfaction. We are dedicated
to delivering without interruption the quality of support and service that
you have come to expect from Oracle and Sun, and more. Oracle plans to
enhance Sun customer support by improving support access, offering better
interoperability support between Oracle and Sun products and delivering
services in more local languages. Support procedures for your existing Sun
and Oracle products are unchanged, so for now you should continue to use
the same channels you've been using. Customers can continue to purchase
products from Sun in the same way they did prior to the acquisition. We
will communicate any changes to this through regular channels.

We are very excited about this combination and look forward to delivering
to you increased innovation through accelerated investment in Sun's
hardware and software technologies such as SPARC, Solaris, Java, and MySQL.
If you weren't able to join the live event on January 27 where we, along
with Larry Ellison and other executives from Oracle and Sun outlined how
this powerful combination will transform the IT industry, you are welcome
to view the replay that can be accessed at

oracle.com/sun.

Sincerely,


Charles Phillips
President

Safra Catz
President

 

This document is for informational purposes only and may not be
incorporated into a contract or agreement.



  SOFTWARE. HARDWARE. COMPLETE.
 





Copyright C 2010, Oracle. All rights reserved.

 
 Contact Us |
 Legal Notices and Terms of Use |
 Privacy Statement 




Oracle Corporation - Worldwide Headquarters, 500 Oracle Parkway, OPL -
E-mail Services, Redwood Shores, CA 94065, United States 

 

[PHP-DB] FW: Help keep the Internet free -- MySQL petition to EU

[Daevid Vincent]

-Original Message-
From: Michael Widenius [mailto:mo...@askmonty.org] 
Sent: Tuesday, December 29, 2009 5:00 AM
To: my...@lists.mysql.com
Subject: Help keep the Internet free


Hi!

We have just launched a worldwide, multilingual petition at
http://helpmysql.org to get signatures to show the regulators in the
EU and other places that it's important that MySQL continues to be
available and developed as a strong Open Source product for all
database needs.

If you care about the future of MySQL as an Open Source product,
please go and sign the petition and tell others about it!

We are also searching for volunteers that can help us with gathering
names for the petition.  If you have a bit a spare time and think that
MySQL is worth saving, please join us on the #helpmysql IRC channel on
Freenode and help us with spreading the world and gather names!

You can make a real difference, wherever you are in the world! The
more names we are able to get, the higher the chance is that we can
keep MySQL free and available for all!

Don't be fooled by the empty promises Oracle have given about the
future of MySQL.  I examined them in my previous blog post at
http://monty-says.blogspot.com/2009/12/oracle-gives-only-empty-promises-fo
r.html
and showed that Oracle is not really promising anything; Not even that
the Open Source version of MySQL will be developed further.

Thanks to everyone that helped us with the previous campaign. It was
of great help, but probably not enough, which is why we had to start
this new campaign to gather even more names.

This time we will be able to use the names to influence decisions
worldwide (not just in the EU) and we will get more public
attention. This will be far more powerful.

During the previous campaign there was a lot of discussions in
different medias about my incentives for driving it.

I have tried to answer most of these concerns in my latest blogpost:
http://monty-says.blogspot.com/2009/12/help-keep-internet-free.html

Help us keep the Infrastructure of the Internet free!

Regards,
Monty
Creator of MySQL



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Fw: Help me with this someone

[Chris]

Warning: mysql_pconnect() [function.mysql-pconnect]: Lost connection to MySQL 
server during query in /home/www/broadwaysecure.biz.nf/Index.php on line 9
Could not connect : Lost connection to MySQL server during query


What's line 9? You haven't sent 9 lines of code.

Also I suggest changing your mysql password, you've just broadcast it to 
the world. The mailing list is automatically archived in several places 
which all search engines have access to.



$broadway = mysql_pconnect("82.197.130.17", "218708_accounts", "sanity", false, 2) or 
die("Could not connect : " . mysql_error());


This is the wrong syntax for pconnect. RTFM:

http://au.php.net/mysql_pconnect

mysql_pconnect  ([ string $server=ini_get("mysql.default_host")  [, 
string $username=ini_get("mysql.default_user")  [, string 
$password=ini_get("mysql.default_password")  [, int $client_flags   )


Get rid of the "FALSE" argument.

--
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Fw: Help me with this someone

[Wilson Osemeilu]

i get the error:
Warning: mysql_pconnect() [function.mysql-pconnect]: Lost connection to MySQL 
server during query in /home/www/broadwaysecure.biz.nf/Index.php on line 9
Could not connect : Lost connection to MySQL server during query
 
 
I have done everything to connect to my database but its not working
this is my database information:
host: fdb1.biz.nf or 82.197.130.17 (pinged and working)
db name: 218708_accounts
pass: ***

the scrip is

 


  

RE: [PHP-DB] FW: Kesalahan posting: Don Komo

[Instruct ICC]

Date: Fri, 12 Oct 2007 11:29:27 -0400
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] FW: Kesalahan posting: Don Komo


Why do I get this everytime I post?

I think Don Komo registered to this PHP list with the private email address 
[EMAIL PROTECTED]
So since we are not a member of the googlegroup, we get these notices.

The same kind of notice that anyone would get if they posted to a list for 
which they had not yet registered.

I think he should be forced to unregister this email address.  And/or be 
advised that it has been dropped for this reason.


_
Peek-a-boo FREE Tricks & Treats for You!
http://www.reallivemoms.com?ocid=TXT_TAGHM&loc=us

[PHP-DB] FW: Kesalahan posting: Don Komo

[VanBuskirk, Patricia]

Why do I get this everytime I post?

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 12, 2007 11:26 AM
To: VanBuskirk, Patricia
Subject: Kesalahan posting: Don Komo

  Anda tidak memiliki izin untuk memposting ke grup donkomo. Anda
mungkin harus bergabung ke grup agar dibolehkan memposting atau grup ini
mungkin tidak dapat terbuka untuk memposting. 

 Kunjungi http://groups.google.com/group/donkomo/about?hl=id untuk
bergabung atau mempelajari lebih lanjut tentang siapa yang dibolehkan
memposting ke grup. 

 Bantuan untuk menggunakan Google Groups juga tersedia di:
 http://groups.google.com/support?hl=id
--- Begin Message ---
The info he was trying to submit was 883 characters, including spaces
(counted in Word).  Many times, people have very detailed descriptions
they need to send in.  Can you think of a way to work around this
limitation?  Also, what happened when he tried to submit is he got an
email back with "Undefined variable" errors wherever the database was
supposed to send back info, and no record was created.

 

From: Bastien Koert [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 12, 2007 11:12 AM
To: VanBuskirk, Patricia; php-db@lists.php.net
Subject: RE: [PHP-DB] php maximum characters in text field

 

Unless you are using a text field (which holds 64K [mysql]) a normal
varchar maxs out at 255 characters
 
Post is limited by the php.ini file amounts (usually in the megabyte
range).
 
what is the size of the post?
 
Bastien

> Date: Fri, 12 Oct 2007 10:41:15 -0400
> From: [EMAIL PROTECTED]
> To: php-db@lists.php.net
> Subject: [PHP-DB] php maximum characters in text field
> 
> Is there a maximum number of character $_POST will/can return from a
> text field. I have an online form that was driving me nuts trying to
> troubleshoot, as most orders were coming in fine, but this one would
> not. I narrowed down to the length of the "customer description" field
> which has no limits on the form or in the database. I was told there
> was a limit to how much $_POST could return. Can someone advise?
> 
> 
> 
> Thanks!
> 
> Trish
> 





Express yourself with free Messenger emoticons. Get them today!
 


--- End Message ---
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Fw: odbc problem

[bedul]

- Original Message -
From: "Chris" <[EMAIL PROTECTED]>
To: "bedul" <[EMAIL PROTECTED]>
Cc: 
Sent: Monday, March 12, 2007 12:00 PM
Subject: Re: [PHP-DB] Fw: odbc problem


> bedul wrote:
> > - Original Message -
> > From: "gunawan" <[EMAIL PROTECTED]>
> > To: 
> > Sent: Monday, March 12, 2007 11:46 AM
> > Subject: odbc problem
> >
> >
> >> i have this warning.. i don't know what the meaning
>
> http://www.php.net/manual/en/function.odbc-error.php
>
> Use the error function and work out what it's complaining about.
>
it return
 Warning: odbc_exec() [function.odbc-exec]: SQL error: [Caché ODBC][State :
S1000][Native Code 400] [C:\ProgramFiles\xampp\apache\bin\apache.exe]
General server error, SQL state S1000 in SQLExecDirect in my script

i don't understand what happen??
apache error?? i already restart the apache

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Fw: odbc problem

[Chris]

bedul wrote:

- Original Message -
From: "gunawan" <[EMAIL PROTECTED]>
To: 
Sent: Monday, March 12, 2007 11:46 AM
Subject: odbc problem



i have this warning.. i don't know what the meaning


http://www.php.net/manual/en/function.odbc-error.php

Use the error function and work out what it's complaining about.


--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Fw: odbc problem

[bedul]

- Original Message -
From: "gunawan" <[EMAIL PROTECTED]>
To: 
Sent: Monday, March 12, 2007 11:46 AM
Subject: odbc problem


> i have this warning.. i don't know what the meaning
> 
> Using odbc_num_fields
>
> Warning: odbc_exec() [function.odbc-exec]: SQL error: [Caché ODBC][State :
> S1000][Native Code 400] [C:\ProgramFiles\xampp\apache\bin\apache.exe]
> General server error, SQL state S1000 in SQLExecDirect in
> C:\dokumen_php\tes\odbc\c-6.php on line 12
> -
>
> this is my script.. i know this is simple..
> 
> Using odbc_num_fields 
> //include "c-config.php";
> $DBname = 'medtrak2'; //'MSAccessDriver'
> $DBuser = "_system";
> $DBpass = "sys";
>
> $con = odbc_connect($DBname, $DBuser, $DBPass);
> if ($con)
> {
>   $txt.= "odbc connected
>  ";
>   $sql =  "select * from PA_Adm";
>   //this function will execute the sql satametn in
>   //correspondance to the table in the db
>  $exec = odbc_exec($con, $sql);
>   //int odbc_num_fields ( resource result_id )
>  $n= odbc_num_fields($exec); //$Query_ID);
>
>  $txt.="\ntotal column=".$n;
> }
>
> //$txt.= readThisFile($filename);
>
> print $txt;
> ?>
>
> ---
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Fw: cara php&asp bisa jalan bareng|how to make asp & php work together

[Bastien Koert]

1. install php, we have both running on our iis servers with no problems

2. you can use either one iis or apache ( my work machine runs several 
servers at once) The trick will be to designate the ports that the servers 
listen on


bastien



From: "bedul" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
CC: ,
Subject: [PHP-DB] Fw: cara php&asp bisa jalan bareng|how to make asp & php 
work together

Date: Fri, 2 Mar 2007 17:17:11 +0700


- Original Message -
From: "gunawan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: ; 
Sent: Friday, March 02, 2007 5:10 PM
Subject: cara php&asp bisa jalan bareng|how to make asp & php work together


> wa kirim ke site english jd harap maklum kl pake bahasa inggris
>
> i have problem to solve.
> my office have only limited budget and only able buy one server and it
only
> asp inside.. the problem is, I want to make that server work for php and
for
> asp which that was already inside (since my office using some aplication
> using asp).
>
> 1.how to make the server able to respon both asp and php.. even thought 
i

> will not touch the asp??
> 2. is better i use apache or iis??
>
> thx for your reply
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



_
Free Alerts : Be smart - let your information find you ! 
http://alerts.live.com/Alerts/Default.aspx


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Fw: cara php&asp bisa jalan bareng|how to make asp & php work together

[bedul]

- Original Message -
From: "gunawan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: ; 
Sent: Friday, March 02, 2007 5:10 PM
Subject: cara php&asp bisa jalan bareng|how to make asp & php work together


> wa kirim ke site english jd harap maklum kl pake bahasa inggris
>
> i have problem to solve.
> my office have only limited budget and only able buy one server and it
only
> asp inside.. the problem is, I want to make that server work for php and
for
> asp which that was already inside (since my office using some aplication
> using asp).
>
> 1.how to make the server able to respon both asp and php.. even thought i
> will not touch the asp??
> 2. is better i use apache or iis??
>
> thx for your reply
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] FW: Excel to CSV

[Nur_Adman]

Thanks a lot for your response.

 

Actually I reposted my message caused there was failure notice from
[EMAIL PROTECTED] when sending my previous email.

 

 

 

-Original Message-
From: chris smith [mailto:[EMAIL PROTECTED] 
Sent: Saturday, March 11, 2006 2:12 PM
To: Adman, Nur anita
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] FW: Excel to CSV

 

> Have you any script/example how to Save As Excel file to CSV using
PHP?

 

You don't need to repost your question if you don't get an immediate
response.

 

Going "file", "save as" is client side. PHP can't interact with excel

like that. Create a VB macro or something to do it.

 

--

Postgresql & php tutorials

http://www.designmagick.com/

Re: [PHP-DB] FW: Excel to CSV

[chris smith]

> Have you any script/example how to Save As Excel file to CSV using PHP?

You don't need to repost your question if you don't get an immediate response.

Going "file", "save as" is client side. PHP can't interact with excel
like that. Create a VB macro or something to do it.

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW: Excel to CSV

[Nur_Adman]

 

Dear All,

 

Have you any script/example how to Save As Excel file to CSV using PHP?

 

Thanks & Regards,

Anita

[PHP-DB] Fw: for help

[Julien Bonastre]

This guy is starting to get to me, I am a busy guy, I did give him some 
pointers, but I just DO not have the time to help and I DO not have the heart 
to say no..


He just wants a basic tutorial site for php beginners etc.. He comes from a 
VB/C++ background..


Thanks a million

- Original Message - 
From: Rajendra Babu dhakal 
To: [EMAIL PROTECTED] 
Sent: Thursday, January 05, 2006 3:50 PM
Subject: for help


HI !
I'm Raaz from Chitwan-Districit,NEPAL. I've already sent you two 
mail. In these mail you've promise to help me as a result i want to be a also 
php programmer for official, funny etc expects. I'm able to connect by use php 
making dsn and also able to present data store in database. but i don't know 
about how to response
1,form
2,set cookies,expires it
and others please help me for more informations

sincerely yours
Raaz Sharma   






Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, 
whatever.

[PHP-DB] FW: write to file, difficulty inputting data

[mayo]

SORRY everyone, posted to wrong list
 
 
I'm writing customer orders into a file. I'm 
 
1. getting data from session variables and a database,
2. putting it into a variable called $fileContent
3. then touch($filename);
4. then writing $fileContent to $filename - the code is at the bottom
 
The test versions of this have all gone well.
 
The file must contain the data in a preset format. All the data is on
one line (no line breaks) and each field has a preset limit, The file is
FTPed and the data parsed.
 
So far so good. It works with one customer order
 
Now when I want to write multiple customer orders it doesn't work?
Abbreviated code is below
 
// CODE FOR MULTIPLE ORDERS
 
while($row = mysql_fetch_array( $result ))
{
 
$theItemID=$row["orderedItems.itemID"];
$theItemPrice=$row["itemPrice"];
$theItemQty=$row["itemQty"];
 
$thisItemID= sprintf("% 6d",$theItemID);
$thisItemPrice= sprintf("%7.2f",$theItemPrice);
$thisItemQty= sprintf("% 7d",$theItemQty);
 
$moreContent=
 
"\n" .
"20" .
$thisOrder .
 
$thisItemID .
 
$thisItemPrice .
 
$thisItemQty . "\n";
 
}
//END CODE
 
// CODE BELOW IS FOR WRITE TO FILE
 
// Make sure the file exists and is writable first.
if (is_writable($filename)) {
 
// Open $filename in write mode.
 
if (!$handle = fopen($filename, 'w')) {
 echo "Cannot open file ($filename)";
 exit;
}
 
// Write $fileContent to opened file.
if (fwrite($handle, $fileContent) === FALSE) {
echo "Cannot write to file ($filename)";
exit;
}
 
fclose($handle);

[PHP-DB] Fw: [PHP-ES] crc32 en PHP y VisualFox

[Eduardo Cortés]

PRUEBA CON ESTO



Returns 59278a3
Witch is missing a leading zero.



Returns the correct string: 059278a3 
AttE :
-
Eduardo Cortés C.
Ingeniero Informático
-
Empresas Verschae M.R
-
TEL : 032 - 267326  
-
- Original Message - 
From: Eduardo Cortés 
To: Leonel Quinteros 
Sent: Tuesday, October 05, 2004 5:52 PM
Subject: Re: [PHP-ES] crc32 en PHP y VisualFox


HOLA LEONEL

MIRA TE QUERIA HACER UNA CONSULTA

YO IGUAL TRABAJO EN FOXPRO Y RECIEN ESTOY IMPLEMENTANDO

CONSULTAS VIA WEB CON PHP, PERO ME ENCONTRATO CON EL PROBLEMA

DE QUE AÚN NO PUEDO ACCEDER A LAS TABLAS LIBRES 

COMO LO HACES???

DE ANTE MANO MUCHAS GRACIAS
AttE :
-
Eduardo Cortés C.
Ingeniero Informático
-
Empresas Verschae M.R
-
TEL : 032 - 267326  
-
  - Original Message - 
  From: Leonel Quinteros 
  To: [EMAIL PROTECTED] 
  Sent: Tuesday, October 05, 2004 5:15 PM
  Subject: [PHP-ES] crc32 en PHP y VisualFox


  Hola lista, tengo un sistema hecho en Visual Fox para mantener actualizados 
datos en una sucursal y en otra, estoy implementando ahora lo mismo, pero en PHP y me 
encuentro con que tengo que modificar la forma en que la integridad de los datos se 
validan. 
  El tema es que encuentro en Visual Fox, la función para calcular el crc32 
(polinomio de comprobación de reduncancia cíclica de 32 bits), supuestamente el mismo 
que otorga la funcion crc32() de PHP y entonces me pongo a probar y me encuentro que 
con cadenas cortitas los resultados son los mismos, pero cuando supero los 9 
caracteres, me devuelven valores distintos y no entiendo por qué. 
  El primer detalle que observé es que cuando empieza a diferir el valor devuelto, 
en PHP siempre es negativo, mientras que el de Visual Fox sigue siempre siendo 
positivo... será que estoy errando al momento de mostrar el valor o me falta tener 
algo en cuenta?? alguna idea de algo?? será del Visual Fox??

  el código con el que lo hago en PHP es:

  

  que me devuelve: 
  -694980236

  y en Visual Fox lo hago asi (por si alguno usa VFP nomas):

  ? Sys(2007, "holaquetalcomoestas", 0, 1)

  que me devuelve:
  3599987060

  Saludos y gracias

  Leonel

[PHP-DB] // FW Water_foul AW: [PHP-DB] Hi I am new

[Shahed, Raja]

This is a very easy and clear tutorial.The basic of PHP/DB you can learn here.

http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html

Best Regards
Raja shahed



>-Ursprüngliche Nachricht-
>Von: water_foul [mailto:[EMAIL PROTECTED] 
>Gesendet: Samstag, 24. April 2004 05:06
>An: [EMAIL PROTECTED]
>Betreff: [PHP-DB] Hi I am new
>
>
>I am new to databases and php and I was wondering if any one 
>would point me
>to a good guide
>anything would help :)
>thanks in advance,
>water_foul
>
>-- 
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] fw:¤£°eªáªº²z¥Ñ.

[©÷­ô]

> >
> >不送花的理由
> >
> >朋友讀美術系的女友問：
> >「我的生日耶！你怎麼都不送花給我？」
> >「什麼？」讀園藝系的某某竟然說：
> >「你不知道花是植物的生殖器嗎？！我們為什麼要將人家的生殖器割下來，然
> >[EMAIL PROTECTED]
> >
> >這男人真是狠角色..
> >竟然講到那女孩子慚愧地低下頭來.』
> >
> >所以
> >1.有些女生會比較誰收到的生殖器比較多、比較大
> >2.有經驗的女生，會認為未割過包皮的生殖器(含苞的)可以較持久
> >3.女生們會[EMAIL PROTECTED]
的
> >笑容
> > 

 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW: sql bind parameter problem

[Angelo Zanetti]

HI,

I have this error after my database crashed (power failure) but have already
"repaired" the database.

sql bind parameter not used for all parameters.

not sure what the error is. cant find much on the net about this error.
if anyone can give me some info or links, ill appreciate it.

ps: sorry for the off topic post.

Angelo


Disclaimer 
This e-mail transmission contains confidential information,
which is the property of the sender.
The information in this e-mail or attachments thereto is 
intended for the attention and use only of the addressee. 
Should you have received this e-mail in error, please delete 
and destroy it and any attachments thereto immediately. 
Under no circumstances will the Cape Technikon or the sender 
of this e-mail be liable to any party for any direct, indirect, 
special or other consequential damages for any use of this e-mail.
For the detailed e-mail disclaimer please refer to 
http://www.ctech.ac.za/polic or call +27 (0)21 460 3911

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] FW: db design - which is better

[webmaster]

> There just seems to be times when non-normalized table structures are
easier
> to work with.

There are times when de-normalizing is acceptable.  One of the more common
uses of denormalized data is in data warehousing.  Such as pre-summing
sales, and storing pre-calculated aggregate information to relieve the db of
doing heavy or complex calculations when summary data is going to be queried
on a frequent basis.

Often php-based message boards will use columns of pre-sumed data as part of
a "normal" table (for example, a count of total user posts stored in the
user table, that is incremented/decremented when a user adds/deletes a post,
or the total number posts in a given thread stored in the topic table).
This helps to allieviate the need for a count() whenever a message thread is
built and you want to show the number of posts each user in the thread has,
etc.

So there are some acceptable situations :)

Cheers,
Keith.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] FW: db design - which is better

[mayo]

Yeah,

I think it's just the devil sending me strange thoughts. :-)

It does sound dumb to have normalized tables AND to duplicate some of the
data in another table.

thx,

just tossing off some ideas.

-- gil




 > -Original Message-
 > From: Ignatius Reilly [mailto:[EMAIL PROTECTED]
 > Sent: Saturday, February 07, 2004 6:31 PM
 > To: mayo; php-db
 > Subject: Re: [PHP-DB] FW: db design - which is better
 >
 >
 > Hmmm...
 >
 > What of maintenance?
 > One day your pointed-headed boss asks you to add a "civility" field
 > (Mr|Mrs|Colonel|...), a birthdate, etc.
 > How do you do that with a 1-table design? You will have to create 1-NF
 > temporary tables in the process...
 >
 > How do you search for an author? You will have to create a
 > needlessly large
 > and inefficient index on (LastName + FirstName), instead of a
 > nice integer
 > index.
 >
 > And when querying the articleID, I do not think that there should be a
 > significant performance penalty, if your indexes are properly designed.
 >
 > cheers
 >
 > Ignatius
 > _
 > - Original Message -
 > From: "mayo" <[EMAIL PROTECTED]>
 > To: "php-db" <[EMAIL PROTECTED]>
 > Sent: Sunday, February 08, 2004 00:10
 > Subject: RE: [PHP-DB] FW: db design - which is better
 >
 >
 > > Let's say you have a page that is hit fairly frequently and
 > spits out 100s
 > > of results.
 > >
 > > On it you have articleTitle, authorFName, authorLName.
 > >
 > > I ran a few tests and found that if all the above fields are
 > in one table
 > it
 > > gets processed quicker than if there's a join. (authorID ->
 > authorFName,
 > > authorLName)
 > >
 > > So, I'm beginning to think that processing time would be quicker if I
 > insert
 > > authorFName and authorLName into 2 tables. One the author table and the
 > > other the *VERY* frequently hit article table.
 > >
 > > That way when someone wants a list of articles, author FName,
 > author LName
 > > all the data comes from one table.
 > >
 > > This would be probably very stupid in a financial or medical database
 > which
 > > has tens of millions of records and 100s if not 1000s of
 > tables but SEEMS
 > > (I'm very open to being corrected) to work better on a fairly small web
 > > accessed database.
 > >
 > > yours,
 > >
 > > Gil
 > >
 > >
 > >
 > >
 > >
 > >
 > >
 > >
 > >
 > >  > -Original Message-
 > >  > From: Ignatius Reilly [mailto:[EMAIL PROTECTED]
 > >  > Sent: Saturday, February 07, 2004 6:01 PM
 > >  > To: mayo; php-db
 > >  > Subject: Re: [PHP-DB] FW: db design - which is better
 > >  >
 > >  >
 > >  > There are perhaps such times, but I have yet to meet one.
 > >  >
 > >  > with 1NF:
 > >  > - your table space will be smaller
 > >  > - your indexes will work better
 > >  > - your SQL will be easier to write
 > >  > - ease of maintenance
 > >  >
 > >  > Just my 2 Belgian francs
 > >  >
 > >  > Ignatius
 > >  > _
 > >  > - Original Message -
 > >  > From: "mayo" <[EMAIL PROTECTED]>
 > >  > To: "php-db" <[EMAIL PROTECTED]>
 > >  > Sent: Saturday, February 07, 2004 23:45
 > >  > Subject: RE: [PHP-DB] FW: db design - which is better
 > >  >
 > >  >
 > >  > >
 > >  > > Thanks,
 > >  > >
 > >  > > There just seems to be times when non-normalized table
 > structures are
 > >  > easier
 > >  > > to work with. A few hundred to a few thousand records, maybe 20
 > fields,
 > >  > > rarely adding another field.
 > >  > >
 > >  > > I wonder sometimes whether it make sense to put everything in one
 > table
 > >  > > instead of using joins.
 > >  > >
 > >  > > yours, putting-his-foot-in-his-mouth,
 > >  > >
 > >  > > Gil
 > >  > >
 > >  > >
 > >  > >  > -Original Message-
 > >  > >  > From: Ignatius Reilly [mailto:[EMAIL PROTECTED]
 > >  > >  > Sent: Saturday, February 07, 2004 5:33 PM
 > >  > >  > To: mayo; php-db
 > >  > >  > Subject: Re: [PHP-DB] FW: db design - which is better
 > >  > >  >
 > >  > >  >
 > >  > >  > Use the second design. SQL 101 / 1st normal form.
 > >

Re: [PHP-DB] FW: db design - which is better

[Ignatius Reilly]

Hmmm...

What of maintenance?
One day your pointed-headed boss asks you to add a "civility" field
(Mr|Mrs|Colonel|...), a birthdate, etc.
How do you do that with a 1-table design? You will have to create 1-NF
temporary tables in the process...

How do you search for an author? You will have to create a needlessly large
and inefficient index on (LastName + FirstName), instead of a nice integer
index.

And when querying the articleID, I do not think that there should be a
significant performance penalty, if your indexes are properly designed.

cheers

Ignatius
_
- Original Message -
From: "mayo" <[EMAIL PROTECTED]>
To: "php-db" <[EMAIL PROTECTED]>
Sent: Sunday, February 08, 2004 00:10
Subject: RE: [PHP-DB] FW: db design - which is better


> Let's say you have a page that is hit fairly frequently and spits out 100s
> of results.
>
> On it you have articleTitle, authorFName, authorLName.
>
> I ran a few tests and found that if all the above fields are in one table
it
> gets processed quicker than if there's a join. (authorID -> authorFName,
> authorLName)
>
> So, I'm beginning to think that processing time would be quicker if I
insert
> authorFName and authorLName into 2 tables. One the author table and the
> other the *VERY* frequently hit article table.
>
> That way when someone wants a list of articles, author FName, author LName
> all the data comes from one table.
>
> This would be probably very stupid in a financial or medical database
which
> has tens of millions of records and 100s if not 1000s of tables but SEEMS
> (I'm very open to being corrected) to work better on a fairly small web
> accessed database.
>
> yours,
>
> Gil
>
>
>
>
>
>
>
>
>
>  > -----Original Message-
>  > From: Ignatius Reilly [mailto:[EMAIL PROTECTED]
>  > Sent: Saturday, February 07, 2004 6:01 PM
>  > To: mayo; php-db
>  > Subject: Re: [PHP-DB] FW: db design - which is better
>  >
>  >
>  > There are perhaps such times, but I have yet to meet one.
>  >
>  > with 1NF:
>  > - your table space will be smaller
>  > - your indexes will work better
>  > - your SQL will be easier to write
>  > - ease of maintenance
>  >
>  > Just my 2 Belgian francs
>  >
>  > Ignatius
>  > _
>  > - Original Message -
>  > From: "mayo" <[EMAIL PROTECTED]>
>  > To: "php-db" <[EMAIL PROTECTED]>
>  > Sent: Saturday, February 07, 2004 23:45
>  > Subject: RE: [PHP-DB] FW: db design - which is better
>  >
>  >
>  > >
>  > > Thanks,
>  > >
>  > > There just seems to be times when non-normalized table structures are
>  > easier
>  > > to work with. A few hundred to a few thousand records, maybe 20
fields,
>  > > rarely adding another field.
>  > >
>  > > I wonder sometimes whether it make sense to put everything in one
table
>  > > instead of using joins.
>  > >
>  > > yours, putting-his-foot-in-his-mouth,
>  > >
>  > > Gil
>  > >
>  > >
>  > >  > -Original Message-
>  > >  > From: Ignatius Reilly [mailto:[EMAIL PROTECTED]
>  > >  > Sent: Saturday, February 07, 2004 5:33 PM
>  > >  > To: mayo; php-db
>  > >  > Subject: Re: [PHP-DB] FW: db design - which is better
>  > >  >
>  > >  >
>  > >  > Use the second design. SQL 101 / 1st normal form.
>  > >  > _
>  > >  > - Original Message -
>  > >  > From: "mayo" <[EMAIL PROTECTED]>
>  > >  > To: "php-db" <[EMAIL PROTECTED]>
>  > >  > Sent: Saturday, February 07, 2004 23:19
>  > >  > Subject: [PHP-DB] FW: db design - which is better
>  > >  >
>  > >  >
>  > >  > >
>  > >  > >
>  > >  > > -Original Message-
>  > >  > > From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]
>  > >  > > Sent: Saturday, February 07, 2004 5:09 PM
>  > >  > > To: php-db
>  > >  > > Subject: db design - which is better
>  > >  > >
>  > >  > >
>  > >  > > I have a client who has hundreds of articles. Each article can
>  > >  > be seen by
>  > >  > > one or more permission groups.
>  > >  > >
>  > >  > > I have questions regarding setting up the an
>  > article_display table.
>  > >  > >
>  > >  

RE: [PHP-DB] FW: db design - which is better

[mayo]

Let's say you have a page that is hit fairly frequently and spits out 100s
of results.

On it you have articleTitle, authorFName, authorLName.

I ran a few tests and found that if all the above fields are in one table it
gets processed quicker than if there's a join. (authorID -> authorFName,
authorLName)

So, I'm beginning to think that processing time would be quicker if I insert
authorFName and authorLName into 2 tables. One the author table and the
other the *VERY* frequently hit article table.

That way when someone wants a list of articles, author FName, author LName
all the data comes from one table.

This would be probably very stupid in a financial or medical database which
has tens of millions of records and 100s if not 1000s of tables but SEEMS
(I'm very open to being corrected) to work better on a fairly small web
accessed database.

yours,

Gil









 > -Original Message-
 > From: Ignatius Reilly [mailto:[EMAIL PROTECTED]
 > Sent: Saturday, February 07, 2004 6:01 PM
 > To: mayo; php-db
 > Subject: Re: [PHP-DB] FW: db design - which is better
 >
 >
 > There are perhaps such times, but I have yet to meet one.
 >
 > with 1NF:
 > - your table space will be smaller
 > - your indexes will work better
 > - your SQL will be easier to write
 > - ease of maintenance
 >
 > Just my 2 Belgian francs
 >
 > Ignatius
 > _
 > - Original Message -
 > From: "mayo" <[EMAIL PROTECTED]>
 > To: "php-db" <[EMAIL PROTECTED]>
 > Sent: Saturday, February 07, 2004 23:45
 > Subject: RE: [PHP-DB] FW: db design - which is better
 >
 >
 > >
 > > Thanks,
 > >
 > > There just seems to be times when non-normalized table structures are
 > easier
 > > to work with. A few hundred to a few thousand records, maybe 20 fields,
 > > rarely adding another field.
 > >
 > > I wonder sometimes whether it make sense to put everything in one table
 > > instead of using joins.
 > >
 > > yours, putting-his-foot-in-his-mouth,
 > >
 > > Gil
 > >
 > >
 > >  > -Original Message-
 > >  > From: Ignatius Reilly [mailto:[EMAIL PROTECTED]
 > >  > Sent: Saturday, February 07, 2004 5:33 PM
 > >  > To: mayo; php-db
 > >  > Subject: Re: [PHP-DB] FW: db design - which is better
 > >  >
 > >  >
 > >  > Use the second design. SQL 101 / 1st normal form.
 > >  > _
 > >  > - Original Message -
 > >  > From: "mayo" <[EMAIL PROTECTED]>
 > >  > To: "php-db" <[EMAIL PROTECTED]>
 > >  > Sent: Saturday, February 07, 2004 23:19
 > >  > Subject: [PHP-DB] FW: db design - which is better
 > >  >
 > >  >
 > >  > >
 > >  > >
 > >  > > -Original Message-
 > >  > > From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]
 > >  > > Sent: Saturday, February 07, 2004 5:09 PM
 > >  > > To: php-db
 > >  > > Subject: db design - which is better
 > >  > >
 > >  > >
 > >  > > I have a client who has hundreds of articles. Each article can
 > >  > be seen by
 > >  > > one or more permission groups.
 > >  > >
 > >  > > I have questions regarding setting up the an
 > article_display table.
 > >  > >
 > >  > > The easiest table to read and to conceptualize would list the
 > >  > articles and
 > >  > > use a boolean for each of the permission groups (let's
 > call the PGs
 > for
 > >  > this
 > >  > > example).
 > >  > >
 > >  > > (articleNameID refers back to the article table)
 > >  > >
 > >  > > articleNameID---PG1---PG2---PG3---PG4---PG5
 > >  > > 1001-1-0-0-0-0
 > >  > > 1002-1-1-0-0-0
 > >  > > 1003-0-0-1-0-0
 > >  > >
 > >  > >
 > >  > > Or should the table set up be:
 > >  > >
 > >  > > articleNameID--PG
 > >  > > 10011
 > >  > > 10021
 > >  > > 10022
 > >  > > 10033
 > >  > >
 > >  > > etc...
 > >  > >
 > >  > > gil
 > >  > >
 > >  > > --
 > >  > > PHP Database Mailing List (http://www.php.net/)
 > >  > > To unsubscribe, visit: http://www.php.net/unsub.php
 > >  > >
 > >  > >
 > >  >
 > >  > --
 > >  > PHP Database Mailing List (http://www.php.net/)
 > >  > To unsubscribe, visit: http://www.php.net/unsub.php
 > >  >
 > >
 > > --
 > > PHP Database Mailing List (http://www.php.net/)
 > > To unsubscribe, visit: http://www.php.net/unsub.php
 > >
 > >
 >
 > --
 > PHP Database Mailing List (http://www.php.net/)
 > To unsubscribe, visit: http://www.php.net/unsub.php
 >

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] FW: db design - which is better

[Ignatius Reilly]

There are perhaps such times, but I have yet to meet one.

with 1NF:
- your table space will be smaller
- your indexes will work better
- your SQL will be easier to write
- ease of maintenance

Just my 2 Belgian francs

Ignatius
_
- Original Message -
From: "mayo" <[EMAIL PROTECTED]>
To: "php-db" <[EMAIL PROTECTED]>
Sent: Saturday, February 07, 2004 23:45
Subject: RE: [PHP-DB] FW: db design - which is better


>
> Thanks,
>
> There just seems to be times when non-normalized table structures are
easier
> to work with. A few hundred to a few thousand records, maybe 20 fields,
> rarely adding another field.
>
> I wonder sometimes whether it make sense to put everything in one table
> instead of using joins.
>
> yours, putting-his-foot-in-his-mouth,
>
> Gil
>
>
>  > -Original Message-
>  > From: Ignatius Reilly [mailto:[EMAIL PROTECTED]
>  > Sent: Saturday, February 07, 2004 5:33 PM
>  > To: mayo; php-db
>  > Subject: Re: [PHP-DB] FW: db design - which is better
>  >
>  >
>  > Use the second design. SQL 101 / 1st normal form.
>  > _
>  > - Original Message -
>  > From: "mayo" <[EMAIL PROTECTED]>
>  > To: "php-db" <[EMAIL PROTECTED]>
>  > Sent: Saturday, February 07, 2004 23:19
>  > Subject: [PHP-DB] FW: db design - which is better
>  >
>  >
>  > >
>  > >
>  > > -Original Message-
>  > > From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]
>  > > Sent: Saturday, February 07, 2004 5:09 PM
>  > > To: php-db
>  > > Subject: db design - which is better
>  > >
>  > >
>  > > I have a client who has hundreds of articles. Each article can
>  > be seen by
>  > > one or more permission groups.
>  > >
>  > > I have questions regarding setting up the an article_display table.
>  > >
>  > > The easiest table to read and to conceptualize would list the
>  > articles and
>  > > use a boolean for each of the permission groups (let's call the PGs
for
>  > this
>  > > example).
>  > >
>  > > (articleNameID refers back to the article table)
>  > >
>  > > articleNameID---PG1---PG2---PG3---PG4---PG5
>  > > 1001-1-0-0-0-0
>  > > 1002-1-1-0-0-0
>  > > 1003-0-0-1-0-0
>  > >
>  > >
>  > > Or should the table set up be:
>  > >
>  > > articleNameID--PG
>  > > 10011
>  > > 10021
>  > > 10022
>  > > 10033
>  > >
>  > > etc...
>  > >
>  > > gil
>  > >
>  > > --
>  > > PHP Database Mailing List (http://www.php.net/)
>  > > To unsubscribe, visit: http://www.php.net/unsub.php
>  > >
>  > >
>  >
>  > --
>  > PHP Database Mailing List (http://www.php.net/)
>  > To unsubscribe, visit: http://www.php.net/unsub.php
>  >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] FW: db design - which is better

[mayo]

Thanks,

There just seems to be times when non-normalized table structures are easier
to work with. A few hundred to a few thousand records, maybe 20 fields,
rarely adding another field.

I wonder sometimes whether it make sense to put everything in one table
instead of using joins.

yours, putting-his-foot-in-his-mouth,

Gil


 > -Original Message-
 > From: Ignatius Reilly [mailto:[EMAIL PROTECTED]
 > Sent: Saturday, February 07, 2004 5:33 PM
 > To: mayo; php-db
 > Subject: Re: [PHP-DB] FW: db design - which is better
 >
 >
 > Use the second design. SQL 101 / 1st normal form.
 > _
 > - Original Message -
 > From: "mayo" <[EMAIL PROTECTED]>
 > To: "php-db" <[EMAIL PROTECTED]>
 > Sent: Saturday, February 07, 2004 23:19
 > Subject: [PHP-DB] FW: db design - which is better
 >
 >
 > >
 > >
 > > -Original Message-
 > > From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]
 > > Sent: Saturday, February 07, 2004 5:09 PM
 > > To: php-db
 > > Subject: db design - which is better
 > >
 > >
 > > I have a client who has hundreds of articles. Each article can
 > be seen by
 > > one or more permission groups.
 > >
 > > I have questions regarding setting up the an article_display table.
 > >
 > > The easiest table to read and to conceptualize would list the
 > articles and
 > > use a boolean for each of the permission groups (let's call the PGs for
 > this
 > > example).
 > >
 > > (articleNameID refers back to the article table)
 > >
 > > articleNameID---PG1---PG2---PG3---PG4---PG5
 > > 1001-1-0-0-0-0
 > > 1002-1-1-0-0-0
 > > 1003-0-0-1-0-0
 > >
 > >
 > > Or should the table set up be:
 > >
 > > articleNameID--PG
 > > 10011
 > > 10021
 > > 10022
 > > 10033
 > >
 > > etc...
 > >
 > > gil
 > >
 > > --
 > > PHP Database Mailing List (http://www.php.net/)
 > > To unsubscribe, visit: http://www.php.net/unsub.php
 > >
 > >
 >
 > --
 > PHP Database Mailing List (http://www.php.net/)
 > To unsubscribe, visit: http://www.php.net/unsub.php
 >

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] FW: db design - which is better

[Ignatius Reilly]

Use the second design. SQL 101 / 1st normal form.
_
- Original Message -
From: "mayo" <[EMAIL PROTECTED]>
To: "php-db" <[EMAIL PROTECTED]>
Sent: Saturday, February 07, 2004 23:19
Subject: [PHP-DB] FW: db design - which is better


>
>
> -Original Message-
> From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]
> Sent: Saturday, February 07, 2004 5:09 PM
> To: php-db
> Subject: db design - which is better
>
>
> I have a client who has hundreds of articles. Each article can be seen by
> one or more permission groups.
>
> I have questions regarding setting up the an article_display table.
>
> The easiest table to read and to conceptualize would list the articles and
> use a boolean for each of the permission groups (let's call the PGs for
this
> example).
>
> (articleNameID refers back to the article table)
>
> articleNameID---PG1---PG2---PG3---PG4---PG5
> 1001-1-0-0-0-0
> 1002-1-1-0-0-0
> 1003-0-0-1-0-0
>
>
> Or should the table set up be:
>
> articleNameID--PG
> 10011
> 10021
> 10022
> 10033
>
> etc...
>
> gil
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW: db design - which is better

[mayo]

-Original Message-
From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 07, 2004 5:09 PM
To: php-db
Subject: db design - which is better


I have a client who has hundreds of articles. Each article can be seen by
one or more permission groups.

I have questions regarding setting up the an article_display table.

The easiest table to read and to conceptualize would list the articles and
use a boolean for each of the permission groups (let's call the PGs for this
example).

(articleNameID refers back to the article table)

articleNameID---PG1---PG2---PG3---PG4---PG5
1001-1-0-0-0-0
1002-1-1-0-0-0
1003-0-0-1-0-0


Or should the table set up be:

articleNameID--PG
10011
10021
10022
10033

etc...

gil

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Fw: informix problem

[Martin Marques]

Mensaje citado por stefan bogdan <[EMAIL PROTECTED]>:

>  
>  
> i have winnt 4.0 servicepack 6 + apache 2.0.47 + php 430 + informix client
> for nt

> ilogin demo works fine

> sql editor works fine

> but when i try to connect  to informix via php i'get an error like

>  
>  Warning: ifx_connect(): E [SQLSTATE=S1 001 SQLCODE=-406]  

This is not a PHP problem. The problem is in the Informix server:

[EMAIL PROTECTED]:~ > finderr -406
-406Memory allocation failed.

Something in the current statement required the allocation of memory
for data storage, but the memory was not available. Several things can
cause this error. For example, your application has a memory leak; you
are asking for more resources than the system is configured to allow;
or a problem with the UNIX system itself requires rebooting the
system.

Roll back the current transaction. Look for ways to make this statement
simpler or move less data. Also, confer with your UNIX system
administrator to solve memory problems or look for ways to make the
operating system give this program more virtual memory in which to run.
On DOS systems, exit to the operating-system command line, free some
disk space, and resubmit your program.


> i have 256MB memory and 20 GB hard (6GB free)

It doesn't matter how much you have, but how much you assign to Informix to use as
virtual memory.

-- 
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-
Martín Marqués  |   Programador, DBA
Centro de Telemática| Administrador
   Universidad Nacional
del Litoral
-

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Fw: informix problem

[stefan bogdan]

 
 
i have winnt 4.0 servicepack 6 + apache 2.0.47 + php 430 + informix client for nt
ilogin demo works fine
sql editor works fine
but when i try to connect  to informix via php i'get an error like
 
 Warning: ifx_connect(): E [SQLSTATE=S1 001 SQLCODE=-406]  
 
i have informix server 2000 installed on other (unix) machine.
i have 256MB memory and 20 GB hard (6GB free)
what should i do?
 
Bogdan
 
















  IncrediMail - Email has finally evolved - Click Here

[PHP-DB] FW: Fonction timer

[Michel GUIRAUDOU]

Bonjour la liste,

J'ai regardé la doc php, et je n'ai pas trouvé de fonction timer.
Je souhaite lancer un timer à l'expiration duquel j'exécuterai un programme.
Est ce possible? Y a t'il des fonctions ou des morceaux de programme
facileme à reprendre
 pour faire ça?

Merci pour votre aide,

 Message Classification:
 [X] General Public Use
 [ ] Motorola Internal Use Only
 [ ] Motorola Confidential Proprietary

Michel GUIRAUDOU

MOTOROLA LABS
(RASSEL) Radio Access System and Spectrum   Engineering Lab

Parc Les Algorithmes
   91193 Gif sur Yvette Cedex

Tel: 33.(0)1.69.35.48.23
Fax: 33.(0)1.69.35.25.01

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Fw: Mysql Query

[Sean Burlington]

Mohammad Saadullah wrote:
Hi guys,

I am resending the same query again because still stuck on it.

I have been working in php/oracle for quite some time now but recently
 had to shift myself to mysql and I am struggling with a particular query here.
what is the query you would write for oracle ?


Scenario is, certain researchers can submit their proposals
> and those proposal are stored in a table researcher.
[snip]
--

Sean

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Fw: Mysql Query

[Mohammad Saadullah]

Hi guys,

I am resending the same query again because still stuck on it.

I have been working in php/oracle for quite some time now but recently had to shift 
myself to mysql and I am struggling with a particular query here.

Scenario is, certain researchers can submit their proposals and those proposal are 
stored in a table researcher. 
proposals are of 2 types lets say type 1 and type 2.
Later they can view their own submited proposals which is working fine, but there is 
one new condition now.What my client wants is that these researchers can view all 
proposals of type 2 but only those proposals of type 1 should be displayed to a 
researcher whose submit date is greater than a certain date lets say '2003-08-01'. Now 
how do I create a single query which can return me such results. I know there is a way 
with join but cant find a solution, with oracle I would have used sub query but that 
cannot be done on mysql so I need your guys help thanks

Table name: researcher

Concerned fields
pid <-- porposal id
rid <-- researcher id
ptype <--- proposal type
submitd <-- submission date.

I would use rid = 42 and for ptype = 1 submitd should be greater than '2003-08-01' and 
there is no restriction of date with ptype =2.

Thanks again.
if there is something not clear feel free to ask

Re: [PHP-DB] Fw: php-db Digest 17 Jun 2003 06:02:39 -0000 Issue 1886

[Becoming Digital]

> Any added spyware or so ?

I believe someone sent a few attachments to the list.

Edward Dudlik
Becoming Digital
www.becomingdigital.com


- Original Message - 
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, 19 June, 2003 12:35
Subject: [PHP-DB] Fw: php-db Digest 17 Jun 2003 06:02:39 - Issue 1886


The digest files are coming as attachments 

Attachmnts are very light (just 900 bytes or some  2 or 4 Kb.

This one carries a whooping 46 KB.

Any added spyware or so ?

Thanks

Raf



- Original Message - 
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 3:02 AM
Subject: php-db Digest 17 Jun 2003 06:02:39 - Issue 1886






-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Fw: php-db Digest 17 Jun 2003 06:02:39 -0000 Issue 1886

[rafael2]

The digest files are coming as attachments 

Attachmnts are very light (just 900 bytes or some  2 or 4 Kb.

This one carries a whooping 46 KB.

Any added spyware or so ?

Thanks

Raf



- Original Message - 
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 3:02 AM
Subject: php-db Digest 17 Jun 2003 06:02:39 - Issue 1886






-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

FW: [PHP-DB] FW: Call to undefined function: mysql_connect

[Idan Dolev]

 HI,
> I am using redhat 9 2.4.20-9 kernel and the following rpm's 
> MySQL-devel-4.0.13-0 MySQL-server-4.0.13-0
> MySQL-client-4.0.13-0
> MySQL-shared-3.23.51-1
> php-mysql-4.2.2-17
> 
in my phpinfo file I see --with-mysql

> I get the  following error when I try to access my php page:
> 
> Fatal error: Call to undefined function: mysql_connect() in
> 
> help
> 
> Idan


---
This e-mail message may contain confidential, commercial and privileged
information or data that constitute proprietary information of Cellcom
Israel Ltd. Any review or distribution by others is strictly prohibited.
If you are not the intended recipient you are hereby notified that any
use of this information or data by any other person is absolutely
prohibited. If you are not the intended recipient, please delete all
copies and contact us by e-mailing to: [EMAIL PROTECTED] Thank You.



---
This e-mail message may contain confidential, commercial and privileged information or 
data that constitute proprietary information of Cellcom Israel Ltd. Any review or 
distribution by others is strictly prohibited. If you are not the intended recipient 
you are hereby notified that any use of this information or data by any other person 
is absolutely prohibited. If you are not the intended recipient, please delete all 
copies and contact us by e-mailing to: [EMAIL PROTECTED]
Thank You.




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW: Call to undefined function: mysql_connect

[Idan Dolev]

>  -Original Message-
> From: Idan Dolev  
> Sent: Tuesday, June 17, 2003 2:52 PM
> To:   '[EMAIL PROTECTED]'
> Subject:  Call to undefined function: mysql_connect
> 
> HI,
> I am using redhat 9 2.4.20-9 kernel and the following rpm's
> MySQL-devel-4.0.13-0
> MySQL-server-4.0.13-0
> MySQL-client-4.0.13-0
> MySQL-shared-3.23.51-1
> php-mysql-4.2.2-17
> 
in my phpinfo file I see --with-mysql

> I get the  following error when I try to access my php page:
> 
> Fatal error: Call to undefined function: mysql_connect() in 
> 
> help
> 
> Idan

---
This e-mail message may contain confidential, commercial and privileged information or 
data that constitute proprietary information of Cellcom Israel Ltd. Any review or 
distribution by others is strictly prohibited. If you are not the intended recipient 
you are hereby notified that any use of this information or data by any other person 
is absolutely prohibited. If you are not the intended recipient, please delete all 
copies and contact us by e-mailing to: [EMAIL PROTECTED]
Thank You.

[PHP-DB] Fw: Windows 2000 problems

[Sabina A. Schneider]

I am writing to you to report a problem, which I haven't found in the
FAQs and errors. I have installed Apache 1.3.27 for Windows, with PHP4 and
Mysql 1.4 and when I try to see a page, that contains sessions there appears
an error- window that says that Windows closes Apache, because it has
genereted a problem. I search in the Apache logs but nothing appears. I've
followed the php code that I've generated and the problem is where the
script tris to register a variable. I attach here my php.ini that I'm using
in C:\Winnt .Thank you very much for your help and time.
  Sabina Alejandra Schneider
[EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] FW: Oracle connectivity question...

[Ryan Jameson (USA)]

Yeah, on the server you should be able to type tnsping and your tnsname to make sure 
it is configured correctly.

<>< Ryan

-Original Message-
From: Andrey Hristov [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 10:05 AM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: Re: [PHP-DB] FW: Oracle connectivity question...


  Hey,

A friend of mine told me that :
kalo 19:02: trjanbva ti

tnsping vdb.masq

kalo 19:02: uf.. ne znam kak ce nastrojva tnslistaner-a..;(

kalo 19:03: ima si programa s kojato se pipat nastraojkite na TNSListener-a

kalo 19:03: ina4e ne mozesh ada se zaka4ish..


Translared to english :
19:02 You need
tnsping the_machine
19:03 : uff, I don't know how to setup the tnslistener
19:03 : there is a program to change the setting of TNSListener
19:03 : otherwise you can't connect


If this helps you :))

Andrey

- Original Mesage -
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 18, 2002 6:51 PM
Subject: [PHP-DB] FW: Oracle connectivity question...


> More information on the problem...  I tried including the SID in the
> OCILogon function and think that I may have gotten a bit further, but
still
> not a successful logon.  Here is the error I am now receiving with the
SID:
>
> Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name
in
> /www/DW/oratest.php on line 11
> Unable to logon to database.
> Thanks agian.
>
> >  -Original Message-
> > From: NIPP, SCOTT V (SBCSI)
> > Sent: Wednesday, December 18, 2002 10:30 AM
> > To: '[EMAIL PROTECTED]'
> > Subject: Oracle connectivity question...
> >
> > OK.  I think I now have Oracle support built into PHP/Apache.  The
> > biggest hiccup for HP-UX seems to be that once you add Oracle support to
> > PHP, you CANNOT built PHP as a DSO, PHP MUST be compiled into Apache.
> > Once again, I think this is the case, I am still not completely sure at
> > this point.
> >
> > I am now receiving an error on trying to connect to the Oracle
> > database that I do not understand, but leads me to believe that the PHP
> > Oracle support is functioning.  Here is the code I am attempting:
> >
> >  > $connection = OCILogon("userid", "password") or die ("Unable to logon to
> > database.");
> > # phpinfo();
> > ?>
> >
> > Here is the error I am receiving:
> >
> > Warning: OCISessionBegin: ORA-01034: ORACLE not available in
> > /www/DW/oratest.php on line 10
> > Unable to logon to database.
> > The code I am attempting is simply to verify successful connectivity
> > to the database.  I know that this doesn't really do anything, but I am
> > trying this simply to test for a successful connection.  Please let me
> > know if you have any ideas or suggestions.  Thanks again.
> >
> > Scott Nipp
> > Phone:  (214) 858-1289
> > E-mail:  [EMAIL PROTECTED]
> > Web:  http:\\ldsa.sbcld.sbc.com
> >
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] FW: Oracle connectivity question...

[Andrey Hristov]

  Hey,

A friend of mine told me that :
kalo 19:02: trjanbva ti

tnsping vdb.masq

kalo 19:02: uf.. ne znam kak ce nastrojva tnslistaner-a..;(

kalo 19:03: ima si programa s kojato se pipat nastraojkite na TNSListener-a

kalo 19:03: ina4e ne mozesh ada se zaka4ish..


Translared to english :
19:02 You need
tnsping the_machine
19:03 : uff, I don't know how to setup the tnslistener
19:03 : there is a program to change the setting of TNSListener
19:03 : otherwise you can't connect


If this helps you :))

Andrey

- Original Mesage -
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 18, 2002 6:51 PM
Subject: [PHP-DB] FW: Oracle connectivity question...


> More information on the problem...  I tried including the SID in the
> OCILogon function and think that I may have gotten a bit further, but
still
> not a successful logon.  Here is the error I am now receiving with the
SID:
>
> Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name
in
> /www/DW/oratest.php on line 11
> Unable to logon to database.
> Thanks agian.
>
> >  -Original Message-
> > From: NIPP, SCOTT V (SBCSI)
> > Sent: Wednesday, December 18, 2002 10:30 AM
> > To: '[EMAIL PROTECTED]'
> > Subject: Oracle connectivity question...
> >
> > OK.  I think I now have Oracle support built into PHP/Apache.  The
> > biggest hiccup for HP-UX seems to be that once you add Oracle support to
> > PHP, you CANNOT built PHP as a DSO, PHP MUST be compiled into Apache.
> > Once again, I think this is the case, I am still not completely sure at
> > this point.
> >
> > I am now receiving an error on trying to connect to the Oracle
> > database that I do not understand, but leads me to believe that the PHP
> > Oracle support is functioning.  Here is the code I am attempting:
> >
> >  > $connection = OCILogon("userid", "password") or die ("Unable to logon to
> > database.");
> > # phpinfo();
> > ?>
> >
> > Here is the error I am receiving:
> >
> > Warning: OCISessionBegin: ORA-01034: ORACLE not available in
> > /www/DW/oratest.php on line 10
> > Unable to logon to database.
> > The code I am attempting is simply to verify successful connectivity
> > to the database.  I know that this doesn't really do anything, but I am
> > trying this simply to test for a successful connection.  Please let me
> > know if you have any ideas or suggestions.  Thanks again.
> >
> > Scott Nipp
> > Phone:  (214) 858-1289
> > E-mail:  [EMAIL PROTECTED]
> > Web:  http:\\ldsa.sbcld.sbc.com
> >
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW: Oracle connectivity question...

[NIPP, SCOTT V (SBCSI)]

More information on the problem...  I tried including the SID in the
OCILogon function and think that I may have gotten a bit further, but still
not a successful logon.  Here is the error I am now receiving with the SID:

Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name in
/www/DW/oratest.php on line 11
Unable to logon to database.
Thanks agian.

>  -Original Message-
> From: NIPP, SCOTT V (SBCSI)  
> Sent: Wednesday, December 18, 2002 10:30 AM
> To:   '[EMAIL PROTECTED]'
> Subject:  Oracle connectivity question...
> 
>   OK.  I think I now have Oracle support built into PHP/Apache.  The
> biggest hiccup for HP-UX seems to be that once you add Oracle support to
> PHP, you CANNOT built PHP as a DSO, PHP MUST be compiled into Apache.
> Once again, I think this is the case, I am still not completely sure at
> this point.
> 
>   I am now receiving an error on trying to connect to the Oracle
> database that I do not understand, but leads me to believe that the PHP
> Oracle support is functioning.  Here is the code I am attempting:
> 
>  $connection = OCILogon("userid", "password") or die ("Unable to logon to
> database.");
> # phpinfo();
> ?>
> 
>   Here is the error I am receiving:
> 
> Warning: OCISessionBegin: ORA-01034: ORACLE not available in
> /www/DW/oratest.php on line 10
> Unable to logon to database.
>   The code I am attempting is simply to verify successful connectivity
> to the database.  I know that this doesn't really do anything, but I am
> trying this simply to test for a successful connection.  Please let me
> know if you have any ideas or suggestions.  Thanks again.
> 
> Scott Nipp
> Phone:  (214) 858-1289
> E-mail:  [EMAIL PROTECTED]
> Web:  http:\\ldsa.sbcld.sbc.com
> 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW: PHP/Oracle Install questions...

[NIPP, SCOTT V (SBCSI)]

More information for someone to hopefully come to my rescue on
this...

root@torvalds:/usr/local/apache/bin> ./apachectl startssl
/usr/lib/dld.sl: Can't shl_load() a library containing Thread Local Storage:
/us
r/lib/libcl.2
/usr/lib/dld.sl: Exec format error
Syntax error on line 207 of /usr/local/apache/conf/httpd.conf:
Cannot load /usr/local/apache/libexec/libphp4.so into server: Exec format
error
./apachectl startssl: httpd could not be started

This is what I get when I attempt to start Apache once I think I
have compiled the new PHP module properly.

>  -Original Message-
> From: NIPP, SCOTT V (SBCSI)  
> Sent: Tuesday, December 17, 2002 9:56 AM
> To:   '[EMAIL PROTECTED]'
> Subject:  PHP/Oracle Install questions...
> 
>   I am attempting to recompile PHP 4.2.3 on HP-UX 11.00 for
> connectivity to both a MySQL and a remote Oracle server.  I am not having
> much luck with this right now.  Currently I am getting a couple of
> different errors that are of concern for me.  First of all, in the Apache
> error log I am seeing the following entry every time I start the Apache
> server:
> 
>   [Tue Dec 17 09:42:39 2002] [warn] module php4_module is already
> loaded, skipping
> 
>   I am not sure as to why I am receiving this error.  I know that PHP
> is only compiled as a module, because it does not show up in a httpd -l.
> I am wondering if this is a result of some kind of syntax error in my
> httpd.conf file.
> 
>   The big problem though is getting PHP to compile completely again.
> I know that on HP there is an issue with the extension on the php library.
> It has something to do with .sl as opposed to .so, but I cannot remember
> exactly what it is and for some reason I can't seem to find the
> documentation on it this time around.  Any help in the right direction
> here would be most appreciated.
> 
> Scott Nipp
> Phone:  (214) 858-1289
> E-mail:  [EMAIL PROTECTED]
> Web:  http:\\ldsa.sbcld.sbc.com
> 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Fw: Insert strtoupper

[Antonio Bernabei]

> Hi,
>
> I want to insert the upper case of the strings written in the forn, so I
put
> on the php file called these lines
>
> $NOME=strtoupper($nome);
>
> mysql_query ("INSERT INTO anagrafe (codice,nome, cognome, codicefiscale)
>
> VALUES
>
('strtoupper($codicefiscale)','$NOME','strtoupper($cognome)','strtoupper($co
> dicefiscale)', ...
>
> but if $codice if for example abc in field codice I don't get ABC but
> uppercase(abc)
> while if $nome is mario in the filed nome I get MARIO
>
> Can I avoid to write extra lines for the conversion?
> Thanks
> Antonio
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW: Re: phpMyAdmin/Hostname MySQL

[Ruprecht Helms]

Hi,

in the following mail he writes about editing the config.inc.php

Regards,
Ruprecht

-FW: <[EMAIL PROTECTED]>-

Date: Mon, 25 Nov 2002 14:08:15 +0100
From: "Johannes G.  Arlt" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: phpMyAdmin/Hostname MySQL

Am Sonntag, 24. November 2002 22:26 schrieb Ruprecht Helms:

hast du die Datei config.inc.php angepaßt?

-- 
Einen erfolgreichen Tag

Johannes G.  Arlt
[EMAIL PROTECTED]

--End of forwarded message-

--
Ruprecht Helms IT-Service und Softwareentwicklung

Tel/Fax.:  +49[0]7621 16 99 16
Homepage:  http://www.rheyn.de
email:  [EMAIL PROTECTED]
--

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] FW: Selecting not on DB

[John W. Holmes]

> Hi there,
> 
> I have a problem that I cannot seem to solve. I'm using MySql and
query
> it using PHP.
> 
> I have create table ABC with field called "number" containing
(1,4,6,10)
> 
> How is to select all number form 1 to 10 which are not
> in that field so the output somehow like this :
> 
> ++
> | Number |
> ++
> |  2 |
> |  3 |
> |  5 |
> |  7 |
> |  8 |
> |  9 |
> ++
> 

SELECT * FROM abc WHERE Number NOT BETWEEN 1 AND 10;

---John Holmes...



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] FW: Selecting not on DB

[Ignatius Reilly]

You could create an auxiliary table nb_1_10 containing a field nb with all
integers from 1 to 10

Then perform a SELECT join:

SELECT nb_1_10.*
FROM ABC, nb_1_10
WHERE nb_1_10.nb NOT IN ABC.number
AND < some condition that returns only one row from ABC - like here
(1,4,6,10) >

Ignatius

- Original Message -
From: "milisphp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 21, 2002 5:29 AM
Subject: [PHP-DB] FW: Selecting not on DB


> Hi there,
>
> I have a problem that I cannot seem to solve. I'm using MySql and query
> it using PHP.
>
> I have create table ABC with field called "number" containing (1,4,6,10)
>
> How is to select all number form 1 to 10 which are not
> in that field so the output somehow like this :
>
> ++
> | Number |
> ++
> |  2 |
> |  3 |
> |  5 |
> |  7 |
> |  8 |
> |  9 |
> ++
>
> Thanks, Hansen
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW: Selecting not on DB

[milisphp]

Hi there,
 
I have a problem that I cannot seem to solve. I'm using MySql and query
it using PHP.
 
I have create table ABC with field called "number" containing (1,4,6,10)
 
How is to select all number form 1 to 10 which are not
in that field so the output somehow like this :
 
++
| Number |
++
|  2 |
|  3 |
|  5 |
|  7 |
|  8 |
|  9 |
++
 
Thanks, Hansen

Re: [PHP-DB] FW: php J2EE .NET

[Peter Beckman]

Well, I know from experience this:

 PHP 3 and 4.various, sessions enabled on every page (using DB to store)
 MySQL 3.23.various
 Apache 1.2.various
 300,000 users in the DB
 2600 dynamic pages
 No images or static multimedia content (on this server)
 PC, Dual 800Mhz
 1GB Ram
 4 18GB drives, 7200RPM, raided 0/1 (Mirrored)
 FreeBSD 4.various

 ~150 queries per second on mysql
 1,233,771 page views in 24 hours, all served without issue.
 Each page ~100K
 Averaged 424,192 page views per day.

That's just my experience.  It was adcritic.com at its peak.

Peter

On Thu, 7 Nov 2002, Peter Lovatt wrote:

> Hi
>
> There is an article on sitepoint.com about benchmarking J2EE and  .NET and
> some controversy over the result
> http://www.sitepoint.com/newsletters/viewissue.php?fid=3&id=3&issue=52
>
> Does anybody have experience of php/MySql in comparison with either of the
> above in terms of efficiency or ultimate performance?
>
> Is anybody interested in putting a php/MySql setup through the same
> benchmarks?
>
> Mostly for fun, but might be useful for the 'but Open Source is not up to
> Enterprise Applications' augment.
>
> Peter
>
> Mysql query blah..
> ---
> Excellence in internet and open source software
> ---
> Sunmaia
> Birmingham
> UK
> www.sunmaia.net
> tel. 0121-242-1473
> International +44-121-242-1473
> ---
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

---
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EMAIL PROTECTED] http://www.purplecow.com/
---


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW: php J2EE .NET

[Peter Lovatt]

Hi

There is an article on sitepoint.com about benchmarking J2EE and  .NET and
some controversy over the result
http://www.sitepoint.com/newsletters/viewissue.php?fid=3&id=3&issue=52

Does anybody have experience of php/MySql in comparison with either of the
above in terms of efficiency or ultimate performance?

Is anybody interested in putting a php/MySql setup through the same
benchmarks?

Mostly for fun, but might be useful for the 'but Open Source is not up to
Enterprise Applications' augment.

Peter

Mysql query blah..
---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Fw: Dows anyone know why this was bounced?

[Robert Twitty]

Does anyone know why all mail that I send to any aspect of the php-db list
is bounced when it is sent from the address below?

-- bob

- Original Message -
From: "Robert Twitty" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 9:39 PM
Subject: Returned mail: see transcript for details (fwd)


>
>
> -- Forwarded message --
> Date: Thu, 31 Oct 2002 19:45:12 -0500 (EST)
> From: Mail Delivery Subsystem <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Returned mail: see transcript for details
>
> The original message was received at Thu, 31 Oct 2002 19:45:12 -0500 (EST)
> from neutron.ushmm.org [207.77.113.18]
>
>- The following addresses had permanent fatal errors -
> <[EMAIL PROTECTED]>
> (reason: 553 This entry was last confirmed open on 2/16/2002)
>
>- Transcript of session follows -
> ... while talking to pair1.php.net.:
> >>> RCPT To:<[EMAIL PROTECTED]>
> <<< 553 This entry was last confirmed open on 2/16/2002
> 550 5.1.1 <[EMAIL PROTECTED]>... User unknown
>

--- Begin Message ---



--- End Message ---
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Fw: array transfer via form.

[Garry Climacosa]

yes i did, and it creates a the access.temp2.txt file but it only contains
the last array...

- Original Message -
From: "Jason Wong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 6:40 PM
Subject: Re: [PHP-DB] Fw: array transfer via form.


> On Friday 25 October 2002 10:40, Garry Climacosa wrote:
>
> > 6. heres the action page check_act.php
> >  > $file2write = fopen("/var/lib/data/access.temp2.txt", "w");
> > $write2line = "$myline\n";
> > $filewrite = fwrite($file2write, $write2line);
> > ?>
>
> The first thing to check -- did you echo $myline (or $write2line) to see
> whether it contains what you had expected it to contain?
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
>
>
> /*
> It's not the fall that kills you, it's the landing.
> */
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Fw: array transfer via form.

[Jason Wong]

On Friday 25 October 2002 10:40, Garry Climacosa wrote:

> 6. heres the action page check_act.php
>  $file2write = fopen("/var/lib/data/access.temp2.txt", "w");
> $write2line = "$myline\n";
> $filewrite = fwrite($file2write, $write2line);
> ?>

The first thing to check -- did you echo $myline (or $write2line) to see 
whether it contains what you had expected it to contain?

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *


/*
It's not the fall that kills you, it's the landing.
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Fw: array transfer via form.

[Garry Climacosa]

1. i have a txt file with data 
like this: LINE 1-->  12345678890
 LINE 2-->  abcdefghglld
 LINE 3-->  asdfg
 .
 .
 .
 LINE X --> bla-bla-bla
2. then i view this txt file in a browser with a 

in my browser it looks like this:
  
  
  
 

3. now i want to edit this txt file here in my browser using this form..

4. how can i create a file that will write the changes i made in this form? i did 
write the file but i get only 1 line (asdfg) the last array..

5. heres my code checkbox.php


No record found please try 
again later."; }
  for ($i=0; $i<$number_of_lines; $i++)
  {
  $myinfo = $rory[$i];
  $myline = substr($myinfo,0,-1);
?>


 
  


6. heres the action page check_act.php

[PHP-DB] Fw: search question

[Meltem Demirkus]

> Hi,
> Is there any other efficient way (--except using LIKE)of searching a
keyword
> in mysql ...
>
> thanks
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] FW: Php database support

[Andrew Hill]

David,

You will be pleased with OpenLink Software's ODBC Drivers.  This
requires setting up PHP --with-iodbc, as per the HOWTO's on
http://www.iodbc.org and the ODBC drivers are available as a free 30-day
download from our site.

Please let me know if you have any questions.

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software  http://www.openlinksw.com
Universal Data Access & Virtuoso Universal Server

-Original Message-
From: Walgamotte, David [mailto:[EMAIL PROTECTED]] 
Sent: Monday, September 09, 2002 8:16 AM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] FW: Php database support

>  Hello All !!!
> 
>  We use PHP in a production e-commerce web environment with a mysql 
> database server. The higher ups have decided they want to move to 
> Microsoft SQL. I'm now tasked to convert our Unix Apache PHP 
> environment to use a remote Microsoft SQL server. I've researched and 
> used TDS the Sybase connector to Microsoft SQL. It works but is very 
> slow.
> 
> Has anyone completed such a migration ? Can anyone recommend a solid 
> connector between UNIX PHP and Microsoft SQL DB and a place to go for 
> setup procedures ?
> 
> Thanks You very much ?
> 
> DW
> 



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW: Php database support

[Walgamotte, David]

>  Hello All !!!
> 
>  We use PHP in a production e-commerce web environment with a mysql 
> database server. The higher ups have decided they want to move to 
> Microsoft SQL. I'm now tasked to convert our Unix Apache PHP 
> environment to use a remote Microsoft SQL server. I've researched and 
> used TDS the Sybase connector to Microsoft SQL. It works but is very 
> slow.
> 
> Has anyone completed such a migration ? Can anyone recommend a solid 
> connector between UNIX PHP and Microsoft SQL DB and a place to go for 
> setup procedures ?
> 
> Thanks You very much ?
> 
> DW
> 

[PHP-DB] FW: MUDAR DE OPERADOR E MANTER O SEU NUMERO DE TELEMOVEL

[José Moreira]

MUDAR DE OPERADOR E MANTER O SEU NUMERO DE TELEMOVEL
-Mensagem original-
De: Ivan Santos [mailto:[EMAIL PROTECTED]]
Enviada: segunda-feira, 19 de Agosto de 2002 12:15
Para: '[EMAIL PROTECTED]'
Assunto: MUDAR DE OPERADOR E MANTER O SEU NUMERO DE TELEMOVEL


Está descontente com o seu operador móvel (Optimus, TMN ou Vodafone)?

Sabia que PODE MUDAR DE OPERADOR E MANTER O SEU NÚMERO DE TELEMÓVEL?

APENAS TEM DE MUDAR DE OPERADOR E DIZER QUE QUER FICAR COM O SEU NÚMERO!

Desde o dia 1 de Janeiro de 2002 que foi implementada em Portugal a
PORTABILIDADE DE NÚMERO ENTRE OPERADORES MÓVEIS, isto é, os números de
telefone são pertença dos clientes e SÃO INDEPENDENTES DOS OPERADORES.

OS PREFIXOS JÁ NÃO CORRESPONDEM AOS OPERADORES:
- o 93 não quer dizer Optimus
- o 96 não quer dizer TMN
- o 91 não quer dizer Telecel/Vodafone

Já reparou como os operadores deixaram de falar e fazer referência aos
prefixos? Os operadores não falam deste assunto porque têm medo de perder
clientes.

Durante o processo de consulta e deliberação levado a cabo pela ANACOM
(ex-ICP) os 3 operadores móveis (Optimus, TMN ou Vodafone) opuseram-se à
portabilidade do número por medo de perderem clientes.

A maior parte das pessoas continua sem saber que pode mudar de operador e
ficar com o mesmo número de telemóvel !

Para mais informações:
- site da ANACOM (Autoridade Nacional de Comunicações) -
  http://www.anacom.pt
- número verde (grátis) da ANACOM - 800.206.665

Para mais informações sobre o processo que levou à portabilidade:

http://www.anacom.pt/template13.jsp?categoryId=35254

Re: [PHP-DB] Fw: Date Add

[Pierre-Alain Joye]

On Sun, 4 Aug 2002 17:42:17 +0200
Pierre-Alain Joye <[EMAIL PROTECTED]> wrote:

> On Sun, 4 Aug 2002 17:30:31 +0200
> "John Fishworld" <[EMAIL PROTECTED]> wrote:

> For a specific day, here the current day
WHERE DAYOFMONTH(t_event_date)=DAYOFMONTH(NOW()) AND MONTH(t_event_date)=MONTH(NOW())

if you store as date-time format :).

hth

pa

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Fw: Date Add

[Pierre-Alain Joye]

On Sun, 4 Aug 2002 17:30:31 +0200
"John Fishworld" <[EMAIL PROTECTED]> wrote:


Why not simply does the where clause like :
for a whole month, here is july:
WHERE YEAR(t_event_date)='2002' AND MONTH(t_event_date)='7'

For a specific day, here the current day
WHERE t_event_date=NOW()

That means you store date as date/timestamp/... field type. You do not specify your 
rdbm, but seems to be mysql ;).

hth

pa


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Fw: Date Add

[John Fishworld]

> I thought I had this working, but it seems unfortunately not !!!
>
> I'm trying to list events for each month and my select query is as follows
>
> SELECT DISTINCT t_city_name,t_city_id_city FROM
> t_city,t_zipcodecity,t_location,t_event WHERE (t_city_id_city =
> t_zipcodecity_id_city) AND (t_zipcodecity_zipcode = t_location_zipcode )
AND
> ((t_location_sex = 4) OR (t_location_sex = 6) OR (t_location_sex = 0)) AND
> (t_location_id_location = t_event_id_location) AND (t_event_date <
> (DATE_ADD('2002-08-01 00:00:00', INTERVAL 31 day)) ) AND (t_event_date >
> '2002-08-01 00:00:00') ORDER by t_city_name
>
> this is for August and seems to work fine, but my problem is that in the
> running month I only want to show the still forthcoming events so for
today
> July the 31 st my query looks like this
>
> SELECT DISTINCT t_city_name,t_city_id_city FROM
> t_city,t_zipcodecity,t_location,t_event WHERE (t_city_id_city =
> t_zipcodecity_id_city) AND (t_zipcodecity_zipcode = t_location_zipcode )
AND
> ((t_location_sex = 4) OR (t_location_sex = 6) OR (t_location_sex = 0)) AND
> (t_location_id_location = t_event_id_location) AND (t_event_date <
> (DATE_ADD('2002-07-31 00:00:00', INTERVAL 0 day)) ) AND (t_event_date >
> '2002-07-31 00:00:00') ORDER by t_city_name
>
> But it doesn't work ??
> Can anyone give me a hint in the right direction ??
> The problem is definately in the last part  (t_event_date <
> (DATE_ADD('2002-07-31 00:00:00', INTERVAL 0 day)) ) AND (t_event_date >
> '2002-07-31 00:00:00')
>
> Thanks in advance
>
>
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Fw: mysql multiple query

[ditzi]

> hello..
> i have a pretty wired query to do with php/mysql .
> i don't manage to do
>
> mysql_query($qry,$connection); .
> (query bellow)
>
> so i found a quick and dirty solution.see bellow .
> but it's no realy elegant .
>
> any ideea how can i do multiple queries at once with mysql_query() ?
>
> function copy_question($qid,$test_target) {
> global $connection,$username,$password,$database;
>
>
> $fp = fopen ('/tmp/copy_table_qry', 'w');
>
> $qry="create temporary table q_temp as select * from questions;
> create temporary table ans_temp as select * from answers;
> set @test_id=$test_target;
> set @q_id=$qid;
> insert into questions select
>
'',@test_id,t2.q_type,t2.description,t2.dimension,t2.combination,t2.checkit
> from q_temp as t2 where id=@q_id;
> select @last:=LAST_INSERT_ID();
> insert into answers select '',@last,score,description from ans_temp where
> id_question_fk=@q_id;";
>
>  fputs($fp,"$qry");
>  fclose($fp);
>
> $a=exec("/usr/bin/mysql -u $username -p$password $database
>  --
>
> thnx .
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW:

[Jose Moreira]

- Nco quebre a brincadeira. 
> > >>> > > 
> > >>> > > Se seu nome estiver na lista, coloque um asterisco ao 
> > >>> > > lado. 
> > >>> > > Se NAO, adicione seu nome em ordem alfabitica. 
> > >>> > > Mande para 10 pessoas e tambim para pessoa que lhe 
> > >>> > > enviou. 
> > >>> > > Vai ver o que acontece... i super legal! 
> > >>> > > 
> > >>> > > Abigail* 
> > >>> > > Adriana* 
> > >>> > > Albert 
> > >>> > > Aaron* 
> > >>> > > Adam 
> > >>> > > Adelaide 
> > >>> > > Ademir 
> > >>> > > Alaide 
> > >>> > > Alam 
> > >>> > > Alessandra** 
> > >>> > > Alfredo 
> > >>> > > Alice* 
> > >>> > > Alex 
> > >>> > > Alix 
> > >>> > > Allison 
> > >>> > > Alyce 
> > >>> > > Allyson 
> > >>> > > Alvaro 
> > >>> > > Amanda*** 
> > >>> > > Amber 
> > >>> > > Amelia 
> > >>> >  Amy 
> > >>> >  > Ana Bela 
> > >>> > > Ana Carolina* 
> > >>> > > Ana Claudia 
> > >>> > > Ana Cristina** 
> > >>> > > Ana Helena 
> > >>> > > Ana Isabel 
> > >>> > > Ana Lucia** 
> > >>> >  Ana Maria** * 
> > >>> >  Ana Margarida 
> > >>> > > Ana Paula** * 
  Ana Rita
> > >>> > > Ana Silvia 
> > >>> > > Anaurelin 
> > >>> > > Anderson** 
> > >>> > > Andre 
> > >>> > > Andrea* 
> > >>> > > Andreia** 
> > >>> > > Andreza 
> > >>> > > Anelisa 
> > >>> > > Anezinho 
> > >>> > > Angela 
> > >>> > > Angelica 
> > >>> > > Anna*** 
> > >>> > > Annie** 
> > >>> > > Annike 
> > >>> > > Antoine 
  Antonieta 
> > >>> > > Antonio* 
> > >>> > > April 
> > >>> > > Aristoteles 
> > >>> > > Arthur 
> > >>> > > Ash** 
> > >>> > > Ashlee* 
> > >>> > > Ashley*** 
> > >>> > > Audrey 
> > >>> > > Austin 
> > >>> > > Barbara * 
> > >>> > > Basemate 
> > >>> > > Beatriz*** 
> > >>> > > Betania 
> > >>> > > Beth*** 
> > >>> > > Beti 
> > >>> > > Bianca 
> > >>> > > Bill 
> > >>> > > Bob 
> > >>> > > Bobbie 
> > >>> > > Bobby 
> > >>> > > Bonnie 
> > >>> > > Brad** 
> > >>> > > Branco 
> > >>> > > Breiann 
> > >>> > > Brian ** 
> > >>> > > Bridget* 
> > >>> > > Brittany* 
> > >>> > > Britney 
> > >>> > > Brooke 
> > >>> > > Bruno** 
> > >>> > > Blake 
> > >>> > > Carina 
> > >>> > > Camila 
> > >>> > > Carla * 
> > >>> > > Carlos * *** 
> > >>> > > Carmem 
> > >>> > > Carmen 
> > >>> > > Carolina* 
> > >>> > > Caroline* 
> > >>> > > Casey 
> > >>> > > Cassandra* 
> > >>> > > Cassia** 
> > >>> > > Cassiana 
> > >>> > > Cassidy 
> > >>> > > Caitli 
> > >>> > > Celeste 
> > >>> > > Cesar 
> > >>> > > Chastity 
> > >>> > > Chelsea 
> > >>> > > Chris 
> > >>> > > Christopher* 
> > >>> > > Christian 
> > >>> > > Christina ** 
> > >>> > > Christiane* 
> > >>> > > Chrystiano 
> > >>> > > Cristina  
> > >>> > > Chuck * 
> > >>> > > Cibele 
> > >>> > > Cida * 
> > >>> > > Cidinha 
> > >>> > > Cindy 
> > >>> > > Cintia 
> > >>> > > Cidilene* 
> > >>> > > Claire* 
> > >>> > > Claude 
> > >>> > > Claudenice 
> > >>> > > Claudia 
> > >>> > > Claudio 
> > >>> > > Cleusa 
> > >>> > > Cliceu 
> > >>> > > Conceigco  * 
> > >>> > > Connie 
> > >>> > > Courtney 
> > >>> > > Cristiane* 
> > >>> > > Cristhiane 
> > >>> > > Daniel* 
> > >>> > > Daniela* 
> > >>> > > Daniele 
> > >>> > > Danieli 
> > >>> > > Davi 
> > >>> > > Davine 
> > >>> > > Debora 
> > >>> > > Deborah 
> > >>> > > Debra 
> > >>> > > Deise 
> > >>> > > Deizi 
> > >>> > > Delila 
> > >>> > > Dennean 
> > >>> > > Denise 
> > >>> > > Deolinda 
> > >>> > > Diana* 
> > >>> > > Diane 
> > >>> > > Dilbert 
> > >>> > > Diogo** 
> > >>> > > Dolores * 
> > >>> > > Douglas 
> > >>> > > Dudley 
> > >>> > > Dulce 
> > >>> > > Edilson 
> > >>> > > Edmundo 
> > >>> > > Edna* 
> > >>> > > Edrio 
> > >>> > > Edson* 
> > >>> > > Eduardo 
> > >>> > > Eduy 
> > >>> > > Edward 
> > >>> > > 
> > >>> > > Euginia *** 
> > >>> > > Elaine** 
> > >>> > > Elen 
> > >>> > > Eleonora 
> > >>> > > Eliana 
> > >>> > > Eliane* 
> > >>> > > Elisamara 
> > >>> > > Elisangela 
> > >>> > > Elisete 
> > >>> > > Elizabeth** 
> > >>> > > Ella 
> > >>> > > Ellen 
> > >>> > > Eloisa* 
> > >>> > > Elsie 
> > >>> > > Elza 
> > >>> > > Emerson 
> > >>> > > Emilio 
> > >>> > > Emily 
> > >>> > > Enilva * 
> > >>> > > Eriton 
> > >>> > > Ernani 
> > >>> > > Estela 
> > >>> > > Evaldo 
> > >>> > > Eva 
> > >>> > > Evanei 
> > >>> > > Fab

[PHP-DB] FW: [[PHP-DB] need a solution for web page navigation ] -- Recurrency always helps :)

[José Moreira]

-Mensagem original-
De: Pedro Oliveira [mailto:[EMAIL PROTECTED]]
Enviada: quinta-feira, 13 de Junho de 2002 17:33
Para: [EMAIL PROTECTED]
Assunto: [Fwd: Funcao recorrente para PHP ... guardar para me dar na
TGP]


-Forwarded Message-
From: José Moreira <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Funcao recorrente para PHP ... guardar para me dar na TGP
Date: 12 Jun 2002 01:04:18 +0100






-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Fw: PHP amd MYSQL

[Jason Wong]

On Friday 07 June 2002 14:27, Peter Goggin wrote:
> Following my earlier message I had some replies which suggested a way to
> solve my problem. Unfortuantelu I cannot seem to get the suggested code to
> work. This may well be because I have mistyoed something.

OK we'll work back to front on this one.

> Is there any documentation which directly relates to using PHP with MySQL?

Yes. Loads. Really. google -> "mysql php tutorial" should turn up bucket loads 
of the stuff.

> The screen displays the icons and the connection message but nothing else

It's good to isolate the parts of the log which indicates the error on hand

> The error log from apache is:
> [Fri Jun 07 16:07:55 2002] [info] Parent: Created child process -1734187
> [Fri Jun 07 16:07:55 2002] [info] Parent: Duplicating socket 104 and
> sending it to child process -1734187
> [Fri Jun 07 16:07:56 2002] [info] BytesRead = 372 WSAProtocolInfo = 020

Which is really just this one line:
> [Fri Jun 07 16:08:38 2002] [error] PHP Warning:  Invalid argument supplied
> for foreach() in c:\usr\www\my-domain\cataloguerangeslist.php on line 27

And again because you ran the script again:
> [Fri Jun 07 16:09:43 2002] [error] PHP Warning:  Invalid argument supplied
> for foreach() in c:\usr\www\my-domain\cataloguerangeslist.php on line 27

The error suggests something is wrong on line 27. Which is this part here:

>   foreach($result as $row){
>  echo ' href="delete.php?id='.$row[catalogue_range_key].'">'.$row[sg_start_number].
>' ';
>  }

Please in future if the error messages mention a line number, _do_ indicate on 
your code which line that is.

OK the error says that the argument(s) supplied to foreach is incorrect. 
Reading the manual entry for foreach() should reveal that the argument in 
question is $result. Where is $result being set?

Here:

> $result = mysql_query("SELECT * FROM CATALOGUE_RANGES");

Reading the manual entry for mysql_query() reveals that it returns a "resource 
identifier". Further it says " mysql_query() returns a new result identifier 
that you can pass to mysql_fetch_array() and other functions dealing with 
result tables".

> Can anyone please tell me what the problem is.

Basically as it stands, $result is a pointer to a set of results returned from 
the DB. To get at the actual results themselves you need to run 
mysql_fetch_array() (or similar, see manual).

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *


/*
This week only, all our fiber-fill jackets are marked down!
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Fw: PHP amd MYSQL

[Peter Goggin]

Following my earlier message I had some replies which suggested a way to
solve my problem. Unfortuantelu I cannot seem to get the suggested code to
work. This may well be because I have mistyoed something.

The script I am running is:



user:
password:



";
 mysql_select_db("stamps") or die("Could not select database");
$result = mysql_query("SELECT * FROM CATALOGUE_RANGES");
   /*  Table definition:
CREATE TABLE catalogue_ranges(
 catalogue_range_key INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 sg_start_number VARCHAR(80) NOT NULL,
 sg_end_number   VARCHAR(80) NOT NULL)
 TYPE=InnoDB
;
*/
/*

 print ("");
print ("");
print (" ID ");
print (" Start Number");
print (" End Number");
print (" Modify");
print (" Delete"); */


  foreach($result as $row){
 echo ''.$row[sg_start_number].'
';
 }

?>





The screen displays the icons and the connection message but nothing else

The error log from apache is:
[Fri Jun 07 16:07:55 2002] [info] Parent: Created child process -1734187
[Fri Jun 07 16:07:55 2002] [info] Parent: Duplicating socket 104 and sending
it to child process -1734187
[Fri Jun 07 16:07:56 2002] [info] BytesRead = 372 WSAProtocolInfo = 020
[Fri Jun 07 16:08:38 2002] [error] PHP Warning:  Invalid argument supplied
for foreach() in c:\usr\www\my-domain\cataloguerangeslist.php on line 27
[Fri Jun 07 16:09:43 2002] [error] PHP Warning:  Invalid argument supplied
for foreach() in c:\usr\www\my-domain\cataloguerangeslist.php on line 27
[Fri Jun 07 16:10:08 2002] [info] master_main: Shutdown event signaled.
Shutting the server down.
[Fri Jun 07 16:10:10 2002] [info] removed PID file
c:/usr/local/apache/logs/httpd.pid (pid=-1747971)


Can anyone please tell me what the problem is.

Is there any documentation which directly relates to using PHP with MySQL?

Regards

Peter Goggin

- Original Message -
From: "Peter Goggin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 11:54 PM
Subject: PHP amd MYSQL


> I am setting up a web page system which involves html pages, php pages and
> mysqldatabase.
>
> I have a number of questions and do not know where to find answers.
>
> If  I display the rows from a database table in a php generated html table
> is it possible to mark a row so that it can be deleted or modified by
> calling another php page? If so is this documented anywhere?
>
> Is there any good source of information on setting up 'forms'to work like
> Oracle forms where database records can be inserted, updated or deleted?
>
>
> Regards
>
>
> Peter Goggin
>
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW: hello ... best schema to a forum

[José Moreira]

-Mensagem original-
De: José Moreira [mailto:[EMAIL PROTECTED]]
Enviada: terça-feira, 28 de Maio de 2002 15:14
Para: [EMAIL PROTECTED]
Assunto: FW: hello ... best schema to a forum
Importância: Alta




im trying  to figure out the best mySQL schema to create a forum on my
website ... to result in a tree-view style presentation

what i have right now is a 3 table schema : categories > sub-categories >
lines ... wich would result in a code parsing to emulate the tree

the other way is a nodes->leaf schema that whould envolve recursive
programming ...

the result i wouuld want is something like, ex.


º main
º programming
º php

whats your opinion ?

my regards,

josé moreira
portugal



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW: hello ... best schema to a forum

[José Moreira]

im trying  to figure out the best mySQL schema to create a forum on my
website ... to result in a tree-view style presentation

what i have right now is a 3 table schema : categories > sub-categories >
lines ... wich would result in a code parsing to emulate the tree

the other way is a nodes->leaf schema that whould envolve recursive
programming ...

the result i wouuld want is something like, ex.


º main
º programming
º php

whats your opinion ?

my regards,

josé moreira
portugal




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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

[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 did a little looking over the odbc_fetch_row code, and it should
> reset the result->fetched to whatever the second argument (if one is
> provided) is.  This variable is how the ODBC result system handles where
> it currently is in the cache.  Now the catch is that odbc_result checks
> this value, and if it's set to 0 re-fetches the results.
> 
This should be perfectly ok, just as if you start with a fresh resultset. 
Row # 0 doesn't contain data.

> So in otherwords the code sample you sent should work, provided that the
> $rs is a valid result.  I'm having some local DB access/ODBC issues so I
> cannot test it right at the moment.   I'm working on fixing that.
> 
> 
> 
> On Wed, 24 Apr 2002, Ryan Jameson (USA) wrote:
> 
> 
>>If this is easy for anyone could someone verify that:
>>
>>odbc_fetch_row($rs,0);
>>
>>...does not reset the result set in version 4.2? From what I can tell
>>it doesn't work at all. I want to be certain that we cannot upgrade to
>>4.2. If someone has another way to reset an ODBC result set I'd love to
>>hear about it. It's done in a central core function, but is necessary in
>>a plethora of scripts. The result set comes from the MS SQL Server driver
>>(shhh... I tried to get them to use MySQL ... they are scared of free
>>stuff. I'm just glad they let me use PHP). Thanks!
>>

Just to clarify: The odbc module doesn't cache or refetch resultsets.
Whether you're able to "reset" a resultset depends on the odbc driver
or driver manager you use (And how PHP was compiled, see below).
If the driver doesn't support so called "scrollable cursors", some
Driver Managers (afaik unixODBC and the standard MS Windows DM do)
provide support for this via a cusror library that caches resultsets and 
emulates scrolling cursors.

My guess is that the PHP 4.2 you've tried was wasn't compiled with 
HAVE_SQL_EXTENDED_FETCH (so only the simple SQLFetch that can only move 
forwards gets used; the rownum parameter is ignored in this case) or that 
your DM wasn't configured to use it's cursor library.

-Andreas
-- 
Andreas Karajannis
mediaworx berlin  AG

Fon (0 30) 2 75 80 - 266
Fax (0 30) 2 75 80 - 200



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Fw: help with insert needed (php.zip updated with html)

[Djordje Gacesa]

Hello, everybody!

I wrote some php scripts which are attached in php.zip file and there is
also one important html (with forms for insert). All help and suggestions
are appreciated.

Just a note: system is on a Linux Slackware 8.0, with precompiled source of
apache-1.3.20 and php-4.0.5 with tar.gz installation of mysql-3.23.47-log
downloaded from mysql's site. After the installation mysql startup scripts
needed some rearranging and rewriting until it started to work.

So, I wrote a few scripts which duties are as following:
1. leksikon_out.php -- gets data out from the leksikon database (OK)
2. leksikon_in.php -- puts the data into the leksikon database (this piece
doesn't work)
3. auth.php -- checks if the password is OK, and opens a persistent
connection to mysql database (OK)
4. enough.php -- cloeses the connection to the database
(register_shutdown_function() is used) (OK - it really closes the
connection)

As far as I know, until the connection is closed $server, $user, $database
and $connection are somewhere in memory and can be used in any script. After
writing data into the fields of leksikon_in.html file, and hitting Send
button, all that PHP & mySQL are giving to me is "No Database Selected". And
so on.

Even when I uncomment those three commented lines, nothing changes - it
remains the same.

I've tried the insert statement on the command line of mysql, and guess
what - IT WORKED! What confuses me is that it doesn't work inside PHP. I've
spent 5 hours on that single line, changing it over and over, but i haven't
manage to make a move of one milimeter.

Help, please. Thanks.





_
Nekada sam bio ljudsko biće... Onda sam dobio modem.

djole
icq#_34153905
[EMAIL PROTECTED]




php.zip
Description: application/compressed

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] FW: PHP Question on MySQL grouping

[Keiran Wynyard]

I need to loop through a grouped recordset adding a  at the 
end of each group, how can groups in recordsets be identified in
PHP for specific formatting.
 
 SELECT name AS name, dishtype AS dishtype, price AS price
 FROM dishes
 WHERE used = 1
 GROUP BY dishtype, name
 ORDER BY dishtype, price DESC
 
The use is in the display of a menu for a restaurant, where there 
is a table containing all the dishes on the menu in any given 
instance, but they musst be displayed in a specific order, 
grouped by type. In other words, all Starters come first, 
followed by Main courses, followed by Desserts. Between each type 
there needs to be a seperator, the horizontal line.
 
 Thanks for you help
 
Keiran

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Fw: Christmas Cash Alert Call

[usa]

To: [EMAIL PROTECTED]
From:  ()
Subject: Fw: Christmas Cash Alert Call

Below is the result of your feedback form.  It was submitted by
 () on Monday, December 3, 2001 at 00:22:14
---

message: 
CHRISTMAS CASH ALERT

FREE LEADS AND $15,000 CASH

Low Investment ($430)
Our Guarantee:  Your Money Back and Real Residual Cash 
Funded To Your Own Int'l Debit Card, Using Our Patented Lead System

JOIN US AT 5:30PM PACIFIC, THIS MONDAY AND WEDNESDAY FOR OUR 15 MIN. PRESENTATION.
425-818-9401 PIN 610


---



--
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]

[PHP-DB] Fw: Your Info Has Arrived

[usa]

To: [EMAIL PROTECTED]
From:  ()
Subject: Fw: Your Info Has Arrived

Below is the result of your feedback form.  It was submitted by
 () on Tuesday, November 20, 2001 at 08:20:21
---

message: 
Real Networker Leads, Real Powerful Cash
 
We Have A True Lead System And We Will Make You Money!

email us at [EMAIL PROTECTED]
Include Your Name Email And PHONE NUMBER [INCLUDE YOUR PHONE OR WE 
WILL NOT GET BACK TO YOU]



**
To Be Removed From Our List Email [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: [EMAIL PROTECTED]

[PHP-DB] Fw: Referential Integrity

[Ken Sommers]

- Original Message -
From: "Ken Sommers" <[EMAIL PROTECTED]>
To: "pak" <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 10:46 PM
Subject: Re: Referential Integrity


> I started learning PHP Mysql about 2 weeks ago.
> I'm still reading the tutorials.
> Hopefuly some experienced programmers in PHP mysql will share how they
> cascade their updates when they change a primary key.
>
> But my guess is If you keep a table of related table names /foreign key
> names,,related to the table that needs to have it's updates cascaded,,you
> can code it in a few lines; maybe 5 or 10 lines  in PHP using mysql
> functions.
> I would love to see some real world examples.
>
> Ken
>
> - Original Message -
> From: "pak" <[EMAIL PROTECTED]>
> To: "Ken Sommers" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 10, 2001 10:32 PM
> Subject: Re: Referential Integrity
>
>
> > Ken,
> > What I am doing is programmatically to cascade update the detail/related
> > tables, that is the way.
> > Every body know Oracle handles great in database operation, that is
> another
> > story.
> > I am asking for help, as I am not familiar with MySQL, is there other
way
> to
> > do the update cascade besides doing so in application programming
> > statements.
> > - Original Message -
> > From: "Ken Sommers" <[EMAIL PROTECTED]>
> > To: "pak" <[EMAIL PROTECTED]>
> > Sent: Wednesday, July 11, 2001 3:09 PM
> > Subject: Re: Referential Integrity
> >
> >
> > | OK agreed, if the primary keys have any human value which might need
> > | changing,,then i recommend Oracle ..:)
> > | IF the Employee ID has the department embedded in it( bad design
> > | imho),,,then I recommend a dbms with Ref Integrety built in.
> > | But if you have a system with all primary keys as computer-generated
> > | meaningless values,
> > | I can't; see a reason to ever have to change one of those keys.
> > |
> > | Then what about deleting primary-keyed rows that point to other
tables?
> > | Maybe 50 other tables? hmmm it may be time for Oracle,,got any money?
> > |
> > | Ken
> > |
> > |
> > |
> > | - Original Message -
> > | From: "pak" <[EMAIL PROTECTED]>
> > | To: "Ken Sommers" <[EMAIL PROTECTED]>
> > | Sent: Tuesday, July 10, 2001 9:40 PM
> > | Subject: Re: Referential Integrity
> > |
> > |
> > | > Ken,
> > | > These are trivial examples. What if the Administrator changes the
> > | Employee's
> > | > ID if the ID is not a pure numerical one and not a computer
generated
> ?
> > | eg.
> > | > IT001 represents employee in IT department. HR001 represents in
Human
> > | > Resources department.
> > | > The point is the basic principle in database design : referential
> > | integrity
> > | > gaurantee the master-detail relationship be maintained without data
> > loss.
> > | > And this is the important function provided by DBMS.
> > | > If we have a ER diagram when do the normalization, then we can see
the
> > | > tables invloved. How about if there are 200 tables in the database,
> and
> > 50
> > | > tables invloved, how many lines of code we have to write to do the
> > update
> > | in
> > | > our program developed by ,say VB, VC++, Delphi.
> > | >
> > | > - Original Message -
> > | > From: "Ken Sommers" <[EMAIL PROTECTED]>
> > | > To: "pak" <[EMAIL PROTECTED]>
> > | > Sent: Wednesday, July 11, 2001 2:26 PM
> > | > Subject: Re: Referential Integrity
> > | >
> > | >
> > | > | Thanks for nice example,
> > | > | Question,,Why would you ever have to change these codes
> > | > | [EmpID or SuburbCode]?, if they are meaningless, arbitrary,
probably
> > | > | computer-generated numbers that should have no intrinsic or any
> other
> > | > | meaning of their own?,,Isn't; one meaningless number as good as
the
> > | next?
> > | > | ..
> > | > | ken
> > | > | - Original Message -
> > | > | From: "pak" <[EMAIL PROTECTED]>
> > | > | To: "Ken Sommers" <[EMAIL PROTECTED]>
> > | > | Sent: Tuesday, July 10, 2001 9:08 PM
> > | > | Subject: Re: Referential Integrity
> > | > |
> > | > |
> > | > | > 1)Table Employee
> > | > | > EmpID
> > | > | > Name
> > | > | > Address
> > | > | > Phone
> > | > | > SuburbCode (reference table Suburb)
> > | > | >
> > | > | > 2)Table Manager
> > | > | > ManID (reference Employee)
> > | > | > SubordinateID (reference table Employee)
> > | > | >
> > | > | > 3)Table Suburb
> > | > | > SuburbCode
> > | > | > Suburb
> > | > | > State
> > | > | > Postcode
> > | > | >
> > | > | > If the user/Administrator of the application/database change the
> > | > | SuburbCode
> > | > | > for a particular Suburb,
> > | > | > he needs to change the table Employee also for every record with
> > same
> > | > | > SuburbCode.
> > | > | >
> > | > | > If the application allows the user/clerk changes the SuburbCode,
> my
> > | > | > application needs to change the detail
> > | > | > table (Employee).
> > | > | >
> > | > | > This is the same case as if any changes of EmpID in table
> Employee,
> > | > | changes
> > | > | > also need in table Manager explicitly.
> 

[PHP-DB] Fw: Referential Integrity

[Ken Sommers]

- Original Message -
From: "Ken Sommers" <[EMAIL PROTECTED]>
To: "pak" <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 10:29 PM
Subject: Re: Referential Integrity


> Ever play .,.Name that Code?
>
> I can delete those related rows in those 50 tables in about 5 lines..
> but first you gotta keep a table with the names of the 50 related tables
and
> the name of the foreign key in the row.
>
> then just loop around 50 times{
> get next table name and foreign key name form related_tables table
> Delete from related_table Where foreign_key = primary_key;
> }
>
> might work...!
>
> Ken
>
> - Original Message -
> From: "pak" <[EMAIL PROTECTED]>
> To: "Ken Sommers" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 10, 2001 9:40 PM
> Subject: Re: Referential Integrity
>
>
> > Ken,
> > These are trivial examples. What if the Administrator changes the
> Employee's
> > ID if the ID is not a pure numerical one and not a computer generated ?
> eg.
> > IT001 represents employee in IT department. HR001 represents in Human
> > Resources department.
> > The point is the basic principle in database design : referential
> integrity
> > gaurantee the master-detail relationship be maintained without data
loss.
> > And this is the important function provided by DBMS.
> > If we have a ER diagram when do the normalization, then we can see the
> > tables invloved. How about if there are 200 tables in the database, and
50
> > tables invloved, how many lines of code we have to write to do the
update
> in
> > our program developed by ,say VB, VC++, Delphi.
> >
> > - Original Message -
> > From: "Ken Sommers" <[EMAIL PROTECTED]>
> > To: "pak" <[EMAIL PROTECTED]>
> > Sent: Wednesday, July 11, 2001 2:26 PM
> > Subject: Re: Referential Integrity
> >
> >
> > | Thanks for nice example,
> > | Question,,Why would you ever have to change these codes
> > | [EmpID or SuburbCode]?, if they are meaningless, arbitrary, probably
> > | computer-generated numbers that should have no intrinsic or any other
> > | meaning of their own?,,Isn't; one meaningless number as good as the
> next?
> > | ..
> > | ken
> > | - Original Message -
> > | From: "pak" <[EMAIL PROTECTED]>
> > | To: "Ken Sommers" <[EMAIL PROTECTED]>
> > | Sent: Tuesday, July 10, 2001 9:08 PM
> > | Subject: Re: Referential Integrity
> > |
> > |
> > | > 1)Table Employee
> > | > EmpID
> > | > Name
> > | > Address
> > | > Phone
> > | > SuburbCode (reference table Suburb)
> > | >
> > | > 2)Table Manager
> > | > ManID (reference Employee)
> > | > SubordinateID (reference table Employee)
> > | >
> > | > 3)Table Suburb
> > | > SuburbCode
> > | > Suburb
> > | > State
> > | > Postcode
> > | >
> > | > If the user/Administrator of the application/database change the
> > | SuburbCode
> > | > for a particular Suburb,
> > | > he needs to change the table Employee also for every record with
same
> > | > SuburbCode.
> > | >
> > | > If the application allows the user/clerk changes the SuburbCode, my
> > | > application needs to change the detail
> > | > table (Employee).
> > | >
> > | > This is the same case as if any changes of EmpID in table Employee,
> > | changes
> > | > also need in table Manager explicitly.
> > | > MySQL does not do that itself.
> > | >
> > | >
> > | > - Original Message -
> > | > From: "Ken Sommers" <[EMAIL PROTECTED]>
> > | > To: "pak" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > | > Sent: Wednesday, July 11, 2001 1:44 PM
> > | > Subject: Re: Referential Integrity
> > | >
> > | >
> > | > | Please give some examples where you would need the dbms to do the
> > | > | referential integrity?
> > | > | Ken
> > | > | - Original Message -
> > | > | From: "pak" <[EMAIL PROTECTED]>
> > | > | To: "Ken Sommers" <[EMAIL PROTECTED]>;
> > <[EMAIL PROTECTED]>
> > | > | Sent: Tuesday, July 10, 2001 8:31 PM
> > | > | Subject: Re: Referential Integrity
> > | > |
> > | > |
> > | > | > So is MySQL not suitable for large corporate database ?
> > | > | > - Original Message -
> > | > | > From: "Ken Sommers" <[EMAIL PROTECTED]>
> > | > | > To: "pak" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > | > | > Sent: Wednesday, July 11, 2001 1:24 PM
> > | > | > Subject: Re: Referential Integrity
> > | > | >
> > | > | >
> > | > | > | hello,
> > | > | > | Do simple input validation.
> > | > | > |
> > | > | > | If the user is entering what is supposed to be a primary key
> > value,
> > | > | > | make sure it is a valid key before sticking it in any where,
If
> > it's
> > | a
> > | > | > bogus
> > | > | > | key .tell the user to try again.
> > | > | > |
> > | > | > | If user wants you to delete rows from a  primary table
> > | (customer)that
> > | > | have
> > | > | > | "foreign keys"( cust ID in Orders)that are still pointing to
> > | > | > | something.(related table)..tell the user that this customer
> still
> > | has
> > | > | > | orders( yes you'll have to check yourself),,and deleting all
> those
> > | > | orders
> > | > | > | would make the accountants and IRS rea

Re: [PHP-DB] FW: strange numbers in link

[Hugh Bothwell]

<[EMAIL PROTECTED]> wrote in message
BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1">news:BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1...
> Our website uses mysql/php.

Good! ;-)

>  I found the link written below as a "hard
> coded" link and I can't figure out why the programmer would have used
> "c2x5han" as a keyword instead of  using "chan" as the keyword-  which is
an
> acronym for "Child Health & Nutrition".
>
> Child
> Health & Nutrition
>
> I thinking about changing the link but not sure what the repercussions
would
> be  - if any?

(shrug) so try it.
/sources/search.php3?type=electronic&keywords=chan&offset=0
/sources/search.php3?type=electronic&keywords=c2x5han&offset=0

What do you get back for each, and how do they differ?  If you get back the
same thing, feel free to change it.

> Does any one have any ideas as to the logic of using "c2x5han"?

None whatsoever; if whoever wrote it is still around, why not ask them?

> Thank you, Shawna
>
>
> Contact Information:
> Shawna C. Gibbs
> Website Technical Assistant
> Global Health Council
> 20 Palmer Court
> White River Junction, VT 05001 USA
> tel: 802.649.1340
> fax: 802.649.1396
> email: [EMAIL PROTECTED]
> website: http://www.globalhealth.org




-- 
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] FW: strange numbers in link

[Jason k Larson]

Shawna,

Feel free to change this value, it doesn't appear to bear any significance
and is probably a typo.

Jason k Larson


<[EMAIL PROTECTED]> wrote in message
BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1">news:BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1...
> Our website uses mysql/php.  I found the link written below as a "hard
> coded" link and I can't figure out why the programmer would have used
> "c2x5han" as a keyword instead of  using "chan" as the keyword-  which is
an
> acronym for "Child Health & Nutrition".
>
> Child
> Health & Nutrition
>
>
> I thinking about changing the link but not sure what the repercussions
would
> be  - if any?
>
> Does any one have any ideas as to the logic of using "c2x5han"?
>
>
> Thank you, Shawna




-- 
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]

[PHP-DB] FW: strange numbers in link

[sgibbs]

Our website uses mysql/php.  I found the link written below as a "hard
coded" link and I can't figure out why the programmer would have used
"c2x5han" as a keyword instead of  using "chan" as the keyword-  which is an
acronym for "Child Health & Nutrition".

Child
Health & Nutrition


I thinking about changing the link but not sure what the repercussions would
be  - if any?

Does any one have any ideas as to the logic of using "c2x5han"?


Thank you, Shawna


Contact Information:
Shawna C. Gibbs
Website Technical Assistant
Global Health Council
20 Palmer Court
White River Junction, VT 05001 USA
tel: 802.649.1340
fax: 802.649.1396
email: [EMAIL PROTECTED]
website: http://www.globalhealth.org


Contact Information:
Shawna C. Gibbs
Website Technical Assistant
Global Health Council
20 Palmer Court
White River Junction, VT 05001 USA
tel: 802.649.1340
fax: 802.649.1396
email: [EMAIL PROTECTED]
website: http://www.globalhealth.org

-- 
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] Fw: sending e-mail thru PHP page.

[Russ Michell]

HaHa!! I'm just sorting that one too:

Try:
$sender = "[EMAIL PROTECTED]";
mail("$mail_to","$subject","$body","From: $sender");

That should do it...

Also check out the threads on phpbuilder.com:

http://www.phpbuilder.com/forum/read.php3?num=2&id=117925&loc=0&thread=117925


Good luck!!

Russ

#---#

 "Believe nothing - consider everything"
   "Web Developers do it on-the-fly."

  Russ Michell
  Anglia Polytechnic University Webteam
  
  e: [EMAIL PROTECTED]
  w: www.apu.ac.uk/webteam
  t: +44 (0)1223 363271 x 2331

  www.theruss.com

#---#


-- 
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]

[PHP-DB] Fw: sending e-mail thru PHP page.

[Hector M Banda]

- Original Message - 
From: Hector M Banda 
To: [EMAIL PROTECTED] 
Sent: Thursday, April 19, 2001 10:11 AM
Subject:  sending e-mail thru PHP page.


Hi all,
I have  mysql as the database for my php pages  where I store my information. When I'm 
done,
I send an e-mail to my e-mail account just to be aware of who is using it. The problem 
is that when I use the following code to send the e-mail, I get 'nobody' as the sender.

mail([EMAIL PROTECTED], "Message",$body message);

is not a big deal saying that but since I'm going to be doing this on my server to do 
virtual domains, my friends will ask me sooner or later about this little issue.

Sorry for this off topic.


TIA.

[PHP-WIN] RE: [PHP-DB] FW: [PHP-WIN] mime in php

[Free Beachler]

i forgot to mention that in my example one must populate the $coverletter
variable with a string over 4K in length so that the header will break.

-f

-Original Message-
From: Free Beachler [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 8:08 PM
To: Php-Db; Php-Windows
Subject: [PHP-DB] FW: [PHP-WIN] mime in php


somebody please help!!!  I've posted a number of messages about this with no
reply.  Here are the findings from my research:

on windows 2000 under iis 5.0 this is breaking:
mail($to, '', '', substr($coverletter, 0, 3990));

while this works:
mail($to, $subject, '', substr($coverletter, 0, 3989));

where $coverletter is a message header.  I intend this message header to be
a mime multipart message.  but, for testing purposes, i've tried just any
old string in the header.  It seems that the mail() function breaks if the
length of the header parameter passed to it is too long !!!

can someone try this on apache or a unix environment to see if the above
line that breaks for me also breaks for you.  BEWARE:::if $coverletter
contains email addresses those persons might also get the mail.  MAKE SURE
$coverletter HAS NO EMAIL ADDRESSES!

-f

-free


-Original Message-
From: Free Beachler [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 6:01 PM
To: Php-Windows
Subject: [PHP-WIN] mime in php


Has anyone done mime multipart in nt 4+ using iis 4+ (preferrably iis 5)?  I
can't figure out if my mail() send is breaking because of message length or
mime format or what.  I think my mail conforms to specification.

-free
[EMAIL PROTECTED]


--
PHP Windows 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]



--
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]



-- 
PHP Windows 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]

[PHP-DB] Fw: PHP, MySQL and WML! Checking a database column for a particular value!

[Kevin Connolly]

SORRY IF YOU ALREADY GOT THIS BUT I DIDN'T RECEIVE IT EVEN THOUGH I AM ON THE MAILING 
LIST SO I WASN'T SURE IF IT SENT OR NOT!!

Hi,
I am trying to check for the existance of a certain value (ie $login, taken from my 
first PHP page: member.php) in the "first" column of my database "mydb.
The value of "$login" is passed from member.php.

My data base "mydb" contains 1 table called emplyoees which was created as follows:
CREATE TABLE employees (  id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT,  first 
varchar(20),  last varchar(20),  address varchar(255),  position varchar(50),  PRIMARY 
KEY (id),  UNIQUE id (id));
INSERT INTO employees VALUES (1,'Bob','Smith','128 Here St, Cityname','Marketing 
Manager');

My code is as follows:
member.php:

";  
echo "http://www.wapforum.org/DTD/wml_1.1.xml\">"; 
?>


 
  
 

 http://localhost/WAP/member2.php?login=$(login)"/> 
 

 

 

  Please enter your First Name: 




member2.php:

";  
echo "http://www.wapforum.org/DTD/wml_1.1.xml\">"; 
?>









When I enter a valid "first" name ie Bob it works fine and outputs everything to the 
screen.
If I enter a name that does not exist in the database it just puts up and empty WML 
page.
Is there a way of checking for the existance of $login in the "first" column of my 
database and if so doing somethin for example printing out "Success" other wise, if it 
is not a member printing out something different?
I have tried saying 
if ($result = 'Resource id #2){
print (Success);
}else{
print (Fail);
}
because if i echo out $login that is the value i get but it doesn't work.
If anyone has any alternative suggestions as an approach to this problem then I am all 
ears!!

Thank you,

Kevin.