EG:
CREATE TABLE category (
id int not null auto_increment,
parent int default 0,
name varchar 100,
);
The parent field contains the ID of the record of which category it belongs.
Then use a recursive function to display the 'levels' of data. (If parent is
0 then it is top level category)
Luke
Use the parent/child relationship thing:
CREATE TABLE Categories (
CategoryID int(11) NOT NULL auto_increment,
ParentID int(11) NOT NULL default '0',
Category_Name tinytext NOT NULL,
PRIMARY KEY (CategoryID)
) TYPE=MyISAM;
So at each level you can find the subcategories by:
SELECT * FRO
Im figuring this is more of an sql question than anything else.
I'm trying to figure out a table structure to create unlimited depths of
categorical data.
I've done something for category/subcategories before, but haven't an
idea how to create categories at an unlimited depth.
Any pointers would
Hi, I'm having a big problem with php and Oracle.
I'm using Oracle 8.1.6 and PHP 4.2 with the Oracle component in a Solaris
server, I can not recompile apache and php to install the oci8 component
and I'm having lot of problems with CLOBs, I'm receiving this error:
Warning: Ora_Exec failed (ORA
Wait, I'm stupid. You're closing the window upon submission of the form,
so that will close the session, so the php at the beginning will never
process after form submission. Make the form submit to another page that
won't be closed.
-Micah
On Mon, 2003-01-13 at 13:24, Mignon Hunter wrote:
> U
Dear [EMAIL PROTECTED],
The Crystal Reports/Oracle Database Fundamentals course is being offered in various
locations over the next few months:
01/23-24/2003 Melbourne, FL
01/30-31/2003 Houston, TX
02/13-14/2003 Detroit, MI
02/13-14/2003 San Francisco, CA
02/1
I am starting to use the PEAR OCI8 driver, linked against Oracle 9. It
works fine until the very end. I can connect, fetch a table and print
it, but when the PHP exits (I am testing with standalone PHP), it
crashes with a SegFault.
I am running RedHat 8.0 with PHP 4.2.2. I linked it myself.
Ma
Nevermind Micah,
Thanks for your input, I just did 2 buttons for the user - one to submit
and one to close the window.
Thanks for your help
Mignon
On Mon, 2003-01-13 at 15:24, Mignon Hunter wrote:
> Unfortunately I havnt gotten it to work yet. Am I missing something ?
>
> PS the query works
Unfortunately I havnt gotten it to work yet. Am I missing something ?
PS the query works without the closewindow()
Enter your details here:
On Mon, 2003-01-13 at 14:44, Micah Stevens wrote:
> The window.close(); function is not returning control to the form after
> closing th
Anybody could hep me converting the following form to dropdown box? The
easier task (I assume) is to populate the box with the all possible
values of a column in mySQL table (I don't know what how to do this yet,
though). I also haven't been able to find the dropbox's equivalent of
form's inp
The window.close(); function is not returning control to the form after
closing the window. You must tell it to do so. Use:
onClick="return window.close();"
This will return the window.close() value to the submit button so that
it can do its thing after the window has been closed.
Use the same t
Hello List,
Has anyone had any problems using the onClick="window.close();"
function within a input type = "submit" ?
I'm trying
But evidently it's reading the close before the submit because the value
of my form var is not being passed.
I have also tried it in conjunction with a hidden f
I need know if 's possible show a mysql table like when you are entering
some code product, you press an icon with ? (by example) and there appear
the window showing the table with the code and the description and the you
choose and pick some item from that table and the code pass to the input
fiel
Hello all,
Well it's Monday :( and my code wont work.
I have a form that dynamically produces tables. From each cat_detail
any of the checkboxes can be picked, be it the detail itself, levels 1
or 2 or 3, and or a 'yes'.
I can capture the cat_detail in the prob[] array in the next page. I
can
I don't think this aspect of php could justify a whole book to itself, at
least not yet.
A decent php book that has good coverage of php and oop is Web Application
Development with PHP 4.0, New Riders (this is an advanced text though) A
really good general php book is Programming PHP by Rasmus Ler
Hi,
I got the following ( simple :) ) problem. I have like 1 million keys and I
want to browse through them like"show next 10" or "show last 10" or
"show next" or "show last" for example. this is pretty easy in mysql but for
some reason not in oracle:)
The first solution I had is to have a sub
> -Original Message-
> From: xxx [mailto:[EMAIL PROTECTED]]
> Sent: 13 January 2003 14:25
>
> Hy,
> I have a matrix with strings ex. 4 cols and many rows
> how could I sort the matrix after the 2nd field with
> maintaining the indexes order
>
> Like in a table
>
> name surname age
Hy,
I have a matrix with strings ex. 4 cols and many rows
how could I sort the matrix after the 2nd field with maintaining the indexes order
Like in a table
name surname age address..
i have many records and i'd like to print the records in age order ascendent or after
the surname order...
it's
This won't be a one time deal, in theory, the users will go online, click a button and
their data will be uploaded from their access db to our mysql dbthen in a few
days, weeks, whatever, they can upload again. Hopefully each time we will grab all
the new stuff.
Eddie
-Original Messa
Umm, if it's a one time deal, why not just have access output a CSV (comma seperated version, or something like that)
and use PHP or phpMyAdmin if it will do it, to do your insert's? That way you don't have to have PHP interface with
Access, just the MySQL part which is real easy.
On Mon,
Ok, I know I have asked this question several times but it is time for me to
start coding so I am looking for some goog tutorials somewhere. I need to
use php to transfer data from an access file to mysql db. I assume I will
just use an odbc connection but I am unsure as to where to start. If an
On Monday 13 January 2003 19:00, Vic Sutton wrote:
> Folks,
> I have PHP 4.2.2, Apache 1.3.6 & MySQL 3.22.53 installed. The access to
> MySQL is fine from the command line, but fails from Apache with "Fatal
> error: Call to undefined function: mysql_connect() in .." when running
> same scri
Folks,
I have PHP 4.2.2, Apache 1.3.6 & MySQL 3.22.53 installed. The access to
MySQL is fine from the command line, but fails from Apache with "Fatal
error: Call to undefined function: mysql_connect() in .." when running
same script via a page. Has anyone seen this behavier before ?
Regard
23 matches
Mail list logo
