PHP - Php-mysql Fetch The Events Of This Month?

Hello

i want to fetch the content from my MySQL db for one table and show it on a page, i'm using this code:
Code: [Select]
<?php include("inc/connect.php"); ?>
<?php
$result = $_REQUEST['result'];
?> Code: [Select]
<?php
$query = mysql_query("select * from listtest order by id asc");
while($result = mysql_fetch_array($query))
{
?>
  <tr>
    <td><?php echo $result['id']; ?></td>
    <td><?php echo $result['code']; ?></td>
    <td align="center"><a href="edit.php?id=<?php echo $result['id']; ?>">View</a></td>

    <td align="center">&nbsp;</td>
  </tr>
<?php } ?>

it's throwing me this error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in 32qgtf.php on line 30

What am i doing wrong ?

/Edit: line 29/30 is the mysql query / fetch.

i want to make a monthly report
  the user selects month from drop down and i must get the specified dates of that month from the DB
  I am using ajax to get the dates

so im trying to setup a page for my bills that i pay monthly so me and my gf can access it remotely whenever we need to. we have a few loans that we are paying off in installment loans every month so i created a table like the picture below (which is actually in excel but it looks about the same).  i know how to pull via select and sum everything that i need but what i'm actually going for is this:

every month on those certain due dates i'd like for the monthly payment to be subtracted from the balance automatically..and it show the reflected balance. i'm not sure how to go about such a thing though as i've never worked with dates and times.  my logic is that i have to setup a beginning time stamp for it to work off of..and then every 30 days from that time stamp..subtract the payment.  then again, there's not always 30 days in a month and it'd get off track.  any ideas?

Hi friends,

I'm looking to try and echo the profits from a MySQL "totals" table for each month of the year... the table bascically consists of a "totals" column which contains the total amount spent on each order, a "suppliertotals" column which contains the total amount that it costs us to buy the goods for that order and an "orderdate" column which stores the order date as "d/m/y" (so 01/01/01).

To work out the total margin from the complete table, I calculate the sum of totals minus the sum of suppliertotals. This is our margin.

I'm currently doing the calculation with MySQL's sum() function, and using PHP explode to get the date, but I'm obviously doing something wrong since PHP is returning the same month several times with different amounts...

