This works for me. Search result with a SQL condition:
[abase form="1,search" table="wp_routedb" columns="areaid,numtopo,name,gradenum,comment,in_10$Search dato" elements="areaid,numtopo,name,gradenum,comment,in_10"]
[abase table="wp_routedb" columns="areaid,numtopo,name,gradenum,comment,in_10" where="AND <code>gradenum</code>='7b+'" echo="0" ack="blue"]
< code > = `
form the forum replaces ` with < code >
Thank you very much for this solution.
I have modified the file abase.php:
$myWhere=” WHERE userId = “.get_current_user_id();
$sql_in .= $myWhere;
I will try your version for the problem.
Thanks a lot.
Radu.
Joseyaz
I tried your suggestion and got an error. I am using the Abase shortcode in the sidebar. Maybe I don’t understand the use of
I need to use a variable ($listing_id) as a search variable. in the code below hoaid= “$listing_id” –
[abase table= “wp_awpcp_ads” columns = “ad_title, hoaid” notitle=”1″ where= “AND hoaid = ‘$lisitng_id’ ” echo=”0″]
Also in the sidebar I am retrieving the listing id (from a current directory listing) with the following php, which works fine:
<?php
$id_or_slug = ”;
if ( get_query_var( ‘listing’ ) || isset( $_GET[‘listing’] ) )
$id_or_slug = get_query_var( ‘listing’ ) ? get_query_var( ‘listing’ ) : wpbdp_getv( $_GET, ‘listing’, 0 );
else
$id_or_slug = get_query_var( ‘id’ ) ? get_query_var( ‘id’ ) : wpbdp_getv( $_GET, ‘id’, 0 );
$listing_id = wpbdp_get_post_by_id_or_slug( $id_or_slug, ‘id’, ‘id’ );
$field = wpbdp_get_form_field( 13);
echo $field->display( $listing_id );
?>
<p> <?php echo $listing_id; ?> </p>
<?php echo post_permalink( $listing_id ); ?>
I have been unable to come up with a way to grab this $listing_id (which is also the value in the other database in field hoaid) and use in in my Where clause.
Thanks
ragordon
