Output multiple records php

Question

Okay so I think I just set up my MySQL table poorly. I id, other stuff that doesnt matter, then, movielink1, movielink2, movielink3, movielink4, movielink5

I want a button to appear for each one, ONLY if the movielink# exists. Most of them just have only movielink1 filled.

I think im just looking at it the wrong way. Here's my code.

              0 ) {
            while($info2 = mysql_fetch_array($data2)) {
                Print '';
                }
            } else {
                Print 'Error!'; 
            }
            ?>

Thanks for suggestions, I just added this, but its still not working correctly, nor is a great way to approach it.

        $data1 = mysql_query("SELECT movielink1 FROM movies WHERE id=$id");
        if (mysql_num_rows($data1) > 0 ) {
        while($info1 = mysql_fetch_array($data1)) {
            Print '';
            }
        } else {
        }

        $data2 = mysql_query("SELECT movielink2 FROM movies WHERE id=$id");
        if (mysql_num_rows($data2) > 0 ) {
        while($info2 = mysql_fetch_array($data2)) {
            Print '';
            }
        } else {
        }
        $data3 = mysql_query("SELECT movielink3 FROM movies WHERE id=$id");
        if (mysql_num_rows($data3) > 0 ) {
        while($info3 = mysql_fetch_array($data3)) {
            Print '';
            }
        } else {
        }
        $data4 = mysql_query("SELECT movielink4 FROM movies WHERE id=$id");
        if (mysql_num_rows($data4) > 0 ) {
        while($info4 = mysql_fetch_array($data4)) {
            Print '';
            }
        } else {
        }
        $data5 = mysql_query("SELECT movielink5 FROM movies WHERE id=$id");
        if (mysql_num_rows($data5) > 0 ) {
        while($info5 = mysql_fetch_array($data5)) {
            Print '';
            }
        } else {
        }

3dgoo · Accepted Answer

There are a number of little problems in your code. Such as you fetch the row from results and set it to $info2 but then you call $info.

Here is your code fixed up:

$sqlResults = mysql_query("SELECT * FROM movies WHERE id=$id");

if (mysql_num_rows($sqlResults) > 0 ) {
    while($sqlRow = mysql_fetch_array($sqlResults)) {
        if (!empty($sqlRow['movielink1'])) {
            print '';
        }
        if (!empty($sqlRow['movielink2'])) {
            print '';
        }
        if (!empty($sqlRow['movielink3'])) {
            print '';
        }
        if (!empty($sqlRow['movielink4'])) {
            print '';
        }
        if (!empty($sqlRow['movielink5'])) {
            print '';
        }

    }
} 
else 
{
    print 'Error!'; 
}

Output multiple records php

Answers (1)

Related Questions