10,946 Topics
 | |
| | 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 ) … |
| | So i had to do the following assignment in GWT: 1.Implement a selection/de-selection component as described below: The selected item in the first list goes into the second list and is removed from the first list when the >> button is pressed. The selected item in the second list goes … |
| | I have made some tables and created relationship from phpmyadmin. Relationship is as below [IMG]http://img295.imageshack.us/img295/2411/relationship.jpg[/IMG] Problem is that requisition table allow [B]material id[/B] which is not in [B]material table[/B]. what is the problem. How can I solve this. Simply Foreign key can not be such value which is not in … |
| | Hi There, I've got a membership script and a login using PHP and MySQL databases however when it logs in it simply displays a PHP page - the same one for all users. I want to be able to customise the members page so it says things like: Hello, <username>. … |
| | Hi, I have a problem with importing special slovenian characters (č, ć, š, đ, ž etc) from excel to mysql database. I changed database coding to utf-8 in phpmyadmin and in php editor (Eclipse). Adding articles (to table) from html form works fine (with special characters: č, đ etc), but … |
| | hi, I have a table called shoutbox, i created it this way: [CODE]CREATE TABLE `shoutbox` ( `id` INT NOT NULL AUTO_INCREMENT , `ip` varchar(20) NOT NULL , `name` varchar(30) NOT NULL , `url` varchar(30) NOT NULL , `message` varchar(50) NOT NULL , `date` date NOT NULL , PRIMARY KEY ( … |
| | Hi everyone, I have a database with X items, and each of them can have one or more of 20+ properties. How I currently make this work is I have a huge table with each of the properties having it's own column, and a boolean to determine does the property … |
| | Hi All, I am using MySql and wrote all my create table scripts directly on the command line client. Now I have no tracks of them. I need all the table scripts present in my database region for future reference. I used the below command to view the script of … |
 | Ok...this is my "HELP ME! HELP ME!" thread.:D I finally got my code to work...almost. The form posts to my database but only the first query data inserts and the last value of the third query. All the form fields are correct and the problem appears to be with my … |
| | I've used the code below previously with success, but I'm having problems this time around, and hoped someone could point me in the right direction. I complete the form, click submit, and receive the message confirming data has been added. However, when I look at the database, there's nothing there. … |
| | why i am i getting this synyax error when trying to display data from the database the code for saving the data is [CODE]// save content to db if(isset($_POST["inpContent"])) { $sContent=stripslashes($_POST['inpContent']); // remove slashes (/) $sContent=ereg_replace("'","''",$sContent); // fix SQL $sql="UPDATE cms_core SET editorial='$sContent' WHERE id=$id"; $query = mysql_query($sql); }[/CODE] and … |
| | hi there, I'm having a problem with mysql, php and phpmyadmin 1. MySQL will not start as a Server Service, on Windows XP - when installing goes through process and tells me it cannot start as a service, and then tells me mysqld.exe will close, is there anything I can … |
| | Hi..... There is a problem with the following mysql query create table emp2 (Leave decimal(12,2) default NULL) [B][U]Error message[/U][/B] Error Code: 1064 - 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 'Leave decimal(12,2) … |
| | Hi All, I just want to share my simple program :-) [url]http://www.momococo.com/nmbp/ajax/virtual_edc_sales.php[/url] Isaiah 9:6, Isaiah 7:14, Matthew 1:22-23, Jude 1:5, 1 John 4:2-3, I Timothy 3:16 [url]http://armandecastro.wordpress.com[/url] |
The End.