Let me show you the code I have; I presume I need to use some kind of foreach statement, but I'm not sure where or how... hoping you can help!



    if (!$con)  { die('Could not connect: ' . mysql_error()); }

    mysql_select_db("onetelec_wsshop", $con);

     $result=mysql_query("SELECT orderdate FROM totals", $con);

    while($row = mysql_fetch_array($result))

    {

    $ordmonth = explode("/", $row['orderdate']);

    $ordmonth = $ordmonth[1];



    switch ($ordmonth) {

    case "01":

     $stresult=mysql_query("SELECT sum(total), sum(stotal) FROM totals WHERE ordate LIKE '%/$ordmonth/%'", $con);

    while($strow = mysql_fetch_array($stresult))

    {

    $margin = $strow['sum(total)'] - $strow['sum(stotal)'];

    }

    echo $margin." for January<br /><br />";

    break;



    case "02":

     $stresult=mysql_query("SELECT sum(total), sum(stotal) FROM totals WHERE ordate LIKE '%/$ordmonth/%'", $con);

    while($strow = mysql_fetch_array($stresult))

    {

    $margin = $strow['sum(total)'] - $strow['sum(stotal)'];

    }

    echo $margin." for February<br /><br />";

    break;



    case "03":

     $stresult=mysql_query("SELECT sum(total), sum(stotal) FROM totals WHERE ordate LIKE '%/$ordmonth/%'", $con);

    while($strow = mysql_fetch_array($stresult))

    {

    $margin = $strow['sum(total)'] - $strow['sum(stotal)'];

    }

    echo $margin." for March<br /><br />";

    break;



    case "04":

     $stresult=mysql_query("SELECT sum(total), sum(stotal) FROM totals WHERE ordate LIKE '%/$ordmonth/%'", $con);

    while($strow = mysql_fetch_array($stresult))

    {

    $margin = $strow['sum(total)'] - $strow['sum(stotal)'];

    }

    echo $margin." for April<br /><br />";

    break;



    case "05":

     $stresult=mysql_query("SELECT sum(total), sum(stotal) FROM totals WHERE ordate LIKE '%/$ordmonth/%'", $con);

    while($strow = mysql_fetch_array($stresult))

    {

    $margin = $strow['sum(total)'] - $strow['sum(stotal)'];

    }

    echo $margin." for May<br /><br />";

    break;



    case "06":

     $stresult=mysql_query("SELECT sum(total), sum(stotal) FROM totals WHERE ordate LIKE '%/$ordmonth/%'", $con);

    while($strow = mysql_fetch_array($stresult))

    {

    $margin = $strow['sum(total)'] - $strow['sum(stotal)'];

    }

    echo $margin." for June<br /><br />";

    break;



    case "07":

     $stresult=mysql_query("SELECT sum(total), sum(stotal) FROM totals WHERE ordate LIKE '%/$ordmonth/%'", $con);

    while($strow = mysql_fetch_array($stresult))

    {

    $margin = $strow['sum(total)'] - $strow['sum(stotal)'];

    }

    echo $margin." for July<br /><br />";

    break;



    case "08":

     $stresult=mysql_query("SELECT sum(total), sum(stotal) FROM totals WHERE ordate LIKE '%/$ordmonth/%'", $con);

    while($strow = mysql_fetch_array($stresult))

    {

    $margin = $strow['sum(total)'] - $strow['sum(stotal)'];

    }

    echo $margin." for August<br /><br />";

    break;



    case "09":

     $stresult=mysql_query("SELECT sum(total), sum(stotal) FROM totals WHERE ordate LIKE '%/$ordmonth/%'", $con);

    while($strow = mysql_fetch_array($stresult))

    {

    $margin = $strow['sum(total)'] - $strow['sum(stotal)'];

    }

    echo $margin." for September<br /><br />";

    break;



    case "10":

     $stresult=mysql_query("SELECT sum(total), sum(stotal) FROM totals WHERE ordate LIKE '%/$ordmonth/%'", $con);

    while($strow = mysql_fetch_array($stresult))

    {

    $margin += $strow['sum(total)'] - $strow['sum(stotal)'];

    }

    echo $margin." for October<br /><br />";

    break;



    case "11":

     $stresult=mysql_query("SELECT sum(total), sum(stotal) FROM totals WHERE ordate LIKE '%/$ordmonth/%'", $con);

    while($strow = mysql_fetch_array($stresult))

    {

    $margin += $strow['sum(total)'] - $strow['sum(stotal)'];

    }

    echo $margin." for November<br /><br />";

    break;



    case "12":

     $stresult=mysql_query("SELECT sum(total), sum(stotal) FROM totals WHERE ordate LIKE '%/$ordmonth/%'", $con);

    while($strow = mysql_fetch_array($stresult))

    {

    $margin += $strow['sum(total)'] - $strow['sum(stotal)'];

    }

    echo $margin." for December<br /><br />";

    break;

    }

}

I created a "statistics of site" page, stats.php.
Currently stats.php updates every visit, that's over 25 queries for every visit, with over 9,000 visits a day, I wish to cut down.
What is the best way to make it so all queries are done every hour, therefore requiring less queries to the database?
I assume the best way to go at this would be either to run a time() based script every 60 minutes and:

  - update this to a new field, then stats.php will require 1 query every visit, plus the 1 every hour.
or
  - update a text file and read that each stats.php visit, meaning just the 1 query every hour.

Now, I understand the second option will run much less queries overall, but is it the best way to go? Is there a better way to go about doing this?

Hi,   Does anyone have a clue how I might solve this little issue:   I have a MySQL query, for example:

<?php
// Make a MySQL Connection
$query = "SELECT * FROM staff";
    
$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result)){

    if($row['clock'] < time()) {
    echo "<b>"$row['name']. " - ". $row['age']"</b>";
    echo "<br />";

    } else {

    echo $row['name']. " - ". $row['age'];
    echo "<br />";

    }
}
?>

