10,940 Topics
 | |
 | |
 | how to upload and download the Folder zip file in php??? |
 | Whenever i execute this, only the last row of the loop gets inserted even if i click on the first row or any row. What i need is: if i click register, the entire selected row must store in another table Whats wrong here? Please help me.. <table class="table table-striped …  |
 | hi frinds. hope you are well. as i writte this writting im thinking about a my [site](http://Iraniantranslate.com) .... how can i introduce my site to other people? and how can i popular it in google search? best regards,  |
| | Hi, I have problem to count a multiple condition in one query. Usually i have to select count it one by one just like this : SELECT COUNT(kod_urusan) as num1 FROM customer_info WHERE kod_urusan = '0001' SELECT COUNT(kod_urusan) as num2 FROM customer_info WHERE kod_urusan = '0002' SELECT COUNT(kod_urusan) as num3 … |
| | I know how to do a fetch array to create a while loop as well as the mysql query in ASC order. What I'm trying to sort out is how I might be able to make it create the ASC order but to ignore the initial words "The" or "A" … |
 | I have done master master replication . I want to do multi master master replication. I research and found mostly master master replication in circular topology. But I want to do one supermaster who reads and update other masters. Is it possible? Is anybody did this? |
| | Hi I am new in PHP. I have used dropdown to bind with my sql data. It is ok But I could not insert data into table only from dropdown. Other controls like text can be inserted. I have given code below. Pls advise me. Maideen <?php require_once '../inc/header.php'; ?> … |
 | how to fix this? Port 3306 in use by ""C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" MySQL57"! |
 | Hey everyone, I have been going over this in my head and can't seem to figure out the solution. I've got a database table called brands and in my form I'm trying to get it to where when I edit a brand, I can't edit it into an already existing … |
| | Hi. can someone help me with my problem regarding search function, i have hard time knowing where to insert my if(isset($_POST['search'])).................and so on codes within my phpfile. here is my code, (pagination working) <?php $sql = "SELECT COUNT(user_id) FROM view_onse_officers"; $query = mysqli_query($db_conx, $sql); $row = mysqli_fetch_row($query); $rows = $row[0]; …  |
 | Hi Dynamic Dependent Select Box last one not working Bank,State,District is working branch ont working please check below code Please help. index.php <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <style type="text/css"> .select-boxes{width: 280px;text-align: center;} select { background-color: #F5F5F5; border: 1px double #FB4314; color: #55BB91; font-family: Georgia; font-weight: bold; font-size: 14px; height: 39px; … |
| | I have a login session where it checks the user name and displays it to the form (it displays FirstName LastName). That username is also being used as a variable to pull up data in db. Now I also have another page where user's can update the db, I dont …  |
 | HI,everyone , I m stum in this question for long time, could somebody help me out, my output is success ,but the arrange in table is wrong. below is my code.. <?php $no_pensyarah=$_SESSION['no_pengguna']; $tahunsemasa =date('Y'); include '../includes/dbconnect.php'; $sql_rekod = "SELECT a.*,b.nama_subjek,c.nama_kursus FROM info_subjek_pensyarah as a, subjek as b,kursus as c …  |
 | I am looking for a mysql query to search and list most common pairs with their IDs and number of occurence. Thanks. |
 | Hi all, I am working on program that will connect to MySQL database, colect data from table and show them in grid. Where user can edit cell, and then on enter key changes will bi save directly into database table. Curent problem is that I am stuck at importing data … |
 | My scripts are doing a lookup of transactions in table B. Each transaction contains an integer which is an ID of the business for each transaction. I also want the name (a varchar) of the business in the original transaction. My solution was to do a 2nd lookup for each …  |
| | Hi, not very familiar with mysql. I have here a mysql statement: table customer: [CODE]CREATE TABLE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30), PRIMARY KEY (SID));[/CODE] table orders: [CODE]CREATE TABLE ORDERS (Order_ID integer, Order_Date date, Customer_SID integer, Amount double, Primary Key (Order_ID), Foreign Key (Customer_SID) references CUSTOMER(SID));[/CODE] My question is, …  |
| | I am trying to retrieved data from database and update a single column. column1 | column2 | column3 value1 | value1 | ------- value2 | value2 | ------- <=== this column3 rows does not have value in database yet so it will be blank when I retrieved the data Now …  |
 | [Click Here](http://www.acchajob.com) if (isset($_POST['createresume'])) { $university = $_POST['university']; $frommon = $_POST['frommon']; $tomon = $_POST['tomon']; $lavel = $_POST['lavel']; $courtitle = $_POST['courtitle']; $eduinfo = $_POST['eduinfo']; $typeskill = $_POST['typeskill']; $lavelskill = $_POST['lavelskill']; $skilldetails = $_POST['skilldetails']; $langskill_1 = mysqli_real_escape_string($con, $_POST['langskill_1']); $langskill_2 = mysqli_real_escape_string($con, $_POST['langskill_2']); $langskill_3 = mysqli_real_escape_string($con, $_POST['langskill_3']); $langskill_4 = mysqli_real_escape_string($con, $_POST['langskill_4']); $langskill_5 = … |
 | **USE SELECT...WHERE FOR TEXT FIELDS IMPOSSIBLE** I use SELECT search with WHERE fieldsname by VARCHAR imposible. But good use with INT fields. Why's that. Please tell me about it . My code as : <?php mysqli_select_db($connect ,'simple_login'); $sql = 'SELECT * FROM table where username= hai ' ; $retval = … |
 | my page ain't loading.. i think it its from the my comment querires .. pls some one help out <?php require_once 'dbconnect.php'; //select full thread from thread table $selFull = "SELECT * FROM frthreads WHERE threadId=".$_GET['threadId']; $selFullChck = mysqli_query($con, $selFull); $commentquery = "SELECT * FROM frcomments WHERE threadId =3"; $commentQuery …  |
 | I want to display records from my database in div and in a grid format using php. I want to set it to display 3 items in a row and then create another row and then display another 3 items continuously until the set limit but unfortunately only one item … |
| | Hi, i have installed prestashop 1.4.8.2 & i need a report of first order date for each customers, please help me to create mysql query. i need below columns information from database. id_customer, firstname, lastname, first order date thanks, Ritesh  |
| | Hi, i have installed prestashop 1.4.8.2 & i need a report of last order date for each customers, please help me to create mysql query. i need below columns information from database. id_customer, firstname, lastname, email, last order date. or is there any way i can export in active customers … |
| | i am getting this error when i process this form Notice: Undefined index: image in C:\xampp2\htdocs\trail\auction_upload.php on line 10 Notice: Undefined index: image in C:\xampp2\htdocs\trail\auction_upload.php on line 13 <?php session_start(); $_SESSION['message']=""; $mysqli = new mysqli('localhost', 'root', '','auction'); if ($_SERVER['REQUEST_METHOD'] == 'POST') { $item_name = $mysqli->real_escape_string($_POST['item_name']); $item_description = $mysqli->real_escape_string($_POST['item_description']); $item_image = … |
| | |
| | I currently have some code that gets the overall top 25 frame sales, which is as follows: `Dim FrameCountSelectStr As String = "SELECT TOP 25 Count(Glasses.OrderID) AS GlassesCount, Glasses.Manufacturer, Glasses.FrameName FROM(Glasses) WHERE FrameName <> '' AND OrderDate >= #" & SearchDateStart & "# AND OrderDate < #" & SearchDateEnd & …  |
| | Recently I tried many ways to retrive two columns from database. First I'll explain my database structure: Module Table mod_id,name,year,semester Lesson Table less_id,name,location,mod_id,year,semester,faculty I want to retrive mod_id,name from module table. I used this select query to do that : select md.mod_id as 'mdid',md.name as 'nme' from module md,lesson ls … |
| | hey guys I'm doing lms project. I created login page and php file. I can't find where I stucked. Here explanation of login form : * Check whether given username and password correct or not.. * If correct then check user type... * redirect to different pages according to user's … |
The End.