PHP - Getting a string from MySQL Query

Question

I need to retrieve a string from a query and then use that later on in another SQL query.

This is what I have, I'm retrieving the current branch ID for the currently logged in user:

$neededBranch = mysqli_query($con, "SELECT BranchNumber FROM Staff WHERE staffID = '".$_SESSION['username_login']."'");

And then I need to use said string here like this:

$result = mysqli_query($con, "INSERT INTO SomeTable (
                    blah,
                    blah,
                    )
                    VALUES ('".$SomeValue."',"
                              . " '".$_SESSION['username_login']."',"
                              . " '".$neededBranch."')");

Now, the ". " '".$neededBranch."')");" does not work because it is expecting a string.

My question is: How do I actually get the value I'm needing from the first query and use it in the second query? I'm new at PHP and don't have a clue.

from what I see, the first query is correct but it is not what you want to do. To actually get the string, you can either use mysqli fetch assoc or mysql fetch array and get the value from your query. Moreover, on the second query, after "INSERT INTO SomeTable (blah, blah, )" you have to insert a third parameter (the third coloumn) in order to insert the "$neededBranch". — briosheje
– briosheje, Commented May 4, 2014 at 21:25

meda · Accepted Answer · 2014-05-04 21:33:25Z

1

Fetch the data you queried:

$result= mysqli_query($con, $query);//query is the select stmt
$row = mysqli_fetch_assoc($result);
$neededBranch = $row['BranchNumber'];

answered May 4, 2014 at 21:33

meda

45.5k14 gold badges96 silver badges123 bronze badges

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

Collectives™ on Stack Overflow

PHP - Getting a string from MySQL Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related