java , mysql and php

I have an intranet, a database mysql (i admin with phpmyadmin) I use a program java in order to put data in mysql and i want to know if it is possible to put prog java in php page on my intranet ? I want to start my program on the web ? please help! excuse me for my english antoine -- MySQL Ge

RE: Newbie question -- PHP document

En réponse à George Pitcher <[EMAIL PROTECTED]>: > -- Début du message d'origine > Nate, > > The absence of details on the db and table structure prevent > testing. > > However, if you 'View Source' you'll see thet the form isn't > being sent to > any response

RE: Newbie question -- PHP document

Nate, The absence of details on the db and table structure prevent testing. However, if you 'View Source' you'll see thet the form isn't being sent to any response page, so there's nothing to handle the query and show the results. '' Hope this helps George in Oxford > -Original Message---

Newbie question -- PHP document

Thanks for the help with my first question. using the USE mysql command did the trick. The book I am reading ( http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=2T67AHHR6W&isbn=0764516507&itm=1 ) PHP & MySQL for Dummies has a CD Rom with several PHP files. One is called mysql_se

Re: quotas

In the last episode (Jul 21), Paul Chvostek said: > On Sun, Jul 20, 2003 at 11:43:20PM -0500, Dan Nelson wrote: > > > For example user1 has a web space in /home/hostings/user1 and his > > > database in /home/hostings/user1/data and user2 will have his web > > > space in /home/hostings/user2 and dat

Re: quotas

On Sun, Jul 20, 2003 at 11:43:20PM -0500, Dan Nelson wrote: > > > > For example user1 has a web space in /home/hostings/user1 and his > > database in /home/hostings/user1/data and user2 will have his web > > space in /home/hostings/user2 and database in > > /home/hostings/user2/data > > Create sy

Re: quotas

In the last episode (Jul 21), LaCraze said: > I am a Redhat user. Presently using RH 7.3 and mysql 3.23. I am doing > some web hosting services. I have system quota installled and enable. > Is there a way, to tell mysql to have individual databases in my > user's directories instead of /var/lib/mys

quotas

Hi, I am a Redhat user. Presently using RH 7.3 and mysql 3.23. I am doing some web hosting services. I have system quota installled and enable. Is there a way, to tell mysql to have individual databases in my user's directories instead of /var/lib/mysql/ ? For example user1 has a web space in /ho

Re: Newbie question -- user accounts

At 14:30 -0500 7/20/03, Nate Dawg wrote: I setup MySQL 4.0.13 Win32. I also setup PHP 4.3.2. I am trying to learn MySQL and PHP. I am using PHP & MySQL for dummies. I am having a problem. Look: mysql> SELECT * FROM user -> ; ERROR 1046: No Database Selected mysql> Ok so the book says " Thi

Re: Fulltext searches question

