[PHP-DB] Re: passing variables through frames

2003-02-01 Thread Edwin Boersma
It's better to use input type=hidden name=... value..., because my experience is that it does not work with passing them in the action-option of form. This is the case if u have other input boxes, at least I think it is. If u don't have other input fields, just use a href=url.php?var1=

[PHP-DB] Re: to connect access mdb

2003-02-01 Thread Edwin Boersma
Use the correct ng for your problems. this is for PHP, not ASP. Qt wrote: Dear Sirs, I try to connect my access mdb with following script but I can not succed. I get following error. This server is currently overloaded - please try again later Any idea where is the my mistake. I am using

Re: [PHP-DB] MySQL result resource

2003-02-01 Thread Edwin Boersma
Agree fully Try this: $query = select * from category where id=$scrow-category; $result = mysql_query($query) or die( mysql_error() ); If your query fails, and u still can't find the reason from the information that mysql_error() give you, put a echo $query inbetween to see which string

Re: [PHP-DB] REVISED; need INSERT help

2003-02-01 Thread Edwin Boersma
What about using a form identifier? In each form, use input type=hidden name=formident value=form1 and so on. Then, use: switch ($formident) { case form1: your action for this form break; case form2: and so on. Edwin Mark wrote: I haven't been following any other

[PHP-DB] Parsing html entities to javascript

2003-02-01 Thread Edwin Boersma
Hello, I store Greek characters in my db. In previous versions of php, they were stored as some characters, based on the character page. But now, they are stored as html entities. And now I have a problem, because some of the stored data is parsed to javascript. And that does not know the

Re: [PHP-DB] Re: to connect access mdb

2003-02-01 Thread Micah Stevens
looks like PHP to me. COM connections to Access only handle a few connections at a time. The use of a real DB server is reccommended in your situation.i Edwin Boersma wrote: To: [EMAIL PROTECTED] Date: Sat, 01 Feb 2003 18:41:49 +0200 From: Edwin Boersma [EMAIL PROTECTED] Subject: [PHP-DB] Re:

[PHP-DB] Sessions and Temporary Tables

2003-02-01 Thread Michael Conway
I'm trying to create a temporary table through a query call in php and have no guiding documentation to refer to. I assume it can be created as any other query call. I would use CREATE INSERT but the insert data is coming from a while loop. I understand that the temporary table requires

RE: [PHP-DB] Sessions and Temporary Tables

2003-02-01 Thread John W. Holmes
I'm trying to create a temporary table through a query call in php and have no guiding documentation to refer to. I assume it can be created as any other query call. I would use CREATE INSERT but the insert data is coming from a while loop. I understand that the temporary table requires

RE: [PHP-DB] Parsing html entities to javascript

2003-02-01 Thread Ruprecht Helms
Hi Edwin Boersma, possible this helps http://www.php.net/manual/en/function.urldecode.php Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax.: +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email: [EMAIL

[PHP-DB] Images

2003-02-01 Thread Mihail Bota
Hello, I try to create a simple image from some data from a database (something like a checkerboard: if $a=1 then red, elseif $a=2 then blue etc). Everthing works fine until the assignment of colors. Whenever I use the whole set of data that I have to display, wrong colors are assigned. Whenever

RE: [PHP-DB] Images

2003-02-01 Thread John W. Holmes
I try to create a simple image from some data from a database (something like a checkerboard: if $a=1 then red, elseif $a=2 then blue etc). Everthing works fine until the assignment of colors. Whenever I use the whole set of data that I have to display, wrong colors are assigned. Whenever I

[PHP-DB] TOPTEN select?

2003-02-01 Thread [EMAIL PROTECTED]
hello, i have a question about a table wich works as top-ten list. why i can select all entry from today wich the hightest score? the follow is the tablestructure +--+-+-+ |id|count|timestamp|text... +--+-+-+ thanks for any answers..

RE: [PHP-DB] TOPTEN select?

2003-02-01 Thread John W. Holmes
i have a question about a table wich works as top-ten list. why i can select all entry from today wich the hightest score? the follow is the tablestructure +--+-+-+ |id|count|timestamp|text... +--+-+-+ Maybe... SELECT * FROM table

RE: [PHP-DB] Images

2003-02-01 Thread Mihail Bota
John, the code is listed below. Very cluttered, I acknoweledge:) The limit you'll see in the second query is the maximal value for which I get a good checkerboard. Mihai $q1=mysql_query(select distinct idsend from connections where publi=1 and uid=1 order by idsend);

RE: [PHP-DB] Calling functions recursively: recursive PHP functions

2003-02-01 Thread Kevin Gordon
Thanks John. Your comment helped me through. I used a static variable for the array, array_merge_recursive() function to accumulate the foreign keys and $this-kgforeignkeys as a recursive function in a loop. This all works ok! function kgforeignkeys($tablename = ) {

[PHP-DB] no such database

2003-02-01 Thread Brad Hubbard
Red Hat 8.0 php-4.2.2-8.0.5 postgresql-7.2.2-1 I've used the PEAR DB classes quite a lot in the past but have moved to a new machine and have encountered a bit of a perplexing problem. the following code generates the error; DB Error: no such database ?php require_once 'DB.php'; $dsn =

[PHP-DB] Exploding Nodes Recursively

2003-02-01 Thread Russell Griechen
Explode all folders to all levels? A exploding nodes... A drop down lets user select number of generations and the execution shows the trees being populated... I have been trying to find the code to execute this MySql table Dogs: ID AutoNumber Primary Key RegName Text Sex Yes/No Dame Long Int