Prepared Statements

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all,

I am struggerling with a prepared statement (may not even be suited)


$stmt = $db->stmt_init();

    if($stmt->prepare("SELECT title,live,where FROM content"))
    {

        $stmt->bind_param('sii',$t,$l,$w);

## This bit here

        $stmt->execute();
        $stmt->bind_result($title, $live, $where);

        while($stmt->fetch())
        {
            echo "$title\t -\t $live\t -\t $where";
        }

        $stmt->close();
    }

How can i get the data i want to select into variables in this scenario (title and Live and where)?

BR,

Gavin

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux