10,938 Topics
 | |
| | 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 |
The End.