TalkPHP - Search Results

Account Login

Latest Articles

The basic usage of PHPTAL, a XML/XHTML template library for PHP

by awuehr on 11-10-2008 in Tips & Tricks

Vulnerable methods and the areas they are commonly trusted in.

by Village Idiot on 11-04-2008 in Classes & Objects

Simple way to protect a form from bot

by codefreek on 10-23-2008 in Basic

The Basics On: How Session Stealing Works

by wiifanatic on 09-12-2008 in Security & Permissions

How to keep your forms from double posting data

by drewbee on 07-03-2008 in Tips & Tricks

IRC Channel

Join the friendly bunch on IRC...
(#TalkPHP on Freenode)

...Also available via a web interface.

See this thread for information on the TalkPHP Free Hugs Initiative™. Subject to availability.

Associates

TalkPHP » Search Results

Showing results 1 to 7 of 7
Search took 0.02 seconds. Search: Posts Made By: Sand_Devil

Forum: MySQL & Databases

04-05-2008, 04:25 AM

Replies: 6

mysql query

Views: 1,449

Posted By Sand_Devil

If I understand what you are suggesting... word...

If I understand what you are suggesting... word being the entered string and blah_field being the database entry. || allows you to concatenate strings. To search for the % you need to place an...

Forum: MySQL & Databases

04-04-2008, 02:06 AM

Replies: 6

mysql query

Views: 1,449

Posted By Sand_Devil

% is a wild card. where blah_field like...

% is a wild card.

where blah_field like '%zoo'

Of course, if case is a problem, you can use

where upper(blah_field) like '%ZOO'

Forum: MySQL & Databases

12-01-2007, 11:16 PM

Replies: 16

5 Useful MySQL Functions And Control Flows

Views: 8,981

Posted By Sand_Devil

I have only been coding in mysql and php for the...

I have only been coding in mysql and php for the last year and a half. It was one of the first functions that I discovered (out of necessity).

Forum: MySQL & Databases

11-30-2007, 10:54 PM

Replies: 16

5 Useful MySQL Functions And Control Flows

Views: 8,981

Posted By Sand_Devil

I've always found COALESCE to be very useful. 6:...

I've always found COALESCE to be very useful.
6: COALESCE

Returns the first non null entry
SELECT COALESCE (column1, column2, '') from table

Result: if column1 not null, then returns column1, if...

Forum: Member Introductions

11-29-2007, 08:02 PM

Replies: 9

Howdy!

Views: 795

Posted By Sand_Devil

It wasn't my intention in joining, but I won't be...

It wasn't my intention in joining, but I won't be dumb enough to turn down free advertising.

Forum: Member Introductions

11-29-2007, 04:26 AM

Replies: 9

Howdy!

Views: 795

Posted By Sand_Devil

Well, hopefully obvious is the Miracle League of...

Well, hopefully obvious is the Miracle League of El Paso (http://miracleleagueofelpaso.org) which is little league baseball for children with special needs. It's my first major site and I'm in the...

Forum: Member Introductions

11-29-2007, 04:03 AM

Replies: 9

Howdy!

Views: 795

Posted By Sand_Devil

Hello from me too. I'm from El Paso, TX and do...

Hello from me too. I'm from El Paso, TX and do mostly charity websites.

I know enough PHP, HTML, javascript, and CSS to be barely functional and mostly dangerous.

As I scan the articles and these...

Showing results 1 to 7 of 7

All times are GMT. The time now is 09:41 PM.