Check Database For Email Address (no Duplicates)

Hi,

I have a sign up form that checks the database for username to see if it is taken. If it is there is a display from my english.php file saying that the username is already taken.

I’d like a similar function from above on the same form to check for an email address to see if it is already in the database. If the email address exists I need to display “email address already in use.” from my english.php file.

My problem is that if there is duplicate email addresses in the database it creates a bug in the script.

http://www.edmontonmusic.ca/musicians/join.php

Thank you!

Post Messages To Forums

I require someone to go post 1000 responses to over 100 forums.

I will require a excel spread sheet of links to every response you did, so i can check it.

For eg.
You go to canadianmoneyforum.com you find someone who is looking to invest, and you reply to him with our response.

1. I will give you the forums
2. I will give you the response

All you need to do is, make an account at the forum, and then click copy paste, submit, and move on.

Grabbing Search Results From Sitemeter.com

sitemeter.com is an online counter for websites.

i want a php script that can grab “google search phrases/keywords” from sitemeter.com referrals.

Example sitemeter.com referral link:
http://www.sitemeter.com/?a=stats&s=s15gizmodo&r=11

The script will look “Recent Visitors by Referrals” section on the given sitemeter.com url and will find google referring url’s and grab the google keywords/phrases. The script will record the keywords/phrases to the mysql db.

example referral url : http://www.sitemeter.com/?a=stats&s=s15gizmodo&r=11&v=1

There should be 2 columns on mysql db.
Keywords and Count.
Keyword columns will store keywords/phrases and count column wil store the count of that keyword’s.

For example, our keyword is “latest iphone apps” and sitemeter referral has 24 “latest iphone apps” phrases.

Keywords column will store “latest iphone apps”
Count column will store “24”

it is easy job.

Code Custom WordPress Page

I have a simple wordpress custom page that I need coded.

I have the PSD file so it just needs to be converted to CSS and have a little WordPress coded added to it (display 5 most recent posts from a category). The ‘module’ images are buttons (1 for each module – 8 total).

I’ve attached an image of what the PSD image that needs to be converted looks like.

Use the code word ‘wp fast’ in your bid/PMB to ensure that you have read, understand, and can complete the job in a couple hours.

I need this completed within 48 hours.

Data Verification

I have a list of 50,000 Business Names Physical address and Phone Numbers that need to be verified correct. I also need email address for the locations to be obtained. All locations are based in the US & Canada.

I need this information verified to be correct. Needs to be done with in 7days, no exceptions. File is on CVS format

Thank you

New Mini DisplayPort video adapters from StarTech

All of Apple’s new offerings in the Mac line use Mini DisplayPort to pump video out to other monitors or video displays. Whether it’s an 11″ MacBook Air, a fully-loaded Mac Pro (with two Mini DisplayPort outputs), or any of the machines in between, Apple has standardized on Mini DisplayPort for video output.

To connect to different types of displays, Apple also sells a number of video adapters through Apple retail stores and the online store. There are Apple-branded adapter cables for VGA, DVI, and Dual-link DVI, as well as a Moshi HDMI adapter. Now a new source of these adapters has hit the market.

StarTech is a maker of parts, adapters, KVM switches and the like, and it apparently saw a big potential market for these cables due to Apple’s standardization. StarTech has just announced a Mini DisplayPort to HDMI adapter (US$21.99), a Mini DisplayPort to DVI adapter ($21.99), and a Mini DisplayPort to VGA adapter ($33.99).

The pricing is great on the HDMI and DVI adapters; the HDMI adapter is a full $13 less than the Moshi HDMI adapter, while the DVI adapter is about $8 cheaper. The VGA adapter is about $5 more expensive than the Apple equivalent. If you need to connect your Mac to another video display, it’s good to know that you have another alternative for the necessary cables.

New Mini DisplayPort video adapters from StarTech originally appeared on TUAW on Sat, 20 Nov 2010 12:00:00 EST. Please see our terms for use of feeds.

Source | Permalink | Email this | Comments

LEGO Harry Potter available for iOS, but iPad requires 4.2

LEGO HARRY POTTERWarner Bros. has released the game LEGO Harry Potter: Years 1-4, and it’s available as a universal download from the App Store for US$4.99. Gameplay includes going inside Hogwarts castle, the most detailed LEGO game location ever; the game provides 40+ levels of play along with endless freeplay to discover areas not accessible in Story Mode.

Players can play as any one of over 100 characters including Harry Potter himself, and can cast spells, mix potions, or fly on broomsticks throughout the game. Mike Rose has played both the Wii and iOS versions of HPY1-4, and he notes that the iOS take is more isometric and ‘LEGO-like’ than the 3D action of the Wii version. The iOS game presents specific tasks/quests that have to be performed and puzzles to be solved before you can advance Harry and his cohorts to the next scene of the game.

Potential buyers should note that while the game is ready for the iPhone 3GS, iPhone 4, and iPod touch (3rd and 4th generation) running iOS 4.1 or later, iPad owners will have to wait until they are running iOS 4.2 to play and sync their devices. This is clearly noted in the app description, but it hasn’t stopped some overeager buyers from giving the app one-star reviews because they didn’t notice the caveat beforehand. Maybe while they are waiting for iOS 4.2 to drop they can check out some LEGO guys unboxing an iPad to pass the time.

