Date: 03/18/07 (PHP Community)    Keywords: mysql, sql, google

I've wanted to do this for awhile but I'm not sure where to start.
I want to write a script that takes emails from my pop account and inserts them in to a mysql table.
I found xeoport doing some Google searches but it seems the site is down.

Have suggestions?

Source: http://community.livejournal.com/php/553025.html

Date: 03/18/07 (PHP Community)    Keywords: mysql, browser, database, sql

this might be way too much info, but please bear with me! the end result is, i need to do a query that joins tables that exist in different databases on different servers. how do i do that?

anyway, i'm building a site for a real estate guy who's hosted through 1and1. they only allow you to have 100mb of data per database. he's given me ~500mb of property data and ~100mb of property tax data. i split up the property data and kind of spanned it across five db's, then put the tax data in a sixth. each database you create with 1and1 gets dropped on a random server. i'm able to search property data by checking db1, then db2, and so on... and appending the results. i connect to them all like so

Source: http://community.livejournal.com/php/553672.html

Date: 03/19/07 (PHP Community)    Keywords: php, mysql, database, sql, hosting

regarding my previous problem, i called 1and1 and they said there's no way to get my databases on the same server. whatever process creates your databases through their control panel actually goes out of its way to distribute them on different servers. the only way around this - to exceed the 100mb limit or have multiple db's on the same server - is to rent your own server on a dedicated hosting plan for a minimum of $99/month. no thanks!

so i'm going to switch hosts. i need a host that doesn't limit database sizes beyond overall storage limits, and allows ssh access even with their cheap accounts. cron jobs would be nice but aren't necessary. php5 and mysql and a few gb's of storage.

i don't want to use dreamhost because i've heard too many bad things.

Source: http://community.livejournal.com/php/553852.html

Date: 03/30/07 (MySQL Communtiy)    Keywords: mysql, sql

I have MySQL running on a server with a password-protected root user. Is there any way to call the 'mysqladmin shutdown' command without having to provide the password parameter in clear-text?

Thanks.

Source: http://community.livejournal.com/mysql/112372.html

Date: 04/01/07 (MySQL Communtiy)    Keywords: mysql, sql

I swore there was an open source package to do this, but I wanted to monitor in 30 minute increments, the state of a server dedicated to MySQL. Generally its completely dedicated to MySQL, but it also has a number of IDX aggregator scripts that run throughout the day, some of which take up a considerable amount of resources to transform/normalize it. Instead of just giving MySQL everything (resource wise), I wanted to incrementally move up the caches and allocations until its using only what it needs to be at its best.


If there isn't an open source package, I was thinking a cronscript on the machine would work out, but wanted to see if I could save myself the time.

Source: http://community.livejournal.com/mysql/112479.html

Date: 04/03/07 (PHP Community)    Keywords: php, mysql, sql

I have two tables "Clients" and "ShippingAddresses" that I am trying to join to output two separate form dropdown boxes. Unfortunately I am only now beginning to use the Join command and so I'm running into issues, and could really use some assistance. Below the cut is my old code:

$grabClients = mysql_query("SELECT Client_ID, Client_Company FROM Clients ORDER BY Client_Company ASC") or die(mysql_error());
if (mysql_num_rows($grabClients) == 0) {
  $clientList = "";
  $shippingList = "";
} else {

  $clientList = "";
  $shippingList = "";


  while ($loopClients = mysql_fetch_array($grabClients)) {

    $grabShipping = mysql_query("SELECT Address_ID, Address_Company, Client_ID FROM ShippingAddresses WHERE Client_ID = '$loopClients[Client_ID]' ORDER BY Address_ID ASC") or die(mysql_error());
    if (mysql_num_rows($grabShipping) == 0) {
      $clientList .= "" . $loopClients['Client_Company'] . "";
    } else {

      $clientList .= "" . $loopClients['Client_Company'] . "";
      $shippingList .= "";
        
      while ($loopShipping = mysql_fetch_array($grabShipping)) {
        $shippingList .= "" . $loopShipping['Address_Company'] . "";
      }
    
      $shippingList .= "";
    }
  }
}

Source: http://community.livejournal.com/php/558380.html

Date: 04/05/07 (Web Development)    Keywords: php, mysql, database, sql

here is the site

So basically I am designing a database which lists a client_name, client_description, and then a list of images associated with that particular client. This is all stored in a MySQL database. I am not sure how to handle the images though. Each client will have around 6 images. I currently have it set up where every client has its own folder of images and the PHP just reads every image from that folder and displays it.

Would it be a better idea in terms of best practices to instead have an Images Table that keeps track of every image and what client it is associated with?

Not sure, Mike

Source: http://community.livejournal.com/webdev/400229.html

Date: 04/06/07 (MySQL Communtiy)    Keywords: mysql, sql

