MySQL Query not displaying results

Question

I have the following query on an external file to a WordPress install querying a BuddyPress table. I am receiving no errors yet the results are displaying?

$the_pro = "". implode(", ", $user) ."";

    $query ="SELECT 
        (SELECT value  FROM wp_bp_xprofile_data WHERE 'user_id' IN (" . $the_pro . ") AND field_id = '2') as 'prof',
        (SELECT value  FROM wp_bp_xprofile_data WHERE 'user_id' IN (" . $the_pro . ") AND field_id = '3') as 'address',
        (SELECT value FROM wp_bp_xprofile_data WHERE 'user_id' IN (" . $the_pro . ") AND field_id = '4') AS 'city',
        (SELECT value FROM wp_bp_xprofile_data WHERE 'user_id' IN (" . $the_pro . ") AND field_id = '5') AS 'state',
        (SELECT value FROM wp_bp_xprofile_data WHERE 'user_id' IN (" . $the_pro . ") AND field_id = '6') AS 'zip',
        (SELECT value FROM wp_bp_xprofile_data WHERE 'user_id' IN (" . $the_pro . ") AND field_id = '7') AS 'link'
        ";
     $results = mysql_query($query);
 while($row = mysql_fetch_array($results)) { 

?>

        <div style="padding-bottom:4px; border-bottom:#CCC 1px solid;" >
        <div class="prof"><a href="#" onClick="myClick(0);"><?php echo $row['prof']; ?></a></div>
        <div class="address"><span style="margin-bottom:3px;"><?php echo $row['address']; ?></div>
        <div class="local"><?php echo $row['city']; ?>, <?php echo $row['state']; ?> &nbsp;<?php echo $row['zip']; ?></div>
        </div>
        <?php 
  }?>

Do you tried to run your query inside the mysql client? It's works as expected? — Andrey Bakharev, Oct 05 '14 at 16:30
echo $query - and note that PHP's mysql API is long since deprecated — Strawberry, Oct 05 '14 at 16:35
Use a single select and move the conditions to a CASE statement. — Mihai, Oct 05 '14 at 20:08

score 0 · Answer 1 · answered Oct 05 '14 at 20:05

0

Please try adding: if (!$result) { die('Invalid query: ' . mysql_error()); } so you know if there's an error or it really returned an empty result.

answered Oct 05 '14 at 20:05

MiGs

13
3

MySQL Query not displaying results

1 Answers1