2,569 Topics
 | |
 | My site use to work fine. But today for some reason pages with mysqli_num_rows takes a very long time to load. I can visit the page but it takes a long time to load. When it loads there are no errors but the error file in the root directory have …  |
| | Hi all, I wanted to procedure to return number of days and weekdays between two dates. This is what I came up with and it seems to work ok, but I'd like to read what others think. And if there's already a single line function for this, oops. Also, I'm … |
| | I am working on an app where a user registers and its passed to the server where there information is added to the database. It passes various checks along the way but ails to add the user. Code below: <?php $con = mysqli_connect('localhost', 'root', 'root', 'eat4lessaccess'); //check connection if(mysqli_connect_errno()) { … |
 | Hello. I have a quick question. I am making a database as a personal project (I am using Microsoft SQL Server therefore I am using its SQL syntax). All it does is that it keeps track of singing groups and bands, the members in these groups, albums they made, songs …  |
 | All Time Show Null value Please help me what is the wrong in my code declare @mxdbvlu int declare @dbvlunm int set @mxdbvlu= (select max(Database_name) from TBL_FY_SELECT_1) if @mxdbvlu = null set @dbvlunm=1000 else set @dbvlunm=sum(@mxdbvlu+1) select @dbvlunm,@mxdbvlu  |
| | here is the normal rows coming  i want to show the group by product name with the count of store as the below picture  here are mysql query SELECT i.barcode, i.name, u.company_name, COUNT(i.id) AS IQTY, COUNT(U.id) AS UQTY FROM inventory i, USER u |
| | can someone please help me with coding. I need to create a dropdown menu with the options being the category the user has inputted into a file upload page. |
| | How do I echo selected option? <?php session_start(); if(isset($_SESSION['cherianne'])){ }else{ header("Location:login.php"); } include("../includes/header.php"); // Retrieve our critical page setter variable. $char_id = $_GET['id']; //echo "<h1>$char_id</h1>"; // set this as a default value if (!isset($char_id)) { $result = mysqli_query($con, "SELECT bid FROM cde_blog LIMIT 1"); while ($row = mysqli_fetch_array($result)) { $char_id … |
 | CREATE TABLE Peaje ( id_no_pk CHAR(2) NOT NULL, nombre VARCHAR(30) NOT NULL, localizacion VARCHAR(30) NOT NULL, dirrecion VARCHAR(50) NOT NULL, tipo CHAR(1) NOT NULL, municipio_fk CHAR(2), CONSTRAINT Peaje_id_no_pk PRIMARY KEY(id_no_pk) CONSTRAINT Peaje_municipio_fk FOREIGN KEY (municipio_fk) REFERENCES Municipio(id_no_pk)); CONSTRAINT Peaje_municipio_fk FOREIGN KEY (municipio_fk) REFERENCES Municipio(id_no_pk)) * ERROR at line 9: ORA-00907: … |
