[RESOLVED] query results

[auddog]

I have the following code which creates a selection based upon '$id'. The problem that I'm having is I only get the first variable. Is there something with the bind command I'm missing?

A

/* check connection */
            if(!mysqli_connect_errno())
            {

        /*** our SELECT query ***/
        $sql = "SELECT id, job_name, job_number, owner FROM ada where id = '$id' ";


        /*** prepare statement ***/
            if($stmt = $mysqli->prepare($sql))
                {

                /*** execute our SQL query ***/
                $stmt->execute();

                /*** bind the results ***/
                $stmt->bind_result($id, $job_name, $job_number, $owner);
                }

                /*** close connection ***/
                $mysqli->close();
        }
            else
        {
        /*** if we are unable to connect ***/
        echo 'Unable to connect';
        exit();
        }

[bradgrafelman]

I'm no MySQLi expert, but I couldn't find anything wrong with your syntax.

If I could make a suggestion, however, I would suggest that you remove the quotes around your value for the "id" column in your query. I'm assuming that the "id" column is of a numeric type (at least, it sounds like it SHOULD be), so MySQL is expecting numbers for that value - not a string.

[auddog]

I removed the quotes around the variable 'id', but that didn't resolve anything. I still only get the variable 'id' to show up. I even removed the bind results for 'id', which then didn't show anything. Do I need to put anything after the bind to show what it is?

A

[pete_bisby]

Are you sure there is data in the table that matches the id?

The variable 'id' will show up because it already exists - try renaming the variables in the bind statement and see if that makes any difference.

[auddog]

I have tried different name for the variables in the bind statement, but that doesn't make any difference. Is there a difference between the printf command and the echo command that could be causing the problem?

A

[auddog]

I was just looking over my list of projects page and here is my code for this page. Maybe I already have the bind statement set correctly here and it's something on the other page.

A

/* check connection */
if(!mysqli_connect_errno())
    {

/*** our SELECT query ***/
$sql = "SELECT id, job_name, job_number, owner FROM ada";

/*** prepare statement ***/
if($stmt = $mysqli->prepare($sql))
    {
    /*** execute our SQL query ***/
    $stmt->execute();
    /*** bind the results ***/
    $stmt->bind_result($id, $job_name, $job_number, $owner);
    /*** loop over the result set ***/
    while ($stmt->fetch())
        {
        /*** echo our table rows ***/
        echo ("<tr><td><A HREF='ada_project_info.php?comp_id=$id'>$id</a></td><td>$job_name</td><td>$job_number</td><td>$owner</td></tr>");
        }
    }
/*** close connection ***/
$mysqli->close();
}
else
    {
    /*** if we are unable to connect ***/
    echo 'Unable to connect';
    exit();
    }

[auddog]

I wound up redoing my entire page and using the mysqli procedural way and got everything to work. I will have to try this way at a later time. Thanks to everyone for your help.

A