0

using this query to get all tables with @ in them then selecting that table ,Im struggling to get the table returned in php because i dont know whats row1 identified by.

include "db.php";
$sq5 = "show tables LIKE '%@%'";
$result = mysqli_query($connection,$sq5);
$rowcounty=mysqli_num_rows($result);
if ($rowcounty == 0){
    echo "<center>";
    echo "<h2>No Users</h2>";
}else{
while($row1 = mysqli_fetch_assoc($result)){
$start = "
echo '<center>';
echo '<br>';
echo '<table id='customers'>';
echo '<tr>';
echo '<th>Id</th>';
echo '<th>Name</th>';
echo '<th>Inbox</th>';
echo '</tr>'";
echo $start;
$sq = "Select * FROM ".$row1[what do i put here?]."";
$result1 = mysqli_query($connection,$sq);
$newmsg=mysqli_num_rows($result1);
while($row = mysqli_fetch_assoc($result)){
    foreach($row as $key => $value){
        echo "$key=$value";
        $msg = "
        echo '</tr>';
          echo '<tr>';
          echo '<td>'".$row['id']."'</td>';
          echo '<td>'".$row['firstName']."'</td>';
          echo '<td>'".$newmsg." New Messages'</td>';
          echo '</tr>';";
          echo $message;
    }
}
    echo $msg;
}
}
M Suhayl
  • 27
  • 4

0 Answers0