Help in querying

Hi All, I'm using mysql as my database. I have a table which has the following colums: idx productname value My question is how do i display and select all the data that has a value of more than 915. Hope you can help. Regards, Delz -- MySQL General Mailing List For list archives: http

Text formatting

. ?php echo $textarea;? the output is like this on the browser : Hello World.Hello World. Hello World. Its printing the output in one straight line. Are there any command other than echo that can output the same format as that given on the text area. Please help. Regards, Delz -- MySQL General

Re: Text formatting

Hi Tony, Thanks a lot. That solved my problem. Regards, Delz - Original Message - From: Tony Thomas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 29, 2003 12:40 PM Subject: Re: Text formatting That's because the browser doesn't read the line breaks without a br

Re: Date computation in MySQL PHP

Hi Pete, Thanks for this info Regards, Delz - Original Message - From: Peter Vertes [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 14, 2003 12:05 AM Subject: Re: Date computation in MySQL PHP On Sat, 2003-09-13 at 02:50, delz wrote: I want to know how do I

Date computation in MySQL PHP

on a Sunday, it will be moved to Monday. I just want to disregard Sunday and want to use Monday to Saturday. Anyone who can help me will be appreciated. Regards, Delz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Stripping off commas

, Delz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Blobbing data on MySQL

HI Thomas, Thanks for the reply. Well actually I don't need to search the content of the blob data stored in mysql. I'm just going to create a description w/ a couple of text box that describes the file uploaded. Regards, Delz - Original Message - From: Thomas Spahni [EMAIL PROTECTED

Blobbing data on MySQL

on this. Regards, Delz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Currency Problem

Hi, I just want to know if mysql can set the output of a certain currency to this pattern : $1,500.00 If I use a comma on a certain amount then I add it up to another amount with a comma I get the wrong answer. I'm using php mysql by the way. Any hints on this one? Regards, Delz

AUTO_INCREMENT PROBLEM

Hi All, Good day !!! I'm using phpmyadmin to create database on Mysql server. I want my idx to start at 1800 then implement auto increment. How do i do it using phpmyadmin? Regards, Delz, - Before posting, please check

Re: Math Computations

Hi All, How do I make calculations in php or mysql if the value has a comma like 2,000 + 32,000 = 34,000. I have a problem calculating if one of my values has a comma. It doesn't display the right output. I'll appreciate anyone who can help me with this. Thanks. Delz. - Original Message

Math Computations

| Purchasing | $ 300.00 | $ 900.00 | - --- 20 $ 8400.00 Can anyone help me how to do this in mysql or php. I will surely appreciate any help I can get. Thanks. Delz

Re: Math Computations

Hi Adam, Thanks for your reply. How about if I have more than 3 rows and I'm continously adding entries in my table. What do I need to do? Delz - Original Message - From: Adam Alkins [EMAIL PROTECTED] To: delz [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 5:44

Multiple Search

Hi All, How do i perform multiple search in mysql. For example I have a database running in a computer shop and I want to search for Monitors specifically purchased from 03/01/2002 to 03/31/2002. Can any one help me? Regards, Delz

Re: Request-URI Too Large

); mysql_free_result($result); include(links.y); ? - Original Message - From: ds [EMAIL PROTECTED] To: delz [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 4:02 AM Subject: Re: Request-URI Too Large If all the data is in your database, why are you passing it in your

Re: Request-URI Too Large

); mysql_free_result($result); include(links.y); ? - Original Message - From: ds [EMAIL PROTECTED] To: delz [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 4:02 AM Subject: Re: Request-URI Too Large If all the data is in your database, why are you passing it in your

Remote Connection to Linux MySQL

Hi, How do I configure mysql so that it will accept remote connections because I get the error message Host 192.168.1.253 is not allowed to connect to this MySQL Server Can someone help me with this. Delz - Before posting

Request-URI Too Large

Hi, I'm using php and mysql as my server, when I'm updating a large page on my database using a browser I get Request-URI Too Large the requested URL's length exceeds the capacity limit for this server. request failed: URI too long Why is this so? Do I need to adjust something on mysql or

Problems connecting MS Access to Mysql Server

it. Thanks Delz - 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