[wp-hackers] Custom search, how ?

[Frédéric Trudeau]

Use the class $wpdb, and build the query yourself.
See http://codex.wordpress.org/Function_Reference/wpdb_Class

--
.     .     .     .     .     .     .     .     . .     . .     . 
.     . .     .
.     .     .     .     .     .     .     .     . .     . .     . 
.     . .     .

*Frédéric Trudeau**
Prospek | Stratégie d'affaires internet*
Directeur technique
ftrudeau at prospek.ca <mailto:christian at prospek.ca>
+1 514 931-4000 #236*
prospek.ca <http://prospek.ca/>*

.     .     .     .     .     .     .     .     . .     . .     . 
.     . .     .
.     .     .     .     .     .     .     .     . .     . .     . 
.     . .     .

On 2010-08-18 08:19, Lox wrote:
>> You should join using the post ID directly.
>>
> I can't actually because, the separated table is "read only" for me. It is a
> separated excel database regularly dumped into mysql.
>
> 2010/8/18 Lox<lox.dev at knc.nc>
>
>> Thanks figured it myself. It works with WP_Query, I call it with a custom
>> query var that I can check for in posts_join (is the way to do?)
>>
>> How can I JOIN with a custom table ON a custom meta field ?
>
> I have found the thing and I have done some progress:
>
> I have a custom post-type "training" and a custom table "wp_training_infos".
> For each training post type, I have a drop down box to select the matching
> record in the "wp_training_infos" table. (I have no other way to link them
> other than manually).
> So each post_type object (like the one returned by get_post() ) is now
> extended with the matching data from wp_training_infos. (I use posts_join
> and posts_where when post_type matches "training")
>
> Doing so, it is ok, I can do:
>
> $wp_query('post_type=training&field_from_wp_training_info=value)
> Witch is nice. But, now, I need to select training posts for an other meta,
> withc would be:
>
> $wp_query('post_type=training&field_from_wp_training_info=value&meta_key=my_meta&meta_value=the_value)
>
>
> Witch fails because I already use a meta to join with my custom table.....
>
> (1) here is my code http://paste2.org/p/954990
>