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?

CCNA 1 Final Exam 2011 latest (hot hot hot)

  Hi! I have been posted content of ccna1 final exam (latest and only question.) I will post the answer and insert image on sunday. If you care, please subscribe your email an become a first person have full test content. Subcribe now  Some question  have not content because this question have images content. So that can you wait for me? SUNDAY 1. A user sees the command prompt: Router(config-if)# . What task can be performed at this mode? Reload the device. Perform basic tests. Configure individual interfaces. Configure individual terminal lines. 2. Refer to the exhibit. Host A attempts to establish a TCP/IP session with host C. During this attempt, a frame was captured with the source MAC address 0050.7320.D632 and the destination MAC address 0030.8517.44C4. The packet inside the captured frame has an IP source address 192.168.7.5, and the destination IP address is 192.168.219.24. At which point in the network was this packet captured? leaving host A leaving ATL leaving...