在mysql查询中使用if else

Question

I'll keep this brief: can anyone tell me why this doesn't work? The "else" section works, the if bit doesn't.

<?php

$sql2 = mysql_query("SELECT * FROM products_new WHERE id='" . $result['id_kit'] . "'");

    while($row = mysql_fetch_assoc($sql2)){

    if ($result['id_kit'] == 0) {

            ?>

            //DO THIS BIT IF $result['id_kit'] IS "0". 

            <?php
            }

    else {
            ?>

            //DO THIS BIT IF $result['id_kit'] IS ANYTHING OTHER THAN "0".  THIS BIT WORKS FINE

    <?php
    }
?>
<?php
    }
    ?>

Answer 1

Change the following

Change

                    $sql2 = mysql_query ( "SELECT * FROM products_new WHERE id='" . $result ['id_kit'] . "'" );

                <?php 
                    while ( $row = mysql_fetch_assoc ( $sql2 ) ) {

To

                    $sql2 = mysql_query ( "SELECT * FROM products_new WHERE id='" . mysql_real_escape_string($result['id_kit']) . "'" );
                    while ( $row = mysql_fetch_assoc ( $sql2 ) ) {

Change

if ($result['id_kit'] == 0) {

To

if (empty($row)) {

You should have a working code

Thanks :)