Taking data from the following table setup:   name - age - clock Timmy Mellowman - 23 - 09:00:00
Sandy Smith - 21 - 12:00:00
Bobby Wallace - 15 - 14:00:00   What im trying to achieve is compare the current time to the time in the clock column and depending if it's earlier or later, change the styling of the results.   The above code does appear to work somewhat however it seems to change the styling of all results in one go, rather than individually when it passes the time in the cell, which is what im looking for.   Thanks

I am trying to create a simple calendar where a user can add/remove their availability date. This part works so far. Now what I am having trouble with is highlighting the already selected dates that are fetched from a MySQL database.

 

Here's my code.

// HTML
<div id="datetimepicker1"></div>

// Jquery/Ajax

<script>
$(document).ready(function () {

  $('#datetimepicker1').datepicker({
    dateFormat: "yy-mm-dd",
    multidate: true,
    onSelect: function () {
        var getDate = $("#datetimepicker1").val();

        $.ajax({
             type: "POST", //or GET. Whichever floats your boat.
             url: "snippets/adapter-set.php",
             data: { date: getDate },
             success: function(data) {
              // alert(data);
             },
             error: function() {
                 alert("Error.");
             }
        });
    }
  });
});
</script>

// PHP
// adapter-set.php

$post_date = $_POST['date'];

$find_query = $db->prepare("SELECT user_id FROM user_dates WHERE date_available = :date_available");
$find_query->bindParam(':date_available', $post_date);
$find_query->execute();
$result_find = $find_query->fetchAll(PDO::FETCH_ASSOC);
if(count($result_find) > 0) {
  foreach($result_find as $row) {
    $user_id =	$row['user_id'];
  }
  $delete_query = $db->prepare("DELETE FROM user_dates WHERE user_id = :user_id");
  $delete_query->bindParam(':user_id', $user_id);
  $delete_query->execute();
  $result_delete = $delete_query->execute();
  if($result_delete == false) {
   echo 'delete false';
  } else {
   echo 'delete success';
  }
} else {
  $insert_query = $db->prepare("INSERT INTO user_dates(date_available) VALUES(:date_available)");
  $insert_query->bindParam(':date_available', $post_date);
  $result_insert = $insert_query->execute();
  if($result_insert == false) {
   echo 'insert false';
  } else {
   echo 'insert success';
  }

}

 

The above code works fine. It inserts and deletes a date row in MySQL database table based on a click.

Now what I would like to do is to highlight all the "available" dates that are already inserted into the database; so that the user knows which dates he has already selected. This is my code for that. But it doesn't seem to be working. No errors. It's just not highlighting the inserted dates. Can you tell me what I'm doing wrong?

// JQUERY
<script>
    $(document).ready(function() {

        $.post('snippets/adapter-fetch.php', {}, function(data){
            $("#datetimepicker1").datepicker({
              datesEnabled : data.datesEnabled
            });
        }, 'json');

    });
</script>

// PHP
// adapter-fetch.php

$global_user_id = 5;

$find_query = $db->prepare("SELECT date_available FROM user_dates WHERE user_id = :user_id");
$find_query->bindParam(':user_id', $global_user_id);
$find_query->execute();
$result_find = $find_query->fetchAll(PDO::FETCH_ASSOC);
if(count($result_find) > 0) {
  foreach($result_find as $row) {
    $date_available =	$row['date_available'];

    echo $date_available;
  }
} else {
  echo 'not dates available';
}

 

Hello,

So I have a weird error where if I fetch more than a certain number of rows from a mysql table, it triggers a 500 Internal Server Error.

I am using Apache Web Server (through GoDaddy) and the offending code is below:

Code: [Select]
set_time_limit(0);
$this->Connect();
$Output = array();
$search = "SELECT * FROM <table> WHERE user_id = ?";
if($Statement = $this->MySQLi->prepare($search)){
  $Statement->bind_param("i", $UserId);
  $Statement->execute();
  $Statement->bind_result(<result variables>);
  $count = 0;
  while($Statement->fetch() && $count++ < 70){
ChromePhp::log(<result variables>);
  }
  $Statement->close();
}
$this->Disconnect();

ChromePhp::log is a way of dumping things to the Javascript Console in your browser from within a PHP script just as a heads-up. So when I set the stop number as 70, everything is fine. If I try to fetch more than that it triggers a 500 internal server error on Apache Server port 443. I have looked through the error logs and can't figure out the cause but this is almost certainly a server configuration issue? I'd appreciate any feedback, especially anyone familiar with GoDaddy's hosting services

