11,093 Topics
 | |
| | Hello! I have a problem which I don't know if it is related to MySQL or Python. I am writing a database using wx.Python and MySQLdb. My problem is that when I want to send some string which contains accents to the MySQL database (for instance, 'Empordà ') it is inserted … |
| | Hello! I have a problem which I think it is related to Python, however I may be wrong. I am writing a database using wx.Python and MySQLdb. My problem is that when I want to send some string which contains accents to the MySQL database (for instance, 'Empordà ') it is … |
| | I am newbie to MySQL.I create a database in MySQL in command shell by "create database DBNAME". But I can not use my own created database.So friends help me how to log into my database named "DBNAME" because I want to create some tables in that. Thank You |
| | After close to 40 years of programming one might think that databases would be a well known subject, but it's not for me. In fact I have never had a need for a database until now. I have installed Joomla because I want to develop my websites faster and more … |
| | Hi there, I am trying to make a piece of code in C that: 1. opens a specified file, 2. Reads the data in the file and include it in MySQL, based on the position of commas, 3. Converts the last two number into binary and then performs some check … |
| | Hi Experts, I have a website which is hosted in Bluehost. I would like to access my Mysql database from remote without using browser. Is there any tool to access my Mysql database something like Filezilla? Thanks in advance, Manim |
| | Hi everyone, I'm a bit of a noob on the forum so please correct me if this is posted in the wrong area/or post is incorrect. I'm currently working on a new website ([URL="http://www.worldwidemixtapes.com"]http://www.worldwidemixtapes.com[/URL]) and currently stuck on the "sort by" section at the top of the page. What I'm … |
| | Hi this is driving me a little crazy, have been looking everywhere for a solution for the last few days. I'm new to php and i'm trying to create a simple food shopping cart, i have a repeat region for food extras attached to the food item. [CODE=php]<table width="100%" border="0" … |
| | I am learning mySQL and PHP and am very appreciative of the help I have received here. As some of you know, I am working on a Hockey Pool site. One of my first experiments was to build a static form on a php page that would take the input … |
| | Hi, I am using vb.net 2008 with MySQL for my project. I have a datagridview on my form which displays records from Mysql table on form load. i want to delete the selected row in datagrid from table on 'row header mouse click' event. The 2 different codes that i … |
| | Hi, I have the following problem: I want to update the column "UPDATE_VALUE" of table A with values from the column "SOURCE_VALUE" from another table B. Both tables have a timestamp column, and the value that should be updated in table A should be the one of the row of … |
| | I was told on another forum that my table was not set up properly. Specifically, two of my columns, "keywords" and "catagory" should be in child tables. I just dont see that, or I dont understand why I would need to do this for these columns. here is my info … |
 | Hello I amm designing a website for my mom the site is to advertise her book. it has a message board in it. the message board works great locally but when i upload it t a server i get a: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result … |
| | Can anyone provide me with a small code to [B]retrieve[/B] value either from [B]oracle 10G XE[/B] database or [B]MySql[/B] database using Java applets....... I searchd the whole internet but none worked fine for me.. Regardds Niks |
| | Hi guys! I'm trying to access a remote database (MySQL) that is installed on my home computer. The code is: [CODE] public void initDB(String ipaddress, String databasename, String login, String pass) { try { Class.forName("com.mysql.jdbc.Driver"); db = (Connection) DriverManager.getConnection("jdbc:mysql://" + ipaddress + "/" + databasename, login, pass); statement = (Statement) … |
| | Hi, this report is taking too long to run, there is alot of data in the tables. does anyone know a quicker way to optimize this: [CODE]<?php // This report outputs everything to excel format /** Error reporting */ error_reporting(E_ALL); ini_set('display_errors',TRUE); ini_set("memory_limit","1024M"); date_default_timezone_set('Europe/London'); /** PHPExcel */ require_once '../includes/PHPExcel.php'; include ("../../config.php"); … |
| | i have a process that runs, but stops after about 3 minutes. It only processes some of the information (65 entries out of 500). i modified the php.ini, thinking this was the case. The process takes data from a mysql database and writes them to a file. register_globals = off … |
 | I have a 2 tables that I want to select in a weird way but I'm not sure how to join them, should I use inner join or join left or group by etc... [CODE]//my desired out come employee_id | training_name ---------------------------- 1 | training a | training b | … |
| | |
| | Hello I want to make search box like google. when typing in the text box it will show search list. the list must be from mysql query search. How can I do that.  |
| | Is there any way to convert microsoft access database to mysql data. Please help me |
| | Hi all. I want to ask about storing the photos in a MySql database. I am developing a Software for Tours & Traveling company in that i need to store the photos of the customer. The further requirement is to export the database to an Excel sheet including the photo. … |
 | Hi all I'm rather perplexed as to how I'm supposed to select rows from a database without having to use 9999 in my limit and I can't seem to find anything on how you specify fetching anything from a certain row onwards. Using this at the moment [CODE=mysql]LIMIT 10, 9999[/CODE] …  |
| | i have this code but it cant work in my hosting usualy the error is : The following errors were reported: 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 ''comments' ( 'id' int …  |
| | Hi There, For some reason the following is not working - Inside the text field it displays nothing: [CODE]<?php include 'dbc.php'; page_protect(); $rs_settings = mysql_query("select * from users where id='$_SESSION[id]'"); $row_settings = mysql_fetch_array($rs_settings); ?> <html> <head> </head> <body> <form action="index.php" method="post" name="regForm" id="regForm" > <input name="first_name" type="text" class="updateusersmall" id="first_name" value="<? … |
| | Hi There, I've set up a profile page where people can enter the address and then it displays all the information. However the URL doesn't seem grab the MySQL information for the certain ID. How do I do it? Example URL: [url]http://www.website.com/profile.php?id=[/url][B]1[/B] so when you go to that URL it … |
| | Hello I m not so expert in web design. I need ur help. I have two table. One has a [B]primary key[/B] and other [B]foreign key[/B]. I want that foreign key must be from primary key. other than primary key it will not except any value. I made relationship from … |
| | Hello, I have the code below and I'm having a problem checking the returned values from the query i send,i really would like to know how to check each and every row the query return if it contains null values.And if it does contain the null values to update another … |
| | I am reading XML and PHP. I have to import a xml file in mysql database using PHP script. I tried using 'simplexml_load_string()' and 'simplexml_load_file()' functions. It worked. But how the xml parser is used to import XML files into Mysql Database. Please tell me about this, I tried the … |
| | Hi, My mysql_error is No Database Selected. errno 1046 I am connected to the database and it has worked fine before so I was wondering what I am doing wrong. The code is from a tutorial I am using. [CODE]<?php require_once('Connections/connAdmin.php'); ?> <?php //file properties $file = $_FILES['content']['tmp_name']; if (!isset($file)) … |
| | Hi, I have created a MYSQL database and connected to it using Dreamweaver CS3. There is a Master and Detail page and the initial creation works correctly. (not bad for my first attempt!!):cool: The site is for a dog rescue charity and it would be best to be able to … |
| | here's the process: 1. i display the mysql data in rows with checkboxes on each row 2. i want to add the checked values into another table under the specific field employee here's the problem: i can't seem to insert the checked value to the specified project table. what if …  |
 | when I try to access my phpMyAdmin. It occurs this error message. [QUOTE]MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: NO) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and … |
