Possible drawbacks of suggested mysql install?
Hi there, I would like to know some professional opinions on the following: -Are there any drawbacks on installing Mysql on a windows server? Would it be possible to install it on the same server that hosts SQL server? Can they coexist properly? I do not expect too much usage of the Mysql server. We want to provide the MySQL service to our staff but might not be able to justify seperate servers. Are there any good articles available on this matter Cheers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Specs for a dedicated MySQL server
This looks like a flash server. I am not sure if we will have enough Mysql use to justify this. Does anyone have an idea for what kind of use (amount of db etc) that I would use this kind of server? Guy -Original Message- From: Gabriel Ricard [mailto:[EMAIL PROTECTED] Sent: Tuesday, 9 December 2003 7:32 a.m. To: Defryn, Guy Cc: [EMAIL PROTECTED] Subject: Re: Specs for a dedicated MySQL server There's actually a MySQL Database Appliance out there. Have you looked at that yet? http://pogolinux.com/mysql/index.html You could run MySQL on any number of different machines. Intel, Athlon, PowerPC, etc. Linux, FreeBSD, Windows, Mac OS X. - Gabriel On Dec 7, 2003, at 4:41 PM, Defryn, Guy wrote: Hi there, I have been asked to investigate a solution to offer MySQL to our staff. I am not sure how many people will make use of it at this stage. Most people would most likely use it as a backend for message boards And to store information on whatever they are doing. I am sure it will be for web purposes only. I cannot see the need for transactions etc. My employer usually goes for HP DL380 G3 servers. Any tips on redundancy, backup etc? Also, Is there anyone who uses Windows on a Mysql production server? I want to use FreeBSD or Linux but that might not be up to me. What License do I need? Basically we are an ISP for our departments Cheers GUY -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Specs for a dedicated MySQL server
There is one server that we have and that I can possible use Dual Pentium 1.2 ghz CPU 1 gig of Ram 18 gb SCSI 0+1 Raid What performance can I expect from this machine. What usage would it be able to handle? cheers -Original Message- From: Defryn, Guy Sent: Tuesday, 9 December 2003 9:01 a.m. To: [EMAIL PROTECTED] Subject: RE: Specs for a dedicated MySQL server This looks like a flash server. I am not sure if we will have enough Mysql use to justify this. Does anyone have an idea for what kind of use (amount of db etc) that I would use this kind of server? Guy -Original Message- From: Gabriel Ricard [mailto:[EMAIL PROTECTED] Sent: Tuesday, 9 December 2003 7:32 a.m. To: Defryn, Guy Cc: [EMAIL PROTECTED] Subject: Re: Specs for a dedicated MySQL server There's actually a MySQL Database Appliance out there. Have you looked at that yet? http://pogolinux.com/mysql/index.html You could run MySQL on any number of different machines. Intel, Athlon, PowerPC, etc. Linux, FreeBSD, Windows, Mac OS X. - Gabriel On Dec 7, 2003, at 4:41 PM, Defryn, Guy wrote: Hi there, I have been asked to investigate a solution to offer MySQL to our staff. I am not sure how many people will make use of it at this stage. Most people would most likely use it as a backend for message boards And to store information on whatever they are doing. I am sure it will be for web purposes only. I cannot see the need for transactions etc. My employer usually goes for HP DL380 G3 servers. Any tips on redundancy, backup etc? Also, Is there anyone who uses Windows on a Mysql production server? I want to use FreeBSD or Linux but that might not be up to me. What License do I need? Basically we are an ISP for our departments Cheers GUY -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Disk Configuration
I have another question regarding specs for a server. I have talked to a DBA who has no mySQL knowledge but did work with Oracle, etc He said I should do some more investigation on disk configuration and how mysql benefits from Separating log files, data files, etc. All feedback welcome!
Specs for a dedicated MySQL server
Hi there, I have been asked to investigate a solution to offer MySQL to our staff. I am not sure how many people will make use of it at this stage. Most people would most likely use it as a backend for message boards And to store information on whatever they are doing. I am sure it will be for web purposes only. I cannot see the need for transactions etc. My employer usually goes for HP DL380 G3 servers. Any tips on redundancy, backup etc? Also, Is there anyone who uses Windows on a Mysql production server? I want to use FreeBSD or Linux but that might not be up to me. What License do I need? Basically we are an ISP for our departments Cheers GUY
Apache/PHP question
I have set apache 2.0 and PHP 4.3.1 as well as mysql. I was wondering how I can disable PHP per user directory?. At the moment everyone can put php scripts on their personal website. I want to limit it to a few users. Cheers Sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
startup and install issues
I have installed 4.0.9 from source. After compiling it I want to start it with /usr/local/mysql/bin/mysqld_safe --user=mysql and the message mysqld ended appears. When I move the startup script to the appropriate directory and reboot I get the following error Can't execute @bindir@/mysqld_safe from [EMAIL PROTECTED]@ Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Auto-completion
Is auto completion a feature that only works in Mysql4? Cheers Sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: RE: Auto-completion
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 February 2003 11:03 a.m. To: Defryn, Guy Subject: Re: RE: Auto-completion Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query,queries,smallint If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: However, I have never noticed it to work on Windows. Are you using Windows? I am the moment so that explains why it did not work Cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is it my English or does this sound bad?
I was just reading through the Mysql manual section 3.32 And came across a sentence that started like this Animal sex can be represented in a variety of ways My mother tongue is not English but doesn't it sound rude ? :-) mysql CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), - species VARCHAR(20), sex CHAR(1), birth DATE, death DATE); VARCHAR is a good choice for the name, owner, and species columns because the column values will vary in length. The lengths of those columns need not all be the same, and need not be 20. You can pick any length from 1 to 255, whatever seems most reasonable to you. (If you make a poor choice and it turns out later that you need a longer field, MySQL provides an ALTER TABLE statement.) Animal sex can be represented in a variety of ways, for example, m and f, or perhaps male and female. It's simplest to use the single characters m and f. Query/mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Detecting Mysql servers on the network
Is it possible to detect mysql servers on the network without knowing the hostname? cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
data directory in 4.0.9
Where does mysql places the databases in 4.0.9 when installing from source? The var directory does not seem to be there anymore - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unable to install 4.08 or 4.09
I have tried to install mysql 4.0.8 and 4.0.9 and I get the following error After running gunzip mysql-4.0.9-gamma.tar.gz (source install) Mysql-4.0.9-gamma/bdb/ Mysql-4.0.9-gamma/bdb/db/ Mysql-4.0.9-gamma/bdb/db/db_upg.c Mysql-4.0.9-gamma/bdb/db/db.c Mysql-4.0.9-gamma/bdb/db/tags Tar : skipping to next header Tar: archive contains obsolescent base-64 headers Gunzip: stdin: invalid compressed data --crc error Tar: error exit delayed from previous errors Does anyone know why this happens. I am using a fresh freebsd 4.7 install Cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Unable to install 4.08 or 4.09
Thanks Paul, It's working now. cheers -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 14 January 2003 3:41 p.m. To: Defryn, Guy; '[EMAIL PROTECTED]' Subject: Re: Unable to install 4.08 or 4.09 At 15:31 +1300 1/14/03, Defryn, Guy wrote: I have tried to install mysql 4.0.8 and 4.0.9 and I get the following error After running gunzip mysql-4.0.9-gamma.tar.gz (source install) Mysql-4.0.9-gamma/bdb/ Mysql-4.0.9-gamma/bdb/db/ Mysql-4.0.9-gamma/bdb/db/db_upg.c Mysql-4.0.9-gamma/bdb/db/db.c Mysql-4.0.9-gamma/bdb/db/tags Tar : skipping to next header Tar: archive contains obsolescent base-64 headers Gunzip: stdin: invalid compressed data --crc error Tar: error exit delayed from previous errors Does anyone know why this happens. I am using a fresh freebsd 4.7 install You're not transferring the distribution in binary (image) mode, and you're ending up with a corrupted download as a result. At least, that's the most common reason for errors such as these. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysock.sql problem
I have installed mysql from the ports collection on FreeBSD and it was working fine. I would like to move the /tmp/mysql.sock file ( or is it safe to leave it there?) so I Created a my.cnf file with the following options [mysqld] port=3306 socket=/usr/local/mysql/mysql.sock I take down the mysql server and restart but it refuses to work. It is still looking in the /tmp directory What am I doing wrong? Could this be a permission thing on the sock file? What permissions does this file need? Cheers Guy Sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Another one on lost connections( using web interface)
I also have a problem with lost connections. I have small mysql database (version 3.23.49 on FreeBSD 4.5) I have created a website interface to enter and retrieve data. I used ASP to do this. Sometimes when I go to the website I get the error can't connect or lost connection to server. The mysql install has been done with default settings and There are never more than 2 people using the database at the same time. I also created a PHP interface to the database and I received the same error. The error does not occur all the time and when it occurs it goes away by refreshing the web browser. I never have any problems when working on the mysql server from the command line. Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lost connection to mysql server
I have a build an ASP page to enter data in a mysql database. When I open the page I get the following error : Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [TCX][MyODBC]Lost connection to MySQL server during query /centraladmin/products.asp, line 88 When I refresh it works fine. It seems to me it's like a Timeout thing. This is my connection to the database set oconn = server.createobject(Adodb.connection) oconn.connectionstring = server=192.168.1.73;driver=MySQL;db=supplies;uid=myname;pwd=mypwd oconn.open Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lost connection to mysql server
I have a build an ASP page to enter data in a mysql database. When I open the page I get the following error : Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [TCX][MyODBC]Lost connection to MySQL server during query /centraladmin/products.asp, line 88 When I refresh it works fine. It seems to me it's like a Timeout thing. This is my connection to the database set oconn = server.createobject(Adodb.connection) oconn.connectionstring = server=192.168.1.73;driver=MySQL;db=supplies;uid=myname;pwd=mypwd oconn.open Any ideas? Sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lost connection to mysql server
I have a build an ASP page to enter data in a mysql database. When I open the page I get the following error : Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [TCX][MyODBC]Lost connection to MySQL server during query /centraladmin/products.asp, line 88 When I refresh it works fine. It seems to me it's like a Timeout thing. This is my connection to the database set oconn = server.createobject(Adodb.connection) oconn.connectionstring = server=192.168.1.73;driver=MySQL;db=supplies;uid=myname;pwd=mypwd oconn.open Any ideas? Sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Joins, ANSI 92 or the old way
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 17 July 2002 1:59 p.m. To: Defryn, Guy Subject: Re: Joins, ANSI 92 or the old way Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I was wondering what advantages one has over the other. I think the old way is easier but is it good enough? Cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Calculations in mysql
Hi there, I am creating a tracking system for the consumables we give away to our staff. It is working but I need to know if there is a better practice than I what I did I need to print reports via a website so I used ASP It needs name,product, amount per item, price per item and total per order. This is pretty straightforward My query looks like this sqltext1 = Select orders.orderdate AS orderdate,orders.user AS user , products.productname AS productname, orders.amount as amount,products.price AS Price, sqltext1 = sqltext1 (amount* price) AS subtotal from orders,products where orders.product = products.productid sqltext1 = sqltext1 and cluster = ' cluster ' and orderdate ' printdate ' order by orderdate; Now the other thing I need is the total of all orders so I created a 2nd query sqltext2 = Select sum(orders.amount * products.price) AS total from orders,products where orders.product=products.productid AND cluster = ' cluster 'and orderdate ' printdate '; I have the required result but is there some way I can have everything in one query G - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Calculations in mysql
Hi there, I am creating a tracking system for the consumables we give away to our staff. It is working but I need to know if there is a better practice than I what I did I need to print reports via a website so I used ASP It needs name,product, amount per item, price per item and total per order. This is pretty straightforward My query looks like this sqltext1 = Select orders.orderdate AS orderdate,orders.user AS user , products.productname AS productname, orders.amount as amount,products.price AS Price, sqltext1 = sqltext1 (amount* price) AS subtotal from orders,products where orders.product = products.productid sqltext1 = sqltext1 and cluster = ' cluster ' and orderdate ' printdate ' order by orderdate; Now the other thing I need is the total of all orders so I created a 2nd query sqltext2 = Select sum(orders.amount * products.price) AS total from orders,products where orders.product=products.productid AND cluster = ' cluster 'and orderdate ' printdate '; I have the required result but is there some way I can have everything in one query G - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql certification
I was wondering if anybody heard about a possible release of books that help you prepare for the Mysql certification? Cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Join problem in MYSQL
sql,query Can anyone have a look at my join. It returns errors Select O.name, O.amount , P.Productname, P.price From Orders AS O JOIN Products AS P ON O.product=P.Productid Where O.cluster= 'ANP'; It works fine when I use Select O.Name, O.amount, P.productname , P.price From Orders as O, Products as P Where O.product=P.productid AND O.cluster = 'ANP'; When I use the first example with INNER JOIN it works as well. The book I use as study guide is a few years old so maybe the syntax has changed ?? Any ideas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: find record using MYSQL command in ASP
Hi there, Try this % dim objconn, objrs dim sqltxt, criteriatxt, adopenkeyset, adlockoptimistic adopenkeyset=1 adlockoptimistic=3 set objconn = server.createobject(adodb.connection) set objrs = server.createobject(adodb.recordset) objconn.connectionstring=server=192.168.0.1;driver=MySQL;db=clientdb;uid=us er;pwd=user objconn.open connectionstring sqltxt = select * from client criteriatxt = name like 'TELE*' objrs.open sqltxt, objconn, adopenkeyset, adlockoptimistic objrs.find criteriatxt if objrs.eof then response.write(record is not exist!) else response.write objrs(code) objrs(name) objrs(address) br end if objrs.close objconn.close set objrs = nothing set objconn = nothing % Hope this helps - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Insert with ASP into mysql
Hi there, I want to insert data in a mysql database. When I submit I don't get any errors. It takes me to the page that processes everything However, when I check the database the records are not there. Selecting data from the website works fine. My code is below but I don't think anything is wrong because I don't get any errors. Any ideas? % dim product,amount,cluster,user,orderdate,entered,comment,oconn,sqltext,arrdate function newstr(str) newstr=replace(replace(str,',''),chr(34),quot;) End function product=request.form(product) amount=request.form(amount) cluster=request.form(cluster) user=newstr(request.form(user)) orderdate=request.form(orderdate) comment=newstr(request.form(comment)) entered=request.form(entered) set oconn = server.createobject(Adodb.connection) oconn.connectionstring = server=130.123.80.73;driver=MySQL;db=supplies;uid=itsupport;pwd=itsupport oconn.open sqltext = Insert into orders(orderid,product,amount,cluster,user,orderdate,comment,entered) sqltext = sqltext values(NULL, product , amount ,' cluster ',' user ',# orderdate #,' comment ',' entered ') oconn.close set oconn = nothing % - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Setting up a mysql server for the web
I hope someone can tell me a bit more on how to integrate a MYSQL server with a windows network. I have a web server that is running IIS5. The internet user account is IUSR_Machinename. I do not want to run the database on the web server. When I tried this with Access it did not work because the IUSR_machinename only exists on the web server. How can I give internet users access to a database That is on another server? I would rather use mysql than Access and preferably run mysql on Unix but it is not a must. Hope this makes sense Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
insert into multiple tables??
Is it possible to insert data into different tables with one insert statement. For example , I have one form on my web page and the data needs to go into different tables( first 5 entries to table A and the rest to table B)? Mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Insert dates with PHP
I am working with PHP for the first time and I need a form To insert some details and a date. When I check the mysql database the date is displayed as -00-00 Here is my php script: ? $query = Insert into computers(id,itnumber,hdd,processor,ram,monitor,os,invoice,datebought) values . (NULL,'$itnumber','$hdsize','$processor','$ram','$monitor','$os','$invoice' ,'$datebought'); mysql_query($query) or die (mysql_error()); ? Everything else works fine. When I enter the date into mysql itself it works fine. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Insert dates with PHP
I did forget to mention that I was using that format. So it must be something else?? Guy -Original Message- From: Uma Shankari T. [mailto:[EMAIL PROTECTED]] Sent: Thursday, 16 May 2002 4:09 p.m. To: Defryn, Guy Cc: [EMAIL PROTECTED] Subject: Re: Insert dates with PHP you have to enter ur date as in this format -MM-DD for example: 2002-04-04 Hope this will work Uma On Thu, 16 May 2002, Defryn, Guy wrote: DG DG DGI am working with PHP for the first time and I need a form DGTo insert some details and a date. DG DGWhen I check the mysql database the date is displayed as -00-00 DG DGHere is my php script: DG DG? DG$query = Insert into computers(id,itnumber,hdd,processor,ram,monitor,os,invoice,datebought) values . (NULL,'$itnumber','$hdsize','$processor','$ram','$monitor','$os','$invoice' DG,'$datebought'); DG DGmysql_query($query) or die (mysql_error()); DG DG? DG DGEverything else works fine. When I enter the date into mysql itself it works fine. DG DGThanks DG DG DG- DGBefore posting, please check: DG http://www.mysql.com/manual.php (the manual) DG http://lists.mysql.com/ (the list archive) DG DGTo request this thread, e-mail [EMAIL PROTECTED] DGTo unsubscribe, e-mail [EMAIL PROTECTED] DGTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php DG -- Love and you shall be loved by others - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
relationships between databases
This is my first post to the list What is the best way of making a relationship between tables in Mysql. Do you set it up when you are creating the tables or is it done with the insert statement I am a newbie to Mysql, BTW Guy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php