10,940 Topics
 | |
| | Hello Friends, I have three table and i want to select data from them Table 1 Roll No. --- Name---Age 1------------a--------12 2------------b--------13 Table 2 Roll No.---Name---Age 7------------d------12 8------------b------13 9------------c------12 Table 10 Roll No.---Name---Age 41---------d---------12 43---------b---------13 44---------c---------12 Table 3 Roll No.---Sex 1------------f 7------------f 41----------f i want to select date from Table … |
| | |
| | Good day to all. I have an existing vb project and my back end is ms access. I changed my database to MySQL and SQL but the problem is I don't have any idea how to connect my VB project to MySQL and SQL throuch ODBC. Your help is very … |
| | hi guyzz, i wanted to have two connection using access and mysql in my proj. my access was my main db connection and what ever data in my access will store directly in mysql db when their is internet connection... I declared 2 fuction connection but my problem is the … |
 | "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." Now this is a really stupid error. (yes that sums up the error S T U P I D) I am making an update to … |
| | I have written this code in Jsp file . [code=JSP]<% Connection con=null; Statement st=null; PreparedStatement ps; String nm=request.getParameter("tnm"); String loc=request.getParameter("tlc"); try { Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3306/rahul","root","root"); st=con.createStatement(); try { ps=con.prepareStatement("insert into dept(deptname,location) values(?,?)"); ps.setString(1,nm); ps.setString(2,loc); ps.executeUpdate(); out.println("Value inserted "); } catch(SQLException e) { out.println("sql is not executed"); } } catch(Exception ex) { …  |
 | I am helping a website owner to transfer a site to new servers. All site files have been uploaded onto the new server, only thing left is the database. In phpmyadmin, when I try to export the DATABASE to my local PC, using zip or gzip to compress, as this … |
| | Using rs.open (bla bla bla........) then i need to streamreader each line from MySQL....how can i implement it? thanks |
| | I am reading records from a linked server table, and trying to use the output in the next update statement, not on the linked server. I am assigning it to a declared variable. The file is being updated with NULL, instead of the correct check number. Any help??? Example code: … |
| | Hi guys, I did a quick tutorial on the internet on using php and mysql. It is my first ever time using it so forgive me if im being a bit of a "NOOB". anyways ill post the script below and can you give me a few pointers about where …  |
| | Is this an appropriate place to submit a question concerning netbeans and creating queries?  |
 | Please tell me what I'm doing wrong. The sql query is in bold. [CODE]<?php //////////////////////////////////////////////////////////////////////////////// // // SECRET PAGE // // Invokes require_authentication() to ensure that the user is authenticated // //////////////////////////////////////////////////////////////////////////////// require("common.php"); require_authentication(); session_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns='http://www.w3.org/1999/xhtml' xmlns:b='http://www.google.com/2005/gml/b' xmlns:data='http://www.google.com/2005/gml/data' xmlns:expr='http://www.google.com/2005/gml/expr' xml:lang="en"> <head> … |
| | I am able to connect to the database and located the table. I am unable to populate the db. Attached is a in image of the phpmyadmin trucks table structure. Please help. I am excited to be so close to getting it right. [CODE] echo '<blockquote><blockquote><blockquote>'; echo '<form method="post" action="/inventory/">'; … |
| | Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\vhosts\thepinflow.com\httpdocs\staff\checklogin.php on line 12 Wrong Username or Password That is the error message I am recieving. I was using another website to host a PHP/SQL website before, currently located at: [url]http://www.blackairplane.com/Pinflow/index.php[/url] which works. When I copied all the … |
| | Hi Everyone, Good Day,, can you help me to config mysql server to be able for me to connect to it thru a network. for example the mysql server is on the other pc and i am using a software in other pc. how can i connect to it.? thanks … |
| | Well, i am facing this problem when i try to configure my ODBC 3.51 Driver. I had successfully installed MySQL. Then i try to install and configure my ODBC 3.51 driver. I add a new user DSN, filling with the correct username and password, with the data source name. However … |
| | Hello, I'm having some sintax problems using PL/SQL in mySQL TRIGGERS.. I need some help please :). Here is the code: [code] CREATE TRIGGER modificou AFTER UPDATE ON monitor FOR EACH ROW BEGIN IF NOT EXISTS(SELECT estado_tmp FROM alteracoes WHERE id_tmp = OLD.id) THEN INSERT INTO alteracoes VALUES(OLD.id,NEW.estado); ELSE UPDATE … |
| | How do i store images on a mysql server and preview on a webpage using PHP. or how do i preview images using PHP on webpages.  |
 | Hi all, I want to insert multiple records into a table using one query. And my query is INSERT INTO table2(id,message) SELECT id FROM table1 WHERE condn,'hello' but it displays an error.... Can you help me? Thanx in advance.... jino |
| | Helo everybody How to convert database type from datetime to varchar? and decimal to varchar? Can I use this code? [QUOTE]CAST(now() as varchar(20))[/QUOTE] I use MySQL version 5.0.21 Other question: If I execute procedure [QUOTE]CREATE PROCEDURE `formatdate`(dtDate datetime) BEGIN SELECT date_format(now(),'%d-%m-%Y') AS idate; END $$[/QUOTE] in Visual Basic 6 using …  |
| | Hi everyone and thanks for reading! I have a MySQL database with a table called "lessons". Inside lessons there are about six or seven fields holding information about piano lessons. The table looks like this: [CODE]vid int(10) (Primary Key) title varchar(50) date date teaser varchar(500) description varchar(2000) vurl varchar(50) extra … |
| | Hi All, Can any body help me out how to pass an array values from php file to mysql stored procedures as parameter list and how to use the array inside the stored procedure. Please help me out to solve this problem. Thank you. |
| | I'm trying to carry out the following delete statements [CODE]DELETE FROM images AS i WHERE i.image_id = 803 AND i.plant_num = 2277 LIMIT 1 DELETE FROM images AS i WHERE i.image_id = 804 AND i.plant_num = 2277 LIMIT 1 DELETE FROM images AS i WHERE i.image_id = 805 AND i.plant_num … |
| | I am having a problem porting an application written in ASP, using an MS SQL Server database, to a different ISP using MySQL. Code that seems to run fine on the current site generates errors on the new site. My connection to the MySQL db is: [code] set objConn = … |
 | I have a ton of inserts in an sql file that look like this: [code] INSERT INTO grades (GWid, classid, semester, year, grade, required) VALUES(100000089, 'CS210', 'B', 'fall', '2006', 'yes'); [/code] but when I get my filled tables, the semester and grades are all null and the year is 0000. … |
| | Hi, I need to send a SMS message or/and Email in my database project. Which one is better option for me; Shall i create database with Oracle or MySQL? Thanks  |
| | guyzz i wanted to make 2 connection in my inventory system. using mysql and access. i wanted to use the mysql as my main database..and if their no internet connection it posible save first the data in my access.. and if their an internet connection it will update and stored …  |
| | Hello everybody!!!! I am just curious if I can make a database where all the data are images like bitmap, jpeg and other pictures format... If yes, can you pls show me some code or sites to where I can learn a lot about this.. YOUR HELP IS HIGHLY APPRECIATED.... … |
| | I'm brand new to SQL queries, hoping someone can help me set up this query. I'm using [URL="http://www.phplist.com"]phpList [/URL]to manage my mailing list. All user defined attributes appear to be stored in a table called phplist_user_user_attribute. The structure of this table is:[INDENT][U]Field[/U], [U]Type[/U] attributeid, int(11) userid, int(11) value, varchar(255) [/INDENT]attributeid … |
| | hi ALL... i'm a new in IT woRLD.. right now i work with PHP, Apache, And MySQL i want to create aplication that already work(use Apache,PHP, MysQL but it stand ALone )being apLication that executable what i want is in the future all that i need is just install the … |
The End.