Date: 12/11/06 (MySQL Communtiy)    Keywords: database, web

[edit to add:] Problem solved - in the end I have merged the tables together so all the data is now in one table. Thank you everyone for your suggestions - it was just getting too complicated and dragging the search time down with the data split out.

Hi

I'm working on a project that has 600,000+ records and they have been divided up by state in the database (therefore there are 51 different tables - including DC) and I'm having a problem getting all of the data out of the tables when more than one table is selected.

My original select statement looks something like this:

-----

SELECT AZ_ID,AR_ID,AZ.BusinessName,AR.BusinessName,AZ.Address,AR.Address,AZ.City,AR.City,AZ.State,AR.State,
AZ.Zip,AR.Zip,AZ.Phone,AR.Phone,AZ.SalesVolume,AR.SalesVolume,AZ.ContactFirstLastTitle,AR.ContactFirstLastTitle
FROM AZ, AR WHERE AZ.SalesVolume = 'Less than $500,000' AND AZ.WebAddress IS NOT NULL
AND AR.SalesVolume = 'Less than $500,000' AND AR.WebAddress IS NOT NULL LIMIT 500

-----

I have tried doing joins but there are no common fields so it is returning the results of the last state selected.

Any assistance would be greatly appreciated as this has been stumping me for the past little while.

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

Date: 12/11/06 (Web Hosts)    Keywords: web

Hello everyone.

I am a small business owner and I recently got a dedicated server at ServerPronto.

I am new to this so I have two questions:

1) Does anyone else have a server there and if you do, what are your experiences with it?
2) Based on their site, how do you think they compares to other services?

Really looking forward to some input!

[X Posted in Webhost]

Thanks,
Christina

Source: http://community.livejournal.com/webhosts/37186.html

Date: 12/12/06 (WebDesign)    Keywords: software, web

I'm setting up a website for a local charity, and I have it in mind to set it up for people to make donations online (isn't that the point?). I've never done this, however, and I don't have any idea how to start. Are there any services (Paypal-esque perhaps) that are set up to handle this? Are there any software packages already written specifically for this purpose? What's involved in personally processing credit card donations, or would we be better off using a service as mentioned? I have no experience with this, either with making donations online or receiving them, or with any brand of e-commerce, so any advice at all would be appreciated.

Source: http://community.livejournal.com/webdesign/1195234.html

Date: 12/12/06 (Web Technology)    Keywords: web

Mozilla wants Web application developers and its own testing community to get their hands on Gran Paradiso Alpha 1.

Source: http://news.zdnet.com/2100-9588_22-6142960.html

Date: 12/13/06 (Computer Help)    Keywords: web

So I pretty much know nothing about computers other than how to go to websites and talk on AIM. So I thought I'd come ask the people who know best.

For the past few months when I try putting in a disc it doesn't automatically start. So I go to my computer and try to open it and it says there's no disc in there. I go to run and it still doesn't read the disc. hHw can I fix this?

I have an 'e machines' computer and Windows XP. I read all the information in the userinfo that I SHOULD state but I have no idea how to find out most of them. THANK YOU IN ADVANCE!

Source: http://community.livejournal.com/computer_help/722537.html

Date: 12/13/06 (Web Technology)    Keywords: web, yahoo, microsoft

Popularity of MySpace helps push Fox's lead over Yahoo among Web users in U.S. Microsoft in third place.

Source: http://news.zdnet.com/2100-9588_22-6143288.html

Date: 12/13/06 (Security)    Keywords: web

Former UBS PaineWebber worker sentenced to 8 years over scheme to make stock market profit from a corporate network attack.

Source: http://news.zdnet.com/2100-1009_22-6143563.html

Date: 12/14/06 (MySQL Communtiy)    Keywords: php, mysql, browser, html, sql, web

I realized I haven't told Livejournal about the MySQL Podcast that's been produced. The third episode has been published -- see http://www.technocation.org to subscribe or search for "mysql" or "oursql" on your favorite site to find podcasts, including itunes. Episode 0 and Episode 1 are still available.