| | after i key-in the form, the function change the whole column with the same value for example if i put first name JOHN it will update whole column with JOHN <?php session_start(); require_once("connection.php"); if (isset($_POST['edit'])) { session_start(); $s=mysqli_query($con,"UPDATE user SET first_name ='" . $_POST['first_name'] . "'"); $row = mysqli_fetch_assoc($s); if … |
| | So I am really interested in making a database, I have knowledge about html and css, not javascript and I just want to begin learning and making a database. I am going to use this website: https://www.000webhost.com/?utm_source=000webhostapp&utm_campaign=000_logo&utm_medium=website&utm_content=footer_img so you can see my website in the internet, I don't really expect …  |
 | I am currently creating a product lookup system for a project of mine, however from reading around it has come to my attention that an OLEDB connection will not handle the SQL query below as it will not handle more than a simple "SELECT, FROM". Table: tbl_ProductInformation Field: Product_Name CurrentEntry … |
| | I do not have a clue as to what the problem is with this code. I am running php 7.0. This was an old form I used long ago, decided to upgrade it for random use. It works on php 5.0 but not in 7. I have run it through …  |
| | Please I need your help, I am new to PHP and I need your help in inserting multiple select array into the database in the form of this. This is what I want to achieve. My table has 3 columns (id, examno, results). I want results column to be inform … |
| | Please I need your help, I am new to PHP and I need your help in inserting multiple select array into the database in the form of this. This is what I want to achieve. My table has 3 columns (id, examno, results). I want results column to be inform … |
| | Hi everyone! i have a question that, if there are two radio buttons Male and Female, if some select male,this value will be store into database, but if he select again another value which is female,then how the first value(Male) will be replace by second value (Female) in the database … |
| | If an index file is missing in a folder, apache uses its own file/files to list the contents of the folder. Since I don’t want to create an index file in every folder in the file systems, I wonder where I can find the file/files that apache uses when there …  |
 | I use MampPro to setup my sites on the local server... all well and good. So, every time I fire it up I get the upgrade nag... so, I figure its time, and hit the upgrade... and it does its thing. BOOM, every database I had there - gone! GRR! … |
| | Hi all, How to store data in two different tables when we click the button. Suppose I have a 2 tables named as team1 and team2. In table team1 have 2 fields teamid,teamname In table team2 have 3 fields team2id,team2name,teamid here teamid is foreign key. So when i click on … |
| | Hello! I have a question and I don’t know whether the title is actually descriptive. For some background on the matter, we use Sage 50 as our merchandise information system and for our reporting and controlling tools we run Access queries. Since our database had been reset at some point … |
| | Hi, I have a form which consists a dynamic dependent dropdown and I want to maintain the entered data into the fields after the form is saved or edited. For an example: <input type="text" name="serial" value="<?php echo $serial;?>"> Similary i need to get the value in my dropdown as well. …  |
 | I have storing major data in mysql and logs are stored in cassandra. Cassandra db getting heavier and difficult to do queries. So I want to migrate all my cassandra's table in mysql is it possible? |
| | in sql server there is a group problem statement: DENSE_RANK() OVER (ORDER BY TABLUONGNV3.HOVATEN) AS STT How to write in sql access issues in groups? I'm not writing well: (Select Count (*) FROM [TABLUONGNV3] as Temp WHERE [Temp].[MANHANVIEN] < [TABLUONGNV3].[MANHANVIEN]) + 1 AS STT SELECT (Select Count (*) FROM [TABLUONGNV3] … |
| | My data SQL Server is reported this error, How does this error fix you ? SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0x5555aaaa). It occurred during a read of page (1:210768) in database ID 7 at offset 0x00000066ea0000 in file 'G:\Database\MyData.mdf'. Additional … |
| | In MySQL Database i have a worker who has 1 year of leave days (about 360 days): +--------+---------+---------+-------------+---------+-----------+ |ID_LEAVE|ID_WORKER| BEGIN_DATE | END_DATE | +--------+---------+---------+---------+------------+------------+ | 4 | 26 |2019-03-19 07:00:00 |2020-03-19 15:00:00 | +--------+---------+---------+----------------------+------------+ When i I'm going to run below Mysql Command which calculates leave time without weekends and … |
| | Show error when I login to the SQL server management. First, I change the server name. Second restart the server/1st stop services the start services. Then I check the server name SELECT @@servername AS 'ServerName' using this line the show new change server name. Then I closed the window of …  |
| | TITLE: Connect to Server ------------------------------ Cannot connect to (LocalDb)\MSSQLLocalDB. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote … |
| | hi, i have installed XAMPP, but i would like to run my localhost from another computer.. |
 | Hi group, I'm attempting to populate a listview with data from my test database created via Visual Studio 2019. I'm getting a syntax error that says, "Incorrect syntax near the keyword 'FROM'." It's not clear to me what the error is. The code I've written is as follows: Dim strQ …  |
