Hello Noah,
On 22-Jun-01 21:17:35, you wrote:
what are the advantages and disadvantages of primary keys and indices?
A primary key is a unique index.
Use indexes for the fields that will be most looked up in the first
condition of the WHERE clause of your SQL queries, especially if your
Do you get an Oracle error code back?
What version of PHP are you using?
Cheers,
Graeme
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf
Of Ludo
Sent: Saturday, 23 June 2001 1:31 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] ORACLE 8 randomly
** Reply to note from Jonathan Hilgeman [EMAIL PROTECTED] Fri, 22 Jun 2001 14:44:57
-0700
Jonathan asks:
Whats your query look like? Do you perform any joins?
$query = SELECT * FROM $table WHERE CustNo='$CustNo';
Pretty vanilla stuff.
[ . . . ]
BUT! If the field is NULL, php spits out
I'm trying to figure out the most elegant way to solve my database design
problem and I thought I pick some at the brains on this list.
The problem involves 2 tables, one of editors and one of categories, both
have unique ID numbers. Each editor can have authority over an arbitrary
number of
With reference to my previous problem in connecting to the oracle
database, I found out some additional information.
I defined the TNS_ADMIN variable in the startup file and added
this line to my php-script:
putenv(TNS_ADMIN=/ora1/app/oracle/product/8.1.6/network/admin);
The problem involves 2 tables, one of editors and one of categories, both
have unique ID numbers. Each editor can have authority over an arbitrary
number of categories, and conversely, each category can have an arbitrary
number of editors. So what is the best way to represent this in the
On Friday 22 June 2001 15:03, Martin Pavlas wrote:
Hi all,
I'm totaly lost. I have a Linux server (Debian Potato), which runs
Apache (1.3.14) + PHP (4.0.5) and MySQL (3.23.39).
Now, I need to connect to other machine (NT) which runs MS SQL 7 and I
need to insert some data to this machine.
With indices you speed SELECTs, but slow INSERTs and UPDATEs.
Noah Spitzer-Williams [EMAIL PROTECTED] ha scritto nel messaggio
9h0n6v$l2h$[EMAIL PROTECTED]">news:9h0n6v$l2h$[EMAIL PROTECTED]...
what are the advantages and disadvantages of primary keys and indices?
- Noah
--
PHP Database
El sábado 23 de junio de 2001 (13:52), Kristian Duske escribió:
The problem involves 2 tables, one of editors and one of categories, both
have unique ID numbers. Each editor can have authority over an arbitrary
number of categories, and conversely, each category can have an arbitrary
I just found the apache.org docs on this yesterday.
Read about it there, then form a more specific question, as .htacess can
do lots of things
url:
http://httpd.apache.org/docs/
that's where I'd begin.
Chadwick Rolfs
On Fri, 22 Jun 2001, vipin chandran wrote:
Hi,
Can anyone tell me
I am running oracle-8.1.6 on RH 7.0 with apache 1.3.14 and
php4.0.4. We are developing a system which might be required to take very
heavy loads. How do we improve the load factor so as to enable maximum
number of connections simultaneously? What changes have to made to either
I see,
What about if you had 3 or 4 columns that would always be unique, is there
an advantage to naming them as primary keys? does this slow inserts because
it has to check if theres a duplicate entry?
Manuel Lemos [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL
I get *.csv file like this (1 string):
7,'Markovic Stevo','NULL','NULL'
When I use LOAD DATA INFILE syntax I get word NULL in cell (MySQL table)
q: I want cell to be empty (in table), where the NULL is (in *.csv), how?
tomaz, Slovenia
Hello Noah,
On 23-Jun-01 12:10:20, you wrote:
I see,
What about if you had 3 or 4 columns that would always be unique, is there
an advantage to naming them as primary keys? does this slow inserts because
it has to check if theres a duplicate entry?
What really slows down is updating the index
Yeah the keys would be part of the first condition of the where clause...
this table is like this:
username | siteid | bannerid | clicks | someotherstat
an update would be like: update tbl set clicks=clicks+1 where
username='something' and siteid='something' and bannerid='something'
a select
** Reply to note from [EMAIL PROTECTED] 23 Jun 2001
06:24:11 -
Hello, Todd:
Is there a way to dynamically build an option list from an enum/set
type? In other words, if I don't know the possible values of the
enum or set field ahead of time, how can I retrieve that information
at
** Reply to note from Jonathan Hilgeman [EMAIL PROTECTED] Fri, 22 Jun 2001 14:44:57
-0700
Jonathan asks:
Whats your query look like? Do you perform any joins?
Hmmm . . . everything after $query got chopped off, and didn't
display in the digest version I received. Well, I'll try again:
*
Hello Noah,
On 23-Jun-01 14:29:58, you wrote:
Yeah the keys would be part of the first condition of the where clause...
this table is like this:
username | siteid | bannerid | clicks | someotherstat
an update would be like: update tbl set clicks=clicks+1 where
username='something' and
Hello,
Thank you! this wont slow updates or inserts?
Not the updates. The update query will use the index to lookup find the
table line that it will update. Then, since you will not change any of the
indexed columns the index does not need to be updated too.
Manuel Lemos
- Original
dear list
I have attempted to use session end to no avail. I have a
self-referencing form with a button, that when checked and sent, calls
session_end(). I get a call to undefined function error.
Does there need to be something compiled into the php module? Everything
else seems to work with
Antonio M?rmol Albert ([EMAIL PROTECTED]) wrote:
With index in the third table, How would it be ?
It depends on the dynamics of the application.
1) If you have to ask what cateogories does the editor edit?, you
create an index on editor.
2) If you have toa sk what editors does this category
try session_destroy()
olinux
-Original Message-
From: Chadwick Rolfs [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 23, 2001 12:39 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] session_end()
dear list
I have attempted to use session end to no avail. I have a
self-referencing form with
www.oosha.com/phpdev/index.php3
Ive had some great response to the site but not as much as id hoped if you
have any ideas please email them to me and ill implement them
--
[EMAIL PROTECTED]
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL
With index in the third table, How would it be ?
PRIMARY KEY (editor, category)
or
KEY (editor),
KEY (category)
What's the better (more efficient and correct) ??
I don't really know - I personally use a third id field as a primary key,
but if you want to use REPLACE to update / insert
I really need help here. What I am trying to do is the following.
-
$today = date(m.d.y);
$time = date(g:i a);
if($row[3] == $today){
if(($row[4] $time) and ($time $row[6])){
print(Now Showing);
} else {
print(Today at $row[4]);
}
}
check out http://www.php.net/manual/en/function.mktime.php
If you still need assistance, I'm here.
On Sun, 24 Jun 2001, Matthew Cothier wrote:
I really need help here. What I am trying to do is the following.
-
$today = date(m.d.y);
$time = date(g:i a);
if($row[3] ==
At 22.06.2001 16:22, you wrote:
Very strange
Warning: mail() is not supported in this PHP build in
/virtual/sergio/public/prova.php on line 18
What's this ?
This is _totally_ unrelated to php-db, and should have been posted on the
php-general list!
But basically your php install hasn't
e, sergio (oz. admin), rekompajlaj php na serverju z mail() funkcijo
omogoceno, oz. jo omogoci kako drugace, ce znas:)
p.s. in ni prova, nego je proba :)
lp, tomaz
At 22.06.2001 16:22, you wrote:
Very strange
Warning: mail() is not supported in this PHP build in
28 matches
Mail list logo
