Setting Value of variable from query

Question

Hi anyone know how to get the TID. I only need the TID and set it to variable $TID

$sql = 'SELECT TID FROM  walkin ORDER BY TID DESC LIMIT 1';

$result = mysqli_query($conn, $sql);

if ($conn->error) {
    die("Query failed: " . $conn->error);
}
$TID = /answer here/

Have you checked the documentation? And have you tried anything so far? StackOverflow isn't a free code-writing service, and expects you to try to solve your own problem first. Please update your question to show what you have already tried, showcasing a specific problem you are facing in a minimal, complete, and verifiable example. — Obsidian Age
– Obsidian Age, Commented Feb 23, 2018 at 1:46
Maybe fetch it. Wherever you saw query and error they didn't show an example of fetching? — AbraCadaver
– AbraCadaver, Commented Feb 23, 2018 at 1:56

mickmackusa · Accepted Answer · 2018-02-23 01:58:03Z

0

How about a prepared statement with a bind_result and fetch call?

if($stmt=$conn->prepare("SELECT TID FROM walkin ORDER BY TID DESC LIMIT 1")){
    if($stmt->execute() && $stmt->bind_result($TID) && $stmt->fetch()){
        echo $TID;
    }
}

answered Feb 23, 2018 at 1:58

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mickmackusa Over a year ago

@Isaiah Did my answer solve your problem? If so, please award the green tick to my answer. If not, please leave me a comment describing what has gone wrong for you while implementing.

Collectives™ on Stack Overflow

Setting Value of variable from query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related