WordPress.org

Ready to get started?Download WordPress

Forums

Trouble with a custom query on a page (4 posts)

  1. arcanerei
    Member
    Posted 3 years ago #

    Hello,
    I am having trouble printing out data from a custom wordpress table. When I attempt to print out the results of a query all that is returned is a string with the word "Array".

    Info as follows:

    Table Name: wp_mbv_property
    Relevant Fields Names: property_id (PK), property_address
    Page: Using shortcode to call the function that this code here is within.

    Plugin code:

    $mbv_table_property = $wpdb->prefix."mbv_property";
    
    	$mbv_query = "
    	SELECT property_address
    	FROM $wpdb->prefix.mbv_property
    	WHERE property_id = '1'
    	";
    
    	$mbv_test = $wpdb->get_col($mbv_query,1);
    	printf('<pre>//'.print_r( $mbv_test ).'\\</pre>');

    I have tried this also it with:

    $mbv_test = $wpdb->get_results($mbv_query,OBJECT);

    In both instances all that is returned to my page is the word Array.

    There is only 1 property address with an ID of 1, so what am I missing?

    I have also tried this to no avail either:

    $mbv_properties = $wpdb->get_results($mbv_query, ARRAY_A);
    	$mbv_counter = 1;
    
    	foreach ($mbv_properties as &$value) {
    		printf($value.'  |  ');
    		$mbv_counter = $mbv_counter++;
    		printf('counter value: '.$mbv_counter.' ');
    		if ($mbv_counter == 10) {
    			printf('<br>');
    		}
    	}

    I feel like there is something stupid that I am missing but I can't seem to figure out what....

    All I need it to do is to print out the property address....

    Any help would be greatly appreciated, I have been beating my head on this for way to long.

    Thanks!
    -Bob

  2. stvwlf
    Member
    Posted 3 years ago #

    Since you are after one column from one row, you can use "Select a Variable"
    http://codex.wordpress.org/Function_Reference/wpdb_Class#SELECT_a_Variable

    which returns a single value, not an array. Included is an example of how to echo the returned value.

  3. arcanerei
    Member
    Posted 3 years ago #

    Stvwlf,
    My example data right now contains only 1 address. How eventually I will need to be able to display multiple addresses (in blocks of 10 which is what the last block of code was attempting to do).

    I will take a look at what you posted though to see if I can retro fit it and least get 1 variable to print out.

    Thanks!
    -Bob

  4. arcanerei
    Member
    Posted 3 years ago #

    When I use the get_var (as below)

    $mbv_query = "
    	SELECT property_address
    	FROM $wpdb->prefix.mbv_property
    	WHERE property_id = '1'
    	";
    
    $mbv_test = $wpdb->get_var($mbv_query,6,0);
    printf('<pre>Value: '.print_r( $mbv_test ).'</pre>');

    I return the value of "1" regardless of what I change the row and column offset to....

Topic Closed

This topic has been closed to new replies.

About this Topic