MySQL Sort by Array

Hi Guys, I'm trying to sort by a particular order: SELECT * FROM tablename WHERE id='5' OR id='9' OR id='25' OR id='34' ORDER BY id(5, 34, 9, 25) Can anyone tell me the proper syntax to accomplish this task? Thanks for your help. Keith

Time Zone Support

Hi, We need to add support for time zone to our existing PHP Board Member Extranet applications. Could those of you with experience supporting a time zone field in your MySQL data tables offer some advice? Would you use a single field? Would you use just an offset value? How would you

Zip Codes with Leading Zeros

Hi, RE: Zip Codes with Leading Zeros We need to export a MySQL table with a zip code field to Excel. We currently use PhpMyAdmin to export to CSV or Excel files. We have had problems with zip codes with leading zeros. The leading zeros are removed so that we are left with incomplete

Re: Zip Codes with Leading Zeros

for the printer. I'm working on either finding or producing a script that will repair the 12,000 rows of mixed zip (5 digit) and zip+4 data. I appreciate your taking the time to help us Johnny. Keith - Original Message - From: Johnny Withers To: Keith Spiller Sent: Thursday

Re: Zip Codes with Leading Zeros

- From: Keith Spiller [mailto:[EMAIL PROTECTED] Sent: Thu 21-Aug-08 22:11 To: mysql@lists.mysql.com Subject: Zip Codes with Leading Zeros Hi, RE: Zip Codes with Leading Zeros We need to export a MySQL table with a zip code field to Excel. We currently use PhpMyAdmin to export to CSV or Excel

MySQL Application Builder

Hi, I've been building my PHP/MySQL applications by hand for years. Now I am wondering after seeing a Flex demo if some sort of instant or super easy mysql application builder existings. I want something for rapid development with a graphical user interface. Maybe drag and drop table query

Re: Sort Select by List

: Sort Select by List In the last episode (Dec 16), Dan Nelson said: In the last episode (Dec 16), Mark Leith said: Pintér Tibor wrote: Keith Spiller írta: I'm wondering how I would turn three different queries: SELECT * FROM team WHERE office = 'Exec' SELECT * FROM team WHERE

Sort Select by List

Hello, RE: Sort Select by List I'm wondering how I would turn three different queries: SELECT * FROM team WHERE office = 'Exec' SELECT * FROM team WHERE office = 'VP' SELECT * FROM team WHERE office = 'Dir' Into one query with the sort order of office = 'Exec', 'VP', 'Dir'...

Re: Sort Select by List

Hi Hal, I appreciate your help, but the order can not be alphabetical. It must be explicitly Exec, VP, Dir... Keith - Original Message - From: Hal Wigoda [EMAIL PROTECTED] To: Keith Spiller [EMAIL PROTECTED] Sent: Saturday, December 16, 2006 2:28 PM Subject: Re: Sort Select by List

Manually Inserted Data

Hi, I'm trying to manually insert data into a mysql query so that the data will be sorted by the query but not inserted into the table. Here's what I have so far: ( SELECT ID, Title, Label, Location, Start, End, Time, Description, Organization, Department, Contact, Phone, Email, Global,

Re: Manually Inserted Data

DESC, Time ASC a Does anyone see my mistake? Keith - Original Message - From: Rolando Edwards [EMAIL PROTECTED] To: Keith Spiller [EMAIL PROTECTED] Cc: MySQL mysql@lists.mysql.com Sent: Wednesday, November 01, 2006 2:11 PM Subject: Re: Manually Inserted Data The first UNION part has

Ftp of Mysql Files

Hello, I already use phpmyadmin to dump the mysql data into sql files, but I would like to back up the original database files as well. I found the actual database files on my server in var/lib/mysql and want to download copies, but I do not know wether I should use binary or ascii format.

Now() and Timestamp

Hello, I am trying to figure out how to use the NOW() function with a MySQL Insert command on a Timestamp field. Here is my mysql command: INSERT INTO $tablename (sender, recipient, whenread, whensent, subject, messagetext, folder, priority, condition) VALUES ('$directorid', '$SendTo',

mysqlimport

Hello, mysqlimport --replace --fields-terminated-by=\| --verbose --user=user --password=mysql database tables.sql I'm trying to use the mysqlimport command. I have multiple tables listed in my table.sql file. But the command requires that the filesname be the same as the table you try to

Proper Case Conversion

Hello, I'm reading data from a mysql table that is entirely in uppercase letters. I'd very much like to convert them to lowercase. After searching a while, I found that there is are php commands to convert text strings between upper and lower case, but I was unable to find anything that can

Opps: Proper Case NOT lower case

-Opps: I meant to say I would like to convert to Proper Case, rather than lower case or UPPER CASE. I'm reading data from a mysql table that is entirely in uppercase letters. I'd very much like to convert them to Proper Case. After searching a while, I found that there is are php commands

LIMIT with mysql_num_rows

already knew. Is it possible to get this figure without doing a separate query? Thanks for any help... Keith Spiller [EMAIL PROTECTED]

LIMIT with mysql_num_rows

already knew. Is it possible to get this figure without doing a separate query? Thanks for any help... Keith Spiller [EMAIL PROTECTED]

array awry

This associative array embedded within a function and declared as a global at the start of the function, is meant to be a multidimensional array, but with every loop of the while ($myrow = mysql_fetch_row($result)) statement, it's previous values are replaced by the new ones. Any ideas on how

Join causing Error?

qorder",$db); Works perfectly? Keith Spiller a.k.a. Larentium