, should not be too hard to
come up with a couple of lines of code to display only 1 variable based on
the value of variable 5. Overhead should be pretty minimal as well
You'll be writing something to display a value anyway
Jack van Zanen
-
This e-mail and any attachments may
.
Jack van Zanen
-
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment
).
Any help would be greatly appreciated.
Thanks,
Karl
Design Drumm
Sent from losPhone
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Jack van Zanen
-
This e-mail and any attachments may contain
List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Jack van Zanen
-
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware
culprit is number 2.
Jack van Zanen
-
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any
I thought he said he was using the gmail smtp server?
Jack van Zanen
-
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying
Just keep in mind that while that may be a very possible solution when
datasets are small. This could get problematic when for instance there are a
10 years worth of dates and millions of records in the other tables. The
resulting program could end up taking lots of time to display data. In your
in my understanding/code.
Can you see what it is?
-Govinda
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Jack van Zanen
-
This e-mail and any attachments may contain confidential material for the
sole
be different for each entry in the database.
$id=1 or 2 or 3 etc...
and
$note = a href=http://example.com;Example/a
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Jack van Zanen
-
This e-mail and any
and will not be included in the query.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Jack van Zanen
-
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you
_
// Diseño Comunicación //
+
_
// emiliano.borag...@gmail.com /
// 15 40 58 60 02 ///
+
_
--
Jack van Zanen
-
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient
://www.php.net/unsub.php
--
Jack van Zanen
-
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any
_
Reunite with the people closest to you, chat face to face with Messenger.
http://go.microsoft.com/?linkid=9650736
--
Jack van Zanen
-
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you
That looks like it should work, just execute the select query and see what
is the output
Jack
2008/12/29 Keith Spiller larent...@hosthive.com
Another option that would work if I can figure out the correct syntax is to
just NULL certain values if a given condition exists. If
did they change the source at WoWhead?
2008/12/11 Nicholas Mercier [EMAIL PROTECTED]
So I had a code project that took the name of a piece of equipment in World
of Warcraft - pulled the XML from WoWhead and pulled the database item
number from the XML file. It worked for a long while and
Just put the time out in your PHP.INI file
max_execution_time = 30 ; Maximum execution time of each script, in
seconds
2008/10/16 Piyush Kumar [EMAIL PROTECTED]
I'm using http://myclient.polarlava.com/ as web query interface for mysql
server
Now I want to add Query Timeout functionality
I am not up to scratch with innodb, but in oracle
you would have a Primary key on both the id fields in the Car and person
table and a Foreign key on PersonId linking it to Id in the Person table.
IN your select an index on PersonId would be beneficial if the tables get
large.
Jack
2008/10/2 J
If it were Oracle I'd go with one database and separate schema for each
blog.
For Mysql I think I'd go for a database each blog.
Jack
2008/9/28 Martin Zvarík [EMAIL PROTECTED]
Hi,
I am working on a blog system and I am currently thinking of what would be
the best DB approach.
I have read
Hi
If I am not mistaken,
the second part of the union contains all rows that are in the first part of
the union. just remove the first part.
Also
What is the table sizes of the tables?
How many records are expected to come back from the union sub query?
How many records are expected to
]
Jack van Zanen wrote:
Hi
If I am not mistaken,
the second part of the union contains all rows that are in the first part
of
the union. just remove the first part.
Kind of.
The first part is a join, the second isn't.
I was going to suggest rewriting the subquery into a single:
where
As a caution,
I would never, ever use a query that relies on the data to be returned from
the table in a certain order. That is just wrong and goes against the
principals of a rdbms.
Just write your queries in such a way that the result is always returned the
way you want it regardless of the
Try
to_char(task_start-(+480/1440),'mm/dd/yy-hh24:mi') as
task_start),to_char(task_end-(+480/1440),'mm/dd/yy-hh24:mi') as task_end
,task_owner,label_phase,to_char(task_actual_start-(+480/1440),'mm/dd/yy-hh24
:mi') as task_actual_start
Jack
-Original Message-
From: hridyesh pant
I agree it depends on the architecture, however...
100 is not that many records.
I personally like to keep my data together that could/should be used together.
Jack
-Original Message-
From: Evert Lammerts [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2008 7:15 AM
To:
10.2.0.4 client
apache 2.2
php 5.2.6
Thanks
On 01/09/2008, Evert Lammerts [EMAIL PROTECTED] wrote:
Can you send your and the output of phpinfo when run from the command
line and when run from the browser?
On Mon, Sep 1, 2008 at 6:35 AM, Jack van Zanen [EMAIL PROTECTED] wrote:
Hi List,
I
apache's and PHP's logs say?
On Mon, Sep 1, 2008 at 1:25 PM, Jack van Zanen [EMAIL PROTECTED] wrote:
Attached is phpinfo() both from the command line and from apache on the
same
machine
I have done the exact same setup on my laptop and it works fine from
apache
and cli.
I even
that it worked ok
I really need to understand more about windows I guess
Jack
-Original Message-
From: Evert Lammerts [mailto:[EMAIL PROTECTED]
Sent: Monday, September 01, 2008 10:32 PM
To: Jack van Zanen
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] OCI8 , PHP and APACHE issue
Hi List,
I have installed Oracle, PHP and apache on my windows machine and have the
following issue
If I run phpinfo() from the command line it shows OCI8 as enabled and I can
connect to oracle databases.
When I copy my php.ini to my windows directory (from my php directory) and
start apache
Hi
I have written a little program that cycles through a list of databases and
checks conectivity. it writes the status of this to a table
now to check all 143 databases it takes about 50 seconds and I was wondering
if this sounds about right to you guys.
?php
//Include the required
Jack
On 27/08/2008, Chris [EMAIL PROTECTED] wrote:
Jack van Zanen wrote:
Hi
I have written a little program that cycles through a list of databases
and
checks conectivity. it writes the status of this to a table
now to check all 143 databases it takes about 50 seconds and I
Hi
my example earlier does not show the email address in the source of the
displayed web page.
It is in the source code, but you can change that to be put in a config file
and include this file in the script.
Jack
-Original Message-
From: howard gramer [mailto:[EMAIL PROTECTED]
Sent:
check your apache httpd.conf (or iis configuration or whatever your
webserver is)
see if you told it to parse php scripts before presenting it to the web.
***
LoadModule php4_module c:/php/sapi/php4apache2.dll
AddType application/x-httpd-php .php
***
or
Hi,
I installed Apache/2.0.47 (Unix) PHP/5.0.0b1 pretty much the same way I
installed version 4.3.3 on this apache and both work fine with Mysql
straight from the start. This is on Linux and I did compile features into
Apache
***
MySQL Support enabled
Hi
You did not mention your DB , but following syntax should get you on your
way
select tbl1.user_id
, tbl1.username
, tbl2.age
, tbl3.town
, tbl3.country
fromtbl1
, tbl2
, tbl3
where tbl1.user_id=tbl2.user_id
and tbl1.user_id=tbl2.user_id
and
Hi
I don't know how this shared library works, but to the best of my knowledge you'll
always need oracle client software (SQL*Net) installed on the php server to connect to
an oracle database . Please correct me if I'm wrong and point me to the docs.
Tia
Jack
-Original Message-
Hi
I have a date that is formatted in the following way
day(00-31)/Mon(Jan-Dec)/year(2003):hour(00-23):minute(00-59):sec(00-59)
I want to load this into mysql table (date column)
In oracle I can just use the to_date function but all I find about MYSQL
seems to want the date in a specific
that just before midnight every day I load the data.
I'll look at my PHP insert script one day to see if I can easily change this
to pre format the date field .
Jack
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]
Sent: dinsdag 26 augustus 2003 1:13
To: Jack van Zanen
Hi List,
I have installed MYSQL 4.1 with support for derived tables. If I query Mysql
with a query that has a subquery in the from clause it works fine. If I now
load this query in PHP I get invalid resource error. If I change the select
for another select w/o the subquery it works fine (So my
37 matches
Mail list logo