You may have hit the browser time-out limit, which you can not control (at
least for IE; don't know about others).
To prevent this, arrange for the script send regularly some invisible
content to the browser
(eg send a HTML comment line every 100 lines of your CSV file)
HTH
Ignatius
_
The standard way is XSLT, for which PHP has excellent support.
However, it takes some effort to learn the language.
Get yourself "XSLT" by Michael Kay, Wrox Press.
HTH
Ignatius
_
- Original Message -
From: "stefan bogdan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
If your "&" is meant as a content data, as opposed to an entity call, then
your XML is probably not valid.
To write "&" as a character, you can either:
- use & directly
- declare an & entity having the value & and write & in your
document
HTH
Ignatius
_
- Original Mess
at the top of your script, do:
setlocale ( LC_TIME, 'de_DE' ) ;
(assumes your machine has German support installed)
HTH
Ignatius
_
- Original Message -
From: "Ruprecht Helms" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 26, 2003 16:58
Subje
One possible reason you did not google back anything is that what you are
asking can't be done in SQL.
In SQL you can update only one table at a time.
Why not write a PHP function that does the job successively on each table?
To list tables in MySQL: SHOW TABLES FROM
HTH
Ignatius
__
nother
table.
Ignatius
_
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Ignatius Reilly" <[EMAIL PROTECTED]>
Cc: "PHP DB list" <[EMAIL PROTECTED]>
Sent: Thursday, November 27, 2003 16:02
Subject: Re: [PHP-DB] Updating multilple tables?
> All go
PHP est un langage de programmation, pas un daemon.
Le plus simple est de créer des tâches automatisées qui exécutent des
scripts PHP.
Sous Windows 2000 c'est très facile: Scheduled Task > Command prompt >
(terminer)
Ensuite tu édites la scheduled task: Properties > Run > c:/php/php.exe
c:/tasks/m
Dear friend, you're besides the point and needlessly condescending.
Michel was asking about something very different: PHP cron jobs, not time
intervals.
Ignatius
_
- Original Message -
From: "Ivan Fomitchev" <[EMAIL PROTECTED]>
To: "Michel GUIRAUDOU" <[EMAIL PROTECT
header( "Location: http://..."; ) ;
_
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 02, 2003 12:18
Subject: [PHP-DB] Redirect.
Hi all,
I have a problem.How can I redirect from a PHP script to another script in
asp,
If you have to build complex, dynamic tables, do yourself a favour and use a
class that will allow you to feed directly arrays of numbers.
I use PEAR HTML_Table, which is great and easy to use.
You will have recouped the investment of learning the class after about one
hour.
HTH
Ignatius
_
I would not consider a DB-based design.
I use two approaches (sometimes mixed):
1. Write content in XML files (one per language) and transform them with
XSLT. This is nice for mostly content-based sites.
2. Write the complete application in English and translate it with the
excellent PHP gettext
ent, they'll send you a Spanish one back without messing
> with your tags - only the content gets translated.
>
> Of course, it DOES all come down to dollars and cents and how important
the
> translation really is; only you can decide that.
>
> HTH
>
> Rich
>
Quite right.
When implementing gettext, one will normally use the rule 1 string = 1
sentence (such as "please select a country").
_
- Original Message -
From: "Richard Davey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 15, 2004 19:48
Subject
Somebody with admin rights to this list please castrate this Farinelli user.
Thanks
_
- Original Message -
To: "Ignatius Reilly" <[EMAIL PROTECTED]>
Sent: Thursday, January 15, 2004 20:22
Subject: L'utente Fabio Farinelli ha cambiato indirizzo
extremely powerful.
In addition you can use XSLT if the news are stored as XML strings in the
DB.
HTH
Ignatius
_
- Original Message -
From: "Muhammed Mamedov" <[EMAIL PROTECTED]>
To: "Ignatius Reilly" <[EMAIL PROTECTED]>; "phpdb"
Usually it is the other way round:
to assemble a page, a script will call successively several XSLT
transformations: eg top, left nav bar, central content, footer...
Each XSLT call returns HTML from content stored in XML.
Ignatius
>
> I also wonder if XSLT can accept any php code?
>
>
--
PHP Dat
Standard SQL for comparing strings is LIKE
'=' in lieu of 'LIKE' is a MySQL extension to SQL, therefore non-standard.
Ignatius
_
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 16, 2004 15:39
Subject: [PHP-DB] MySQL gener
The same can be achieved in a much simpler way with Gettext!
With gettext, you send a file to your translator, and receive the same file
completed. Period.
Instead of logging to a DB, the translator simply creates string
translations with a user-friendly editor, such as the excellent POEdit
(http:
SELECT favourite_nb, COUNT(*) AS tally
FROM mytable
GROUP BY favourite_nb
HTH
Ignatius
_
- Original Message -
From: "js" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 30, 2004 19:07
Subject: [PHP-DB] counting a value
i want to know what i can u
The best way I can think of is:
- create a temporary table T with an autoincrement field + desired output
column structure
- perform a INSERT INTO T SELECT 0, in the temp table
- you now have the desired result in your temp table
HTH
Ignatius
_
- Original Message -
Hmmm...
I would not bet money on John Holmes bad coding.
(disclaimer: I have no financial stake in PHP|A, other than being a happy
subscriber)
More likely the original question was not well formulated.
cheers
Ignatius
_
- Original Message -
From: "Martín Marqués" <
C'est possible!
I use the PEAR Spreadsheet_Excel_Writer for this purpose. Very nice.
HTH
Ignatius
_
- Original Message -
From: "Christine Clerc" <[EMAIL PROTECTED]>
To: "PHP DB list" <[EMAIL PROTECTED]>
Sent: Monday, February 02, 2004 11:02
Subject: [PHP-DB] From
By "pop-up" do you really mean "pop-up" or rather drop-down boxes?
Have a look at the PEAR Quickform class and its "hierselect" form element
(hierarchical dropdown boxes)
http://pear.php.net/manual/en/package.html.html-quickform.tutorial.php
HTH
Ignatius
_
- Original M
Check this class:
http://sourceforge.net/projects/phpexcelreader/
HTH
Ignatius
_
- Original Message -
From: "Griffiths, Daniel" <[EMAIL PROTECTED]>
To: "Bruno Pereira" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 06, 2004 10:10
Subject: RE: [PHP-D
A bit of algebra first:
any expression formed of atomic expressions, AND, OR and parentheses can be
reduced to a "canonical" form, by using the De Morgan laws:
a AND ( b OR c ) is equiv. to a AND b OR a AND c
So a rule can eventually be reduced to "AND" groups, joined by "OR":
a(1) AND... AND a(n
Quotes:
$_POST['testField']
_
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 07, 2004 20:36
Subject: [PHP-DB] Question
> Dear friends,
>
> On submitting form to mysql database I get a parse error,There is no
problem
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-
> F
k that the required monomes have been associated as
a complex rule.
HTH (hope I am right! - not tested)
Ignatius
_
- Original Message -
From: "John Dillon" <[EMAIL PROTECTED]>
To: "Ignatius Reilly" <[EMAIL PROTECTED]>
Sent: Saturday, February
k 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
>
>
> > -O
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 datab
UPDATE table
SET column = CONCAT(
MID( column, 2, LENGTH( column ) - 1 ),
MID( column, 1, 1 )
)
WHERE column LIKE 'M%'
HTH
Ignatius
_
- Original Message -
From: "Shaun" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 10, 2004 14:15
Subjec
Hmmm...
Better try:
WHERE (LEFT( Brick,3) = LEFT(`Post Code`,3))
^^ no quotes^^ back ticks (because of the
space in the column name)
HTH
Ignatius
_
- Original Message -
From: "Ricardo Lopes" <[EMAIL PROTECTED]>
To: "Shaun" <[EMAIL PR
Unless you are using 4.1 (which allows subqueries), you should perform 3
queries, the first 2 creating temporary tables:
- sum
- difference
- left join
Ignatius
_
- Original Message -
From: "rogue" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February
G'day, mate,
With MySQL LOAD statement, you can specify which columns of your text file
goes to what DB column.
HTH
Ignatius
_
- Original Message -
From: "JeRRy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 01, 2004 10:08
Subject: [PHP-DB] plain-
# if applicable
( First, Last, Title ) # actual order of your
columns in your txt file, mapping columns names
HTH
Ignatius
_
- Original Message -
From: "JeRRy" <[EMAIL PROTECTED]>
To: "Ignatius Reilly" <[EMAIL PROTECTED]>; <[EMAIL
Two ways:
- full path (like "c:/temp/data.txt")
- simple file name: MySQL will assume the file is located in the current
database data directory (like d:/mysql/data/my_database)
_
- Original Message -
From: "JeRRy" <[EMAIL PROTECTED]>
To:
Your question is rather vague. What kind of "help" are you seeking?
If of the kind "contracting out", we'll be glad to answer your RFQ.
Cheers
Ignatius
__
AUDERGHEM ANALYTICA
Web applications specialists
www.auderghem-analytica.com
Brussels, Belgium
_
SELECT
...
FROM users
WHERE FIND_IN_SET( 2, values ) > 0
Ignatius
_
- Original Message -
From: "peppe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 04, 2004 12:28
Subject: [PHP-DB] SELECT
> Hi I have a table users with columns name email and
$rowArray = mysql_fetch_array($result);
> $access1 = $rowArray[1];
>
> if ($access1 =='2'){
> echo "Access is 2 ";
> } else {
> echo "acces is not 2";
> }
> }
>
> I get always access not 2 how can I make this If works
&
You can do it in SQL:
INSERT
...
SET = NOW()
Ignatius
_
- Original Message -
From: "..: GamCo :.. Gawie Marais" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 04, 2004 14:35
Subject: [PHP-DB] Php datetime
> hi,
>
> i have created a mysql table
Check the excellent JPgraph library.
http://www.aditus.nu/jpgraph/
_
- Original Message -
From: "Carlos D. Carrasco" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 06, 2004 17:32
Subject: [PHP-DB] I'm new on the list and have a question.
> Hi,
Maybe you forgot a "?":
Alert(); or
^^^
Ignatius
_
- Original Message -
From: "Gamze Başaran" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 08, 2004 2:49 PM
Subject: [PHP-DB] javascript question
> Hi everyone;
>
> First of all I'm sorry m
The same can be achieved by using the excellent PEAR HTML_TreeMenu class.
Key advantage, of course, is that the API is in PHP.
HTH
Ignatius
_
- Original Message -
From: "Paul Miller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 30, 2004 4:22 PM
_
- Original Message -
From: "Alireza Balouch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 31, 2004 12:25 PM
Subject: [PHP-DB] Firebird
> It looks like firebird database is on its way to replace of mysql...
E???!!!???
How would you bac
jpgraph is great
http://www.aditus.nu/jpgraph/
open source, very reasonably priced
Ignatius
_
- Original Message -
From: "Craig Hoffman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 06, 2004 4:55 PM
Subject: [PHP-DB] Graphing - bar charts
> H
Use the cURL library.
_
- Original Message -
From: "matthew perry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 15, 2004 6:39 AM
Subject: [PHP-DB] links to maps
> Anyone know a quick and easy way to fill in the address on a yahoo maps
> form
SELECT
IF( B.Booking_End_Date != "-00-00",
DATE_FORMAT( B.Booking_End_Date, "%Y-%m-%d" ),
"N/A"
) AS Booking_End_Date
FROM Bookings AS B, etc.
HTH
Ignatius
_
- Original Message -
From: "Shaun" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
S
Use only one query:
SELECT
category,
item,
...
ORDER BY category, item
Now fetch rows, and keep the latest categoryID in a flag variable:
- if fetched categoryID <> flag, close table, create a new table, add header
row
- otherwise add content row to the current table
- update flag with the latest
al with languages which do not separate words by
whitespaces (in my case Japanese)
HTH
Ignatius
_
- Original Message -
From: "Gavin Amm" <[EMAIL PROTECTED]>
To: "Ignatius Reilly" <[EMAIL PROTECTED]>
Sent: Wednesday, April 28, 2004 10
The functions do not exist.
However, FULLTEXT indexes will do much of this work for you. I encourage you
to experiment with them.
_
- Original Message -
From: "Gavin Amm" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 28, 2004 7:18 AM
Subject: [P
even better:
$_REQUEST['variable_name']
so that you don't have to bother checking both depending on whether your
form was GETted or POSTed.
_
- Original Message -
From: "Mikael Grön" <[EMAIL PROTECTED]>
To: "Kim Jacobs (Crooks) - Mweb" <[EMAIL PROTECTED]>; <[EMAIL
in script;
Now, if there's a POST variable named ID containing an INT matching the
database, and I use $_REQUEST instead of $_GET, I'm in trouble!
Mike
On Apr 29, 2004, at 11:00, Ignatius Reilly wrote:
> even better:
> $_REQUEST['variable_name']
>
> so that you
You can't with standard SQL, nor with MySQL.
_
- Original Message -
From: "JeRRy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 30, 2004 3:04 PM
Subject: [PHP-DB] inserting same data into multiple tables question (?)
>
>
>
> Hi,
>
> I want t
With the PHP IMAP functions you can process your mail box programmatically
as a data repository.
_
- Original Message -
From: "Ruprecht Helms" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 01, 2004 9:40 PM
Subject: [PHP-DB] Procedure for submitting
Hav you tried enclosing the table name with backticks:
SELECT ...
FROM `16-05`
...
Ignatius
_
- Original Message -
From: "Martin E. Koss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 17, 2004 10:48 AM
Subject: [PHP-DB] Wrong table name - can it be
LAST_INSERT_ID() is connection-based, not table-based.
Therefore instead of:
SELECT LAST_INSERT_ID() FROM foo_table
you should do:
SELECT LAST_INSERT_ID()
HTH
Ignatius
_
- Original Message -
From: "Marc Soler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Mond
Here is how I would do:
1. Group your visits by IP, order them in time and give each row a
sequential number starting with 1
(not completely trivial - exercise left to the reader)
Now you have a temporary table T ( ip, timestamp, rank )
2. Join the table to itself on two consecutive rows, and co
Hi the Third,
have you considered dumping the table into a text file?
SELECT *
FROM mytable
INTO OUTFILE "c:/..."
this (AFAI) does not cause memory issues
Ignatius
_
- Original Message -
From: "Leo G. Divinagracia III" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
S
PHP5:
www.ovh.com
MySQL 4.1
probably nobody.
First beta (4.1.3) was released only a few days ago
_
- Original Message -
From: "Jensen, Kimberlee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 08, 2004 11:28 PM
Subject: [PHP-DB] Web host offering
For some of my sites I use a XML file to list all the pages in a structured
manner (sections, access rights, etc.)
I generate the site map by using a XSLT sheet.
_
- Original Message -
From: "Dermot Mc Laughlin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tues
sleep( nb of seconds ) ;
_
- Original Message -
From: "..: GamCo :.." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 20, 2004 9:44 AM
Subject: [PHP-DB] Wait Statement... ?
> Hi all,
>
> I would like to add a line of code in PHP that will execute
Why silly??
it just makes you wait one second on the login page BEFORE the validation
process, not on other pages.
I use it everywhere.
Ignatius
_
- Original Message -
From: "Daevid Vincent" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "'..: GamCo :..'" <[EMAIL
Dezigner
www.datanamic.com
Excellent piece of software.
_
- Original Message -
From: "Vincent Jordan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 28, 2004 1:27 PM
Subject: [PHP-DB] MySQL software question
> Is there a piece of software that
1. What prevents you from implementing the conditions directly in SQL? You
can achieve a lot with CASE and IF.
2. For your paging needs, you may benefit from investigating the PEAR
HTML_Pager class.
Ignatius
_
- Original Message -
From: "Ross Honniball" <[EMAIL PROT
n-hand to decide if I want to 'output' the record or not.
>
> Let me know if you want more detail. It would resolve the present issue if
> it can be done in a query(and improve my sql knowledge).
>
> >_
> >- Original Message -
>
You may profitably investigate PEAR Quickform.
Nice client-side and server-side validation functions to do just that.
HTH
_
- Original Message -
From: "Hafidz Abdullah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 24, 2004 10:43 AM
Subject: [PHP
look at the PEAR HTML_Javascript class
_
- Original Message -
From: "Chris Payne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 26, 2004 2:18 AM
Subject: [PHP-DB] PHP Array to Javascript?
> Hi there everyone,
>
>
>
> I set an array using
Dezign / MySQL Importer
www.datanamic.com
HTH
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I am fairly confident that in this particular case the opinion(s) contained
within this email would nicely coincide with
those of St. Jude Children's Research Hospital.
We live in a world full of geometry.
Ignatius Reilly
_
- Original Message -
From: &qu
Very simply, because a clause
WHERE sales * cost > 100
would look up to "sales" and "cost" in the expression as SELECT fields.
Your clause will wotk if you add "sales" and "cost" to the SELECT fields,
but that would not be economical:
- you don't need them in the result
- you will execute the caclu
have a look at the PEAR Pager class.
very useful.
_
- Original Message -
From: "David Ziggy Lubowa" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 16 December 2004 23:38
Subject: [PHP-DB] Pagination
>
>
> Hey guys,
>
> I am working on an internal db and i ha
There is also the very good PEAR Excel Writer class.
http://pear.php.net/package/Spreadsheet_Excel_Writer
Ignatius
- Original Message -
From: "John Holmes" <[EMAIL PROTECTED]>
To: "Stéphane Pinel" <[EMAIL PROTECTED]>; "'PHP DB'"
Sent: 22 December 2004 20:54
Subject: Re: [PHP-DB] PHP Cla
find there VERY
important design stuff that you won't find in web tutorials.
Ignatius Reilly
- Original Message -
From: Shiloh Madsen
To: [EMAIL PROTECTED]
Sent: Wednesday, August 21, 2002 1:3
for SVG templates for making dynamical plot and line charts; I
haven't found much on the web. Can anyone help?
Thanks
Ignatius Reilly
- Original Message -
From: James Hatridge
To: PHP_DB
There is this cute suggestion in the Wrox PHP book:
/^.+@.+\\..+$/
Looks like a puzzle, but it works (almost) always.
Enjoy
Ignatius Reilly
- Original Message -
From: DL Neil
To: [EMAIL
For a SQL tutorial, I would recommend that you get yourself a copy of Joe
Celko's "SQL for smarties".
Best investment I ever made. Everything you need to know is there.
Bon courage!
- Original Message -
From: "Matt Zur" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, Septembe
Try
SELECT name, COUNT(*) AS nb
FROM mytable
GROUP BY name
ORDER BY nb DESC
Ignatius
"RClark" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello all,
>
> I have a MySQL database with some 2 million rows in it. I am counting
all
> of the different names
Hi Dr,
try:
LOAD DATA INFILE "myfile.csv" INTO TABLE mytable
FIELDS TERMINATED BY ","
LINES TERMINATED BY "\r\n" ;
of course, the structure of your CSV file must match exactly that of your
table.
hth
- Original Message -
From: "Dr. Indera" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
S
LOAD statement
HTH
Ignatius
- Original Message -
From: "Karel Pøíbramský" <[EMAIL PROTECTED]>
To: "Ignatius Reilly" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
"Dr. Indera" <[EMAIL PROTECTED]>
Sent: Wednesday, September 04, 2002 10:33 AM
Subject: RE:
Another way is to refresh the page everytime the user has filled a field in
and moves to another:
function submit_field( i ) {
document.myform.field_to_check.value = "field" + i ;
document.myform.submit() ;
}
The idea is that the "onchange" event is triggered when the
Hello,
I am designing a web application wherein several queries are very long to
perform (like 5 or 10 minutes) ; therefore it is crucial that I be able to
cache them; I am planning to recompute these queries in a nighttime batch
process (meaning I may have to use version 4.0 in production...)
M
Try something like this:
>
(value is a dummy value - HTML will POST the name=value pair only if
checked.)
HTH
Ignatius
- Original Message -
From: "Chris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 09, 2002
Does your process hang or simply is too long? Perhaps the limiting factor is
not the writing speed, but a memory requirement problem.
Try to compute how long it should take:
- do your row processing after a SELECT ... LIMIT 1000 clause
- time how long it takes, and extrapolate
Then you will know
Try:
SELECT C.category_name, SUM( IF( ISNULL( P.product_ID ),0, 1) ) AS total
FROM category AS C LEFT JOIN product AS P
ON C.category_ID = P.category_ID
GROUP BY C.category_ID
Ignatius
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL
When in doubt, bracket :
$sql = "UPDATE $table SET pages = '{$PHP_SELF}' WHERE session =
'{$holy_cow}'";
Less cute, but more readable.
Ignatius
- Original Message -
From: "Dave Smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday
why not simply store the server time at log in in the DB after a successful
log in together with the IP address; and at the next log in request perform
a SQL time difference comparison?
Ignatius
- Original Message -
From: "wade" <[EMAIL PROTECT
It depends what you want to do with it.
To display it in HTML, you can write them in a 2-D array: myarray[$i][$j],
where $i is the row nb and $j the column nb, and write two nested loops.
To export them to Access, CSV, ... you can issue your query through Access
ODBC. You can then save as a CSV.
I have met this problem before.
The only solution I have found is to assign "0" values to the INPUT tags:
HTH
Ignatius
- Original Message -
From: "Shahmat Dahlan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 11, 2002 11:
may treat it as text.. When
> Field1='0'
> Field2='1'
> Field3='2'
>
> Field1+Field2+Field3 = '012'
>
> If you use
> Field1=Number('0')
> Field2=Number('1')
> Field3=Number('2')
>
> Field1+fie
If you want to generalize the process to a n-set, a recursion method is
clearly required.
XSLT looks the best candidate to me to do this. I will tackle it when I find
some time.
Cheers
Ignatius
- Original Message -
From: "Xepherys" <[EMAIL PRO
I know and use a very good one, if you can understand French: www.ovh.net
Free PHP, MySQL, XSLT support.
Ignatius
- Original Message -
From: "Seabird" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 15, 2002 9:46 PM
Subject:
Try instead:
if( $_POST['action'] =="test" ){ echo "Test";}
HTH
Ignatius
- Original Message -
From: "Michel Bakkenes - bakkenes.net" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 18, 2002 1:26 PM
Subject: [PHP-DB] Variable
You can use an auxiliary lookup table:
FK_mygraderank
-
Secret1
A+ 2
...
Now join this table to your SELECT query on FK_mygrade, add 'rank' to the
SELECT items,
and ORDER BY rank
HTH
Ignatius
__
What is your problem exactly?
Ignatius
- Original Message -
From: "Jaap Aikema" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 11:58 AM
Subject: [PHP-DB] Create Table with AutoIncrement-field in M$ AccessDB
> I tr
Hi,
usually, one issues an HTML row for each row of the query result.
BTW, don't forget elements!
But your query results has only one row, and your table has 4 columns.
Can you explain in more detail what you want to do?
Ignatius
- Original Mess
Hi,
in some cases, you might prefer to use a multiple element; this can
give you a much more compact user interface (though you probably won't use
it if you have 40 options ...)
It goes like this:
--all--
conjuration
abjuration
How often in a day must you do this? Every 5mn?
Ignatius
- Original Message -
From: "Leif K-Brooks" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, October 27, 2002 7:33 AM
Subject: [PHP-DB] Getting rows where column has changed?
> I
If you are using MySQL, you may profitably investigate the function
DATE_ADD( date, INTERVAL )
Ignatius J. Reilly
- Original Message -
From: "Frederik Feys" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 04, 2002 10:32 PM
Sub
AND/ OR precedence mistake. Your query will return all the rows for which
order_status='Not Shipped'
Probably what you want is:
select * FROM OrderTable WHERE submitted=1 AND
dateinserted>='1036386000' AND dateinserted<='1036502796' AND
( order_status='Shipped' OR order_status='Not Shipped' )
H
Good point.
"Tell me and I forget, show me and I remember, involve me and I understand"
Ignatius
- Original Message -
From: "Snijders, Mark" <[EMAIL PROTECTED]>
To: "'Marco Tabini'" <[EMAIL PROTECTED]>; "Terry Romine"
<[EMAIL PROTECTED]>
Cc: <[
1 - 100 of 200 matches
Mail list logo