| | Hi.. i need to learn how to send the username and password to the database and when the user logs in it should retrieve the password from the database and authenticate if the username and password is correct. Am using this jsp code and getting error in (Resultset line) [U]here …  |
| | hey everyone i have sugested to create a new club in my school called programmers , so they told me that i have to bring a list of the club aims and they xheck if the aims are good or bad then they accept the club or no , so … |
| | Hi There, I do have an sql query to update and insert row into database which I use it within a form. Problem is ; This sql query works good in one form but in other one it does not at all(same query different form), looks like it is blocked …  |
| | Hi There I do have a form and a little sql query to update the row before do something else. Problem is in the code below works when I enter the date like that= 01-02-2001 but I need to do it dynamic I know getdate() but it does not work.. … |
| | Hi: I have a process allowing the admin to view users information and download files that the user uploaded to MySQL. When the admin clicks on the file link in the admin page, I expect the file will display using the default program (i.e. pdf or txt), or download (i.e. … |
| | Hi All: I have been working very hard and long at understanding this situation. I have tried many different sample scripts, to check my work and find find my solution. I have created a job board for a client, the user applies for a job in application form.php which then … |
| | i'm having trouble getting this to work. i want mysql to delete a row where the word 'example' is within a paragraph of a column. e.g. in the column reply.. it has a paragraph with the word 'example' in it. [code]$deletebadreply1= mysql_query("DELETE FROM `Reply` WHERE `reply` LIKE '%example%'") or die … |
| | I am trying to make an Inventory GUI application using MySQL and NetBeans. So far, i was able to do add,delete,search, and save using Java Desktop Application. I now have to add a SEARCH button, a notification for the quantity if it is less than 10 and a USERNAME and …  |
| | Yesterday, I had started a thread with a problem, am trying to execute the script below, but each time it is failing and returning "Unable to record form details". Note: "Unable to record form details" is the response returned when isset($_POST) is not working, refer the code for more details. … |
| | <?php $allsql="SELECT SUM(Salesprofit)+SUM(Serviceprofit)+SUM(softwareprofit)+SUM(Airtelprofit) FROM billing,service,software,airtel"; $profitall=mysql_query($allsql) or die(mysql_error()); while($row=@mysql_fetch_array($profitall)) { echo $row['SUM(Salesprofit)+SUM(Serviceprofit)+SUM(softwareprofit)+SUM(Airtelprofit)']; } mysql_close($con); ?> Hi everybody.... i have problem in mysql query.. i got the sum for the field called profit from each table... i am getting the TOTAL value as wrong calculation value... how do i get the …  |
| | Hi, I am trying to execute the following script, but each time it is failing and returning "Unable". Note: "Unable" is the response returned when isset($_POST) is not working, refer the code for more details. [COLOR="red"][B]PHP CODE[/B][/COLOR] [CODE]<?php $test = "Hi!"; if ((isset($_POST['usrName'])) && (isset($_POST['pWord']))) { $user = $_POST["usrName"]; $pass … |
 | [CODE]+--------------+------+------------------------------------+-------+ | ProductCode | Qty | Title | Price | +--------------+------+------------------------------------+-------+ | relationaldb | NULL | The Relational Database Dictionary | 14.99 | | artofsql | 50 | The Art of SQL | 44.99 | | databaseid | 0 | Database in Depth | 29.95 | | mysqlspp | 5 … |
| | Hi, Currently I am working on a site that lets users upload photos for their personal page. This page is just a prototype so some of the code is very sloppy so I really should not post all of it. Anyway, here is some: [CODE]$id =$_GET['id']; if(!isset($id) || empty($id)){ die("Please … |
| | Using the above technologies, I want to create a PDF, store it in my db, and email it. All with the click of one button. I also want to call it up and have it be able to display with a hyperlink. I am very new to FPDF. Therefore, I … |
| | At the moment, I have the following to do MySQL queries: [code] MySqlCommand Command = new MySqlCommand(Query, SQLConnection); IAsyncResult Result = Command.BeginExecuteReader(); return Command.EndExecuteReader(Result); [/code] This is a static command in a server in the database class, which includes a static connect/disconnect function (used once when the server starts and … |
| | Hello! Finally I joined daniweb. Great stuff in here guys. Anyways lets get to the problem: I have a page where a number of topics are displayed ( they are added by admin). And to get this list I`m using this script [CODE=php] // Query the database $gettopic = mysql_query("SELECT … |
| | My database has a list of events, and I'd like to return it sorted by date. However, I'd like to have the past events be forced below more recent events, so I try to do this: ( SELECT name, date FROM events WHERE date >= curdate() ORDER BY date ) … |
The End.