Episode 2 is here! It's a bit late due to a computer crash and the fact that I sprained my ankle, but I think it's worth waiting for. Particularly since this week's feature is everyone's favorite -- performance tips!


It's best to subscribe to the podcast by clicking the "podcast" graphic at http://www.technocation.org , or searching for "mysql" in your favorite podcast directory (including iTunes). But if you want to play episode 2 in your browser, visit http://technocation.org/index.php?option=com_content&task=view&id=22&Itemid=29

Please consider promoting the show -- we have a 40 second promo ready for download at:

http://www.technocation.org/podcasts/oursql/OurSQLpromo1.mp3

Show Notes:
News

http://www.mysqlconf.com/

Free Survey, win a free pass

http://www.zoomerang.com/recipient/survey-intro.zgi?p=WEB225WZRG2XU7

You can now find this podcast, OurSQL, on many podcast sites including:


http://www.itunes.com

http://www.podcastalley.com

http://www.podfeed.net

http://www.podcastblaster.com


just search for "mysql" on any of those sites and you'll find the podcast. You can also find it at:


http://feeds.feedburner.com/oursql


Learning Resource

Promo

http://www.tech-in-sight.com/

Feature

Peter Zaitsev's blog post about count for InnoDB tables:
http://www.mysqlperformanceblog.com/2006/12/01/count-for-innodb-tables/

Acknowledgements/Sponsors

http://www.technocation.org

http://music.podshow.com

http://www.russellwolff.com

http://www.smallfishadventures.com/Home.html "The Thank you song" -- Smallfish




You can Direct download oursql podcasts at:
http://technocation.org/podcasts/oursql/

If you have any feedback about this podcast, or want to suggest topics to cover in future podcasts, please email

podcast@technocation.org

You can also:

Call the comment line at +1 617-674-2369

Or use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri

Or use the Technocation forums:
http://tinyurl.com/sc6qw

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

Date: 12/14/06 (Software)    Keywords: software, web, seo

Question: I visit several websites each day (SEO / Blogger) and all of them have a password. Most of them are saved.... but is there a tool /software /something that I can use so that when I want to change my password (it has to happen someday) that will enable me to put in the password once and it will change all of my passwords for me automatically?

using Foxfire

Source: http://community.livejournal.com/software/68210.html

Date: 12/14/06 (Computer Geeks)    Keywords: database, web, google

I run a photo studio. All artists in residence in the studio are working on the same project this year. We have almost a hundred models in our book, and need to find a way to share a calendar so that we can all put down when we're available, not available, have shoots scheduled, and the like. We also need to have an online database for all of our models where we can all see the models' information, write notes, share images, and the like.

In short, we need an online collaboration system.

We've looked at Google Web Apps, and that has nice shared email and a decent calendar, but nothing even close to a shared online database for our models.

Anyone have any suggestions? Free or pay, either is fine. I'm perfectly cool paying for something that works.

Source: http://community.livejournal.com/computergeeks/1010676.html

Date: 12/14/06 (Open Source)    Keywords: web

Web pages already have substantial trademark and copyright protection. Why should patent protections be added?

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

Date: 12/14/06 (Javascript Community)    Keywords: asp, web

@ my work i have started placing messages on accounts in which mail has bounced back. so a typical message would look like:


NEEDS ADDRESS AND ID: 1234 BromhanWay, UT 8116 was returned undeliverable 11-21-2006. The envelope was marked as "No Such Number".

The problem is, I don't want to have to type this message out every time and editing, copying and pasting is cumbersome and has the potential to give mistakes back to me.

So, what I would like to do is have a simply box fill in for various field and then have it post back immediately on the same webpage the results.

ie.

NEEDS ADDRESS AND ID: was returned undeliverable . The envelope was marked as .

Then you would enter the data in the boxes and click

The page would then put all the data in a box below for easy copy/paste access:

NEEDS ADDRESS AND ID: 1234 BromhanWay, UT 8116 was returned undeliverable 11-21-2006. The envelope was marked as "No Such Number".

This is the only resource I have found thus far on it:
http://www.formlogix.com/Help/Faq/DataManagement.aspx#Faq14


any suggestions?

Source: http://community.livejournal.com/javascript/119590.html

Date: 12/15/06 (Computer Help)    Keywords: software, virus, web, spyware

Ok. In the bottom right corner of the screen there's a flashing icon next to the date that is either an exclamation mark in a yellow triangle or switches to a bomb(ball with spikes). I can't right click to try to bring up a roll window to click exit because like a left click it sends me to this friggin website virusbusters.com. I don't have their software, never downloaded it. I cleaned my internet history, cookies, saved text, etc etc. I've also run Mcafee virus scan, spy hunter spyware scanner, and spybot scanner. None of them can pick this up and I don't know where to look for whatever's causing it on my computer beyond add/remove programs and searching my hard drive with *virusbuster*.

Any suggestions? : /

Source: http://community.livejournal.com/computer_help/724383.html

Date: 12/15/06 (PHP Community)    Keywords: php, web, spam

Does anyone know how to do a php code for an form that is e-mailed to you and has a word verification, so that you don't get that much spam from your form?
I have the basic form on my web site right now, www.cardeologist.com on my contact page. But, I have started to get some bots filling in the form and spamming it. Is there another way to stop this or a code to make you enter a word/phrase before it can be submitted?

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

Date: 12/15/06 (WebDesign)    Keywords: php, mysql, sql, web

So I'm reading a tutorial on creating polls using MySQL and PHP, and this is the php side of it.

Is it me, or is this extremely bad to put on a webpage, what with it requiring a usename and password? Am I just not reading it properly?

$host = 'localhost';
$user = 'user';
$pass = 'pass';
$db = 'polls';
print "\n";
print "\n";
print "\n";
print "\n";
print "\n";
print "

\n";
print "

Which of these activities do you most enjoy?

\n";
$dbcon = mysql_connect($host, $user, $pass)
or die('Unable to connect to server ' . $host);
mysql_select_db($db) or die('Unable to find database ' . $db);
$form_query = 'SELECT * FROM poll_answers';
if($result = mysql_query($form_query)) {
while($row = mysql_fetch_array($result)) {
print "". $row['activity'] . "
\n";
}
}
print "\n";
print "

\n";
print "

See vote totals

\n"
;
print "\n";
print "\n";
?>

Source: http://community.livejournal.com/webdesign/1195771.html

Date: 12/16/06 (Security)    Keywords: web

In some cases the antiphishing feature that protects against fraudulent Web sites in Internet Explorer 7 bogged down Windows PCs.

Source: http://news.zdnet.com/2100-1009_22-6144342.html

Date: 12/16/06 (Computer Help)    Keywords: security, web, yahoo

At first I thought it was just LJ, now I have no idea what the problem is, and it's driving me freaking crazy! I don't think I've ever been so freaking frustrated in my entire LIFE.

The first day that I got a livejournal, I changed my viewing options to dystopia, I had the website remember my password. I went to get onto livejournal today, and my password is no longer saved. I went to log in, and clicked "remember me" but it will NOT log me in if the box is checked. If I type in a random username to bring me to the other login screen, it tells me my password security secure, and I want standard. But when I click standard it doesn't remember it. I log in, ask it to remember me, do whatever, I have to go into the management, change my viewing options to what I want them to be, I'm done, I close the window. I come back, and I have to do the same thing OVER, and OVER and OVER again. It won't even remember my VIEWING OPTIONS, for God's sake! I just went to check my Yahoo! mail, and is what it looks like. WHAT IS THE ISSUE? HOW CAN I FIX THIS? I am going completely bonkers, and I'm on the verge of punching a hole in my wall. Obviously my temper isn't the greatest, but this is the most irritating thing EVER.

Thanks for any help.

