Skip to main content

Subquery returns more than 1 row



All





I have two table enter image description here





1st table is : wp_frm_item_metas 2nd table is : wp_frm_items





Now i want to meta_value based on wp_frm_items table fields value.





I fired this sql. it returns me Subquery returns more than 1 row







SELECT meta_value

FROM wp_frm_item_metas

WHERE (item_id=(

SELECT id

FROM wp_frm_items

WHERE form_id ='9' && user_id='1')

&& field_id=128)







I tried this solution







SELECT meta_value

FROM wp_frm_item_metas

WHERE (item_id=(

SELECT count(*) as c,id

FROM wp_frm_items

WHERE form_id ='9' && user_id='1')

&& field_id=128 && c > 1)

ORDER BY c DESC







It returns this error Operand should contain 1 column(s)





My code is







foreach($fp_id_c as $kid=>$id)

{

if (!$id or ($logged_in && !$user_ID)) return;

$id = (int)$id;



//echo $logged_in.'-'.(int)$user_ID;

if ($logged_in){



echo $ff_id_c[$kid];

global $wpdb;

echo "SELECT meta_value FROM wp_frm_item_metas WHERE (item_id=(SELECT count(*) as c,id FROM wp_frm_items WHERE form_id ='$kid' && user_id='". (int)$user_ID ."') && ORDER BY c DESC && field_id=$ff_id_c[$kid])";

$result_c= $wpdb->get_var("SELECT meta_value FROM wp_frm_item_metas WHERE (item_id IN (SELECT count(*) as c,id FROM wp_frm_items WHERE form_id ='$kid' && user_id='". (int)$user_ID ."') && field_id=$ff_id_c[$kid]) ORDER BY c DESC");

echo $result_c;

}

}




Comments

  1. Try

    WHERE item_id IN (<your sub query>) instead of WHERE item_id=

    ReplyDelete
  2. Try the IN clause

    SELECT meta_value FROM wp_frm_item_metas
    WHERE (item_id IN (
    SELECT id FROM
    wp_frm_items WHERE
    form_id ='9' && user_id='1'
    )
    && field_id=128
    )

    ReplyDelete

Post a Comment

Popular posts from this blog

Slow Android emulator

I have a 2.67 GHz Celeron processor, 1.21 GB of RAM on a x86 Windows XP Professional machine. My understanding is that the Android emulator should start fairly quickly on such a machine, but for me it does not. I have followed all instructions in setting up the IDE, SDKs, JDKs and such and have had some success in staring the emulator quickly but is very particulary. How can I, if possible, fix this problem?

Java Urban Myths

Along the line of C++ Urban Myths and Perl Myths : What are the Java Urban Myths? That is, the ideas and conceptions about Java that are common but have no actual roots in reality . As a Java programmer, what ideas held by your fellow Java programmers have you had to disprove so often that you've come to believe they all learned at the feet of the same drunk old story-teller? Ideally, you would express these myths in a single sentence, and include an explanation of why they are false.