Jump to content

Archived

This topic is now archived and is closed to further replies.

rcharris

Simple query...

Recommended Posts

Hi all, apologies for the possible n00bness of this post, but I'm self taugh, and i've never done this query before

I have a query running at the moment which is

[quote]SELECT title, id, type, description, updated FROM portfolio WHERE type = \'Web Design and Build\' ORDER BY id DESC[/quote]

but what I want the query to do is, yes, still retrieve that type, but only rows with a type of Web Design and Build, and "Main Page"

Any ideas?

Muchly grateful in advance :),

rcharris

Share this post


Link to post
Share on other sites
[code]SELECT title, id, type, description, updated FROM portfolio WHERE type IN('Web Design and Build','Main Page') ORDER BY id DESC[/code]

Share this post


Link to post
Share on other sites
Hi there,

Seem to get a

[quote]
Parse error: parse error, unexpected T_STRING in \path\i\do\not\wanr\to\release\Web Design and Build.php on line 174[/quote] error and I cant see where!

Share this post


Link to post
Share on other sites
Probably a problem with mismatched ' and " quotes.  Better show us a dozen or so lines up to and including line 174  ...

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.