10,932 Topics
![]() | |
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 … ![]() |
Hello to all, I am trying to display the images on my page through php from mysql database Problem is - Images are repeating , It always display only first image. <?php include("header.php"); include("connection.php"); $sql = "select Image from flood_light"; $result = $conn -> query($sql); if ($result->num_rows > 0) { … | |
Guys, ... and let's not forget the "Girls"! I am really starting to get pissed off at the searchengines. For 2 days now been googling (tried ask.com now too) searching for web proxy hosts as I want to run a free service like: http://anonymouse.org/anonwww.html But hardly any relevant results. You … ![]() | |
Hi I have a mysql tables shown below: ![table_structure.png](/attachments/large/3/62079f103c06a74ed0c3441ff7036bf7.png "align-center") I need to build a query to select all groupnames a user belongs to in a single field seperated by ',' e.g. I wanted to following results id fname lname groups 1 connor Faulkner group_one,group_two 2 Maisie Yates group_four,group_three Just … | |
hi everyone.. please my code is having an issue... i made a select query and its displaying the error in the IMAGE attached... the code is also attached... pls what could be the error.... the image ain 't uploading....so below is the error... ( ! ) Warning: mysql_fetch_array() expects parameter … | |
I want to start a website like hippofile, cnet download, filehorse or freewarefiles in Wordpress Anyone who knows a Wordpress theme with which that I can build a website like hippofile, cnet download, filehorse or freewarefiles in Wordpress Many thanks | |
I don't have such problems as mentioned. Yesterday MySQL 5.5 couldn't open database. I repeated an effort, but with no result. I have to open database in 3 days up to Monday. | |
I am querying a MYSQL database and would like to return the results so that all of the job numbers that are the same are grouped together and expandable when clicking on the common name. so when the bag loads all you see is a list of job numbers. I … ![]() | |
I have been butting my head against this problem for the past 4 hours, and I have to tap out. I know I can't be too far from correct I am just not sure what the missing ingredients are. Here is the problem question: Student status: List of all students … |
The End.