Clients

select ( "SELECT * FROM users INNER JOIN locations ON users.country=locations.locationid ") or die('error in innerjoin'); $numOfRows = $db->select_one ( "Select count(*) from users" ); //$db->print_last_query(); while ( $row = $db->get_row ( $res, 'MYSQL_BOTH' ) ) { $p = $row ['0']; ?>

	Name	Email	Country	Registration Date	Actions

Add new row Delete all

10) { $pages = floor ( $numOfRows / 10 ); //echo '
'; $change = $numOfRows % 10; //echo '
'; $j = 1; for($i = 0; $i < $pages * 10; $i += 10) { $to = $i + 10; $l = $i . ",10"; if (isset ( $_GET ['pagination'] )) $n = split ( ",", $_GET ['pagination'] ); ?> > 0) { $l = $i . "," . $change; ?> >

Add New Client Form

insert_sql ( "insert into users(firstname,lastname,email,password,phone,mobile,country,city,address) values('" . $_POST ["firstname"] . "','" . $_POST ["lastname"] . "','" . $_POST ["email"] . "','" . $_POST ["txt_Pass"] . "','" . $_POST ["phone"] . "','" . $_POST ["mobile"] . "','" . $_POST ["country"] . "','" . $_POST ["sub_cat"] . "','" . $_POST ["address"] . "')" ) or die('Error in insertion'); //$db->print_last_query(); print ""; } ?>

Update Client Form

select ( "select name,description,path from authentification where id=" . $i [0] ); // $db->print_last_query (); $row = $db->get_row ( $res, 'MYSQL_BOTH' ); ?>

update_sql ( "update authentification set name='" . $_POST ['txt_name'] . "',description='" . $_POST ['txt_wysiwyg'] . "',path='$i1' where id= " . $_GET ['id'] ); } //$db->print_last_query(); ?>