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 covered in the articles. They cover most of the basics, like setting up Apache/PHP/MySQL For MySQL you cant go far wrong with the reference manual http://dev.mysql.com/doc/. Good luck, Conor On 1/8/06, Jon Miller <[EMAIL PROTECTED]> 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) where I can change up > the data as often as I. > > Thanks > > Jon L. Miller, ASE, CNS, CLS, MCNE, CCNA > Director/Sr Systems Consultant > MMT Networks Pty Ltd > http://www.mmtnetworks.com.au > Resellers for: Novell Gold Partner, Cisco Partner, Peopletelecom, Westnet, > Sophos Anti-Virus, > > "I don't know the key to success, but the key to failure > is trying to please everybody." -Bill Cosby > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > >
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 create databases, tables and input the data. I'm using Apache2, PHP4 and MySQL Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386) Thanks Jon Movie Database Fatal error: Call to undefined function: mysql_connect() in /var/www/test5.php on line 8 /var/www/test5.php: Movie Database -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 people >from one with people from the other. The problem is that in one table they >may have used "Ron" and in the other "Ronald". What I want to do is have a >match if on something like "if 'Ronald" is like 'Ron%' but obviously for any >name that could appear. I know this won't help in cases like Bill and William >but it's better than nothing. The first query below is the one I thought >would do the trick and the second one is setup for the specific case I know >exists to test the general idea. The second one works but isn't very useful. >Can someone tell me how to make the first one work? >The example I have has 'Ron' in the 'h' table and 'Ronald' in the 'm' table. >With a last name of Gibson. In general the short name could be in either >table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 record number identifying the actual DB record or do I have to organise that in the table structure. 2) The record hasnt been or cannot be changed by another thread/process, possibly by. locking / re-reading the record (is there another way?). How do I lock and re-read the [actual] record anyway? Code snippet: sprintf(szStr, "SELECT * FROM %s WHERE UserName = '%s'", DB_TABLE, szUserName); if(mysql_real_query(db, szStr, strlen(szStr)) == 0) { result = mysql_store_result(db); if(result) // There are rows { while ((row = mysql_fetch_row(result))) { // *** I need to update the record here! *** } mysql_free_result(result); } TIA. Jan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 long time now), mysql and php last. After that, the book told me to create 2 files called test.php and mysql_up.php to test php and mysql. So far, i could see the files in the browser but as soon as i enter back all the content of my website in the web server (i run apache 2), i could not see the php files anymore. Now, if i enter the adress www.mysite.com/mysql_up.php or localhost/mysql_up.php, it always redirect me to the home page of the website. Can someone tell me what i missed ? I guess the probelm lies in the configuration file of the apache server, but i dont know what to change. thanks a lot ! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: Sent: January 8, 2006 1:19 PM Subject: 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 long time now), mysql and php last. After that, > the book told me to create 2 files called test.php and mysql_up.php to test > php and mysql. So far, i could see the files in the browser but as soon as > i enter back all the content of my website in the web server (i run apache > 2), i could not see the php files anymore. Now, if i enter the adress > www.mysite.com/mysql_up.php or localhost/mysql_up.php, it always redirect > me to the home page of the website. > > Can someone tell me what i missed ? I guess the probelm lies in the > configuration file of the apache server, but i dont know what to change. > > thanks a lot ! > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.371 / Virus Database: 267.14.15/223 - Release Date: 2006-01-06 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 exactly like in the book and i set up my web server(it was already set since i run a website for a long time now), mysql and php last. After that, the book told me to create 2 files called test.php and mysql_up.php to test php and mysql. So far, i could see the files in the browser but as soon as i enter back all the content of my website in the web server (i run apache 2), i could not see the php files anymore. Now, if i enter the adress www.mysite.com/mysql_up.php or localhost/mysql_up.php, it always redirect me to the home page of the website. Can someone tell me what i missed ? I guess the probelm lies in the configuration file of the apache server, but i dont know what to change. thanks a lot ! -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.15/223 - Release Date: 1/6/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 ibdata files. The ibdata files are all preallocated when mysql starts up, is there anyway to preallocate the "file per table" files as well? Is there a specific innodb list? Thanks to Gleb's answer and the hint on the bulk load setting in my.cnf - that seems to have helped some what. I notice in the load data command there is a "CONCURRENT" option - but as far as I can tell, that only does MyISAM tables? You also suggested disablign the keys. I think I tried that, but with a table with 7 mil rows, that takes longer than the load data :-\ TIA. George Law -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 me i See more about me: - ___ Yahoo! doce lar. Faça do Yahoo! sua homepage. http://br.yahoo.com/homepageset.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 DATABASES"; I tried $man mysqlshow, but didn't see any easy way of simply returning a \n seperated list of databases. Any suggestions? I also need to do this for postgresql if anyone else knows of a standalone app that dumps the databases for a specific user. -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html
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 how many > years, in accordance with the "If it ain't broke don't fix it" rule. > > :) Without using DATEDIFF I would suggest subtracting the current UNIXTIME from the UNIXTIME of meets.creation and converting the resulting number of seconds back to days. -jp
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) where I can change up the data as often as I. Thanks Jon L. Miller, ASE, CNS, CLS, MCNE, CCNA Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au Resellers for: Novell Gold Partner, Cisco Partner, Peopletelecom, Westnet, Sophos Anti-Virus, "I don't know the key to success, but the key to failure is trying to please everybody." -Bill Cosby -- life is a game... so have fun. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 applications available? Looking for some basic documentation on MYSQL could someone recommend something online or maybe a book?? I have an old system that will probably need upgrading. Apache 1.3 Mysql 3.22.32 Tomcat 3.1.1 Red Hat 8 Would you recommend upgrading this system or starting from scratch? Thanks in advance. Andrew
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 better applications available? If you don't have remote access to the port MySQL is running on, phpMyAdmin is still very good. However, when ever I can, I use the mysql GUI tools, MySQL Query Browser and MySQLAdmin. They are both written by MySQL and are on the site for download. http://dev.mysql.com/downloads/ Looking for some basic documentation on MYSQL could someone recommend something online or maybe a book?? MySQL maintains a manual for each of the major version online in several formats, including HTML and PDF, I prefer the US - Letter size PDF file. It is over 1,700 pages of information. Most anything you need to know about it can be found in there. http://dev.mysql.com/doc/ I have an old system that will probably need upgrading. Apache 1.3 Mysql 3.22.32 Tomcat 3.1.1 Red Hat 8 Would you recommend upgrading this system or starting from scratch? Well if you want to go all the way to MySQL 5, you will need to do several upgrades. I would just start over with a modern Linux Distribution that has MySQL 4.1 Apache 2 and I think PHP 5. It will take far less effort than upgrading what you have now. -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want & give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 2, PHP5, and one of the latest 4.X versions of mysql. There are generic RPMs for mysql 5 on mysql's website - but I haven't used them - I am running 5.0.18, but using the binary distro because I needed to run both 4.x and 5.x at the same time to migrate some data. -- George Law - Original Message - From: "Andrew Burrows" <[EMAIL PROTECTED]> To: "MYSQL General List" Sent: Sunday, January 08, 2006 8:01 PM Subject: 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 applications available? Looking for some basic documentation on MYSQL could someone recommend something online or maybe a book?? I have an old system that will probably need upgrading. Apache 1.3 Mysql 3.22.32 Tomcat 3.1.1 Red Hat 8 Would you recommend upgrading this system or starting from scratch? Thanks in advance. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]