Sql statements in (search)

  • I dont know is this is the right forum for this kind of post, but i’ll try ??
    I’d like to show posts in loop but dont know how to create statements correctly. I’d like to intersect all those 3 sql statments:
    (*need this for POST search, each select statment represent input)

    SELECT p.* FROM $wpdb->posts p, $wpdb->postmeta m
WHERE p.post_type = 'post'
AND p.ID = m.post_id
AND m.meta_key = 'x1'
AND m.meta_value = 'x2'
AND (p.post_content LIKE '%$search%' OR p.post_title LIKE '%$search%')
    SELECT p.* FROM $wpdb->posts p, $wpdb->postmeta m
WHERE p.ID = m.post_id
AND m.meta_key = 'y1'
AND m.meta_value = 'y2'
    SELECT p.* FROM $wpdb->posts p, $wpdb->postmeta m
AND p.ID = m.post_id
AND m.meta_key = 'c1'
AND m.meta_value = 'c2'

    I really appreciate for any kind of tips/help.

Viewing 1 replies (of 1 total)
  • Thread Starter BPweba

    (@bpweba)

    AFter all i used ??

    SELECT DISTINCT p.* FROM $wpdb->posts p, $wpdb->postmeta m, $wpdb->posts p1, $wpdb->postmeta m1, $wpdb->posts p2, $wpdb->postmeta m2
	             WHERE p.post_type = 'post'
				 AND p.ID = m.post_id
				 AND m.meta_key = 'x1'
				 AND m.meta_value = 'x2'
				 AND m1.meta_key = 'y1'
				 AND m1.meta_value = 'y2'
				 AND m2.meta_key = 'c1'
				 AND m2.meta_value = 'c2'
				 AND (p.post_content LIKE '%$search%' OR p.post_title LIKE '%$search%')
				 ORDER BY p.post_date DESC
Viewing 1 replies (of 1 total)
  • The topic ‘Sql statements in (search)’ is closed to new replies.

Tags