10,940 Topics
 | |
 | can anyone help to check my coding? what i need is to enter the groupcode and when i click search,it will retrieve all the modules. but only one module that appear instead of all. <?php $server="localhost"; $username="root"; $password=""; $connect_mysql=mysql_connect($server,$username,$password) or die ("Connection Failed!"); $mysql_db=mysql_select_db("reportdatabase",$connect_mysql) or die ("Could not Connect to …  |
| | Please can someone help me optmize this query, it is slow and brings the same data for the debtage column SELECT customer.custid,customer.compname,customer.phone,customer.depot,acctofficer.acctfullname AS acctoff, STR_TO_DATE(mastorders.lastsuppdate,'%d-%m-%Y') AS purchdate, STR_TO_DATE(transactions.timestamp,'%Y-%m-%d') AS debtage, format( customer.balance, 2) AS balance, customer.balance AS balance1 FROM customer,mastorders,acctofficer,transactions WHERE customer.custid=mastorders.custid and acctofficer.acctoffid=customer.acctoff AND customer.depot='$depot' GROUP by customer.id ASC. … |
 | Hi, I am trying to insert data into 3 tables using mysql.. At first, I was able to insert in the first table (staffinfo), after coding for the second table insert (empinfo), It inserted into second table without inserting in first table AND finally it echoes 1 record added Successfully …  |
| | Raffle function to generate unique numbers for each player, related to the same table with a recursive aproach. I had to do a simple raffle system for a contest that I was working on and tried many things and the most simple and the most effective one to generate unique … |
| | I want to get the max(id) from a table colum with variable characters. it always returns 999 as the highest yet I have values like 6008 or even over 10000. I have tried the following: 1. SELECT Max(column_name) from table_name where column_name REGEXP '^[0-9]+$' 2. isNumeric as one of the …  |
| | Hello, I have looked everywhere on the web for a solution to this problem. I am trying to store arabic characters into mysql via an html form. i have set the meta charset to utf-8 and have tried mysql_query('set names 'utf=8'") but still i get garbled characters in my table: … |
| | Hi all, I need to do my own version of phpMyAdmin for my php class. I encountered problem when trying modify existing data on database. I don't know what would be best way to modify whole table's data when I don't know exact amount of rows or columns. At this … |
| | Hi there, I have a problam with my code, and i cant fix it, please help. The problam is with the mysql_num_rows on line 4 ; Here is the code: $sql_query = mysql_query("SELECT * FROM upload WHERE MATCH(username,text) AGAINST('$search_term')"); //additional check. Insurance method to re-search the database again in case … |
 | I recently upgraded MySQL 5.5 to 5.6 because I needed some features but now Im not sure which my.cnf 5.6 loads... I try editing the my.cnf in /etc with some lines such as "port=hello" but it still loads and starts correctly. How can I see the exact route of the …  |
| | Hi all, I have one problem on selecting larga data from mysql. I have inserted large data to mysql, and all data was inserted. I see it from phpmyadmin. but when i select that record from database it cannot display whole data.it doesnt show the end part of the data. … |
| | |
 | hi. i'm gonna ask about creating a system in database using Java .. i have a problem about making system because they didn't thought us how to create system... |
| | I want to prepare MySQL Server 5.6 for thousands/millions of inserts. Ive found this: •innodb_doublewrite = 0 •innodb_buffer_pool_size = 50%+ system memory •innodb_log_file_size = 512M •log-bin = 0 •innodb_support_xa = 0 •innodb_flush_log_at_trx_commit = 0 Is there anything else I can do? Thank you |
| | I am using MySQL 5.0 on WinXP pro. Below is the script for creating the table CREATE TABLE `tbl_test` ( `gameID` VARCHAR(45) NOT NULL, `gameName` VARCHAR(100) NOT NULL, `gameStartDateTime` DATETIME NOT NULL ); INSERT INTO `tbl_test`(`gameID`,`gameName`,`gameStartDateTime`) values('gameID1','gameName1','2008-01-01 1:00:00'); INSERT INTO `tbl_test`(`gameID`,`gameName`,`gameStartDateTime`) values('gameID1','gameName1','2008-01-01 8:00:00'); INSERT INTO `tbl_test`(`gameID`,`gameName`,`gameStartDateTime`) values('gameID1','gameName1','2008-01-01 12:00:00'); I would … |
 | Hello, I have tried to install mysql in linux and it said that I already installed it. Then the problem is I do not know the password to enter it. What should I do? davy@ubuntu:~$ mysql -uroot -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: … |
 | I am very confused with the pagination system of my site, the site consist two services android games and movies but in each they all have their categories for example the android games has categories as follows: * ANDRIOD GAMES * 1. Arcade 2. Sports 3. Action 4. Adventure 5. … |
| | I want to store my databases only on RAM. I see that in MySQL server I can choose the "MEMORY" engine and the table with be stored only in the RAM. How about MS SQL Server? How can that be done there? Thank you  |
 | Can you help to show how to upload multiple image with php and mysql, please? |
| | Hi I need to put google maps inside my website so that the user can add his location (manually) Then the location will be stored in the database so I can brows it in the display page.I've looking over the web but couldn't find the way to do it :( … |
 | 0 down vote favorite I have a table: CREATE TABLE `student` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `score` int(11) NOT NULL, PRIMARY KEY (`id`) Now i want to create a stored procedure that will insert new column into this table with the next id (which is … |
 | I am interested in how to know the price of building a website with shipping cart, is there any thumb rule out there for a non-IT expert to evaluate it. you'd better give me some price with website reference, you could also inbox me if you like. thank you |
 | Hi all, I've made a query that gathers info from several tables, after it was working, there was the need to integrate yet another table, however I can't seem to put it to work. I've seen some of this "witchcraft" before, but can't seem to find a tutorial, basically because … |
| | I have a query which i am trying to get the last date and when i do, the purchdate and LastPayDate is the same for all the data. the query is below: SELECT DISTINCT customer.custid,customer.compname,customer.balance AS balance,customer.phone,acctofficer.acctfullname AS acctoff, preAgg1.LastPayDate,customer.depot, MAX(mastorders.lastsuppdate) AS purchdate, MAX(mastorders.id) FROM customer,mastorders,acctofficer, (SELECT DISTINCT T.custid, Max(T.timestamp) … |
| | I am tring to perform a calculation in my query. I've been working on it for hours, so I need another pair of eyes to see what I am missing. Everything in the query is working except for the g.courseFee part. The course fee is not being added to the … |
| | Hi guys i'm creating a new table in sql to allow users to register with my website, this is the sql code that I'm suing does this seem ok to you? CREATE DATABASE `dyscaculia` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; USE `dyscaculia`; CREATE TABLE IF NOT EXISTS `users` ( `Firstname` … |
| | What I'm trying to make is something like this. jsfiddle.net/zunrk/ I want to create a receipt that when you pick the data from the drop down it will show the details on other text box. The other problem is that i wanna create multiple textbox because there will be multiple … |
| | Hey guys, I am having some difficulties regarding a select query logic. Then I have a table with products and it has a column -> submodel with all kind of data in it.  What I want to achieve is to **STRIP** (with REGEXP?) all the strings starting with … |
| | Oldest question in the book. Google says: SELECT NOW()+ 0; And a bunch of other things like UNIX_TIMESTAMP() but doing a select on these, it only returns the seconds, not including the miliseconds. Basically, I need, from MySQL's side the milliseconds. How can I do this? |
 | hi there im currently do some simple webpage that can submit the data save into database into MYSQL Workbench. But currently i have an error for insert into table. The error is --------------------------- App_Web_kclqmsmh --------------------------- You have an error in your SQL syntax; check the manual that corresponds to your … |
| | hi guys i'm creating my own website and i want to let users register and for them to be able to let them take a quiz. I have created this sql code CREATE DATABASE `dyscaculia` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; USE `dyscaculia`; CREATE TABLE IF NOT EXISTS `users` ( … |
The End.