| | Please, why I got this error(SQL Error: ORA-00907: missing right parenthesis ) whats wrong in my code? CREATE TABLE DomeniuAB(ID_DOMAB NUMBER(10) constraint ID_DOMAB_PK PRIMARY KEY , DENUMIRE VARCHAR2(20) NOT NULL, DETALII VARCHAR2(20) NOT NULL, ISBNAB_CarteAB VARCHAR2(15), CONSTRAINT ISBNAB_FK FOREIGN KEY (ISBNAB_CarteAB) REFERENCES CarteAB(ISBNAB), CNPAB_AutorAB NUMBER(10), CONSTRAINT CNPAB_FK FOREING KEY (CNPAB_AutorAB) …  |
| | Hi group, I'm trying to store the information from a various textboxes into my database. However it is not writing the data (I'm getting my planned error message, "New Record FAILED. Please contact your systems administrator." From the code below, do you see where my error may be? What corrections …  |
| | Hi there here is a stupid question. I have created an update statement that updates a table that has null user id using a name as the identifier: [CODE] UPDATE dembel SET userid = 8908 WHERE [Name] = 'o'reily' [/CODE] However the the name already contains an apostrophe which causes … |
 | Hi, I want to make online shop and I made most of it but I have problem on product page.I want for "customers" ( this is my personal project so ... ) to be able to choese and then what they choese to be store into table. I struggling with …  |
| | hello every one please can any body do this task for me please becouse our instructor in the university uploaded it and I dont have enough time becouse im studying for my final exams please any one and i will be helpfull for him/her :) this is the task Create … |
| | I'm writing stored procedure with dynamic sql having dynamic table name as, CREATE OR replace PROCEDURE Pr_get_result (p_table_name IN VARCHAR2, p_object_Id IN VARCHAR2) IS p_prop_code VARCHAR2(50) := 'pH'; BEGIN EXECUTE IMMEDIATE 'DECLARE ' || ' TYPE ObjCurTyp IS REF CURSOR; ' || ' v_obj_cursor ObjCurTyp; ' || ' v_stmt_str VARCHAR2(32000); … |
| | Hi, I need help to create a relational database for shop.The database should contain a column for barcode in order to register items and also to read details of items using barcode scanner.Besides this database will contain tables for performing all operations for shopping store items what are those operations … |
| | |
| | Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in C:\Users\USER\Desktop\Final Year Project\XAMPP\htdocs\littleavenue\shop.php on line 320 <?PHP if(!isset($_GET['product_category'])){ if(!isset($_GET['category'])){ $per_page = 6; if(isset($_GET['page'])){ $page = $_GET['page']; } else { $page = 1; } $startfrom = ($page-1) * $per_page; $getproducts = " SELECT * FROM products OREDR BY 1 DESC … |
| | Hi group, I'm attempting to write code to check to see if an existing account number exists. The user is to input a 10 digit account number. The code then is to query the database to see if that number exists. If it does, the message box displays the message …  |
| | Hi, I want to display the avearage row as images. Is it possible? function reviews_average(){ $avgproduct_id = escape_string($_GET['id']); $avgquery = "SELECT avg(rating) as average_rating FROM reviews WHERE product_id = $avgproduct_id"; $avgresults = query($avgquery); confirm_query($avgquery); while($row = fetch_array($avgresults)){ $avgratings = **--THIS IS THE ONE I WANT TO DISPLAY AS IMAGES--** "{$row['average_rating']}"; … |
| | I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset |
| | I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset |
| | can we able to count how many number of resultset is returned by a stored procedure? i have a sp which will result in multipe resultset. more then 6.sometime 4 sometime 6 based on the parameters. so i need to count how many resultsets are returned by the sp |
| | I have a table where I want to update "time 2" row, in the user's last "time 1" entry. I was try this, but not function. UPDATE `temp` SET `time2`=NOW() WHERE user = 'kraso' (SELECT max(time1) FROM 'temp') |
| | Guys, do you know if I can use SQL in Mobirise? As it's a pain to set all coming mail to separate file manually out of Mobirise's forms. I'm not sure that it's possible to bring any changes to the code of the forms at all. Thanks |
| | I need to create a database from the messages, coming from the Mobirise website builder's forms. What code should I use? This doesn't work. Could you please help me. $link = mysqli_connect('localhost', 'root', 'password'); if (!$link) { $output = 'Unable to connect to the database server.'; include 'output.html.php'; exit(); } |
| | Hello everyone , I have find i script made in 2013 that use Mysql , Today the mysql has removed and remplaced by Mysqli or PDO Can any one help me please to convert the mysql code to mysqli Exemple : <?php $num_queries = 0; $total_time = 0; class ADO … |
 | Hi, How can i make query for this: Table1 Column1 Column2 LS11111 0 LS22222 100 LS33333 10 LS44444 0 LS55555 25 Table2 Column1 Column3 LS11111 100 LS22222 80 LS33333 25 Result i need is Column1 Column2 LS11111 100 LS22222 100 LS33333 25 LS44444 0 LS55555 25 Column1 is same on … |
| | In Access I want to group and assign data according to conditions with 2 values 0 and 1 (true or false) and with the condition NGAYGIAO>= #01/01/2019# and NGAYGIAO <=# 31/01/2019# me How to write commands ? The data I put in the excel file consists of two sheets: Original … |
| | I want to calculate the total conditional in the month but remove the records that are not the same month and not the same year, the condition that eliminates the view on the sql access because the result is true or false in the excel file http://www.mediafire.com/file/kq2mr2v6px1uxan/exercise.rar DOANHTHU2: Sum(IIf(Not IsNull([DONGIA]),[SOLUONG]*([DONGIA]/1000000),[SOLUONG]*([DONGIATT]/1000000))) … |
The End.