703 Topics
| |
public partial class Form4 : Form { private OleDbConnection connect = new OleDbConnection(); public Form4() { InitializeComponent(); connect.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Bino Unity\Desktop\user1.accdb;Persist Security Info=False;"; } private void Form4_Load(object sender, EventArgs e) { } private void login_button_Click(object sender, EventArgs e) { connect.Open(); OleDbCommand command = new OleDbCommand(); command.Connection = connect; command.CommandText … | |
Hey, i dont know how this is called but i have ideas and if it possilbe that someone can help Help me about this: i have file index.php and 2 folders called: blue, red. in these 2 folders therse a pages that content the same backgroundcolor as the foloders name. … | |
Hello, I am trying to update my record but nothing is happening please help me out update.php <?php require_once("connection.php"); if(isset($_POST["update"])) { $uid = $_POST["uid"]; $user_name = $_POST["uname"]; $f_name = $_POST["fname"]; $l_name = $_POST["lname"]; $company = $_POST["company"]; $address = $_POST["address"]; $phone = $_POST["phone"]; $fax = $_POST["fax"]; $mobile = $_POST["mobile"]; $email = … | |
Dear all, I have two identical mysql server with same databases and tables structures but with different data. ServerA ServerB Database Shaqib Database Shaqib Table users Table users ID | Name | Phone ID | Name | Phone 1 |Test1 | 123456 1 |Test13 | 1256456 2 |Test2 | 785632 … | |
Hi, I am working on a wbsite for a training centre. I am querying a web service for the list of their courses. There are three parametres in the query: centre, coursetype and courselocation. When querying it directly or using SoapUI it can be queried using 1, 2, 3 or … | |
Hi . I want to know how pass the data from the datagrid to textbox through query string with only the ID of the selected row being passed as query i.e when I select a particular row all the attributes of that row should be displayed on the textboxes of … | |
Ok, here is what I get when I run the query. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near newmessage`int(4) unsigned NOT NULL DEFAULT `0`,`companyi' at line 4 Here is what … | |
Hi , i hv created 2 tables : a Department table with fields Deptname , Deptid and Employee table with Empid , Empname, Salary . I have created a datagrid with fields empname , address , Salary , Deptname and edit and delete command columns . By clicking on edit … | |
id name class marks 1 H 1 60 2 H 2 50 3 S 1 70 4 S 2 60 5 V 1 55 6 V 2 80 7 K 1 60 8 K 2 70 This is my table structure. I want mysql query to get result like id … | |
Hello I am creating a little application, using VB.net, and Access database. I want to count the number of records whitch have more than 6 hours difference between records. Is it possible to have a query to count the number of recordset where the "Time End" and "Time Start" of … | |
I have images generated by while loop php based on how many course user have when user press on one of those images it will send him to that course page but all images send to one course page this my php code in** home page ** <?php $con=mysqli_connect("localhost","FYP","123","FYP"); $sql= … | |
Hello, I was wondering if the following mysql query can be constructed in a much more efficient way? SELECT distinct(cr.email), m.fname, m.lname, m.email, (SELECT count(*) FROM campaignRecipts where email=cr.email )as ttlsent, (SELECT count(received) FROM campaignRecipts where received='yes' and email=cr.email )as ttlreceived, ((SELECT count(received) FROM campaignRecipts where received='yes' and email=cr.email )/(SELECT … | |
$result = mysqli_query($con,$addtothedb); $cur = "USERS/"; echo $des = $cur.$email.'/'; if($result){ if ( mkdir($des,0777) ) { //http://pastebin.com/7J0BM5fD echo "<br/>"; echo "<br/>"; echo $file_name = $_FILES['file']['name']= 'mfix.png'; echo "<br/>"; echo "<br/>"; echo $file_tmp =$_FILES['file']['tmp_name']= 'mfix.png'; echo "<br/>"; echo "<br/>"; move_uploaded_file($file_tmp, $des.$mfix); echo "<img src='<?php echo $mfix ;?>' alt='Image' style='width:100px;height:100px'>"; /*echo "<img … | |
Hello I have an SQL query that i want to concatenate the fields and display it in a way that those concatenated fields will be displayed first row will have 4 columns,second row will also have 4 columns....etc. for instance the query `SELECT imageurl, caption, template FROM template; The Result … | |
I’m trying to patch a routine and I finally found the problem. I am given the following string: [code] $query = "SELECT title, DATE_FORMAT(event_date, '%Y-%c-%e') AS event_date FROM $dbTable WHERE event_date LIKE '$year-$month%'"; [/code] In the month variable at the end, for the months January through September I am returned … | |
I am looking for help to write a query. I have a database with an ID a Date_Field and a Description. I want to find out two things What Date_Field and Description and Description are the same? {duplicate records} [code] SELECT * FROM TIME_TABLE t1 WHERE EXISTS ( SELECT * … | |
$sql = (" SELECT referral1.*, client.*, employee.* FROM ( select r.referral_date,c.lastname,c.middlename,c.firstname,c.gender,r.presenting_problem,e.employee_nickname from client c inner join referral1 r on c.referral_id = r.referral1_id inner join assign_psychotherapist ap on ap.a_referral_id = c.referral_id inner join employee e on ap.a_psychotherapist_id = e.empid where referral_status ='Assigned' OR referral_status ='Accepted' order by referral_date desc ) as … | |
$this->db->select('referral1.*, client.*, employee.*'); $this->db->from('client'); $this->db->join('referral1', 'client.referral_id = referral1.referral1_id', 'inner' ); $this->db->join('assign_psychotherapist ', 'assign_psychotherapist.a_referral_id = client.referral_id', 'inner' ); $this->db->join('employee ', 'assign_psychotherapist.a_psychotherapist_id = employee.empid', 'inner' ); $this->db->where("referral_status ='Assigned' OR referral_status ='Accepted' "); $this->db->order_by("referral_date", "desc"); $this->db->select('referral1.*, client.*, volunteer.*'); $this->db->from('client'); $this->db->join('referral1', 'client.referral_id = referral1.referral1_id', 'inner' ); $this->db->join('assignvolunteer', 'assignvolunteer.Vreferralid = client.referral_id', 'inner' ); $this->db->join('volunteer', 'assignvolunteer.Vvolunteerid … | |
hi there, for the last one week I am deliberately trying to solve my problem. **Pls help me** For your better understanding, Layout of my page is something like this : Part -A -------- [ Dropdown list ] [ TextBox ] [ Table -1 ] Part - B -------- [ … | |
Hi, I have a problem with exercise 51 from sql-ex.ru, please help. Thanks in advance. # Short database description "Ships" # The database of naval ships that took part in World War II is under consideration. The database has the following relations: Classes(class, type, country, numGuns, bore, displacement) Ships(name, class, … | |
Hi, My query: $query = "select * from ( select * from students union all select * from students ) as tmp order by rand() limit 5"; $myquery = mysqli_query($db_connect, $query); while($students = mysqli_fetch_assoc($myquery)){ $stdid =$students['stdid']; $name = $students['name']; $dept = $students['dept']; echo "<br><br>".$stdid."<br>".$name."<br>".$dept; } There are 20 rows for … | |
I HAVE A QUERY THIS IS PRODUCING THIS RESULT. EVERYTHING WORKS FINE BUT WHAT I WANT TO ACHIEVE IS SLIGHTLY DIFFERENT. INSTEAD OF HAVING REPEATING IMPORTERS, I WANT TO GROUP THE IMPORTERS/DISTRIBUTOR SO THAT NOTHING CAN REPEAT AND HAVE ALL THE BALANCES IN THREE SEPARATE COLUMNS. BELOW IS MY TABLE … | |
What does PDO::query actually do ? Does it query the SQL ? If it queries the SQL, I think the data must be in the PDOStatement object as the result of the query.. But, what I find is just the SQL statement itself. So, I think it does nothing but … | |
I like to join the 3 tables in without using joing query is possible... | |
Hi I need to look in a field to find the text same as another field I have this at the moment but it does not work, hoep you can help update TAB1, TAB2 set `field3` =`field4` where FIND_IN_SET('`FIELD1`', '`FIELD2`') I feel FIND_IN_SET is not the right thing as the … | |
Does anyone know this error : Syntax error (missing operator) in query expression '***Budy Soleman***' **<--( this is content of textbox.text)** This is my code in VB.net with ms-access Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Call connect() Dim simpan As String simpan = "insert … | |
Hi, I want to output a simple result. I join 2 tables and SUM one column in one, i get the SUM results correct but cannot get the num_rows proper. My Code: $clientid = 24; $query = "SELECT items.itemid, SUM(prices.priceid) as PR FROM items JOIN prices ON items.itemid = prices.itemid … | |
Hi guys Im trying to save a combobox selected item to my database but i cant get it working, it saves "user" instead of the username that is stored in the combobox, any suggestions? here's a snippett Try '----------------Sends the message------------------------------------------------------------------- MysqlConn.Open() ' opening the connection to the DB Dim … | |
Hi, I originally created this query to get a result from a single select statement Its funny that it became a very long query having sets of joined table Its also maybe annoying to look for it so im trying to trim it down most of it have same joined … |
The End.