db query problem

martian2k4

hi i'm building a site for some one and at the moment and am building a tutorial section. I've got it displaying the title and the short description in a table and there''s a button and when it's clicked it posts the title of the tutorial they clicked on through to the next page where i have another query
[PHP]mysql_query("SELECT * FROM tuts WHERE title LIKE '$title'");[/PHP]
this works fine but if there is two titles in the database that are along the same lines as each other it will display them both.

How do i change it from getting rows that are like the title that was sent to the page into the title that was sent to the page. I was thinking it might be somthing like WHERE title = '$title' or sommat like that but i'm not sure ... can any one help

daboss

You're on the right track. If you want an exact match use "=".

The "Like" operator simply return everything that is similar to the parameter provided.

E.g.
= "hello" returns only records that matches "hello" exactly
like 'he' returns, everything that matches - e.g. hello, her, head, etc. etc. etc.

martian2k4

thanx a lot that was a great help

OHHH THIS IS MY 100th POST WOOOHHOOOO lol just thought i would mention

pfgannon

Off topic:

It seems that we have been getting alot more programming savvy people here mainly php/SQl

Edit: Would anyone like to take on a big project?

martian2k4

what sorta big project

pfgannon

The gaming site i am working on is in need of a CMS..we are waiting for CMS that is in development and is pretty cheap...$60 USD ( www.acornadmin.com )

Do you think you could take on a big project like this?


We are also looking for another admin if you are interested

martian2k4

sure i could do it for you. PM me with further details

daboss

4tone87 - i'm interested. i'll be doing it for free as a hobby - so i will not be able to commit to deadlines just post what your project is about...