With Harry Potter popularity at a fever pitch right now due to the first-half film version release of Harry Potter and the Deathly Hallows, LEGO Harry Potter might have more than a few fans looking for a good game to download. I myself am looking forward to spending time digging through all the different worlds in the game, especially with a three-day train trip coming up. This should occupy some of that time, for sure.

LEGO Harry Potter available for iOS, but iPad requires 4.2 originally appeared on TUAW on Sat, 20 Nov 2010 11:00:00 EST. Please see our terms for use of feeds.

Source | Permalink | Email this | Comments

Apple updates iTunes Connect Mobile for iPad

Apple has updated the iTunes Connect Mobile app to version 1.1. The app was first released in June of this year and allowed developers to view statistics about their products on the App Store right from their iPhone or iPod touch. Today’s update brings universal support for all iOS devices, including the iPad. It also adds support for multitasking in iOS 4 and adds support for iBookstore providers.

With today’s universal update to iTunes Connect Mobile, Apple has updated most of its iOS apps to take advantage of the iPad’s larger screen. The other remaining holdouts are iMovie, Keynote Remote, Apple Store, and Texas Hold’em.

Apple updates iTunes Connect Mobile for iPad originally appeared on TUAW on Sat, 20 Nov 2010 10:00:00 EST. Please see our terms for use of feeds.

Source | Permalink | Email this | Comments

Count The Beats: A closer look at Amplitube 2.0 for iOS

A few weeks ago, IK Multimedia released Amplitube 2.0, the next iteration of its guitar effects and amplifier emulator app for iOS (don’t forget, you need the external iRig piece of kit, too). It’s only been about 5 months since version 1.0 came out, but when we got word that version 2.0 was in the works, we got pretty excited.

Update 2.0 brings 5 new stomp boxes (additional in-app purchase required), a promise of improved sound quality, a 4-track recorder and master FX section with 3 effects (in-app purchase), the SpeedTrainer as well as the ability to import songs from your iPod library, and a few other tidbits, too.

The nice thing is, you can download a free version of 2.0, like version 1.0. That means you get the improved sound quality, SpeedTrainer, and the ability to import your songs from your iPod library at no extra cost. However, the bulk of the new additions in 2.0 are only available through in-app purchase. The question is, are they worth it?

Click the “Read More” link below to find out.

Continue reading Count The Beats: A closer look at Amplitube 2.0 for iOS

Count The Beats: A closer look at Amplitube 2.0 for iOS originally appeared on TUAW on Sat, 20 Nov 2010 09:00:00 EST. Please see our terms for use of feeds.

Source | Permalink | Email this | Comments

Interview With Bruno Borges

Bruno Borges has an extremely unique look to all of his illustrations; his portfolio is a barrage of color, retro imagery and a multitude of cool collages. This style comes from Bruno’s simplistic approach to design that we discuss in our interview, Bruno also gives some advice and insight into his art so please take a moment to review some of Bruno’s excellent work and insights.


Q Welcome to Psdtuts+, please introduce yourself. Could you tell us where you’re from and how you got started in the field?

Hi, my name is Bruno, graphic designer and illustrator based in São Paulo, Brazil. I started doing Graphic Design in 2003.


Q Most of your illustrations contain a lot of retro imagery that you blend with your own style of colorful shapes and patterns, what exactly led you to create and stick with this specific style of design?

My collage work is really soaked by that retro imagery. It’s only because I like the way it can be revisited, reviewed and then matched to some current elements. I try and tell a whole new history. This kind of approach may stand out from the other stuff you’ll see in my work, but I don’t really stick to a specific style.


Q How does Photoshop factor into your design process? Do you do all of your work in it? And how important of a program is it to you?

It’s an amazing tool. Most designers use it at some point in their workflow but it shouldn’t be the only tool that you use.


Q You also seem to focus a lot on typographic illustrations, is there a difference in the way you approach a typographic piece apposed to a regular illustration? And if so, then why?

Typography has the power of delivering a complete message: verbal and visual. I love this possibility, when a message can hit you right in your face before you can react, or just pick you up from the ground, throw you into outer space and let you think about it. So, this kind of effectiveness affects the way you choose what is going to be said. I think that’s the difference.


Q “Mensageiro Do Vento” is a very creative and unique tribal esque illustration you created. Please tell us a little about the creation of the piece and a little history behind it if it has any.

The intention with that one was to make a mystical composition, but using familiar elements, South American ones. So it somehow looks like those hippie wind chimes that we hang on our verandas, but made out of feathers, a parrot’s eye in the center, a Brazilian landscape, quartz crystals, leaves, branches. And a native above everything acting as the sentry of it all. I know, sounds too stoned but I love that one.


Q What was the most important lesson you have learned since you started designing that might help the newer designers.

Try to have fun even when the job is annoying.


Q Where do you plan to take your designing career in the future? And what do you hope to accomplish in the next couple of years?

Just keep on learning everyday.


Q Thanks again for providing Psdtuts+ with this opportunity to interview you. Any final thoughts for our readers?

Thank you : )

SE


Where to find Bruno on the Web

Read More