Source: http://community.livejournal.com/computer_help/724604.html

Date: 12/16/06 (PHP Community)    Keywords: php, software, database, web, apache

Was playing with the idea of regEx'ing out the domain of an email address and then doing a gethostbyname() to verify that the email address is valid. I know in some cases this won't work, but was curious if anyone has ever tried something similar. Just trying to come up with more validation measures to protect my employeer and their customers from malicious users.


As for Rails VS. PHP

Rail cons
I am on the final stage of deploying a website built in rails and it's been a fun/frustrating learning experience because I've had to build it with a legacy schema that was mangled along the same lines as scope creep (non-standard keys, non-uniform structure (integer keys here, varchar keys there, variables inside join tables, and a lot of orphaned tables forcing the client software to do what the database should be doing [out of query joins or excessive join tables]). For the most part there is a lot of good things about Rails but it's not an end all, be all tool like some people make it out to be. Multi-page/multi-object (ex. user data mixed w/ purchase data) forms are difficult, breaking the rails way of data validation. Debugging has some nice benefits, but is poorly documented and so far I have not found a Rails equivalent to DBG symbolic debugging.... the best appears to be a rails inline assert/breakpoint object that halts the entire system to allow you a glimpse of the system state at that moment but not the ability to step in/out/over.
Lastly there is no mod_perl or mod_php like Apache component so getting Rails on a current server implementation is somewhere between entertaining to unbelievably frustrating. Further more, though rails has a couple different natively supporting webservers (light, webbrick, mongrel) they aren't as well tested or as versatile as Apache. And lastly there is little to no documentation or guidelines, so if you got to do something out of the ordinary, life gets interesting.

Rails pro's
On the plus side, Rails is rich in features, its easier to write C binary packages then PHP, the ActiveRecord & ActiveMailer packages are extremely versatile and thanks to standard Obj. Oriented mantra's, base/parent methods can be supplemented or completely overridden. Otherwise it's a great rapid development platform and practically promotes itself to being used in series with another scripting language if Apache 2.0's mod_proxy or similar httpd proxy service is used. `httdoc/{rails sub-dir/ &| php sub-dir/ & /static content dir}` Prototype and Scriptalicious (spelling) being embedded and wrapped by Rails helpers make Ajax/Web 2.0 stuff a breeze as well. So if you got a simple project on queue and the time to burn stumbling through Rails, I'd recommended checking it out to see if it can compliment and augment your portfolio. Just be prepared to earn your paycheck for the first couple projects. So for speed and minor enhancements to static content, PHP dominates while for complicated, Ajax heavy applications, Rails feels like a good choice.

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

Date: 12/18/06 (Open Source)    Keywords: mysql, database, sql, web

Small companies face a Hobson's Choice as they grow. They may start with mySQL, a solid, simple database, but they wonder whether it will scale as they grow. Given the penchant of Web companies to grow exponentially if they turn out to be winners, this is a question that is occuring earlier-and-earlier in these companies' lives.

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

Date: 12/19/06 (Web Development)    Keywords: technology, web

Hey guys,

I thought this post could be about exchanging up-to-date resources for cutting edge, well-written information about web technology. I don't know if you are aware of this, but most of the information on the web is utter crap! I hope to think most important part of our job is not only creating new technology but also locating the most informative resources out there about new uses of technology and sharing them with other. Well, most of the stuff I discover through Digg and Slashdot are fantastic, but most of them are overhyped and then they never stick around with the users (like us) after the initial excitement wears off. Do you realize how time consuming those sites can be? They hook you up to the latest fad and leave you high and dry and wanting for more! Maybe we can reduce the digging and start the sharing with a sober mind.

To get the ball rolling, I will put forward 24 Ways, whose motto--impress your friends--is aptly chosen. Before discovering it a couple of days ago, I never realized the stuff I read was crappy and out of date. I subscribed to it to its feed at once! And I have read every single article they published.

So, it's your turn. Where do you get your amazing info?

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