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:

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&

Text formatting

mmand echo, i.e. 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

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,

Date computation in MySQL & PHP

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

gards, 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

Blobbing data on MySQL

lp me 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? Regar

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

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. - Origin

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: <[EM

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

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

',subject='$subject',carbon='$carbon',body= '$body',postedby='$postedby' WHERE idx='$idx'"; $result = mysql_db_query("e-bulletin", $query); $query = "SELECT * FROM czz"; $result = mysql_db_query("e-bulletin", $query); my

Re: Request-URI Too Large

',subject='$subject',carbon='$carbon',body= '$body',postedby='$postedby' WHERE idx='$idx'"; $result = mysql_db_query("e-bulletin", $query); $query = "SELECT * FROM czz"; $result = mysql_db_query("e-bulletin", $query); my

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 - Befo

Re: Request-URI Too Large

ate = urldecode($date); $subject = urldecode($subject); $carbon = urldecode($carbon); $postedby = urldecode($postedby); echo " $date $subject $postedby Edit "; } echo ""; } else { echo "No data."; } mysql_free_result($result); ?> Thanks. Delz - Ori

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

surely appreciate 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 u