Prepared Statements

[Gavin Chalkley <gavin.chalkley@xxxxxxxxx>]

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