iamcal.com Since May 2000

• Happy new year!
• Newbie topic - May 2016
• Newbie topic - April 2016
• Newbie topic - March 2016
• Newbie topic - February 2016
• Newbie topic - January 2016
• Newbie topic - November 2015
• Newbie topic - August 2015
• Newbie topic - July 2015
• Newbie topic - May 2015
• Newbie topic - April 2015
• Newbie topic - March 2015
• Newbie topic - September 2014
• Newbie topic - December 2014
• Newbie topic - October 2014
• Newbie topic - August 2014
• Newbie topic - July 2014
• Newbie topic - June 2014
• Newbie topic - May 2014
• Hello!

Right.

$result = mysql_query( "SELECT * FROM tblinfo WHERE strArticle='$search'" );

Gets all the rows from my database where strArticle = $search.

So why doesn't:

$result = mysql_query( "SELECT * FROM tblinfo WHERE strArticle=*.'$search'.*" );

return all the rows that include the $search string? How do I put a wildcard character into that? I have tried everything I can think of and nothing works =[

Or am I going about it the wrong way? Is there an 'includes' rather than 'equals' operator?

you know computers

Not well enough, unfortunatly...

You are close but you need LIKE '%$search%' see:

www.mysql.com/doc/en/String_comparison_f...

This might also be of interest:

www.mysql.com/doc/en/Fulltext_Search.htm...

Cheers.

The full text search suggest that:

$result = mysql_query( "SELECT * FROM tblinfo WHERE MATCH strArticle AGAINST ('$search')" );

should do the trick, but it doesn't =[

I've not used MATCH AGAINST before (I stumbled across it while looking for the manual page on LIKE) but I will certainly be looking at it in the future ;) Good luck with it and let us know how it goes.

I should also correct myself a little as you need quotes here:

LIKE "%$search%"

Jusr reading through the fulltext search entry it can only be used on certain field types and you need to either run FULLTEXT when you CREATE the table or you need to ALTER an existing one. Check both those as they could cause you problems.

Hopefully the LIKE solution should be sufficient for your needs ;)

For those interested, here is that solution in full:

$result = mysql_query( "SELECT * FROM tblinfo WHERE strArticle LIKE '%$search%'" );

Thanks, Emperor.

Who are you, by the way?

Just your friendly neighbourhood spiderman

Me or ilovebeerme?

He is your friendly neighbourhood spiderman or so I hear (and is a close friend of iluvsmerkingtabsme?).

if you're using phpMyAdmin then making FULLTEXT indexes is pretty easy

You, Emp - This is the first time you've posted, or so I belive...

Yes it is - I was passing through and having a nose around and spotted your post so called in ;)

I'm from the OzoneAsylum/Gurus Network where I know DarkGarden/Peter (I'm not sure what name he goes by here) and stuff (I'm not too hot on talking about me ;) ).

I have been looking at Puse and other things - I scooped up a few links and added them to a links database we are working and created a iamcal node too:

development.gurusnetwork.com/links/373/d...

which is nice.

peter is peter here, but hasn't posted since 4th March 2002

He is slack ;) He has been pretty quiet at the Asylum too.

We were discussing you (cal) on ICQ (all good stuff of course) and so (although I've passed through your site rooting out information on various things) I thought it was time to have a rummage around here and a peer into all the corners and such like.

As an aisde I also dropped this into an FAQ here:

faq.ozoneasylum.com/991/

and so any further information that arises on this will be dropped in there 9at the moment it pretty much says the same as my reply ;) ).

a useful resource :)

as are the mysql (www.mysql.com) and php (uk.php.net) manuals

Welcome Emperor.

welcome emprah - quite a suprise to see you here.

...yet it is no suprise that from the very first post, you're being useful.

:o)

are you an ozones person reitsma?

Novemeber: ~waves~

cal: Thanks - the FAQ is a Wiki so all registered inmates can add and edit entries (its an interesting project). Gotta love the manuals :)

reitsma: Nice to see a familiar face :D I always believe i hitting the ground running. And cal he isn't just an ozones person he is at least 3 (having been bunchapixels and thirdperson in the past) ;)

Hail Emperor!

oooo I found an interesting t-shirt that you guys and gals might enjoy....

www.thinkgeek.com/tshirts/coder/595d/

I chuckled at that when I saw it, my Information Systems and Database Design lecturer however didn't after seeing the results of our in-class test the other day......oh dear =D


-Greg-

If you are bored then the GrimForum is coming along nicely - maybe you'd like to take a look:
www.hsmx.com/grimforum/

Peter probably went elsewhere after he saw how mean Cal was to Suzie...

www.iamcal.com/topic.php?id=1123#post707...

part of a fun ongoing series of arguments between me and our ex-chat-host :/

cal - emperor speaks the truth.

the id's that i had there were:

bunchapixels (my first identity)
bunchapissedoffpixels (when i had to flame someone)
thirdperson (alterego, when i was sick of buncha)

...and finally:
reitsma (the one i use all the time now.)

that was where i met peter, was introduced to pixelflo, heard about you, met stephen, went to miscminutiae, and clicked from there to iamcal.com

...and that's my story.

ahh. that must have been quite a while ago now - you've been around here for quite a while...

yes yes, i have.

I believe Peter is doing fun things in the real world - big place somewhere 'out there' (but not where the truth is). I told him I was taking his name in vain (pos. vein ;) ) and he seemed fine with that - which is disappointing.

Grim: interesting are you coding that from the grond up - big effort but pos. worth it in the end.

carbonite: Love the T-shirts there are some days..........