SQL condition..

jassh

hi there friends..

hope you guys are in greatest of condition..

okay, 2 question for today is..
how do i have more than 1 condition in a SQL query..
do i use the 'AND' thingy??

for example..

$query = mysql_query("SELECT * FROM names WHERE first_name = 'Mike' AND first_name = 'Joe' ");

i tried that, but it doesnt seems to return any value..
even though theres a guy name "mike Shinoda"
and a guy name "joe Han"

is there something wrong with my query?

and here's another question on database..
how do i highlight the word in a chunk of text,
(or bold it) based on the text query..
i know if i have the following sentences..

"my dad is a secret agent man"
"i have a little secret"

and i use this query...

$query = mysql_query("SELECT * FROM notes WHERE first_name contents like 'secret' ");

so the result will bold the word secret in the result echoed

2 matches found
"my dad is a secret agent man"
"i have a little secret"

===

Secondly...
i am used to write my code using notepad..
sometimes.. my line of code is so long..
like a SQL query.. so i have to scroll vertically
if i try to press enter.. it usually doesnt work...
i think because PHP think that it is a new line...
is there any way i can do this efficiently..???

lastly..
this is about error checking..
is there anyway i can ask PHP
to detect which line my code is wrong..
ya know, sometimes i might forgot to put the ';' sign..etc
and i spent quite sometimes looking fer it..
normally, if my code has error.. `
it doesnt return anything.. a.k.a a blank screen...

by the way, other than dreamweaver..
any nice application used to write php code??
i'd love something as light and simple as notepad.exe
but perhaps.. with line numbering.. and maybe..
just maybe... syntax color coding...
know anything like that anybody??

anyway,
thanks fer yer time..
i wish yer all the best in todays work...

thanks in advanced..

-jassh

kinglouie

Hi!

Your query doesn't return any values because its contradictious - the firstname could be mike, could be joe but not both. So here only an OR would make sense, if you want all mikes and joes. But of course you could use something like

SELECT * FROM user WHERE first_name='Joe' AND sur_name='Sixpack'

Don't use NOTEPAD! I recommend CodeGenie or Textpad or Ultraedit as editors.

Best regards,

King Louie

Drakla

Hi Louie - which one of those code editors do you think is the best?

My favourite editor of all time is the dos version of Borland C++. I've currently setup Dreamweaver to do the same kind of blue background stuff, but on my 300a running that, MySQL and a few explorer windows I soon run out of 'resources'.

Do they support syntax highlighting, and the customisation of it. I've also got a big problem with Dreamweaver in that I can't change semicolons away from being black, and on a blue background it's a nightmare. Anyone know where to look, because I can't find it in the PHP colour picking bit.

Cheers.
D.

kinglouie

Hi Drakla,

I liked CodeGenie best for being simple but offering the stuff you need and some nice extras.
Textpad and Ultraedit are more powerful, but especially Ultraedit is a bit overloaded.
I cannot say how fine you can adjust the syntaxhighlighting - for me, with CodeGenie it was fine enough.
Best regards,

King Louie

jassh

hi there guys...

kinglouie my fren..
thanks for the guide...
i downloaded code genie..
it's free, no installation...
i love it..

i also tried textpad...
evaluation, since you have to pay for it..
a little heavy like MS Wordpad...
functionality quite the same with codegenie..
only that, it has this features
say if you have filename in your code,
you can right click it, and it opens it..
and there are a lot of other function to toy around..

but i guess i'll stick with code genie

anyway, regarding about my thread
anybody know how i can go about
on bold'ing my search text... thingy..
i'm still working on it...
hope someone can help me with this..

thanks in advanced..
and owh.. kinglouie,
thanks for the tip on the appz..
really appreciate it..

take care y'all

-jassh