At 13:00 -0500 7/19/03, Wesley Hobbie wrote: I am running MySQL 4.0.12 on Windows XP. I am trying to create a library database and have a table named "cardCatalog" in the "library" database. The cardCatalog has the following fields: callNumber (varchar(60)), title (varchar(255)), author (varchar(2

How to write query to select the Max(version) for each unique file_name record?

Hello All, I am a MySQL newbie trying to write a query that selects file_name records possessing the highest numbered version for that unique file_name. I show sample data and two trial queries below. Logically I want to use max(version) as a constraint in a Where Clause. However, the max() fun

About BerkeleyDB used in MySQL

Hi All, I noticed that MySQL 3.23.49 uses Berkeley DB 3.2.9a (February 14, 2002). Does anyone know the difference between this bundled 3.2.9a and the BerkeleyDB 3.2.9 downloaded directly from sleepycat website? Is the difference big or not? Thank you very much! Stan

Re: joining two columns from two different tables in a query

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sunday 20 July 2003 14:18, Veysel Harun Sahin wrote: > Hello, > > I have to join two columns from different tables in a query. Assume that > I have two tables: > > staff > idcompany_Id name > 11FirstName > 2

Re: Newbie question -- user accounts

Did you try to select a database before querying the table? You can do this with use command. mysql>use mysql; Then your command; mysql>select * from user; [EMAIL PROTECTED] wrote: I setup MySQL 4.0.13 Win32. I also setup PHP 4.3.2. I am trying to learn MySQL and PHP. I am using PHP & MySQL fo

Newbie question -- user accounts

I setup MySQL 4.0.13 Win32. I also setup PHP 4.3.2. I am trying to learn MySQL and PHP. I am using PHP & MySQL for dummies. I am having a problem. Look: mysql> SELECT * FROM user -> ; ERROR 1046: No Database Selected mysql> Ok so the book says " This message means your account is not allo

joining two columns from two different tables in a query

Hello, I have to join two columns from different tables in a query. Assume that I have two tables: staff idcompany_Id name 11FirstName 21SecondName 32ThirdName company company_Id owner 1

Fulltext searches question

I am running MySQL 4.0.12 on Windows XP. I am trying to create a library database and have a table named "cardCatalog" in the "library" database. The cardCatalog has the following fields: callNumber (varchar(60)), title (varchar(255)), author (varchar(255)), category (varchar(100)), location (varc

Re: Optimal Disk Configuration

On Sun, Jul 06, 2003 at 10:10:22PM -0600, Jim McAtee wrote: > Jim McAtee wrote: > > > David Lloyd wrote: > > > > > > What would be the ideal RAID configuration for a dedicated MySQL db > > > > server running on FreeBSD? > > > > > > > > We're also running some MySQL databases on Windows 2000 Server

safe_show_database on windows?

Hi all, I'm wondering if I can set safe_show_database on my Windows 2000 MySQL 3.23.56-nt. Here's what I did: --- (c:\winnt\my.ini) [mysqld] set-variable = safe_show_database=1 --- -> NT Service didn't want to (re)start anymore. --- mysql> show variables like "safe%"; ++-

Re: no duplicate entries..

On Sun, 20 Jul 2003, harsh wrote: > > Hi all, > How do i do this ? > i have a table with one of the column named uid, > Now i want to insert a new row,only if no other > row exist with the uid i m trying to insert. > I hope its clear. Hello Harsh, How about making the uid column in your table a

Server restarts on SSL connection

Hi, I am trying to build a MySQL Server running FreeBSD-4.8-STABLE with OpenSSL-0.9.7b. I am able to build and install MySQL successfully with the following options: ./configure --with-vio --with-openssl I can then start the server (using mysqld_safe --log --user=mysql & ), and create a few use

no duplicate entries..

Hi all, How do i do this ? i have a table with one of the column named uid, Now i want to insert a new row,only if no other row exist with the uid i m trying to insert. I hope its clear. thanks for any reply . harsh --

Re: MySQL compiletime errors with --with-debug=full

Worked like a charm! Thank you very much Sergei! :) Adam - Original Message - From: "Sergei Golubchik" <[EMAIL PROTECTED]> To: "Adam Carmichael" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, July 20, 2003 10:04 PM Subject: Re: MySQL compiletime errors with --with-debug=full

Re: db design - the mythical 1:1 relation ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sunday 20 July 2003 09:03, Andreas wrote: > Hi folks, > > how would you design a 1:1 relation ? > > > I'd like to split an entities's attributes because they won't get > equally frequently requested. So I can save memory and disk access time. > The

db design - the mythical 1:1 relation ?

Hi folks, how would you design a 1:1 relation ? I'd like to split an entities's attributes because they won't get equally frequently requested. So I can save memory and disk access time. The integrity of the splitted record should be retained. The key points would be: 1) devide the data collumn

Re: MySQL core certification revision - clients

Matthew, > Hi, I'm clear as to what is meant by "The mysql client" in the MySQL core > certification revision check list. I understand that the mysql database > itself is the "server". Would client then be any program that talks to the > server? Perhaps it is referring to mysql, the command line t

Re: MySQL compiletime errors with --with-debug=full

Hi! On Jul 20, Adam Carmichael wrote: > Hello, > > I am trying to report a bug, and I would like to compile mysql with > debugging enabled to provide further information, but I receive > compile errors. I would like to resolve the compile errors before I > report the possible bug I have discovere

MySQL compiletime errors with --with-debug=full

Hello, I am trying to report a bug, and I would like to compile mysql with debugging enabled to provide further information, but I receive compile errors. I would like to resolve the compile errors before I report the possible bug I have discovered. I am running FreeBSD 4.8, and I attempt to co

Re: passwords & DBI/DBD

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 LOL You could skip the "make test" part... ;-P -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/GmBzmk7m2JX6ki4RArT8AJ0TIXkdJtdLnp8ZX1QX9dAyhrKVSACgo4Q3 BU5O9jhdfBp5nIh/zShajrI= =zUaW -END PGP SIGNATURE- -- MySQL Ge