Tiny problem

Joseph Grogan · #1 (**permalink**) 31-01-2008, 02:55 PM

Hi everyone.. Ok I have a db set up that two tables in it

One called nt_posts the other nt_category

Inside nt_posts i have

post_id
post_name
post_content
category_id

and in nt_category i have

category_id
category_name

Now i have a form set up and I can select a category name to input into the category_id of the nt_posts table and it works fine as i checked it in phpmyadmin and it enters the info properly.

Now here is the problem. I have a page that outputs all the posts and on the side are category links. So when I click on a category it will only display ones with that category_id. It works when the category_id=1 but not for any other bnumber.

Here is the php code i am using to select results from seperate tables as i want to be able to say what category they selected

PHP Code:

  $query = "SELECT * FROM nt_post, nt_category WHERE nt_post.category_id=$category_id = nt_category.category_id=$category_id";

It works fine if i only have it selecting from one table (the nt_posts table) but then i can display the name of the category.

Any one have any ideas

Forbairt · #2 (**permalink**) 31-01-2008, 03:04 PM

quick look .. didn't read your post fully but ... this should work I think

Code:

$query = "
  SELECT
    *
  FROM 
    nt_post, 
    nt_category 
  WHERE 
    nt_post.category_id=$category_id AND
    nt_category.category_id = nt_post.category_id
";

Joseph Grogan · #3 (**permalink**) 31-01-2008, 03:07 PM

That worked perfectly... Cheers James. You dont know how long i was looking at the and didnt even notice that

Forbairt · #4 (**permalink**) 31-01-2008, 03:09 PM

no problem ... I'm having a day of too many work emails and calls ... its doing my head in

I want to get back to some coding

Joseph Grogan · #5 (**permalink**) 31-01-2008, 03:12 PM

Its sort of good to have days like that cause it means you are getting work. Which is the main thing... is it not

Forbairt · #6 (**permalink**) 31-01-2008, 03:16 PM

thats one way of looking at it ...

Actually a good bit of support and proposals (I like to think they are decent ... thought the clients may disagree

)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Javascript No properties defined problem?	Ciarán Mc Cann	Coding Help	2	03-01-2008 05:29 PM
mySQL BLOB Problem	ziycon	Coding Help	3	17-11-2007 06:41 PM
PHP mySQL Problem!?	ziycon	Server / Technical Administration Tips and Queries	1	15-07-2007 08:31 PM
Making the second post in vbulletin topic an advert. Problem!	dude	Coding Help	3	04-04-2007 12:33 PM
Blog XML feed duble quotes problem	Redfly	Forum Feedback, Development and Competitions	3	30-11-2006 10:56 PM

Tiny problem

Tiny problem

Similar Threads