10,938 Topics
 | |
 | Hello i have a problem with a Sql script `SELECT col1_id, col1_name, col2 FROM table GROUP BY ?????` col1_id col1_name col2 A john bear A john dog A john cat A john bear A john dog A john cat A john dog A john cat A john bear A john … |
| | So here's a little background to help with what I'm trying to accomplish (be mindful I'm also fairly new to MySQL): I'm creating a dynamically built navigation for a website using PHP and MySQLi. I've created a class called *Database* where I've got helper functions, such as connect() for connecting … |
| | Hi, I am developing a system that need to monitor machines' licence, so i have a field 'movedate' and 'outdate' every machines can only been kept for 2 years for most. and if the machine didn't go out for almost 2 years, an alert will come out to remind the …  |
| | Hello i want to UNION three tables from the same database. SELECT DISTINCT * FROM (SELECT uid as id, name as name, username as username,bio as aboutme, '' as text, 'user' as type, profile_pic as profile_pic, '' as media_pic, '' as group_pic, 'U' as mediatype, '' as image_path FROM users … |
 | Hi All, I am building an eCommerce website and I really new to PHP and MYSQL but loving the challenge. On my website I have 9 different categories of products with each page having about 8 items to sell. Rather than duplicating the code from each .php/.html file into a …  |
| | I have a webpage which helps download files from database. I want to count the how many times the download button has been clicked and display it on my webpage with unique id. This is my download webpage <div class="container"> <div class="row"> <div class="col-12"> <div class="media"> <img src="./images/<?= $mainImage; ?>" …  |
| | Hello please i have a download webpage which allow users to download mp3 files. I want to display the number of times a user has click the download button and display it on the webpage. The records are in a database and this is my code. This is my download …  |
 | Hello webmasters, I have a website about memes and I want to update the database each time the user scrolls down. I have no problem when I make a few requests to the database, but what if I want to do a lot of requests in a large database? I … |
 | <?php session_start(); ?> <?php include('dbcon.php'); ?> <html> <head> <link rel="stylesheet" type="text/css" href="style.css"> </head> <body> <div class="form-wrapper"> <form action="#" method="post"> <h3>Login here</h3> <div class="form-item"> <input type="text" name="user" required="required" placeholder="Username" autofocus required></input> </div> <div class="form-item"> <input type="password" name="pass" required="required" placeholder="Password" required></input> </div> <div class="button-panel"> <input type="submit" class="button" title="Log In" name="login" value="Login"></input> </div> … |
| | Hi, I am trying to insert to insert a video into a folder and its path into the database. But both the things are not working for me. And also I need to retrieve the video from database. Can someone help me where i went wrong. My html to upload … |
| | course curriculum using php mysql for multiple courses in html and php mysql |
 | inside mysql db which is table employe in coloumn *id_employee*, some data have a leading zero, etc : **id_employee : 0378192918 empy_name : Daniweb** i need to get id_employee for delete employe in my aplication, then i using ajax method like this : if(id) { alert(id); $("#deleteBtn").unbind('click').bind('click',function(){ $.ajax({ url: 'pegawai/delpeg.php', … |
| | Hi, I want to design DB for posts with multiple subcategories and categories. Example: Category has information: C#, PHP, JS, Python. Subcategory can contain: Logger, String, While Loop. A post table contain posts about "while loop" in PHP language and posts about "while" loop in C#. So, this is a …  |
| | i need help on this project it really makes me crazy... imnising access 2007 and vb6 together in my code im trying to make a report using sql query inner join on access database with aggregate function so sad the result is really bad.... the many to many relation ship …  |
| | Hello, So I have buttons on my site connected to a PHP code that updates the column "status" in "users" table with a value based on what button you press. This is the PHP script for that: <?php include('functions.php'); $servername = "localhost"; $username = "root"; $password = ""; $dbname = … |
 | I m working on a MLM project in which i have to store member automatically in binary tree form like 1 is root 2 is child of 1 3 is child of 1 Then 4 is child of 2 5 is child of 2 6 is child of 3 7 … |
| | how to fetch cricket scorecard to mysql database automatically for customization. i m planning to develop a game based on cricket. actually i am using php mysql database for it. i want complete cricket scorecard to mysql database automatically for customization. I m using snoopy class for content fetching from … |
| | I have a script that populates a form from MySQL database table row for editing. I'm performing MySQL SELECT and UPDATE via PDO. After editing a particular table row and clicking on the submit button, the table row doesn't update. The following is "modify-course.php": <?php // configuration require("../includes/config.php"); // query … |
| | I'm somewhat new to coding websites. I'm trying to have a code where it pulls multiple images from a single database and displays it in a grid, not a table. At the top of my page I have a normal connection to the database. (very sorry about not having a … |
 | Hi, When I was trying to create the IT Request Form and testing it out, I got some problems during the testing. The home page (index.blade.php) ended up getting an error called "Undefined offset: 1", maybe due to the table database problem.  The checkboxes in the Request Form (requestForm.blade.php) … |
| | I would like help with creating a form that when submitted, creates a webpage which is able to be edited by whomever submits the form; I would also like this url/link to be added to a database. |
| | Hi All, So I an creating an online store just to play around with code and learn from it. I am building a store and on the confirmation page, I am trying to update the QTY of items in a cart by using the '-' or '+' buttons. However I … |
| | Hi All, I am trying to create some search functionaltiy for my website, but for some reason when I search any word, even if its not in my database it will display all the results from a particular column. Here is my code <?php error_reporting( ~E_DEPRECATED & ~E_NOTICE ); define('DBHOST', … |
| | I am working on a anouncement system. the announcements are displayed everywhere in the website, every anouncement has a acknowledge button, basicaly to mark it as seen. what i have: Table: announcements: annId, annTitle, annContent, annDatetime Table: annComplete: annCompletedId, annId, userId, annCompleteDatetime I first pull all the announcements from the … |
| | Hello i have a mysql statement and i want to add more parameters to get different results. SELECT DISTINCT M.message,F.friend_one,F.friend_two, F.role,U.uid,U.username FROM users U,friends F, messages M WHERE ( U.status='1' AND F.friend_one = '88') OR (F.friend_two='88' ) AND F.role='friend' 88 is the users id so i want to show M.message … |
| | Hello i have a database which users make groups or send messages to other registered, in our project, users. So you have messages as M,users as U, groups as G. So you want to show all updates that happen in these tables WHERE (uid - thats the user id column … |
 | Hello php community, Could you help me in my research? I just cannot find what I am looking for. I am working on a website with PHP and MySQL. I am trying to get a filter option on my website to fetch the information from database. Here are the filter …  |
| | I have one table with questions and another table with correct answer If any user attempt question then I need result with marks.  I want result:-  Thanks in advance! |
| | Hi guys, This is my first post and so glad to start sharing the knowledge. I am using Mysql database with VB.NET and I have this code : Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim str As String = "Server=localhost;Port=3306;Database=testdb;Uid=root;Pwd=password" Using con As New MySqlConnection(str) Dim …  |
| | What's the difference between LCASE() and LOWER() in MySQL? I found places on the web that said they're similar but not a synonym for each other, so I'm not sure what the differences are?  |
The End.