i need to merge rows in a table where column1 = column1 or column2 = column2 or column1 = column2. i'd like to review the data before i merge it. i'm having trouble constructing a query that returns what i need to see. if the table looked like this:

Source: http://community.livejournal.com/mysql/112800.html

Date: 04/08/07 (PHP Community)    Keywords: php, mysql, sql, web

I have a client that may need to have a text message interface with their website. What would type of system would we need to receive and send  text message in a format that I can work with in php/mysql etc

Source: http://community.livejournal.com/php/559576.html

Date: 04/13/07 (MySQL Communtiy)    Keywords: mysql, sql

Hello all,

I'm trying to delete a range of rows in MySQL and coming up broke.

On my command line, I'm doing the following:

mysql> delete from table where table.id in (11700)

Or

mysql> DELETE FROM `table` WHERE `table`.`id` = 11700;

That's great, but, I'll still have 10,000+ more rows to go, and both methods require me to delete rows one by one. I'd rather just delete a range of rows.

I want to only delete rows from 300-11800.Does anyone know how to delete a certain range of rows? Or just tell MySQL to delete a certain range of rows?

Thanks!

Source: http://community.livejournal.com/mysql/112993.html

Date: 04/17/07 (PHP Community)    Keywords: php, programming, mysql, software, browser, css, html, xml, technology, database, sql, java, jsp, web, linux, microsoft, apache

Moderator, if this isn't allowed on this forum just let me know.

I get a lot of emails daily for various web dev and programming positions available. I found a good job, but I keep my resume up. Ya never know.

Just feel guilty constantly deleting them when I know someone may need them. Figured I'd at least post them for any coder friends that may be looking for something. I lj-cut it so it wouldn't be too obtrusive.

If these are just found to be crap, let me know and I'll stop passing them on. But some of them at least appear to have potential. They're all fresh over the past 24 hours.

To whoever is currently looking, hope these help! If it's ok, I'll send periodic digests of these if anyone finds them worthwhile.


Hello,


I came across your resume and would to speak with you in regards to 2 immediate Cold Fusion needs in the Radford, VA areas.

Here are the details.


We need people onsite! 40 hour work week schedules

Location/Address: Radford, VA (Southwestern VA)

Start Date: ASAP

Drop Dead Start Date: ASAP

Project End date: N/A

# Of resources need for role: 1

Position Title: ColdFusion Software Engineer

BE Level/ Job classification: Consultant

Required Skill Set (Yrs Exp):


SKILLS: ColdFusion software developer with experience leading the development of software modules.

EXPERIENCE:
Proven experience analyzing system requirements, guiding overall application development and individual module development. Direct involvement in application development, maintenance and operations of an application environment involving Microsoft SQL Server back-end with Macromedia ColdFusion middleware running on Microsoft IIS webservers.

Specific education and experience requirements include:
1. Minimum 4-year technical degree in Computer Science, Information Technology, or related field from accredited institution
2. Minimum 1 year general programming experience and an additional 1 year experience in web-based application development
3. Minimum 1 year experience with design, development and maintenance of ColdFusion-based online software applications
4. Practical experience in MS SQL Server (v7 or higher) database design, operations, and maintenance involving extensive structured query language (SQL) usage and development of complex queries and procedures
5. Practical experience with MS SQL Server (v7 or higher) database administration
5. Must be a US Citizen
6. Prefer current active Department of Defense (or capable of attaining) Secret Clearance

Preferred Skill Set

Will also consider candidates with Java and JSP experience.



Job#2

Location/Address: Radford, VA (Southwestern VA)

Background of Project:

Start Date: ASAP

Drop Dead Start Date: ASAP

Project End date: N/A

# Of resources need for role: 1

Position Title: Web Page Designer

BE Level/ Job classification: Sr Systems Analyst

Required Skill Set (Yrs Exp):

The candidates we are seeking should be self starters, interested in seeking new ways to help this customer innovate and provide state of the art web design capabilities to DoD customers.

Technical & functional requirements:

- 1-2 years ColdFusion development experience using Version 6.0 or 7.0 (prefer 7.0)
- 1-2 years experience with Enterprise level database design including stored procedures and functions.
- working knowledge of the Fusebox design methodology, using version 3.0 or higher to develop robust web applications.
- proficient with use of Visual Mind software, version 7
- demonstrate ability to elicit requirement definitions from customers, then convert those specifications into realistic software development projects, and further develop a schedule in MS Project for task delegation and performance tracking.
- US Citizen

Preferred Skill Set

XHTML or similar browser based scripting development, web services development experience a plus.
- Cascading Style Sheet development using CSS v2.0 or later preferred.
- Microsoft SQL Server 2000 database design experience preferred.

Please forward me an updated word copy of your resume and give me a call.

Thanks!

Ray Santos | 1-800-627-8323 x9509 | rsantos@mastech.com Mastech | 1000 Commerce Drive Pittsburgh, PA 15275 | Ph:1.888.330.5497 x 9509

