So I know I can do this...

[Aeolus]

But right now my mind is a blank slate. Anyone want to jumpstart my battery?

 

    $result = @mysql_query("SELECT * FROM e_result WHERE EXISTS ( SELECT `points` FROM e_pointscale WHERE e_pointscale.c_group=$c_group AND e_pointscale.place = e_result.rank ) and c_id=$c_id ORDER BY rank");
    if( !$result ) { trigger_error( "Failed Connection: " . mysql_error() ); }
    
    while ($row = mysql_fetch_array($result)) {
        
        echo '<tr> <td><b>
        ' . $row ['name'] . '</b></td> <td>';
        printf("%04.1f", $row ['d_score']); echo '</td> <td>';
        printf("%04.1f", $row ['c_score']); echo '</td> <td>';
        printf("%02.0f", $row ['j_score']); echo '</td> <td>';
        echo $row ['score'] . '</td> <td>';
        echo $row ['count'] . '</td> <td>
        ' . $row ['rank'] . ' </td> <td>';
        echo $row ['points'] . '</td></tr>';
        };

 

it's only returning one row, instead of looping to repeat for each row found. I know it's a simple fix, I'm doing something wrong with requesting my information (trying to get points from points table for each row on the e_results table).

[Bricktop]

Edit.

[Maq]

Looks like you're looping correctly.  Are you sure your query is supposed to return more than 1 record?

[Aeolus]

Should I just replace my while with foreach? That returns an error unexpected ')'

[Maq]

Should I just replace my while with foreach? That returns an error unexpected ')'

 

No.

[Aeolus]

Now it's returning way too many... looks like it's just returning all the rows off the points table... maybe I should try this a different way.. :/

 

        $rowi = mysql_fetch_array($result);
            
            foreach ($rowi as &$row)    {

[Bricktop]

Hi Aeolus,

 

Is this query definitely correct?

 

    $result = @mysql_query("SELECT * FROM e_result WHERE EXISTS ( SELECT `points` FROM e_pointscale WHERE e_pointscale.c_group=$c_group AND e_pointscale.place = e_result.rank ) and c_id=$c_id ORDER BY rank");

[Aeolus]

No, that's what I'm questioning. I'll play around with it and update this posting this afternoon with what I find - for now I have to go feed horses!

[Maq]

No, that's what I'm questioning. I'll play around with it and update this posting this afternoon with what I find - for now I have to go feed horses!

 

It's hard for us to help with that sort of query and not even knowing what you want.  You can echo out your query to ensure it's what you intend:

 

$sql = "SELECT * FROM e_result WHERE EXISTS ( SELECT `points` FROM e_pointscale WHERE e_pointscale.c_group=$c_group AND e_pointscale.place = e_result.rank ) and c_id=$c_id ORDER BY rank";
echo "QUERY=> " . $sql;
$result = mysql_query($sql);