10,946 Topics
 | |
| | |
| | hi all, Is there a code where i can check from all the existing tables if a certain variables exist in it? I am currently working on a project but the tables are not linked properly, having a hard time trying to find out how many tables actually have the … |
| | Hi!! I have a problem to connect VB to Mysql database |
 | Here is the code. For a short time, I will leave the test results up at [URL="http://superiorminitrucks.com/inventory"]superiorminitrucks.com/inventory[/URL] Clearly, I need to stop it from displaying the final entry twice.. Thanks in advance.. [CODE] <?php $db_connection = @mysql_connect("######", "#####", "####"); if (!$db_connection) exit(); mysql_select_db("tefflox", $db_connection); $result = mysql_query("SELECT * FROM trucks"); …  |
| | What would be the php mysql code to search more than 1 field in a table ? Im trying to search for a given partial phone number in all three fields home mobile and work .. im trying to use $query = "SELECT `first`, `last`, `home_phone` , `work_phone` , `mobile_phone` …  |
| | |
| | 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 … |
| | Hi, I put websites together using Xoops and OsCommerce. I need to know how to edit mysql databases using Cpanel. Please could you point me in the direction of some tutorials? There are some which show how to se up a database but not how to edit one. For example, … |
 | I am trying to replace mysql fields with this code... But unfortunatly it is not working... I do not know why... Here is the code please help me. Thank you. [CODE] <?php session_start(); if ($_POST['txtName'] != ''){ $host="****"; $username="****"; $password="****"; $db_name="****"; $tbl_name="****"; mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select … |
| | Does anyone know of a free tool or utility that I could use with pgAdmin III that would accomplish the same type of import functionality found in Navicat? |
| | Hello Everyboby!!! I just want to ask basic information but confusing in my part about the differences of ADO, ODBC and OLEDB ... I get confused in differentiating this three.... I hope you could help me with this problem... Your help is highly appreciated.... Thank You.  |
| | I'm trying to set permissions in mysql for an ecommerce open source application (freeway) for a path: Set the permissions on Freeway/images directory to 777 in my terminal I have typed: chmod 777 /Sites/Freeway/images but it is telling me that "no such file or directory exists", and yet when I … |
| | This maybe an old chessnut to you old sweats but I am a newbie to this.. I getting this error:- [B]mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\dsg\Mytest.php on line 9[/B] the database is called Camsdb the table is called DBF the fields of which there … |
| | Can someone help me figure this out. What do I need to do to set permissions in MySQL? Thanks in advance.  |
| | Hi, Here is my mysql sentence: [CODE]select last_insert_id() from pp;[/CODE] and the table pp is created by: [CODE]create table pp(id int not null auto_increment primary key,name varchar(255) not null);[/CODE] Now I'd like to change the above into sentences that are right in Oracle. First I create table: [CODE]create table pp(id … |
| | Hi. I Installed Apache 2, PHP 5, and Mysql 5 (All Latest Version) and now i when open e script on my localhost that needs a mysql connection (i tried with phpmyadmin) i get a error: Could not load module mysql.dll (ore something like this) but the service is running … |
| | I am using MySql 5.0.51a and am trying to acheive the following I have 2 tables, one of categories and one of company details, each company can select up to 6 different categories for their business. In my category table, I have sub categories, and sub sub categories, eg, Main … |
 | hi is it possible to run a java application on a linux server if so, is it possible to run the exe of the application in the linux server or an applet should be called initially i was doing my project in vb and since it is not possible to … |
| | Hey guys, I am trying to figure out a way to update a row in a table for my database by filling out information in an html form. What I am doing is filling out a form with a username and other information. I want to be able to either … |
| | hi there when im trying to connect to a remote mysql server im getting an error i searched for it and i came to know that MySQL database server remote access disabled for security reasons by default and they provided with lot of steps to enable it the problem is … |
| | Hello, why wont this code give my "Rubrik" a link with its ID? I only get "www.yada.com/open.php?id=" [code=sql]<a href="skapaannons.php">Lägg till annons! </a> <?php $con = mysql_connect(" "," "," "); if (!$con) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db("annons", $con); $result = mysql_query("SELECT annons.id, annons.datum, annons.rubrik, annons.pris, … |
The End.