10,946 Topics
 | |
| | Hi everyone I'm new to JSP and followed a code I read in a book here is my code: [code=JSP]<%@ page import="java.sql.*" %> <%@ page import="java.io.*" %> <% String connectionURL = "jdbc:mysql://192.168.10.2/ox?user=moop&password=unbind"; Connection connection = null; Statement statement = null; ResultSet rs = null; Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection cn = DriverManager.getConnection(connectionURL); Statement … |
| | please help me to resolve the databasbase connectivity problem in java for mysql .i am using jdk 1.5 ,if there is need to put a file then please mention where it should be copied ,and i am writing the code and error occuring that code. code: import java.sql.ResultSet; import java.sql.SQLException; … |
| | [code=php] $_SESSION['MM_paymentstatus']="to be verified"; $modeofpay="Credit Card"; mysql_select_db($database_enamysqldb, $enamysqldb); $query_recunvesummary=sprintf("SELECT * FROM paymentsummary WHERE username=%s AND paymentmode=%s AND foryear=%s AND initialstatus=%s", GetSQLValueString($_SESSION['MM_Username'], "text"), GetSQLValueString($modeofpay, "text"), GetSQLValueString($_SESSION['MM_yearlynow'], "text"), GetSQLValueString($_SESSION['MM_paymentstatus'], "text")); $recunvesummary = mysql_query($query_recunvesummary, $enamysqldb) or die(mysql_error()); $row_recunvesummary = mysql_fetch_assoc($recunvesummary); $totalRows_recunvesummary = mysql_num_rows($recunvesummary); $totalunvepayment=0; while($row = mysql_fetch_array($recunvesummary)){ $totalunvepayment = $totalunvepayment + $row['amountpaid']; } … |
| | [i] Topic The topic of this question is: Creating a MySQL table and Entity from Database. [/i] [icode] Hello and Thank you in advance for any assistance. [/icode] [u] [b] Purpose: [/b] [/u] [b] This is another attempt to render data in a visual web javaserver faces table. The purpose … |
| | Hi i have created a website for my client using PHP and mysql . The client need to backup a table in database as excel file every day. Well he had no idea about coding and all ... He need to backup using a simple way. Please anyone let me … |
| | Hi Ive just came across this syntax error and have no idea on how to go about fixing it hope someone can help? Im using Php myadmin # Server version: 5.0.45 # Protocol version: 10 Here is the error: "You have an error in your SQL syntax; check the manual …  |
| | i am trying to mutiply and add 2 dnamic texts on a php form, but i do not seem to get the reply, but i get the following results "sum (4 + 1)" This is the code that i typed in [ICODE](<?php echo $row_standings['w']; ?>+<?php echo $row_standings['d']; ?>[/ICODE] The 4 … |
| | Hi everyone, I am trying to create a vacation planner where users can log in and save their plans. I have created a table called planner_plans and this is going to contain the main info such as title etc. but how do i make it so that when the user …  |
| | Hi all, I just learn PHP couple days ago, due to some 'trouble' in the company and my boss asking me to create an employee database Help on PHP MYSQL Forms Input With some help of dreamweaver, i finally manage to create a form for employee database but..... Sadly....some of … |
| | hi, I am having a problem doing a select in MySQL among multiple tables. I have two tables that are virtually the same except that one table is for January and one is for February. I have two columns in each of the tables i want to match on: Account, …  |
| | Hi, I'm new in using MySQL database and have problem with character encoding. Database was created by this query: [code=sql]CREATE DATABASE 'dbname' CHARACTER SET utf8 COLLATE utf8_general_ci;[/code] Then I've create table using this query: [code=sql]CREATE TABLE IF NOT EXISTS 'tblname' ( ... ) CHARACTER SET utf8 COLLATE utf8_general_ci;[/code] AFTER query: … |
| | Hi there, I am new to Php and MySql. However, i have been learning for some time now. I get the above error and my line 77 has the following statement: $result=mysql_query($query,$conn); Any ideas? If you need more of the code please let me know. Thanks a lot, Sofia  |
 | Hi The user clicks on a buttons to delete all posts in a thread (this also deletes the parent post). The code is bellow. This however isnt working, its deleting all the parent posts, even those that dont correspond to the topic clicked on. Any ideas [CODE] if (isset ($_GET['delete']) …  |
| | I am getting an "Connection must be valid and open" error. After some research I have found two possible reasons for this: malformed sql or bad connection string. Since the error is being thrown on a second .executescalar statement I will assume the connection string is working. I have two … |
| | hi..I'm just a newbie programmer who needs some help. I'm trying to enter a date and save it in a mysql database. however the format in mysql is yyyy-mm-dd and the format in vb.net is mm-dd-yyyy. how can i format the date in vb in order to successfully enter it … |
| | Good day.! Thank you for all of you in this forum in helping me in all my post. I just got one last problem with my project.!Please help me on how to back up and restore my mysql database that when i click backup my mysql database named (onlineenrolement) will … |
| | My system is a stand alone system, I want to connect to MYSQL using PHP, I am giving hostname as localhost, and the needed username and passoword. In the browser i am getting Internal server error 500. Any sort of help much appreciated, Thank you |
 | hi all, Donn't know much php........... i want that when user register,his registration date store in db.i want to use server date not his system date in db. thankx in adva... |
| | Hi i had a database table which stores images in columns. ie [ICODE]idno + image name + name 1 | lal.jpg | raj 2 | lal2.jpg | raj2 3 | lal3.jpg | raj3 .....[/ICODE] Now I need to show this images and these names in a page as 3 columns.... … |
| | I have these two tables.. [B]Product[/B] ============================= ID Title Description ============================= 1 My first product First description 2 My second product Second description … … … …. …. …. [B]META[/B] ============================= ID PRODID KEY VALUE ============================= 1 1 StartDate 22-MAR-2009 2 1 EndDate 23-MAR-2009 3 2 StartDate 28-MAR-2009 4 2 … |
| | Hi, I want to use a php form textfield to change a value in my databas. Statement i want to send the databas: UPDATE people SET name='VALUE FROM TEXTFILED' WHERE id=1 How do i integrate this statement into a php form textfield? |
| | Hello guys, quick question for ya... Here is the code i am looking at [CODE]<?php $conn=mysql_connect("internal-db.s*****.gridserver.com","db*****","*******") or die(mysql_error()); mysql_select_db("db*****_gradsurvey") or die(mysql_error()); function generatePassword ($length = 5) { // start with a blank password $password = ""; // define possible characters $possible = "0123456789"; // set up a counter $i = … |
| | Hello everyone, I need help. I have two table name: Table 1: resortid resortlocation Table 2 resortid resortname Now I want to get the maximum of resortlocation then getting the name of that specific resort also. I am having a hard time. Can someone please help me? Thanks. |
| | Hi everyone :) I'm completely new here. Let me introduce myself - My name's Dave and I'm a student studying Multimedia applications development at the Waterford Institute of Technology in Waterford, Ireland. [B]I'm currently involved in a college project where I have a JSP web application connecting to a MySQL … |
| | Hello, Im new to that kind of code so forgive me. I have 3 diferent tables players: id_player name_player players_details: id_player position age players_eval: id_player value wage You can see that the ‘id_player’ is in all tables. Now, what i want to do is export on csv and if the … |
 | Accorting to MySql manual and web site I modified the environment variable for installing JConnector for mysql as follows : CLASSPATH C:\Program Files\Java\mysql-connector-java-5.0.7\mysql-connector-java-5.0.7-bin.jar where my MySql connector Folder is placed on Java folder in program files (I put there willingly) But actually when I want to do any testing program …  |
| | hi i want to merge two rows in a table. but a little confused.. Please help!:confused: the example is as shown below Record #1: [B]Nikhil [/B]Bhat [B]1Jan2009 [/B][B]Married [/B]ABC Record #1: Nikhil [B]Ong [/B]1Feb2009 Single [B]DEF[/B] Meged Record : Nikhil Ong 1Jan2009 Married DEF There is a primary key 'ID' … |
| | Hi, How do i order results for most relevant one? [code]Select id, title from data where (titleLIKE '%PHP developer%')[/code] id title ---- ------------------------------- 1 ASP developer 2 WEB developer 3 PHP 4 PHP developer In this case, it should be displayed in this other 4, 3, 2, 1 OR 4, … |
| | Hi I am writing a search script that you will type in a search term and then the system will go off and search 2-3 tables at once and bring back the search results. Now the proble that i have is that i am unsure how to go about sorting … |
| | Hi I seem to be getting this error on the reply section of my forum. I've never had this problem before and have tried google but found nothing. So, now i turn to daniweb, surly someone must be able to help me here. [B]This is the error:[/B] [CODE]Warning: Wrong parameter … |
| | i have a code like this [CODE]select * from tableX group by fieldA order by fieldB[/CODE] this code sort according to fieldA. but i need to sort according to fieldB. please help me ?? |
| | |
| | Thanks for your help in the past, and this forum is great. I have a question about dates, and in searching, there are huge amounts of results, but very hard to narrow it down to exactly what I'm asking. In using PHP, I have some variables pulled from mysql databases … |
| | i am trying to get this code to work but there is something wrong with the array (not to good at these). the main part of the code works it is sending out the email but only ever to one registered user. here is the code i have so far. … |
| | Hi, I have a distributed DB , comprising of 800 db servers (huge data for a social networking company). the records are sorted in db based on user_account _id, and the table also has user's credit card number , now - given a credit card number I need to find … |
| | I'm not very good at MySQL stuff, so I need a little help with a problem I'm having. I'm trying to make a script that will open up a text file and print the contents of the list onto the screen. Additionally I wanted the contents of the file (a.k.a. … |
| | I have three tables: posts, topics, and forums. Each row in post table has a topic id and a author name. Each row in topics has an id that corresponds with the topic_id in posts, and then it has an id for the forum that it (the topic, containing the … |
| | We have integrated Paypal with our application and everything is working perfectly. But after the transaction is completed and successful we need that it should redirect to our application again. But its not happening. We have turned on the auto return option in the paypal too but its still not …  |
| | Hi, I use Ubuntu and want to restore a mysql file. How do i do it? It is on my desktop. Thanks |
| | I keep getting the following error: [b]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/b] on line 17. I'm trying to figure out if there's some problem with my SQL query statement, or what. When I try to print $result, nothing is displayed. I've included my code below. … |
| | I have a query that brings though a list of passenger names, is there a way in which I can set the length of each of these names to equal 10 characters. So even if I have shorter names eg "bob, demarcus, adam and scott" they would display with the … |
| | I am using the syntax: REPLACE(str,from_str,to_str) to replace data in my table. However I have a slight issue I would like to address, when I have the following records jon | jonathon | jonas | jonny and I do the replace with REPLACE(names, jon, '') I am left with | … |
| | I have three tables: posts, topics, and forums. Each row in post table has a topic id and a author name. Each row in topics has an id that corresponds with the topic_id in posts, and then it has an id for the forum that it (the topic, containing the … |
| | i am trying to write a script that will send out an email to all the email addresses stored in a mysql db when the site has been updated. the code i have so far is as follows [CODE]$sql= "INSERT INTO $table (date, title, article) VALUES ('$a', '$b', '$c')"; if … |
 | [url]http://au2.php.net/function.mysql-query[/url] [code] mysql_query($query, $link_identifier); [/code] Which commands require $link_identifier, thought there be a list on google but to no avia. :( Thanks, Regards X PS: There not required but its good practice you use the connection string after the query string. |
| | Hi, [code]INSERT INTO money (salary) VALUES ('100,000,000.00')[/code] 100,000,000.00 is stored as 100.00 in decimal (14,2). I don't know what is wrong? Thanks |
| | There are a few: - I am trying to use it in a function within a function, which then I call the second function (mysql > function > function) ? - Using within while loops (while ( VAR mysql_fetch_aray (query)) ? So any ideas? THanks, Regards X  |
| | Hi, Data is stored like this in Varchar(2500) (with paragraphs): [code] Looking for NET developer, programmer. Required skills: VB.NET NET MsSQL XHTML If you are interested, please call "000" number's test. Thanks [/code] When i echo it, it is displayed like this: [code] Looking for NET developer, programmer. Required skills: … |
| | I know this might sound silly....please forgive on this one I am not a programmer, but simply a graphic designer, but our programmer left us,and since that, my boss (which also my father) askin me to help about this matter. This company is still looking for the replacement, but we …  |
| | Hello everyone..How do i create a user manual or the instructions of the software in vb6? Is it possible to pattern the manual with the manual of mysql or the like.. Another question. How do i populate my treeview in vb6 from a mysql database?? Any help would be very …  |
The End.