Re: tutorial sites

If you're learning PHP I'd take a look at http://www.phpbuilder.com. They have a lot of good atricles and tutorials on setting it up and things you can do with it. I pretty much thought myself PHP through that site a couple of years back. They have pretty active forums if you have any questions

error in script

I'm a newbie to MySQL so please bear with me. I'm creating a program from a script I found and I'm wondering why I keep getting the same error message. I can connect to the mysql server while I'm ssh to the server, I also can run phpmyadmin from my windows desktop and see the databases and

Re: query with vars

You should be able to join the tables like this: select p1.id /* and other cols */ from people1 p1 inner join people2 p2 on p1.Lname = p2.Lname and left(p1.Fname, 3) = left(p2.Fname, 3) group by p1.id; HTH, James Harvard I have two independently built tables of people. I am trying to match

How to update record obtained from a query result?

Hi, Newbie question (MySql 5.0 using C API). I've searched the mysql website/Internet but cannot find the answer. How do I update a record obtained from a query result while ensuring that: 1) The record is the actual record in the database not a possible duplicate, e.g. is there a built-in

Cant access my files through the web site

hi Im quite new to mysql and i bought a book to learn how to work with mysql (php and mysql for dummies...lol). The first problem i have is probably easy to solve but i don't know how. I did exactly like in the book and i set up my web server(it was already set since i run a website for a

Re: Cant access my files through the web site

Hi The problem here does not involve mysql. For better advice, try an apache or PHP group. From what I know, I would check directory permissions in the apache conf file. Mike - Original Message - From: ghislain groulx [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: January 8,

Re: Cant access my files through the web site

Ghislain This question would better be asked on a PHP list. PB - ghislain groulx wrote: hi Im quite new to mysql and i bought a book to learn how to work with mysql (php and mysql for dummies...lol). The first problem i have is probably easy to solve but i don't know how. I did

allocate space for innodb innodb_file_per_table

Hi All, I am running mysql 5.0.18 with a innodb table of 9 GB (plus several others) on suse linux 9.3 with 4 GB ram. when doing a show table status command, this table shows Data_Free:0 I assume this is because it is the file per table setting, where the tables fall outside of the main

Daniel Whitener still in list?

Hi there I checked your post at http://lists.mysql.com/mysql/166873 I'm with some troubles with Multiple Query and error 2013 (lost connection). Can u gimme some help?? 10ks Franz - Francisco Bischoff ICQ#: 1891104 Current ICQ status: + More ways to contact

remotely show databases

I know I can login via ssh and run $mysqlshow But I would then have to parse the outputted text, is there an easier way (I'm using Perl locally here). The pitfall of running it locally is that you DO have to password protect your database user since it's an outside connection to run SHOW

Re: Getting # of days until expiration

On 1/6/06, Brian Dunning [EMAIL PROTECTED] wrote: On Jan 5, 2006, at 9:38 PM, Michael Stassen wrote: DATEDIFF was added in 4.1.1. What version of mysql do you have? Thanks Michael - that was indeed the problem. Some ancient-ass version that's been on my development server for who knows

Re: tutorial sites

google on any and all: codewalkers, phpfreaks, sitepoint, zend, onlamp, devnetwork, phpbuilder, and of course look at all their manuals/docs. Jon Miller wrote: Does anyone know of some good tutorial sites of using Apache, PHP and MySQL.? Just starting out and want to create a website (mine)

General Questions regarding mysql and php

Hi MYSQL users, Just started playing with mysql apache php and other tricky stuff and have a few question to get me going after many years. Was wondering what the best GUI based administration tool is used today, I lasted used phpMyAdmin, is this still used or are there better

Re: General Questions regarding mysql and php

Andrew Burrows wrote: Hi MYSQL users, Just started playing with mysql apache php and other tricky stuff and have a few question to get me going after many years. Was wondering what the best GUI based administration tool is used today, I lasted used phpMyAdmin, is this still used or are there

Re: General Questions regarding mysql and php

Andrew, I used to be a big redhat fan - but if you are looking to totally bring everything up to date, I would suggested opensuse. having used redhat for years, Suse's not a big step - everything is still RPM based, however, Suse's admin tool, YaST, kicks butt :) Suse 10 comes with Apache

Re: Are Mysql ODBC supporting connection pool?

Connection pool facility is not in the JDBC driver. It is provided by the application server like JBoss, Websphere, Weblogic, etc. Tool like Hibernate and IBatis also provide it. Vi. wangxu [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Are Mysql ODBC supporting connection pool?