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;
}
}