10,946 Topics
 | |
| | Need help with the quiz problem. I want to set time limit for each question in quiz module (say 30 seconds) and after that time, the form will auto submit the question (auto submit = no option selected = unanswered). There are 3 questions, so total time limit is 90 …  |
| | I have a database table named with books. it consists of something like below ex database given below, user is trying to search the value by author or title and based on category ex: if user search for adapt by selecting fiction need display both adapt and adaxx below is … |
| | if query passed in search box by selecting the category as fiction or whatever it may be, it should search in both title and author, if value got in title then no need to search in author, if not need to search in author, $search = $_POST['searchvalue']; //assume search value … |
| |  Hi all,how do i do cascade on delete and update on this to tables,i have database,once i enter lecturer i can not delete because of constraints between this 2 tables.I tried in Lecturer table choose cascade on delete and update,not allowed,if do from module table same story.  indicates start and end point of chat by user/agent. Please suggest how we cam give each chat a unique session For Example Chat b/w company_id(5969) and user_id(67) has 1 unique chat id. Not Sure Is it possible in query or have …  |
| | Hi how i can use this sql in php.. SET @a = 0; UPDATE van SET position = @a:=@a+1 where day='2';===>can be variable it goes from 2 to 30 thanks |
| | Hello. Please look at the code below and tell me the correct code for it please. here is the message i get.."Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given" <?php include("function.php"); ?> <?php include("header.php"); ?> <?php include("headscript.php"); ?> <script type="text/javascript"> function noAcc(){ $.fallr('show', { icon : 'error', content … |
| | This code is not working INSERT INTO student_profile set student_id =MAX(student_id )+1; any body help me, my table student_id is abc0001, while inserting another student details it will be abc0002 but not working. |
 | I've got 4 tables: divisions (ID, Division) teams (ID, Team) scores(ID, RelationID, Score) relatives (ID, RelationID, FieldID, ValID) The relatives table is to 'link' divisions and teams by RelationID The FieldID defines the table (1=divisions; 2=teams) The ValID = the ID of the given table. So, my fk is a … |
| | hi all, i had this code working yesterday (to an extent any way lol). the first part of the code seems to be working correctly an tells me i am connected to the db. but then i am getting a an error saying no db selected. here is the code … |
| | I am running a unmanaged VPS - CentOS 6, 1gig of ram, 60gig storage, 256mb Vswap my.conf file: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql symbolic-links=0 max_connections=100 max_user_connections=30 max_allowed_packet=64M wait_timeout=30 interactive_timeout=50 query_cache_type=1 query_cache_size=4M query_cache_limit=1M long_query_time=5 thread_cache_size=4 key_buffer_size=16M table_open_cache=80 log-queries-not-using-indexes log-slow-queries=/var/log/mysql/log-slow-queries.log #innodb_use_native_aio = 0 innodb_file_per_table [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid MySql tuning logs:  ![myturnprimer.png](/attachments/large/4/5860e0cc711113ecbe783cad32fdaa7b.png … |
| | Hi Hope,everyone is doing good out there. I need some help regarding which strategy to use for one of my projects. Here are the project details I want to generate PDF forms, by gathering data from user.There are different questions to ask and based on each answer,we will ask next … |
| | This is the report.php view [CODE] if(isset($_POST["addReport"])) { $report = new Report(); $report->employee_id = $_POST["employee_id"]; $report->date = $_POST["date"]; $report->job_id = $_POST["job_id"]; $report->description = $_POST["description"]; $report->attachment = file_get_contents($_FILES['attachment']['tmp_name']); for($i = 0; $i < count($_POST['date_range']); $i++) { $report->request_date[$i] = $_POST["request_date"]; } for($i = 0; $i < count($_POST['date_range']); $i++) { $report->quantity[$i] = $_POST["quantity"]; … |
| | I'm still a noob in JavaFX, I can print the content of the table that I query, the problem is that I want the content to be placed inside the tableview. This is the code that I have done. public class TableViewController implements Initializable{ @FXML private TableView<studentInfo> tblViewer = new … |
| | i tried to upload some data from csv to MySql data base. but it not working someone help me on this. the below one is my code #!/usr/bin/perl -w use DBI; use strict; use TEXT::CSV; use warnings; my $driver = "mysql"; my $database = "test"; my $host = "localhost" my … |
| | Hi, I need MYSQL coding for develop a MLM Single Leg Plan as per below plan :- 1 Root 2 Child in sponser of 1 3 Child can be sponser with root or 1 4 Child can be sponser with root, child 1 or child 2 as on...... please help …  |
 | HI All , i have an offer table like offer_id , user_id , no_of_clicks , price...etc i want to fetch records and show to user like "best selling offer" , "value for money". best selling offer means the offer which sell more and displaying those offers to users. but what … |
| | Hi every one. I post a topic similar with this at mobile development section but posted here too because I need help from a VB.net programmer I want to create a software for my windows phone 8.1 but already stucked on online database. I tried to use this VB code … |
| | How can I List 15 longest words and their lengths in a table. |
 | Hi everyone i need some help down here. i am trying to connect multiple db and at the same time i want to sum the value of the column. what i have right now is this SELECT SUM(total) as branch1sales FROM icm.sales UNION SELECT sum(total) as branch2sales FROM hism.sales its … |
| | Hi, I would like to know if can we update one table's values while we insert or update values of another table. Both these table have relation but can not be joined directly. They have to joined with the help of a third table which has a common key needed …  |
| | Hi i m trying to count all for example vans who has record as Van1,Van2 ETC... physically in the database i have more than 200 Van1 ..but with select count gives me only 6.. SELECT COUNT(*) FROM route WHERE van='Van1' the rsult only 6 for others 0 and so any … |
| | Hi there. Hope somebody can advise on the following: I have created a table into my database which has a coloumn with datatype defined as DATE. The normal MySQL date order is YYYY-MM-DD, however I need to enter it in format DD-MM-YYYY. I am using php to insert data into … |
| | Hi every one. I want to create a software for my windows phone 8.1 but already stucked on online database. I tried to use this VB code that I use for 1 of my softwares Mysqlconn = New MySqlConnection Mysqlconn.ConnectionString = "server=db4free.net;Port=3306; user id=a****; password=******; database=****" Try Mysqlconn.Open() Dim Query … |
| | how to insert multiple checkbox values in multiple rows mysql database using php pdo? Please give multiple insert option Here is my script: $create = sizeof(isset($_POST['create']) ? $_POST['create'] : array()); $edit = sizeof(isset($_POST['edit']) ? $_POST['edit'] : array()); $delete = sizeof(isset($_POST['delete']) ? $_POST['delete'] : array()); $view = sizeof(isset($_POST['view']) ? $_POST['view'] : … |
 | Hi i have a table called hospitails. the table structure is as below **Hospitals:-** Hospital_id Bigint name varchar(45) city_id bigint district_id bigint state_id bigint now i need to search hospitals based on name,city_id,district_id,state_id. the query must cntain all the 4 fields. when user does not provide any of the value … |
 | Hey, I'm looking for decent MySQL tutorials for connecting a Database in Java. I'm using Java 8 so preferably would like tutorials that correspond with newest code. Thanks!  |
 | I have to make a select to get the info from db from a particular article id it it about an php to mysql database field edit. Thanks in advance! <? include "db.php";//database connection $order = "SELECT * FROM comanda where ['id']=''"; $result = mysql_query($order); $row = mysql_fetch_array($result); ?> <form …  |
| | hello every one i am creating form of 15 question length for 5 questions it worked but when i increase the length of question to 15 or 18 dont work plz help me it's urgent <?php //Start session session_start(); //Include database connection details require_once('connection/config.php'); //Array to store validation errors //$errmsg_arr … |
 | im working on a project .. SCENARIO:::in which we want to collect comment given by 3rd party users or end users and by seeing the comments we should give ratings! My IDEA:: i am grad student- intersted in algorithms and problem solving.. and my intention is to create a two …  |
| | how to insert text box value in mysql using laravel????????  |
| | hi guys , Need help on how to insert files (.docx,pdf and etc.) using laravel . |
| | Hi everyone, I am importing an excel file in php , in that file there are 10 lines,so it read that ten line and saves it in database. After that I inserted five more lines , while again I am inserting , it should avoid the 10 lines and should … |
| | Good Morning, This may be a simple yes or no, or hopefully if it is a no, someone can tell me how to work around it. I have a table that includes 4 columns named the same with incremented numbers in the names step1 / step2 / step3 / step4 … |
| | Dear All, I am looking for a tool which can help me generate reports and multiple types of charts. Can any one recommend based on their experience? I would like to manage to export minimal to excel and pdf too. I have seen one the php report maker unfortunately it …  |
| | I'm preparing a property website. Initially I had written the code for mysql and now moving on to mysqli in order to streamline, make more secure and use prepared statement I don't know much about this and just finding new information as an when needed. I used this tutorial to … |
| | Hello I use Ozeki ng to send sms through database user. The problem: After sending the sms, its status will not be "delivered". It remains "sent" despite the delivery reports arrive through the service provider connection. I followed this [setup guide](http://ozekisms.com/index.php?owpn=164) carefully, I installed the database user again and again, … |
| | Hi, i developing web application in core php. we have five panels superadmin, admin, medical, staff, customer. all records should be display superadmin and created by users. please help me to write a mysql query below my basic query. $user = $DB->prepare("SELECT `u_userid`, `u_username`, `u_password`, `u_rolecode`, `firstname`, `lastname`, `sex`, `age`, … |
| | sir whay this error msg is occurred :Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\xampp\htdocs\aa\connect_db.php on line 4 |
| | how to update multiple update in database using checkbox with php mysql <form action="enableprofile1.php" method="post"> //user id <input type="hidden" name="id1[]" id="id1[]" value="<?php echo $sn; ?>" /> //user id //enable checkbox <input type="checkbox" name="enable[]" id="enable[]" value="1" <?php if($en=='1'){ echo 'checked';} ?> /> //enable checkbox <input type="submit" name="save" value="Save" class="fontBold"> </form> |
| | I have a Yahoo website that uses phpMyAdmin. I've been given the directive "Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!" I do not know how to run this script (or any script) through phpMyAdmin. I've been looking online and … |
| | I'm sure this is simple, but I'm having a time trying to figure out how to add two fields from two different tables together. <?php include_once('conn/db.php'); $query = "SELECT SUM(`sold`) AS total FROM veggies"; $stmt = $con->prepare( $query ); $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){ extract($row); echo "<small><u>Plants Sold</u>: {$total}</small>"; } …  |
| | I am trying to come up with a query to track a student cohort based on their start term. I want to see if the number of students that started in 2012 actually go down in 4 years time. For this example I am starting with fall 2012 (12/FA). I … |
| | I am new for MySQL my tables structures are as follows Table: registration ---------------------------------- | cardNo | mainAgentId |subAgentId| ---------------------------------- | 100 | 1 | 4 | ----------------------------------- | 101 | 1 | 5 | ----------------------------------- | 103 | 2 | 6 | ----------------------------------- | 102 | 1 | 4 … |
| | Hi, sorry for my newbie question but I can't understand what is the different between Logical and Conceptual database design. Can you provide me with some samples for those two types of design? Also what design is generated with MySQL Workbench for example when you import database schema? Is it … |
| | |
| | hello all; scratching my head because I have no clue why this query doesn't work. php5, mysql 5.1 [code]INSERT INTO cats (title,type,cat_parent,cat_descr) VALUES ('Category Name', '0','0','Category Description')[/code] BASIC insert query. and the error I get ad infinitum is this: [CODE]Error: You have an error in your SQL syntax; check the … |
| | CREATE TABLE cash_dtL ( Cash_id varchar(12) NOT NULL, Dateof date NOT NULL, Cash_in_hand number(8) NOT NULL, Cash_in_bank number(8) NOT NULL, Sy_dr number(8) NOT NULL, Property number(8) NOT NULL, FD number(8) NOT NULL, PRIMARY KEY (Cash_id) ); INSERT INTO cash_dtL values('001', '01-JAN-15', 1000, 12000, 1200, 0, 1200); INSERT INTO cash_dtL values('002', … |
| | Hello Everyone, i have table that have some code list if user enter same code from 2 different systems and enter at the same time both user's get data, what i want is the first one will get the data the second one will only see the message that this …  |
The End.