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:
>
>
>
>
>
>
>
>
>
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 to
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
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
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 i
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
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 are
$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:
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 (http://www.php
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 mystable
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 this
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,
Lookup "Variable Variables" in the PHP manual. You'll use something like:
${$i}
-Original Message-
From: LeTortorec, Jean-Louis [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 3:04 PM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] Variables in a loop
I'm trying to write a loop to
http://www.php.net/manual/en/language.variables.variable.php
> -Original Message-
> From: LeTortorec, Jean-Louis [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 29, 2001 2:04 PM
> To: '[EMAIL PROTECTED]'
> Subject: [PHP-DB] Variables in a loop
>
>
> I'm trying to write a loop to read
I'm trying to write a loop to read variables I receive from a form:
I'd like to get something like:
for ($i=1; $i<=10; $i++) { $tab[$i]="a".$i ;}
The expression "a".$i is actually a string, not a variable. Any idea how to
"read" the value of that string?
Thanks for your help.
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. Ther
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 f
Relational databases really are tree structures. However, whereas a tree
parent node has pointers to children or sibling nodes; in a relational
database, the nodes "point up" to the parent node. The nodes might also
maintain a field to identify sibling nodes.
-Original Message-
From: Ro
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 c
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
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, an
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 enou
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]'; R
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 Message--
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
> 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
..
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 performanc
Change code as follows:
".$row['msg']."";
?>
-Original Message-
From: Andrew Duck [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 28, 2001 7:00 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Resource id #2
I am trying to select a message from a table in a database. the message will
will
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 ex
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: [PHP-DB]
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, Email
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: [EM
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
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
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 b
> 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 li
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
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 ins
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
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
--
=
What can I say? Thank you very much for working on this problem! Helped
me a lot!
Niklas
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: 29. lokakuuta 2001 12:27
To: Niklas Lampén; Php-DB; Php-General
Subject: Re: [PHP-DB] mySQL table update
> I have a large table
- 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
>
> 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
43 matches
Mail list logo
