- Original Message -
From: olinux [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 29 October 2001 08:16
Subject: [PHP-DB] category structure
anyone have any ideas on this
I have a table of directory categories
id | parentid | category
so...
1 | 0 | blah1 top
2 | 1 |
hi everyone,
has anyone here created an application using
background processes? what i have in mind
is to be able to run the background process
once a day to check for files that are more than
5 days old and delete them. thanks in advance.
regards,
ric
--
On Fri, 19 Oct 2001 10:26:14 +0200, [EMAIL PROTECTED] (Thorsten Hock)
wrote:
Sorry, natürlich benutze auch ich mssql_connect(). Der Zugriff funktioniert
aber leider nur, wenn sich der SQL-Server und der WEB-Server auf dem
gleichen Host befinden. Ein Zugriff über das Internet auf einen anderen
I installed Red Hat 7.1 (PHP included) + MySQL 3.23 and wanted
to launch PHP-Nuke to create sample web site. I got little Linux
and zero PHP/MySQL knowledge, maybe I am doing something wrong
but after 2 days of fighting I got enough.
Install file suggests to launch page admin.php after the
Yes, I know what a tree data structure is - how to
walk the tree I'm not sure what you mean. But I've
come up with something quite cool. but still not
working.
I select all the data from the catagories table [id |
pid | category] and drop it into the array
=
$menu = array();
while ($row =
has anyone here created an application using
background processes? what i have in mind
is to be able to run the background process
once a day to check for files that are more than
5 days old and delete them. thanks in advance.
ric,
PHP (and scripts) can be executed from the command line
hi,
thanks for the reply. i will look up docs that discuss
cron. i'm sorry but i didn't get what you mean by
m/c. please explain. thanks!
regards,
ric
DL Neil wrote:
has anyone here created an application using
background processes? what i have in mind
is to be able to run the
Olinux,
Yes, I know what a tree data structure is - how to
walk the tree I'm not sure what you mean.
=Walk the tree means using the logic of the 'pointers' in each row to work out which
sub-categories fit within
each category...
But I've
come up with something quite cool. but still not
ric,
Apologies. Abbreviation m/c means machine.
=dn
- Original Message -
From: Ric Manalac [EMAIL PROTECTED]
To: DL Neil [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 29 October 2001 12:03
Subject: Re: [PHP-DB] background process
hi,
thanks for the reply. i will look up docs that
Hi there,
I have problems with the performance while using NC. It workes fine with IE.
As soon as I access the db. It takes aproximatelly 1 -2 min till I see the
page.
Does anybody know some help?
Thank you
Andy
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail:
I have a problem here which I can not find an answer.
My date fields (EmailD in this case) can be in four different formats:
a) dd.mm.
b) d.mm.
c) dd.m.
d) d.m.
So this is what I've tried to do to convert the dates to -mm-dd
format:
INSERT INTO feCompsT (ID, Company,
Ok, found the problem.. I've been fighting with this for like an hour
but the error was here:
POSITION() should be LOCATION().. Way to go Niklas! :)
Niklas
-Original Message-
From: Niklas Lampén [mailto:[EMAIL PROTECTED]]
Sent: 29. lokakuuta 2001 15:46
To: Php-DB
Subject: RE:
What are you trying to do? Your question/example is very unclear.
-Original Message-
From: Mark Weber [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 28, 2001 3:33 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Mathematics Examples MySQL and PHP
Hello Everybody,
Does anybody have some
This could be due to missing tags such as /body and /html
-Original Message-
From: Andy [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 6:41 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Performance problems in NC
Hi there,
I have problems with the performance while
Does anybody have some examples about howto make mathematic
functions in PHP with values from any
MySQL table such as:
Value 1 + Value 2 = Value 3
Value 1 - Value 2 = Value 3
Value 1 * Value 2 = Value 3
Value 1 / Value 2 = Value 3
maybe
UPDATE tablename SET field3=field1+field2
...
but
If any of the values you are trying to insert are not integers, you need to
put single quotes around the variables, ie. $SCRIPT_NAME, $date, $BName, etc
in the insert statement.
Robby Whiteside [EMAIL PROTECTED] said:
Hi There,
I have a query whenever I try to insert something into a
If your first field is an auto insert field, then you have to do it like
this:
insert into tablename (column2,column3,column4,column5) values
(value2,value3,value4,value5)
The auto incremented field will be automatically be filled in with the next
available value.
Ricky
-Original
This also works:
INSERT INTO vcstats VALUES( NULL,column2,column3,column4,column5)
The NULL value will be replaced with theauto-incremented value in the table
-Original Message-
From: Ricky Theil [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 10:26 AM
To: '[EMAIL PROTECTED]';
On Monday 29 October 2001 20:09 pm, Body of Shadows wrote:
I installed Red Hat 7.1 (PHP included) + MySQL 3.23 and wanted
to launch PHP-Nuke to create sample web site. I got little Linux
and zero PHP/MySQL knowledge, maybe I am doing something wrong
but after 2 days of fighting I got enough.
Hi, have a compilation question here related to databases.
I'm trying to compile MS SQL support into php by using the freetds
library, and the --with-sybase-ct directive on the configuration
script. I have a problem when trying to link, saying that there's a
missing library called sybtcl,
Is there an easy way to implement tree structure in a database.
Something like file systems do for files.
Hints, links, anything.
--
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
Hello,
I am trying to run my first php script to connect to a PostgreSQL
database on a Linux box with apache web server.
When I try to load the page with the browser i get the following error:
Fatal error: Call to undefined function: pg_connect() in
/dirname/tryit.php on line 9
I was able to
This means that PostgreSQL support was NOT compiled into PHP. Therefore,
you cannot use PostgreSQL commands.
-Original Message-
From: Rodolfo Napoles [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 2:17 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Fatal error: Call to undefined
Is there a way to configure php (through the conf file?) to support the pg
commands? Is there a manual (link) where I can find how to compile postgreSQL
support into PHP? does it mean to compile PHP ?
Thanks
Rick Emery wrote:
This means that PostgreSQL support was NOT compiled into PHP.
I'm trying to write a loop to read variables I receive from a form:
form ...
input name=a1 value=..
input name=a2 value=..
input name=a3 value=..
input name=a4 value=..
I'd like to get something like:
for ($i=1; $i=10; $i++) { $tab[$i]=a.$i ;}
The expression a.$i is actually a
I was never able to assign a null value to get a row to automatically insert
into SQL server 7. It would always give me an error that said something
like you cannot assign the value NULL to an identity field.
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Monday,
I don't know about SQL server 7. However, when using MySQL (as indicated by
your code), it will work.
For instance, if your table is:
CREATE TABLE mytable (
myID int unsigned auto_increment,
value2 int unsigned,
value3 char(50)
)
Then this will automatically increment myID:
INSERT INTO
Help!
I have drawn a blank..
I want to get the content of a field in a table where I know the
databaseName,tableName and columnName and the rowNumber.
Like:
$answer = mysqlCommand(select ColumnName from tableName WHERE rowNumber =
$rowNumber,$db)
--
PHP Database Mailing List
$query = select ColumnName from tableName WHERE rowNumber =
$rowNumber,$db;
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$answer = $row['ColumnName'];
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 4:07 PM
To:
Compile a dynamic module for use with the dl() function or the php.ini.
./configure --with-pg=shared
make
cp the module in the src/module (pgsql.so) into the location defined for
modules in your php.ini.
either add line to the ini or use the dl('pgsql.so') in your script to call
it.
if you
It seems you don't have flex neither bison installed on your system.
Flex is a lexical analyser generator, and Bison is a parser generator.
There are respectively open-source successors to Unix lex and yacc.
You will find plenty of information or tutorials on the Internet if you
want to. Here is
I need help. Say I have a string coming from a page via a form
$search_var. I need it split up into multiple variables...
e.g
$string=These are some words
I want it to turn into $var1=These, $var2=are, $var3=some, $var4=some
I'm doing this for a search script. Want it to take the
On Tuesday 30 October 2001 12:41 pm, Anthony C. Yandell wrote:
I need help. Say I have a string coming from a page via a form
$search_var. I need it split up into multiple variables...
e.g
$string=These are some words
I want it to turn into $var1=These, $var2=are, $var3=some,
Hi
there everyone,
I'm working on a project for a friend who
owns a travel agent, he has a MySQL database which works very fast, but
the problem is that there are alot of duplicate entries. When I am
retrieving the results from the DB
The OASIS project for ad-server uses hierchical system for the sections
stored in Mysql.
the simplest structure is a row with 3 fields(node_id - autoincrement,
parent_id int, data - sometype). the root has parent_id NULL or 0(because
autoincrements usually starts from 1, but this is subject
Original message
From: LeTortorec, Jean-Louis [EMAIL PROTECTED]
Date: Mon, Oct 29, 2001 at 04:03:45PM -0500
Message-ID: 615315231286D21182E40008C7B1EED23C6E76@COMPAQ3000
Subject: [PHP-DB] Variables in a loop
I'm trying to write a loop to read variables I receive from a form:
form ...
input
I have a large table with quite many dates in format dd.mm. (don't
ask why :) and I want to convert them into -mm-dd for obvious
reasons. How can I do this the smartest way? I know I could do it with
php and update it row by row but that doesn't seem too smart. Can I
somehow do a
Hi,
I have maintained a calendar myself using PHP. I wonder if there is any way
that can let my own calendar synchronized with the calendar in outlook2000.
That is, if I add any event to my PHP calendar, then, I can add this to my
outlook2000 as well, and vice versa.
Can anyone help me with
38 matches
Mail list logo