7,368 Topics
 | |
 | hey guys! this is my first post to daniweb. and also i've not been so long on php. i m trying to manage customer transection records but stuck on one place and i need help.. here is my mysql table for transection of customer id-1 => +-----+------+----------+--------+------+-------| | svn | … |
| | Hi all, I am very new to php and am slowly trying to get something together. I have a MySQL database with a table that has (among others) a field which is TINYINT called "field1". I have managed to be able to store a 1 or 0 in it from … |
 | Hey I'm new to the website but I've been a friend of Dani for a little over a year and attend the DaniWeb meetups. I know I'll need coding help and as a noob I'll be seeking out the help of you experts in javascript w/ jquery & ajax, php, …  |
 | Hi everyone, Please help me to register the sql query exceutor in netbeans and java. I am using ireport 5.5.1 and netbeans 8.0 with jdk 8. The problem is that when i run the reports within netbeans, they run but when i build the project and run it from a … |
| | hey so im trying to save data but i get error: `You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE event_id = '8'' at line 1` this being the line: `$sql = mysql_query("INSERT … |
 | Hello everyone. I have juste started creating my website and I need some help. I have found a thread about this subject but it have been dead since three months back so I didn't get what I wanted from there. What I need help with is: I want to create … |
 | Hello world, I'm developing two applications: 1. Chat room 2. Forum The two are under the same domain : **chat_room**.ask.com and **forum**.ask.com What I wanna do is this, I want users who login to the forum to at the same time use the chat room without login in again...just like … |
| | here i have to store comapnyname,contactperson,city,place,maincategory,subcategory values.but i have 4 tables with data's like maincategory,subcategory,city,place. so how can i store the below data's in table.in spa table i added maincategoryid and cityid is enough or else these city and category i have to store in another table. please give some … |
 | i have a database 'phar' which need to subract its values 'stk' through the request made and gets updated to the db. i used arrays to do subraction.. but not able to store back the values to the db in its position.. my calculations work perfect, but not able to …  |
| | Im trying to delete from multiple tables using full outer join like this: $del_id = (int) $del_id DELETE contact, child, spouse FROM contact FULL OUTER JOIN child ON child_name = c_name FULL OUTER JOIN spouse ON s_name = name WHERE contact_id = $del_id I get warning/notice: unknown table contact in … |
| | I am new to Qt and I'm trying to connect a remote database. QSqlDatabase db = QSqlDatabase::addDatabase( "QMYSQL" ); db.setHostName("IP ADRESS"); // local or IP db.setPort(3306); // Default port is 3306 db.setUserName("DB USER"); // example root db.setPassword("PASSWORD"); db.setDatabaseName("DB NAME"); if( !db.open() ) { qDebug() << db.lastError(); qFatal( "Failed to connect." … |
 | How to select image from folder by name in mysql. This is mysql query for other rows $query = "SELECT `posts`.`id` AS `post_id`, `categories`.`id` AS `category_id`,`title`,`contents`,`date_posted` ,`categories`.`name` FROM `posts` INNER JOIN `categories` ON `categories`.`id`= `posts`.`cat_id`"; how to select row 'image' where is name of image and call that image from … |
| | Is there any syntax error in this code or query because i am not getting the required report? I have created a JFrame with JDatechoosr. When i select the dates and click view report, it gives me empty report while i know there is data within the specified date range. … |
 | I am trying a query in mysql. I have 3 tables which are linked by the same foriegn key ... Table 1 = students (PKey - stdnt_rfid_tag) Table 2 = student_attendance ( FKey - s_id for stdnt_rfid_tag ) Table 3 = users ( Fkey - s_id for stdnt_rfid_tag) In the … |
 | |
 | Cek this syntax: root@ubuntu:/opt/lampp# ./lampp startmysql XAMPP: Starting MySQL...ok. root@ubuntu:/opt/lampp# ./lampp status Version: XAMPP for Linux 1.8.3-3 Apache is running. MySQL is not running. ProFTPD is running. I already start mysql yet it's still unable to run. Why is it?  |
 | Hello to everyone. I have this table: CREATE TABLE `documents_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `active` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; I am trying … |
 | I have two problems with this code. 1. when i refresh the page it uploads the file again. 2. how to i validate the form if required fields are not filled ? i have added the code validation but its not working and there are no errors. <?php if (isset($_POST['upload'])) … |
| | I am trying to add a Mysql Report to Reporting Server. I can call the stored proc and all the info appart from the date will show. So i was wondering if there was a way to do convert the date in mysql |
| | I am currently trying to link a mysql Stored Procedure to a Microsoft SQL Reporting Server. It is coming up with a Syntax error. I believe this is down to the Date_from and Date_to Parameters. The query is below any help would be appreciated DELIMITER $$ USE `mydb`$$ DROP PROCEDURE … |
| | I was wondering if there is any way to do a single mysql query to do a count of filled positions in a multi-level structure to an indefinite depth. That sounds a bit cryptic, but this is what I would like to do if it is at all possible. we …  |
 | I need some help with this project. I've gone as far as I can go, with no results, The inquiry form works, but I need to populate it with my sql table. I could only screen shot my sql and I have no idea of how to put it on … |
 | Hi guys, Got a problem uploading an image to a directory and then including that directory location into the database so that I can display the image. Here is the code I have so far. <div id="main_right"> <?php if ($picture) { ?> <img src="<?php echo "../images/teacher_photo/" . $picture ?>" alt="<?php … |
 | Im doing a query and Im getting this: Error Code: 3. Error writing file '/tmp/MYYQVeZr' (Errcode: 28) Its not a space issue or a permission issue either:  Whats wrong? |
| | Simple timediff: SELECT time_format(timediff('2014-04-24 09:11:37','2014-04-24 09:09:37'),'%H:%m:%s') as dif Returns 00:00:00 . Im problably missing something stupid, my apoligies... |
| | I'm trying to add some mysql table columns to JSF table. And I'm getting error: /index.xhtml: The class 'logon.User' does not have the property 'description'. Please help User.java package logon; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table; @Entity @Table(name="users") public class User { private int …  |
 | I created a Virtual host using WAMP Server.Its working.But its DB connection not working. <VirtualHost *:80> ServerAdmin webmaster@kiwitravel DocumentRoot "c:/wamp/www/kiwi ServerName kiwitravel.localhost ErrorLog "logs/kiwitravel-error.log" CustomLog "logs/kiwitravel-access.log" common </VirtualHost> DB Connection class Database { const DB_HOST = 'localhost'; const DB_USER = 'root'; const DB_PASSWORD = ''; const DB_NAME = 'admin_kiwi'; public … |
| | Dear All, im testing out a way to get data from database depending on the drop down selection and displaying the data into a table by using php. now my first issue which is really really frustrating me because i've done this dozens of time is that i get `Notice: … |
| | I have a bunch of insert querys running and some of them fail with a duplciate entry. I want to see a log where it says "Error: Duplicate key" and that tells me the EXACT INSERT query that fails so I can see what keys are duplicated. Thanks |
| | I was taking a tutorial on PDO with PHP and MySQL and noticed I could not generate an exception from this code. I wonder what setting I need to put in place to generate the exception. If I shut down MySQL I can generate an error but with MySQL running … |
The End.