Thanks

I've been using this code for a long time and realised it's very repetitive, but the id_column I want changes all the time


function getRows()
{
$query = mysql_query($sql);
$rows = array();

while($row = mysql_fetch_assoc($query))
{
$rows[$row['id_column']] = $row;
}

return $rows;
}


So I wrote this function that will automatically create an array with a column I choose if I wish, but I'm not sure if it's very efficient.


function getRows($query, $column_id = false)
{
$rows = array();

while($row = mysql_fetch_assoc($result))
{
if($column_id === false)
{
$rows[] = $row;
}
else
{
if(isset($row[$column_id]))
{
$rows[$row[$column_id]] = $row;
}
else
{
$rows[] = $row;
}
}
}

        return $rows;
}


I would appreciate some input as to make it better.
Thanks.

Warning: mysql_fetch_array() expects parameter 1 to be resource, string given...


im tryin to put class inside code if $dayNumber and $dan are equal

i tried few ways but all are complicated since i have to call some functions this end up as "simple" solution but i dont know where did i get wrong PS that should be possible?

Code: [Select]
else {
                  echo "<td width='40'";
  $moj_id = $_SESSION['id'];
  $query_event = mysql_query("SELECT * FROM events WHERE id_user='$moj_id' GROUP BY 'event_date'") ;
  $test = mysql_fetch_array('$query_event');
  $date_event = $test['event_date'];
  sscanf($date_event, "%d-%d-%d", $godina, $mjesec, $dan);
  if ($dan==$dayNumber && $mjesec==$month && godina==$year)
  {

  echo " class='radni'";
  }
 
 
  echo"><a href='day_info.php?dan=",$dayNumber,"&mj=",$month,"&gd=",$year,"'>" . $dayNumber . " </a></td>\n";
                  $dayNumber++;                           
              }

Hello, I have this simple php form that updates the table, and also shows what the information in it is.

Here it is:


<strong>Update multiple rows in mysql</strong><br>

<?php
$host="localhost"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="test_mysql"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

// Count table rows
$count=mysql_num_rows($result);
?>
<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="">
<tr>
<td>
<table width="500" border="0" cellspacing="1" cellpadding="0">


<tr>
<td align="center"><strong>Id</strong></td>
<td align="center"><strong>Month</strong> <strong>Date</strong> </td>
<td align="center"><strong>Lastname</strong></td>
<td align="center"><strong>Email</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center"><?php $id[]=$rows['id']; ?><?php echo $rows['id']; ?></td>
<td align="center"><input name="month[]" MAXLENGTH="3" size="3" type="text" id="month" value="<?php echo $rows['month']; ?>">-
                   <input name="date[]" MAXLENGTH="2" size="2" type="text" id="date" value="<?php echo $rows['date']; ?>">
</td>
<td align="center"><input name="lastname[]" type="text" id="lastname" value="<?php echo $rows['lastname']; ?>"></td>
<td align="center"><input name="email[]" type="text" id="email" value="<?php echo $rows['email']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<?php
// Check if button name "Submit" is active, do this

if (isset($_POST['Submit'])) { 

for($i=0;$i<$count;$i++){

$month = $_POST['month'];
$date = $_POST['date'];

$lastname = $_POST['lastname'];
$email = $_POST['email'];

$name = $month."<br>".$date;



$sql1="UPDATE $tbl_name SET name='$name[$i]', month='$month[$i]', date='$date[$i]', lastname='$lastname[$i]', email='$email[$i]' WHERE id='$id[$i]'";
$result1=mysql_query($sql1);
}
}

if($result1){
header("location:update2.php");
}
?>    




<?php
$result = mysql_query("SELECT * FROM test_mysql")
or die(mysql_error());  

echo "<table border='1'>";
echo "<tr> <th>Name</th> <th>Age</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo "<tr><td>"; 
    echo $row['name'];
    echo "</td><td>"; 
    echo $row['lastname'];
    echo "</td></tr>"; 
} 

echo "</table>";
 ?>


What it does is this, it gets the row from the database, echos it and I am able to edit it and then save.

