MySQL Database table from PHP code : <p>I have attempted to create a mysql query to create the database schema but with no success, here is the php code that get data from the database, could you please help me create a mysql script that will create the database tables?</p>

<p>here is the php script:</p>

<pre><code>    foreach($string["statuses"] as $status) {
    $selectSQL = 'SELECT * FROM twitter WHERE t_id="'.$status["id"].'" ';
    $queryset = '';
    $queryset = $mysqli-&gt;query ($selectSQL);
    if(mysqli_num_rows($queryset)==0)
        { 
        $text = mysqli_real_escape_string($mysqli, $status["text"]);
        $loc = mysqli_real_escape_string($mysqli, $status["user"]["location"]);
        $user_id = mysqli_real_escape_string($mysqli, $status["user"]["id"]);
        $app = mysqli_real_escape_string($mysqli, $status["source"]);
        $img = mysqli_real_escape_string($mysqli, $status["user"]["profile_image_url"]);
        $retweet = mysqli_real_escape_string($mysqli, $status["retweet_count"]);
        $favorite = mysqli_real_escape_string($mysqli, $status["favorite_count"]);

        $mysqli-&gt;query('INSERT INTO `twitter` VALUES (NULL,"'.$status['id'].'","'.$text.'","'.$status['created_at'].'","'.$loc.'","'.$user_id.'","'.$app.'","'.$img.'","'.$retweet.'","'.$favorite.'")');
        }   
}
</code></pre>
