Xtykutl

I'm working on a project where we are sending messages to users using a database. In this php file, I insert into the database with a to, from, date, and message field. The goal is to send the same message to all the people within one certain company. However, when I try sending it, the message will not send sometimes, and when it does, it will only message the first contact in the group/row that I get from the database. I've seen other examples online, but so far I haven't seen this exact problem with anyone else. Any suggestions would be appreciated.

$sql = 'SELECT drivers.username FROM project.drivers WHERE drivers.sponsor="'.$_SESSION["company"].'"'; //query to get all driver usernames within one company

$result = $conn->query($sql);

//$row = mysqli_fetch_array($result);

while($row = mysqli_fetch_array($result)){ //iterating throughout all the drivers

    $to  = $row["username"]; //username of current driver

    $from = $_SESSION["username"]; //from current company

    $message = $_SESSION["username"] . " updated your point to dollar ratio. Your new point to dollar ratio is " . $_SESSION["pointRatio"] . "."; //message

    $sql2 = "INSERT INTO project.messages(messages.date, messages.to, messages.from, messages.message) VALUES(now(), '".$to."', '".$from."', '".$message."')"; //inserting message into database

    $conn->query($sql2); //query for database

    $to  = $_SESSION["username"]; //this is the same format but sending the message to the company itself

    $message = $_SESSION["username"] . " updated your point to dollar ratio. Your new point to dollar ratio is " . $_SESSION["pointRatio"] . ".";

    $sql2 = "INSERT INTO project.messages(messages.date, messages.to, messages.from, messages.message) VALUES(now(), '".$to."', '".$from."', '".$message."')";

    $conn->query($sql2);

}

if you add var_dump and check records from database - are correct? Do you really get all rows?

$sql = 'SELECT drivers.username FROM project.drivers WHERE drivers.sponsor="'.$_SESSION["company"].'"'; //query to get all driver usernames within one company

$result = $conn->query($sql);

//$row = mysqli_fetch_array($result);

while($row = mysqli_fetch_array($result)){ //iterating throughout all the drivers

    var_dump($row);

}