Mon-Fri 9am-4pm EST
Visualize community
tm
Home
|
Details
|
Support
|
Demo:
User
/
Admin
|
Customer Galleries
|
Contact Us
|
Forums
|
Blog
|
Members Area
|
Buy PhotoPost
PhotoPost Community
>
PhotoPost Support
>
PhotoPost Pro Support Forums
>
Photopost Pro How Do I...?
Simple SQL query help
User Name
Remember Me?
Password
Register
FAQ
Social Groups
Calendar
Mark Forums Read
Photopost Pro How Do I...?
Wondering how to do things in PhotoPost?
LinkBack
Thread Tools
Rate Thread
Display Modes
July 3rd, 2009, 12:57 AM
#
1
(
permalink
)
pengrus
Senior Member
Verified Customer
Join Date: Dec 2002
Location: San Francisco
Posts: 595
Simple SQL query help
This code:
WHERE c.cattype = 'c' AND p.storecat = 0 AND c.password = '' AND p.cat = 4874
How can I change it so that it pulls photos from both p.cat 4874 and 6589?
Thanks,
Sean
July 3rd, 2009, 10:02 AM
#
2
(
permalink
)
Chuck S
Photopost Developer
Verified Customer
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 52,545
AND p.cat IN (4874,6589)
__________________
Photopost Developer and Support Engineer
Please do not PM me for support or sales questions. Thank you for your understanding.
July 3rd, 2009, 10:34 AM
#
3
(
permalink
)
pengrus
Senior Member
Verified Customer
Join Date: Dec 2002
Location: San Francisco
Posts: 595
Thanks so much, Chuck.
July 3rd, 2009, 04:31 PM
#
4
(
permalink
)
Chuck S
Photopost Developer
Verified Customer
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 52,545
Not a problem glad to help.
__________________
Photopost Developer and Support Engineer
Please do not PM me for support or sales questions. Thank you for your understanding.
«
can pp pro play youtube videos?
|
Watermark permanently
»
Currently Active Users Viewing This Thread: 1
(0 members and 1 guests)
Thread Tools
Show Printable Version
Email this Page
Display Modes
Rate This Thread
Linear Mode
Switch to Hybrid Mode
Switch to Threaded Mode
Rate This Thread
:
5 : Excellent
4 : Good
3 : Average
2 : Bad
1 : Terrible
Posting Rules
You
may not
post new threads
You
may not
post replies
You
may not
post attachments
You
may not
edit your posts
BB code
is
On
Smilies
are
On
[IMG]
code is
On
HTML code is
Off
Trackbacks
are
On
Pingbacks
are
On
Refbacks
are
On
Forum Rules
Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
sql query bug
ChefTalk
Photopost Pro Bug Reports
3
July 13th, 2008
11:20 AM
Since last visit SQL query
John_770
Photopost Pro How Do I...?
2
June 6th, 2007
07:23 AM
Extra sql line- Joining two sql statements
Telnoi
How Do I? - vBulletin 3.0.X
0
August 14th, 2005
09:49 AM
Problem with sql query in contact.php
h2ojunkie
Classifieds Bug Reports
2
February 26th, 2005
07:48 AM
All times are GMT -5. The time now is
12:27 AM
.
Contact Us
-
PhotoPost
-
Archive
-
Privacy Statement
-
Top
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by
vBSEO
3.2.0
All Enthusiast Sites:
ResellerRatings: Discount Shopping / Store Ratings
Dealighted: Shopping Coupons, Bargains, Deals
TechIMO.com: Tech Support and Discussion
HOME
| Copyright 2001-2009
ALL ENTHUSIAST, INC.
ALL RIGHTS RESERVED.
LinkBack
LinkBack URL
About LinkBacks
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
Linear Mode