Fax: 412-291-3037


Mastech respects your privacy. We will not share your resume or contact details with any of our clients without your consent.

Source: http://community.livejournal.com/php/561562.html

Date: 04/25/07 (Apache)    Keywords: php, mysql, sql, apache

I'm running Apache 2.2 from wamp (so I have PHP5 and MySQL 5, though I don't think it has anything to do with them) on Windows XP. Anyway.

I can access everything fine using "localhost", and a friend told me that I could access my server by just using my computer's name. So I named my computer "nemo-serv" (all my electrical devices are named after characters from Finding Nemo, my laptop is Nemo,) and then could use nemo-serv fine, just like localhost.

Then I changed something, and I just get a "You don't have permission to access this directory" when using nemo-serv, though localhost is still fine. I really have no idea what I changed that could have done this, but I was hoping you guys would be able to point me in the right direction.

Thanks ^^

Source: http://community.livejournal.com/apache/36535.html

Date: 04/26/07 (Open Source)    Keywords: mysql, sql, microsoft

Is mySQL now a choice enterprises can place alongside Oracle, IBM DB2 and Microsoft SQL Server? Or does it still have a long way to go?

Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/112204538/

Date: 05/10/07 (MySQL Communtiy)    Keywords: php, mysql, software, database, sql, postgresql, web, linux

I am currently working on 2 great jobs for Linux-loving database folk.

1-MySQL and PHP software engineer in PA near Philly (NE). This is for a young software co founded by a guru who had already built another company. He wants hot programmers who will grow with the company. He currently is looking for a Sr person as well as 1-2 junior folk.

1- Linux DBA in Utah - a company with several websites and millions of pageviews and transactions/day. Needs both senior and junior database tuners to keep their PostgreSQL DBS running smoothly. Every millisecond counts. He will take people w/ MySQL and Linux admin and perl  background for the junior position. Full benefits, great work and flexible working conditions, and powder days!

My email is on my info page if you want to pass this on. Thanks!

Source: http://community.livejournal.com/mysql/113663.html

Date: 05/11/07 (Code WTF)    Keywords: mysql, sql

тут вот родные белоруские программеры такое пишут:

SELECT id AS SubSectionLink, content as brief
		FROM network
			WHERE ((title LIKE '%lamers%')
			OR (content LIKE '%lamers%')

			OR (title LIKE '%LAMERS%') 
			OR (content LIKE '%LAMERS%')

			OR (title LIKE '%LaMeRs%') 
			OR (content LIKE '%LaMeRs%')
	      )

Source: http://community.livejournal.com/code_wtf/85322.html

Date: 05/12/07 (Java Web)    Keywords: php, mysql, database, sql, postgresql, linux

Mantis is popular php based defect tracking application which works on top of RDBMS like MySQL and PostgreSQL. Recently I ported our Windows based Mantis installation to Linux. It used MySQL as backend. Here are the steps: 1. Export Mantis MySQL database from Windows, upload it on Linux and then import it to MySQL database on [...]

Source: http://blog.taragana.com/index.php/archive/how-to-migrate-mantis-defect-tracking-system-from-windows-to-linux-fedora-core-6/

Date: 05/14/07 (PHP Community)    Keywords: php, mysql, html, sql

At the end of a very long and tedious php/html/mysql job...

echo "\n\n\n\n\n";

I'm just glad it's over actually.

Source: http://community.livejournal.com/php/566489.html

Date: 05/28/07 (MySQL Communtiy)    Keywords: mysql, sql

Hello,
I'm a new mysql user. I had download the GUI mysqlcc (mysql control center) from source forge. I didn't find any user guide or reference book for this tool on the internet. Please, do you know if it is available anywhere?
Thank you in advance for yours answer.

Source: http://community.livejournal.com/mysql/113991.html

Date: 05/29/07 (Open Source)    Keywords: mysql, software, sql, linux, microsoft, apache

Writer Rodney Gedda at Computerworld writes that aQuantive, the online ad agency Microsoft is buying for $6 billion, is an open source play. The reason? Many aQuantive units, including AvenueA Razorfish and Atlas, make extensive use of open source software, including mySQL, Linux, and Apache. If you use open source, are you ...

Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/120506500/

Date: 05/30/07 (MySQL Communtiy)    Keywords: php, mysql, sql, web

Howdy. I have a MySQL 5.0.41 (community) installed on my home computer under win32. When phpMyAdmin starts, I get a 2003 (server is not responding) error.

Judging from what the console tells me (was checked via "sq query mysql"), MySQL service starts successfully (state: 4 RUNNING) and runs. Until the moment any site from localhost tries to connect to MySQL - after that the service crashes (with win32 exit code 1067).

Didn't find an answer on the web (didn't search thoroughly enough, perhaps). Can someone point me to a solution for this problem, or some further diagnostics?

Source: http://community.livejournal.com/mysql/114398.html