The thing is, it works with the updating but im trying to combine 2 variables into 1 and update that one also.

Im trying to combine month and date textboxes into one variable in the database that is name.

It for some reason updates the column name to A instead of what I had in the 2 fields month and date.

Here is where I combine both fields into one.
$name = $month."<br>".$date;

And here is where $month and $date is set.
$month = $_POST['month'];
$date = $_POST['date'];


Here is a picture.

//my controller
<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use DB;

class homeController extends Controller
{
    public function index() {
        
        $employee = DB::table('employee')->orderBy('id','desc')->get();
        
        $department = DB::table('department')->orderBy('id','desc')->get();

    	return view('index', ['employee' => $employee , 'department' => $department]);
    }
}

//my routes

Route::get('index','homeController@index');

//my view using blade temmplating engine
@foreach($employee as $emp)
<div class="employee">
  <b>{{ $emp->name }} </b>
  <a href="employee/{{ $emp->id }}">
	<p class="intro">{{ substr($emp->intro ,0, 50) }}...</p>   
  </a>
</div>
@endforeach

@foreach($department as $dep)
<div class="department">
  <b>{{ $dep->name }} </b>
  <a href="department/{{ $dep->id }}">
	<p class="desc">{{ substr($dep->description ,0, 100) }}...</p>   
  </a>
</div>
@endforeach

I want to fetch using ajax, how can i do it, teach/help me

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=318996.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=334481.0

Hello I have an array with data from `mysql` that I would like to output it in a table using twig.

The image is an example of want i want to achieve but without any luck.

`print_r` of the array data
 

        Array
    (
        [Administrator] => Array
            (
                [0] => Array
                    (
                        [RoleName] => Administrator
                        [PermissionName] => Catalog-View
                        [PermissionId] => 1
                    )
    
                [1] => Array
                    (
                        [RoleName] => Administrator
                        [PermissionName] => Catalog-Edit
                        [PermissionId] => 2
                    )
    
                [2] => Array
                    (
                        [RoleName] => Administrator
                        [PermissionName] => Catalog-Delete
                        [PermissionId] => 3
                    )
    
            )
    
        [Moderator] => Array
            (
                [0] => Array
                    (
                        [RoleName] => Moderator
                        [PermissionName] => Catalog-View
                        [PermissionId] => 1
                    )
    
            )
    
    )

The `HTML` code:
 

    <table>
        <tr>
            <thead>
                <th>Controller - Action</th>
                {% for permission in permissions %}
                {% for item in permission %}
                <th>{{item.RoleName}}</th>
                {% endfor %}
                {% endfor %}
            </thead>
        </tr>
        {% for permission in permissions %}
        {% for item in permission %}
        <tr>
            <td>{{item.PermissionName}}</td>
            <td>{{item.PermissionId}}</td>
        </tr>
        {% endfor %}
        {% endfor %}
    </table>

OUTPUT:

    <table>
        <tbody>
            <tr></tr>
        </tbody>
        <thead>
            <tr>
                <th>Controller - Action</th>
                <th>Administrator</th>
                <th>Administrator</th>
                <th>Administrator</th>
                <th>Moderator</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td>Catalog-View</td>
                <td>1</td>
            </tr>
            <tr>
                <td>Catalog-Edit</td>
                <td>2</td>
            </tr>
            <tr>
                <td>Catalog-Delete</td>
                <td>3</td>
            </tr>
            <tr>
                <td>Catalog-View</td>
                <td>1</td>
            </tr>
        </tbody>
    </table>

Later Edit
MySQL Query:
 

    SELECT t3.PermissionName, t1.PermissionId, t2.RoleName FROM tbl_user_role_perm AS t1
    INNER JOIN tbl_user_roles AS t2 ON t1.RoleId = t2.RoleId
    INNER JOIN tbl_user_permissions AS t3 ON t1.PermissionId = t3.PermissionId

