11,093 Topics
 | |
| | |
| | Hello, I'm trying to make notification when msql column reach a certain number. For exemple, I have table "items" with products, witch in their structure have columns id, name and quantity, and when column "quantity" reached 5, I want to make automatic notification: - In new table called "notifications" witch …  |
 | HI! Just setting up my site... first thing I see after domain working is..... Fatal error: Call to undefined function session_is_registered() in /home/vhosts/www.universal-abundance.com/config.php on line 87 Any ideas..... I'm db impaired! Thanks, L-D |
| | Hello, I have a table called product and whenever the value of the field stock = 0 I want to send a notification email to a specific email address. I would like your help guys on how I can implement that and if this is possible. I considered using PHP …  |
| | Hey everyone, Sorry for the lack of knowlege. I've tried google-ing how to imput and display images on a web page without the image showing up in weird symbols, but I've had no luck. Can anyone help me? My purpose is to simply store an image manually into a mysql …  |
| | -- phpMyAdmin SQL Dump -- version 3.4.5 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 29, 2013 at 04:31 PM -- Server version: 5.5.16 -- PHP Version: 5.3.8 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET … |
| | I have a MySQL dump and the dump has timestamp datatype. But the values are not escaped in qoutes. I want to write a regular expression to write to match the time tamp column and replace it by enclosing in quotes I have some thing like this: 2006-02-15 04:44:00 I … |
 | hi, im a newbie and just read about triggers.. i am trying to create a trigger using navicat for mysql in the triggers tab for the table i select new trigger with update after insert( these are the ready options it has) then in the definition i added ` DELIMITER … |
| | Hello Guys, During the process of making my website I have been stopped by a problem. Background Info: I am using jQuery sortable lists and I have multiple lists on the site which submit the information to the file that updates them in the database. Problem: If I want to … |
 | Hi All, I am running the following query: UPDATE YFR_Master_Fundraisers SET FRActive=0 WHERE FRNameCode IN ( SELECT FundRaiser FROM YFR_Master GROUP BY FundRaiser HAVING MAX(CollectionDate) < DATE_SUB(CURDATE(),INTERVAL 2 MONTH) ) It is giving the error described in the subject line. The query seems to be taking too long and timing … |
| | Hi I am having a problem with the following line: $query = mysqli_query($link, "UPDATE `getgigs` SET `venue` = '$venue', `town` = '$town', `phone` = '$tel', `website` = '$web', `email` = '$email', `address` = '$add' WHERE `rock` = '$url'") or die("Error: ". mysqli_error($link). " with query ". $query); It is telling … |
 | Hey guys, think I've just been staring at this problem too long to find out how simple it is to fix... worked with several methods of finding and saving image dimensions to MySQL (actually used this same method several times), but the MySQL width and height is not populating this … |
| | I have a site where I upload data into mysql database. When I upload my text, it is just the way it was uploaded in mysql, but when I call for the text upload, in my php page, there are no paragraphs. Everything is just muddled up. what could be …  |
| | I need to get the Club_ID of all the clubs that have more than one member; Here is the sql: CREATE TABLE `Members` ( `ID` INT NOT NULL AUTO_INCREMENT , `Club_ID` INT NULL , `Name` VARCHAR(45) NULL , PRIMARY KEY (`ID`) ); INSERT INTO `Members` (`Club_ID`, `Name`) VALUES ('1', 'Jim'); … |
| | First You Must Download ODBC 5.2w at http://dev.mysql.com/downloads/connector/odbc/ Next Open Your ODBC And click Add  Next click MYSQL ODBC 5.2w Driver  Click Finish And  Click OK and Click OK Again Creating Your MYSQL Create Database With Name data Create Table with name user_data CREATE …  |
 | Hey guys, I want to connect my **VB.NET application to the data saved on my webserver's mysql database**. Can you please tell me, is it possible or not? Can you give me any hint for further coading? Where should i look for help in this regard? Or should I consider … |
| | I have to sync with two tables in the database The following is the error I get: *A database error has occurred Error Number: 1054 Unknown column 'Array' in 'field list' INSERT INTO `client` (`interior_client_name`, `Interior_client_email`, `interior_client_mobile`, `interior_house_id`) VALUES ('a', 'b', '8989898', Array) Filename: C:\xampp\htdocs\ThinkInterio\system\database\DB_driver.php Line Number: 330* These are … |
| | I think this is probably too ambitious, but I though I'd ask anyway. I have a list of about 13 000 music venues, including their name and location, but would like to add phone no., website, and email to that information. To do this manually would take a long time, … |
| | Hi Experts, Which database is better acc to Performance factor. Need Suggestions.. |
| | Hello Today i install mysql on my system and after that when i try to run the server it didn't start from the startup and when i try to run theserver through cmd i found the given error. C:\Program Files\MySQL\MySQL Server 5.6\bin>mysql ERROR 2003 (HY000): Can't connect to MySQL server …  |
| | There are two products Harmony Field Unit, and Tuner. The Harmony Field Unit has a Test Date, Test Station, and Test Results that need to be tracked. The Tuner has a Serial Number, Firmware version, and Hardware Version that needs to be tracked. The Harmony Field Unit is made up … |
| | # Creating a register and login page, by creating a mysql database and all php files. # ## I was reading a [thread that is dead](http://www.daniweb.com/web-development/web-design-html-and-css/threads/97183/to-create-a-registration-page-and-login-page) now, so i started this one: ## **Simple PHP login:** Create a database (mysqladmin) Name the table "dbUsers." It will need 4 fields: Name … |
| | Hey guys, I'm planning to develop a java web text editor which stores its entries on a MySQL database and is then private for every user. This is a learning curve for me and I will share all of my findings and such on here. Can anyone give me any …  |
| | Hi all, I created relationship among table using Data Modeling (MySQL Workbench). When I forward engineering the new model, only the data but relationship among them are not updated. Any hint for me? Thanks a bunch. |
 | <html> <body> <?php $username = 'root'; $password = ''; $hostname = 'localhost'; //connection to the database $con = mysql_connect($hostname, $username, $password,'contactmanager') or die('Unable to connect to MySQL'); echo 'Connected to MySQL<br>'.'<p>'; mysql_query($con,'INSERT INTO Personalinformation(Name, YearOfBirth, Email,Location,PhoneNumber) VALUES(Peter,2008-03-05,peter@hotmail.com,kasland,0269015748)'); mysql_close($con); ?> </body> </html> |
| | So I am trying to create a blog in php and mysql. I am not sure how this is going to work out there. Just let me know if i am on the right track with the DB. Let's say i have database called blog with table user and posts. … |
 | This php code updates a database entry. The form consists of a checkbox (name = download) and a hidden field so I can check it has actually been sumbitted(name = updated). When I run this code it gives me the success message but the database remains unchanged. Why is this? … |
| | I've got a mysql query that should return a single cell SELECT `download` FROM `images` WHERE `owner_un`='$owner' AND `url`='$url' How would I echo the result of this? Thanks for any help  |
 | Hi all I am new to java programming. I need a litte helop. I want to take some results from database so i am trying to connect to database. I have dowloaded jdbcmysql connector but having no idea how to add it in eclipse or jre. Plus i am having …  |
 | hi all! i have here a code. <?php /** * Main.php */ include("include/session.php"); ?> <html> <head> <title>Export to Excel</title> </head> <body> <form action="saverec.php" method="post"> <?php define ('DB_NAME', 'vincegac_vince'); define ('DB_USER', 'root'); define ('DB_PASSWORD', ''); define ('DB_HOST', 'localhost'); $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if (!$link) { die('Could not connect: ' . … |
| | Hi all, I have a very simple question, for many of you.. I need to write out a select list like this : From table pages, I need id and link to fill up the options in my select list. But I need to tjeck in another table, if there … |
| | i have stored some value into DB table and want to get them displayed on my form with a restriction that the column title in DB and the Value of the previous feild are same and only the cloumn rows are shown inthe following feild in the form....!!!! Cant Figure … |
| | hi can any one share some possible way to print an invoice when some thing is registered in a form using PHP and redirects it to html page for printing my form is ok and stores data.... redirects to the disered page as well now i have html lay out … |
| | Hi, Im trying to connect to a database but it doesn't seem to work. This is the code I'm using: [CODE] #include "stdafx.h" #include <iostream> #include <my_global.h> #include <mysql.h> using namespace std; int main(int argc, char **argv) { MYSQL *conn; conn = mysql_init(NULL); if (conn == NULL) { printf("Error %u: …  |
| | Hi, I am trying to create a simple form submission using php and mysql. I am stuck at very basic level of mysql and php code. Here is what i am trying to do. 1. index page where name and email data is shown. 2. add-data.php page where i am … |
| | Hi all, I'm trying to run a stored procedure: BEGIN SELECT YFR_Master_Fundraisers.FRName, YFR_Master_Fundraisers.FRActive FROM YFR_Master INNER JOIN YFR_Master_Fundraisers ON YFR_Master.FundRaiser = YFR_Master_Fundraisers.FRNameCode GROUP BY YFR_Master.FundRaiser HAVING MAX(YFR_Master.CollectionDate) < DATE_SUB(CURDATE(),INTERVAL 2 MONTH) AND YFR_Master_Fundraisers.FRActive = 1; END But I'm getting the following error: Procedure execution failed 1312 - PROCEDURE db355379982.Deactivate can't … |
 | Hi buddies how are you, now am using replication for mysql database from one server to other Master-slave replication, using this article https://www.digitalocean.com/community/articles/how-to-set-up-master-slave-replication-in-mysql but this not satisfied my needs, I have multiple server and all their databased replication to single slave server to be more accurate, I have servers **A**, … |
| | I have the following mySQL query, and for some reason I can't get it working. I have two tables: exp_competition_purchase_upload_total contains a member id and total_uploads column. exp_channel_titles has lots of columns, but the two I need to check is author id and channel id. My aim is to query …  |
 | CASE WHEN ((SELECT COUNT(id) FROM users) > 0) THEN BEGIN INSERT INTO users(username,password) VALUES('Moshe','Ahuva'); END ELSE BEGIN INSERT INTO users(username,password) VALUES('Zvi','Idan'); END END My aim is to save with a condition. but it fails and says: "Check the manual that correponds to the right syntax near ELSE BEGIN ....". please … |
 | I currently have $tableName="thenameofthetable"; $someid=$_GET["someidthruget"]; $result = mysql_query("SELECT name,age FROM ". $tableName. " WHERE idp=". $someid); Which looks really insecure. How can I do it using a stored procedure which I think will make it a lot more secure? Thanks |
| | How to I check for existing username without using mysql in php? I tried something like this but it isnt working. Please help. Thanks. Strictly no SQL... $name=$nme; $name = file("datatext/users.txt"); $ic=file("datatext/users.txt"); if (this.$nme== $name) { echo "this user exits, please log in"; } |
| | Hi: i search as to why my database wont send out emails and find this forum. i find the exact code im using in this forum.. it originally is for xaamp. i need to have it work from my server: http://www.daniweb.com/web-development/php/threads/412468/how-to-send-mail-to-email-address-on-mysql-database. i posted on https://gist.github.com/amkaos/5608094 but i can post code … |
| | Hi all I'm really hoping someone here can help me out with this one... I'm trying to search through a table via php but having difficulty with case - The problem is the data I'm searching through is encrypted (aes_encrypt) and it doesn't seem to matter what I do the … |
| | Hi guys, I'm new here. I have a problem with connecting to my sql database. Everytime when I want to log in, I get this : Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\novi\funkcije.php on line 9 Warning: mysql_query() expects parameter 2 to be resource, boolean …  |
 | There's a error when I run this jsp file --> **" pstmt.executeUpdate();".** **"org.apache.jasper.JasperException: An exception occurred processing JSP page /TestAdd.jsp at line 39"** My code essentially have a text box for users to enter a value, and then the value is sent to the MySQL database. Any help is appreciated …  |
 | There are two tables "LESSON" TABLE Attributes : - id_lesson -lesson_name - semester "LECTURES" TABLE Attributes : - id_lectures - id_lesson - id_lecturer - hour - day How to display all atributes in lectures table where lessons in 2nd semester ? Note : there's id_lesson in lectures table  |
| | ok here is the login function from my class user which parent class is a Db connection file <?php require_once("DBConnection.php"); class User extends DBConnection { .... .... ... ... public function Login() { $sqlSelect = "select `UserName` from `user` where `UserName` = '$this->userName' and `Password` = '$this->password'"; $result = @mysql_query($sqlSelect, … |
| | Hi All I'm sure I'm missing something very small - and embarrassing! I'm being lazy - I could have entered the data manually, but wanted to automate it. I have a small csv file containing swimming meets, dates and locations along the following lines: May-13;;;; 17;other;Level 1 Program 1;Arboretum; 24;other;All … |
| | Hey everyone, So I did some more searching and I found a link that sort of helped me figure this thing out in a sense.. Here's the link https://developers.google.com/maps/articles/phpsqlajax_v3 . When I do all of what the site told me to do, it did give me a map but it … |
| | I need to convert mysql class of one script to make a support for sqlite,but problem is sqlite dont have username/password thing nor database select as well,which means how some parts need to be removed.If i would convert to mssql one search and replace probaly would do the job.There is … |
The End.