11,093 Topics
 | |
 | 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` ( … |
 | i have to backup my database via php codes but i always ended up with an empty file? <?php include "connection.php"; $command = 'mysqldump -u root -p ***** –all-databases > dump.sql'; exec($command) or die(mysql_error()); ?> any help would be great |
 | i am actually working for showing online for loged in user. This is my code: $qt="select userid from plus_login where tm > '$tm' and status='ON'"; $result = mysql_query($qt); while($row=mysql_fetch_array($result)) { $uid = $row['userid']; $qt1="select first_name, last_name from signup where user_id='$uid'"; $result1 = mysql_query($qt1); while($rows=mysql_fetch_array($result1)) { $_SESSION['name']=$rows[0]." ".$rows[1]; echo $_SESSION['name']."<br>"; } … |
| | I'm an experienced ASP/MSSQL programmer trying to make the move to PHP/MYSQL and I've been able to wrangle my way up to now. I have a simple SQL query that works great in mymcadmin but gets lost in PHP. I've simplified it a bit here but this is the actual … |
| | I have a column name descrption in a table.. descrption contains multiple rows like claim for my new mercedes purchase my new car ------ ----- I am trying to explode each row and save each entery in a new column. claim :save in split1 for:save in split2 my:save in split3 …  |
 | I need to upload 5 images at ones with they labels I have made this before to upload many images at one it works fine but I need to have an label for each image how this can be done take a look at my code. this is the HTML …  |
| | Good Day Daniwebbers! Wonder if I can have some help. I am trying to build an 'admin panel' of sorts where the user can add content to their website, edit and delete it, all from one spot (Not unlike a CMS system I guess but purely for the purpose of … |
 | Me again, I have the following which should generate a form and populate that form. <?php session_start(); include("db_connect.php"); if(($_SESSION['user_id']) && ($_SESSION['access_level'] == 1 )) { ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <head> <title>Teaching Int Limited - Home</title> <meta name="title" content="Teaching Int Limited"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta … |
 | Hello, I have used Single Translation Table Approach to make multilanguage site in PHP. You may see [here](http://www.apphp.com/tutorials/index.php?page=multilanguage-database-design-in-mysql#single_translation_table_approach) The current index page is not working. My objective is to have one example to use these tables and display one working page. For example: It should work like [this](http://demo.codeursolitaire.com/multilanguage/index.php) **by using … |
 | Hi everone, Currently i am working on an Pharmacy management project in MVC2 model i have written an servlet code to fetch,insert,update,delete MySQL table contents from the JSP page but my problem is i could insert the data successfully but i am failing at Update and delete here is my … |
 | A while ago I explained how you could tag articles (see [this thread](http://www.daniweb.com/web-development/php/threads/387961/php-code-to-show-related-posts-on-a-blog)). Now you get a full working example. This code and the SQL script is also available on GitHub. The attached MySQL dump needs to be imported into your database, and you must update the credentials in the … |
| | Hi, I've run into absolute brickwall and am really desprate for your help please. I have a MYSQL Database with two Tables called user_comment and the second user_table. When a user register with the site, their details are kept in the user_table. the second table user_comment is so that users …  |
| | Hello I am trying to update the quantity value but I am not able to do it. As soon as the user clicks on Add To Basket, if the items exists I want it to update the value. At the moment, the quantity is one. //so this bit checks if … |
| | Hallo, This is funny. I export mysql codes to the webserver. Yet, I cannot run the codes correctly, there are some errors when I run the codes: Error SQL query: -- -- Database: `project_infracom` -- -- -------------------------------------------------------- -- -- Table structure for table `infracom_admin` -- CREATE TABLE IF NOT EXISTS … |
| | Hello guys i want create a table which willl consist of Regions and Location therefore when i take a region it should give me a list of locations under that region. i hope my question is clear enough THank you |
| | INSERT into tbl_inquiry (name,phone,email,subject,message) values ('apoorva','000012345','email@email.com','subject','hi what's up') |
| | |
| | |
| | I'm hoping that another set of eyes will see something that I'm not. I'm having an issue with a script that I just added a little routine to, so I know the issue is in the routine, because the sript as a whole was working before adding this... the routine … |
 | <?php if (isset($_POST['Login'])){ $Username = $_POST[ 'UserName' ]; $password = $_POST[ 'Password' ]; $user = 'localhost'; $pass = ''; $db = new PDO('mysql:host=localhost;dbname=ovs', $user, $pass ); $sql = "SELECT * FROM Voters WHERE UserName=:UserName"; $query = $db->prepare( $sql ); $query->execute( array( ':Username'=>$UserName ) ); $results = $query->fetchAll( PDO::FETCH_ASSOC ); foreach( … |
 | what iam trying to do is get field parameter and run mysql query to update(decrement) value from field quantity, can any one tell me how to do that? <form method="post"> <table class="bordered"> <thead> <tr> <th>No</th> <th>Drug Name</th> <th>Strength</th> <th>Quantity</th> <th>Dis Qty</th> </tr> </thead> <% try { String query="select * from …  |
 | I have written a code to add users into the database and validate their credentials when a user logs in. Only the added users are allowed to login and for non valid users, simply a username/password does not match error message is echoed. Password encryption and checking codes are not … |
| | Hey guys, me again. OK, I have this form that gets and populates the select boxes with the necessary info. Now, what I would like to do is to take the id field of the select box and use that to do a select query on the relevant table. So … |
The End.