11,093 Topics
 | |
| | Dear Everyone, I have a central Database which I want to spread across our regional offices for faster access and performance. Requirements: 1. A transaction that is effected in a regional office must be syncronized to the central database and vice versa. 2. The databases have primary keys auto-generated. There …  |
| | I have some data in a MySQL table, and I want to use them to populate form fields, so the site's admin can edit them. This is what I have so far in modify.php, but it's not working: <?php // configuration require("../../includes/config.php"); // query users table to retrieve admin homepage's … |
| | Hello guys I'm wondering how to update rows dynamically for instance: if cart contains one product then update its quantity and if cart contains more than one product update their quantities  |
| | I need help adding new users to a table i have made for an admin that can add or delete users from said table freely. What i have so far is an entry that can add date and time but for some reason it doesnt add the username and password. … |
| | imade this query and named it as vwOwnerAnimal. my problem is that i don't know how to display it using listview. can anyone pls help me. SELECT tbowner.owner_code, tbowner.owner_name, tbowner.owner_add, tbowner.owner_cn, tbowneranimal.a_name, tbowneranimal.a_breed, tbowneranimal.a_age, tbowneranimal.a_sex FROM tbowner INNER JOIN tbowneranimal ON tbowner.owner_code = tbowneranimal.owner_code;  |
| | Hello guys I've coded cart class with cart items and showed cart items in a table but I had a problem when I try to update the cart.. It updates all the cart items when I'm changing quantity in one of the items **HTML** <div class="cartContainer"> <h1 class="shoppingBag">your shopping bag</h1> … |
| | Hi, I am familiar with shell script but not really have much experience. I am looking into a shell script that would do this I have 2 tables TableA id name interest ---------------------------------------- TableB id name I have to create a shell script which copies all the id,name values from … |
 | Hy i have a search that now its works only if write or the first name or the last name, both didnt work....fn+ln....what i need to change?...ive tryied JOIN but nothing... if (Input::has('name')) { $name = Input::get('name'); $name = T_entity_details::where('First_Name','LIKE','%'.$name.'%') ->where('Last_Name','LIKE','%'.$name.'%','OR') ->where('Entity_Id','!=',$this->userId) ->get(array('Entity_Id')) ->toArray(); $array1 = []; foreach ($name as … |
| | Hi, By using **group by c3.source**,getting below result. I am trying to add condition in group by clause such that 3 rows should come 1)0+3 source result should merged 50+48 52+75 99+102 2) 4 source result contains ids having source 4 and url like '%daniweb%' source 0_to_7_days 7_to_14_days more_then_15_days 0 … |
| | please help with the query..I want to have a conditional statement in where clause depending on the result of select Count(*) statement originally my query is: select * from StudentMaster where StudentMaster.StudId = @pStudId and exists (select * from tblFinals where tblFinals.StudId=StudentMaster.StudId) but just today, I realize that user will … |
| | how can i delete a record from multiple tables Iam having category id in category table,and in orders table.If iam deleting in that id in category table at a time it should delete in orders table also how can i do this can anyone help me. Thanks in advance  |
| | dept (dept_no, dname, loc, mgrcode) emp (emp_no, ename, designation) project (proj_no, proj_name, status) dept. and emp. are related as 1 to many. Project and emp are related as 1 to many. i) Give the names of employees who are working on ‘Blood Bank’ project.`Inline Code Example Here` |
| | Hi, I make a delete page with php to delete clients from clients table. With this page I try to delete images from gallery table. for example I wish to delete client ABC from clients table and it have three images in gallery table. here under I paste the code …  |
 | I have several databases located over the world, this all have the same structure, with the same tables and triggers. For clarification purposes: Site 1: database_1 (with all its tables same as other sites) Site 2: database_1 (with all its tables same as other sites) Site 3: database_1 (with all … |
| | ** Hello i am newbiw to MYSQL .... iwant to create stored procedure in PHPMYADMIN . But when i am same procedue od MS SQL in MYSQL it is giving error . #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL …  |
| | hello guys i am trying to do something wierd in my query here is my query SELECT * FROM products INNER JOIN smartdevices ON products.id = smartdevices.productId WHERE products.clearName LIKE :keyword1 OR products.clearName LIKE :keyword2 OR products.clearName LIKE :keyword3 when the user enter the search phrase my php code will … |
| | Hey guys, i found this piece of code that is suppose to read a port on my server and write to a .txt file the gps data it get gets. am receiving nothing, am not not sure what the problem is, also am new to gps and php socket programming... … |
 | Hello, I wonder why in this specific sql table I do not see edit, copy & delete in xampp: from_stu_username date messages to_stu_username admin 0000-00-00 messages btjong ----------------------- Other Sql Table has Edit, Copy & Delete Except for messages. Here is my php code for adding the new data in …  |
| | Hi guys, I have 3 classes : 1.Product(Super Class) 2.SmartDevice(Sub Class) 3.Accessories(Sub Class) so I made 3 tables in database and made productId as a foreign key for smartDevice table and accessories table so I've had a trouble thinking about what the code of CRUD will be if I used … |
| | Hi every one. i have built an online fleet management app in php/mysqli successfully. I now have to add a gps device to send lon,lat, speed and so on to online app. I did some reading on php tcp socket listener, but am not very clear. Do any one have … |
| | Hello i try to update the Image using Update Query in MySQL here's the code $pic = $_FILES['photo']['name']; $sql = "UPDATE `std_login` SET `imagename` = '$pic' WHERE `std_id_no` = '$std_id'"; the File upload works, but not Stored in Database. what to do? help me please. |
| | I have 2 servers.Both are masters.One is local another is live.local generates even primary keys and live generates odd primary keys.But i want these primary keys in sequential manner (like 1,2,3,4....). I have divided the primary keys into even and odd due to synchronising issues between local and live. |
 | create table invoices( year int not null ,invoice_number int not null auto_increment ,primary key(year, invoice_number) ); insert into invoices(year) values(2009); insert into invoices(year) values(2009); insert into invoices(year) values(2009); insert into invoices(year) values(2010); insert into invoices(year) values(2010); insert into invoices(year) values(2010); select * from invoices; +------+----------------+ | year | invoice_number | …  |
| | i downloaded mysql-5.6.17-linux-glibc2.5-i686.tar.gz for Ubuntu 13.04 what next step to install it on ubuntu  |
 | I have a form that asks the user to enter in an exam id that they want to delete from the exam table in the DB. The problem I am having is that even if the user enters in an id that does not match in the DB the script … |
| | I am trying to add new data to my mysql database using tkinter in python. Does anyone have any best practices for doing this? I have tried thus far to no avail. thanks in advance for any help.  |
| | <?php if(isset($_POST['login'])) { require 'connection.php'; include 'password.php'; $email = $_POST['email']; $password = $_POST['pass']; $query = $dbh->prepare("SELECT id,name,email,password FROM users WHERE email = :email"); $query->bindParam(':email', $email, PDO::PARAM_STR); $query->execute(); $userData = $query->fetch(PDO::FETCH_ASSOC); $userEmail = $userData['email']; $hash = $userData['password']; if(password_verify($password, $hash) && $email == $userEmail) { session_start(); $_SESSION['sess_user_id'] = $userData['id']; $_SESSION['sess_name'] = $userData['name']; … |
| | Hello Guys I want to insert into two tables with one query in mysql the first table contains a primary key and other stuff the second table contains a foreign key and other stuff I'm wondering how this would happen ? and if so how would be the query of … |
| | /////Get gl accounts class///// $sql_class = "SELECT cid,class_name FROM 0_chart_class WHERE cid>=3 ORDER BY cid ASC"; $result_class = mysql_query($sql_class) or die("Error in query: $sql_project.".mysql_error()); echo "<TABLE class='swPrpTopMenu'>"; echo "<th>Account Code</th><th>Name</th><th>Amount</th>"; while($row_class=mysql_fetch_array($result_class )) { $c_id=$row_class['cid']; $c_name=$row_class['class_name']; echo "<tr><td>$c_name</td></tr>"; ////////get accounts $sql_accounts="select ct.name,ct.class_id,cm.account_code,cm.account_name FROM 0_chart_types ct,0_chart_master cm WHERE ct.id=cm.account_type AND ct.class_id='$c_id' GROUP … |
| | Hello, I'm having a problem with my MySQL InnoDB table, only one of five. Every now and then a row or two will go missing completely with no trace of it being there in the first place. I have a website which takes HTTP requests from my desktop side client …  |
| | I am building a url shortner application in php and mysql and i am using the follwing logic to create short urls, pls tell me how is it First i fetch the last id from the database using select max(id) from urls then suppose if it returns 100 then i … |
| | Hy now i have this code <div class="row"> <div class="col-xs-12 col-md-6 left"> @if(in_array($profile->Entity_Id,$likes)) <a class="btn btn-sm btn-primary" href="{{URL::route('displayProfile',array('profile_id' => $profile->Entity_Id))}}"> <i class="icon-visual-eye-fill icon"></i>1</a> @else <button type="button" class="btn btn-sm btn-primary view-profile" profile-id="{{$profile->Entity_Id}}"> <i class="icon-visual-eye-fill icon"></i>not</button> @endif </div> <div class="col-xs-12 col-md-6 right"> @if(in_array($profile->Entity_Id,$likes)) <a class="btn btn-sm btn-info" href="{{URL::route('messageProfile',array('profile_id' => $profile->Entity_Id))}}"> <i class="icon-envelope-fill-1 …  |
| | I'm a little bit stuck at this moment. As of now, this is the code that I have: private void btnChangeImage_Click(object sender, EventArgs e) { using (OpenFileDialog openFileDialogForImgUser = new OpenFileDialog()) { string location = null; string fileName = null; openFileDialogForImgUser.Filter = "Image Files (*.jpg, *.png, *.gif, *.bmp)|*.jpg; *.png; *.gif; … |
| | Hi I have a problem with inserting into the database. This is my code : $insert = $db_con->query("INSERT INTO users (username,password,email,com-name,com-logo,com-phone,com-mobile) VALUES('".$username."','".$enc_pass."','".$email."','".$com_name."','".$profile_path."','".$com_phone."','".$com_mobile."')"); |
| | I am building a site where members can create profiles that other members can view. I want to add a favourites feature to the profiles so a member can keep a list of their favourties members. This all works fine but now I want to find a way that a … |
| | hey guys. i have this table that lists contacts that are stored in database. the data is selected from 2 tables using join which i have already got working: SELECT c.contact_id,c.salutation,c.fname,c.lname,c.dob,c.houseadd,c.personalno,c.officeno,c.email,c.spouse,c.child, s.spouse_id,s.s_salutation,s.s_fname,s.s_lname,s.my_spouse FROM contact1 c LEFT JOIN spouse1 s ON c.contact_id = s.my_spouse what im having trouble with is selecting … |
| | hello. i was just wondering if it is possible to insert data for date and time separately into database for a column with type datetime. datetime format is like : yyyy-mm-dd h:m:s . I know you can get date and time separately FROM database but is it possible to be … |
 | How do I fetch data from table into dropdown menu in mysql and post back to another table? What I want is to create a registration form for customers and attach an agent to each customer, the agent names are stored in a table and i need to post agent … |
| | hello. I have a table populated by name. The names are links when clicked will pop up a form for editing. each input (for editing) is populated by the equal value from database but im having trouble with one particular text box. this text box is for date of birth … |
| | Hello, I have been breaking my head here and I can't figure out what I am doing wrong, I am trying the get the result of the first query into variables to then run the second query. It works inside mysql but not insite my php query. $data = mysql_query("select … |
| | I want to count records using datediff() and where condition; I am getting the result with no. of days; but cant count records with condition; below is the my query SELECT DATEDIFF(CURDATE(), jobs.jobs_listed_date) FROM tbl_first_category AS FIRST , tbl_second_category AS SECOND , tbl_jobs AS jobs WHERE first.fc_id = second.sc_fc_id AND … |
| | I'm trying to code a registration form. But I'm stuck at adding a borrowed code of image upload, resize, save and store its path in MySQL database. The error message is "Undefined index: fileimage" on the line where I have this code: if($_FILES['fileimage']['name']). Here is the register.php: <?php // include … |
 | How do I upload photos to a mysql database using php and I again reproduce an image from the database and displayed in the browser |
| | Hi There. I have the following code for a login system withing VB 2010. I am getting a Warning: "Variable 'reader' is used before it has been assigned a value. A null reference exception could result at runtime." Where did I go wrong? Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal …  |
| | I have a Website and i want to backup my MySQL data base from cpanel can anyone help me with the solutions? |
| | hey guys. I've always had problems when it comes to getting data from multiple tables in a database and so now I have another one. I want to get data from 3 different tables: contact1, child1 and spouse1. columns in contact1 where i want to get data from: contact_id | … |
 | i have a prinscreen of the problem http://i.imgur.com/GMJho9r.jpg i use mySQL to create the query and i have a database called tap that contains the events table I try SELECT sensor_id,event_type,value from tap.events where events.time = (SELECT MAX(events.time) from tap.events) group by sensor_id,event_type ORDER BY sensor_id,event_type; I get only the … |
| | |
 | i had some trouble when updating a mysql field, i had 2 text fields and 1 textarea fields, both the text fields updated ok through this query: but textarea field is not updating.. edit.php <?php include('connect.php'); $id=$_GET['id']; $result = $db->prepare("SELECT * FROM telugunews WHERE id= :userid"); $result->bindParam(':userid', $id); $result->execute(); for($i=0; … |
| | how could i send email to list of email addresses inside a mysql database?? i want to create a site helping students find home tuitions. when students fill form regarding subjects they want tuitions ,concerning teachers should get e-mail..tell how can i do this??  |
The End.