MySQL Dump:
 

    -- Dumping structure for table tbl_user_permissions
    CREATE TABLE IF NOT EXISTS `tbl_user_permissions` (
      `PermissionId` int(11) NOT NULL AUTO_INCREMENT,
      `PermissionName` varchar(50) NOT NULL,
      `PermissionDescription` varchar(100) NOT NULL,
      PRIMARY KEY (`PermissionId`)
    ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
    
    -- Dumping data for table tbl_user_permissions: ~2 rows (approximately)
    DELETE FROM `tbl_user_permissions`;
    /*!40000 ALTER TABLE `tbl_user_permissions` DISABLE KEYS */;
    INSERT INTO `tbl_user_permissions` (`PermissionId`, `PermissionName`, `PermissionDescription`) VALUES
        (1, 'Catalog->View', 'View Catalog Method'),
        (2, 'Catalog->Edit', 'Edit Catalog Method'),
        (3, 'Catalog->Delete', 'Delete Catalog Method');
    /*!40000 ALTER TABLE `tbl_user_permissions` ENABLE KEYS */;
    
    
    -- Dumping structure for table tbl_user_role
    CREATE TABLE IF NOT EXISTS `tbl_user_role` (
      `UserRoleId` int(10) NOT NULL AUTO_INCREMENT,
      `UserId` int(10) NOT NULL,
      `RoleId` int(10) unsigned NOT NULL,
      PRIMARY KEY (`UserRoleId`),
      KEY `FK_tbl_user_role_tbl_user_roles` (`RoleId`),
      KEY `UserId` (`UserId`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
    
    -- Dumping data for table tbl_user_role: ~2 rows (approximately)
    DELETE FROM `tbl_user_role`;
    /*!40000 ALTER TABLE `tbl_user_role` DISABLE KEYS */;
    INSERT INTO `tbl_user_role` (`UserRoleId`, `UserId`, `RoleId`) VALUES
        (1, 13, 22),
        (2, 14, 22);
    /*!40000 ALTER TABLE `tbl_user_role` ENABLE KEYS */;
    
    
    -- Dumping structure for table tbl_user_roles
    CREATE TABLE IF NOT EXISTS `tbl_user_roles` (
      `RoleId` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `RoleName` varchar(50) NOT NULL,
      `CreatedDate` datetime NOT NULL,
      `ModifiedDate` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
      PRIMARY KEY (`RoleId`)
    ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
    
    -- Dumping data for table tbl_user_roles: ~7 rows (approximately)
    DELETE FROM `tbl_user_roles`;
    /*!40000 ALTER TABLE `tbl_user_roles` DISABLE KEYS */;
    INSERT INTO `tbl_user_roles` (`RoleId`, `RoleName`, `CreatedDate`, `ModifiedDate`) VALUES
        (22, 'Administrator', '2014-10-28 09:53:08', NULL),
        (23, 'Moderator', '2014-10-28 09:53:13', NULL),
        (24, 'Admin', '2014-10-28 12:22:05', '2014-10-28 12:22:06'),
        (25, 'User', '2014-10-29 15:10:36', '2014-10-29 15:10:37'),
        (26, 'SuperUser', '2014-10-29 15:10:45', '2014-10-29 15:10:46'),
        (27, 'Accountant', '2014-10-29 15:10:53', '2014-10-29 15:10:54'),
        (28, 'God', '2014-10-29 15:11:02', '2014-10-29 15:11:02');
    /*!40000 ALTER TABLE `tbl_user_roles` ENABLE KEYS */;
    
    
    -- Dumping structure for table tbl_user_role_perm
    CREATE TABLE IF NOT EXISTS `tbl_user_role_perm` (
      `RoleId` int(10) unsigned NOT NULL,
      `PermissionId` int(10) unsigned NOT NULL,
      KEY `RoleId` (`RoleId`),
      KEY `PermissionId` (`PermissionId`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- Dumping data for table tbl_user_role_perm: ~3 rows (approximately)
    DELETE FROM `tbl_user_role_perm`;
    /*!40000 ALTER TABLE `tbl_user_role_perm` DISABLE KEYS */;
    INSERT INTO `tbl_user_role_perm` (`RoleId`, `PermissionId`) VALUES
        (22, 2),
        (22, 1),
        (23, 1),
        (22, 3);
    /*!40000 ALTER TABLE `tbl_user_role_perm` ENABLE KEYS */;
    /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
    /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

Can  you help me to make the coding required so that the correct column have the correct permissions? thank you in advance.