-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
i need to read data from a sheet in M$ Excel to update some databases in M$
Acess ... but how ???
thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
hello, i think u have to create the series yourself ... before u insert
every record, first calculate the next value :
SELECT MAX(ID) AS NEXT FROM TABLE
then u insert ...
hope it helps ...
-Mensagem original-
De: Daniele Baroncelli [mailto:[EMAIL PROTECTED]]
Enviada: sexta-feira, 14
-Mensagem original-
De: José Moreira [mailto:[EMAIL PROTECTED]]
Enviada: sexta-feira, 14 de Junho de 2002 9:53
Para: Daniele Baroncelli
Cc: Php-Db
Assunto: RE: [PHP-DB] auto increment
hello, i think u have to create the series yourself ... before u insert
every record, first calculate
-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
use this on the first SELECT :
select name=SELECT onChange=window.navigate('?=$PHP_SELF
??choice='+this.value)
when u choose an option the page will be refreshed and the $choice will be
available thru HTTP_GET_VARS[choice]
all u have to do is check if the var exists and execute the
hello ... im sorry to bother with a non-db question but i searched for this
and got 0 record :P
its all about the wrappig in textareas:
how can i convert the end of line/ line breaks ['enter' keys] that the user
hits while
filling a textarea so that when i display the record content the text
://www.completesource.net
Developer's Forums: http://www.completesource.net/forums/
José Moreira [EMAIL PROTECTED] 07/17/02 09:15AM
hello ... im sorry to bother with a non-db question but i searched for this
and got 0 record :P
its all about the wrappig in textareas:
how can i convert the end of line/ line
RTFM
???
-Mensagem original-
De: Jason Wong [mailto:[EMAIL PROTECTED]]
Enviada: quinta-feira, 18 de Julho de 2002 16:24
Para: [EMAIL PROTECTED]
Assunto: Re: [PHP-DB] TEXTAREA ...
On Thursday 18 July 2002 23:18, José Moreira wrote:
using this :
$thePost = nl2br
good day/afternoon/night,
about the textarea thingy :
even knowing that the question i made was non db related,
to everyone who had the pacience to explain the matter for me i thank you,
the question is that aparently a small thing like formatting HTML envolves a
lot of small detais that i was
19 July 2002 17:42, José Moreira wrote:
good day/afternoon/night,
about the textarea thingy :
even knowing that the question i made was non db related,
to everyone who had the pacience to explain the matter for me i thank you,
the question is that aparently a small thing like formatting HTML
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
an example :
my table :
Field,Type,Null,Key,Default,Extra
CATID,int(10) unsigned,,PRI,NULL,auto_increment
PARENT,int(10) unsigned,,,0,
TEXT,varchar(40)
TYPE,set('FILE','POST','FOLDER'),YES,,NULL,
code ( using ADODB ) :
function PrintNode ( $level , $text) { # função para
adapted to your database ... for errors and more information .. let me know
?
# Simple function 2 create an indentation according to the level/depth of
the tree node
function PrintNode ( $level , $text) { # função para imprimir um nó e fazer
o indentamento
if ( $level == 0 ) {
adapted to your database ... for errors and more information .. let me know
?
# Simple function 2 create an indentation according to the level/depth of
the tree node
function PrintNode ( $level , $text) { # função para imprimir um nó e fazer
o indentamento
if ( $level == 0 ) {
hello
how can i calculate the difference in days between 2 dates in SQL or PHP ?
Hello, how can i calculate the number of hours between 2 dates,
and better yet , the work hours ( example from 8.30am to 6pm excluding
weekends)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
thank you for your help,
i figured this out : SELECT id, to_days(t1.closedate) - to_days(t1.date)
FROM tracking AS t1
...
yes i am .. whe are using the IRM http://irm.schoenefeld.org/ for
internal help desk and im creating event reports ...
it only makes sense to include in the
Original Message
Subject: Re: [PHP-DB] convert 2 dates to number of hours
Date: Mon, 30 Sep 2002 16:43:14 +0100
From: José Moreira [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Chris Boget [EMAIL PROTECTED]
CC: PHP-DB [EMAIL PROTECTED]
References: [EMAIL PROTECTED
hello, um using this SQL string :
SELECT computer, date, closedate,UNIX_TIMESTAMP(closedate),
UNIX_TIMESTAMP(date), (UNIX_TIMESTAMP(closedate) -
UNIX_TIMESTAMP(date)) / POW(60,2) FROM tracking (18 Records)
computer date closedate UNIX_TIMESTAMP(closedate)
hello, at my company we have several network printers and i was was
wondering if it's possible to print directly to them using PHP, instead
of showing on the screen or both ...
to gain more control on what is printed, because of the nasty browsers
header and footer ... whom i now how to remove ...
- server web service
- XML - PHP /
client
-Mensagem original-
De: J Wynia [mailto:letterj;Phpgeek.com]
Enviada: quinta-feira, 24 de Outubro de 2002 13:58
Para: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Assunto: [PHP-WIN] Re: Print data
José Moreira wrote:
hello, at my company we have several
]
/ \
/ \
D[5 8] F[9 10]
|
E[6 7]
i have? to update almost every left,righ fields after that node, resulting
in a website performance downgrade
help? even if thjats the only way, how can i do it? perhaps im getting it
wrong ...
best regards
José
: José Moreira [EMAIL PROTECTED]
To: Php-Db (Correio electrónico) [EMAIL PROTECTED]
Sent: Thursday, December 19, 2002 11:45 AM
Subject: [PHP-DB] trees in MySQL
hello im implementing a portal and im choosing between the 'Nested Set'
and
'Adjacency Lists tree' models.
http://users.starpower.net
http://users.starpower.net/rjhalljr/Serve/MySQL/traer.html
-Mensagem original-
De: Cal Evans [mailto:[EMAIL PROTECTED]]
Enviada: sexta-feira, 20 de Dezembro de 2002 5:07
Para: Chris Payne; [EMAIL PROTECTED]
Assunto: RE: [PHP-DB] Theory help needed
Read today's thread about trees.
José Moreira
TEGOPI S.A.
http://www.tegopi.pt
*---
Feliz natal e excelente Ano Novo
Merry Christmas and a joly New Year
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
26 matches
Mail list logo