Quick Question

[Mesk69]

I'm creating a news engine using a invision board.

I'm getting a problem that I'm not familiar with. I never used mysql before I'm use to PL/SQL.

This is the error I get:

SQL-query : [Edit]
SHOW FIELDS FROM `theguildwars_net`.`p` LIKE 'post'
MySQL said:
Table 'theguildwars_net.p' doesn't exist

This is my sql code:

SELECT t.tid,t.title,t.starter_id,t.starter_name,t.posts,t.forum_id,p.post_date,p.post,m.email
FROM ibf_topics t, ibf_posts p, ibf_members m
WHERE t.forum_id=8 AND p.topic_id=t.tid AND p.post_date=t.start_date and p.author_id = m.id and p.new_topic = 1
ORDER BY t.tid desc LIMIT 5

Thanks for taking the time to read and write

Mesk

 

[ideasworking]

Try using

SELECT fieldname from table where fieldname like '%post%';

 

[danielhozac]

It's not complaining about that SQL query. It's complaining about the [tt]SHOW FIELDS FROM `theguildwars_net`.`p` LIKE 'post'[/tt] query.

//Daniel