11,093 Topics
 | |
| | I'm currently designing a report using VB6 and crystal reports using mysql as backend but everytime i open the report in VB i always have the error "Access Denied". I never had such error in the old version of MYSQL. I using WAMP server with MYSQL 5. Anyone who has … |
| | I'm new in MYSQL is there anybody who is expert in MSQL as backend and VB6 as front end please i'll be willing to study espcially on the connection. How and what are the procedures? Thanks a lot in advance...hope to share also my little ideas soon... |
 | hi thanks for ur suggessions now i got mysql connection with vb but i need to use the mysql Queries in this application hope i wil get solution thank u very much |
| | hi there thanks guys now im able to connect to the mysql database and know how to use select statement to access the the data in the database but what to do to view the data retrieved by the select statement |
| | hey guys I've been trying to connect this jsp site with MySQL database for a school assignment and I just can't seem to get it to work. It's getting really really frustrating because I have copied my friend's code(which does work on his pc) and for some odd reason it …  |
| | Hello everybody , Im created an Application in java . In that application i have to store data in a web Mysql database.How can i connect ? |
| | hi all..i had problem here..hope someone can help me.. i`ve create a db that contains several tables. myproblem now the foreign key doesnt parallel with primary key. i had create table named form which form_id is the PK..then table named register which id is the PM.i put form_id in table …  |
| | does anyone no if it is possible to convert a php/mysql page into a html page? if it is would it be possible for you to point me in the right direction as i have no joy searching the net. |
| | can anyone tell me how to use a variable table name in select syntax?? like..select * from tablename here tablename is a variable name ..i read tht it can be done using dynamic sql..but i am not able to do it..can anyone tell me the code for it...i tried writin … |
| | Hello all; I have a mysql on windows server 2003. I have deleted some records from mysql table accidently. I need to see log file to recover INSERT commands and run them again to recover my table. I cant find binary file. but I have a ib_logfile0 and ib_logfile1 file. … |
| | hello people i basically i need some information ive got a booking website which allows users to book a hotel room but once they book the room i dont want that room available to anybody else, im using Mysql databse linked to php, in the database i got a colum …  |
 | Hello, I need some help....I have to create part of an application that uploads an MS Excel file, and stores the data into a MySQL db...and I have no clue where to start...  |
| | Hi, I am trying to build a multipage php form using mysql as the backend much like the ones in monster.com. First page with the personal details Second page with educational details Third page with work experience details Can some one please give me a thread or a link or …  |
| | I know there are many posts on this subject, however after reading them I am still not seeing what the problem is in my code. I have run the SQL Query in phpmyadmin and it works fine, calling up the correct entry from the database. The error is being raised … |
| | Hello all, I am using MySQL version: 5.0.37 I am creating a forum. I am designing the tables for the threads and their replies and the relationship between them. Please have a look at these images and give me your thoughts. I have also included the schema. [URL="http://i284.photobucket.com/albums/ll40/JavaPHPNinja/threadsTableDesign.jpg"]http://i284.photobucket.com/albums/ll40/JavaPHPNinja/threadsTableDesign.jpg[/URL] [URL="http://i284.photobucket.com/albums/ll40/JavaPHPNinja/threadsLogicDesign.jpg"]http://i284.photobucket.com/albums/ll40/JavaPHPNinja/threadsLogicDesign.jpg[/URL] [CODE]CREATE … |
| | Hi, I have a table with 10,000 names. I'd like to group them into groups of 3 and also display the remaining 1. Can anybody help with a suitable query please. Taffd |
| | hai i am nireekshan i am using mySql database in this i am create employe table Now i am davalep One .HTML Page in this i am write the employe table fieldes-----------And write Jsp page inThis i write MYSQL CONNection code And Insert Prapared Staments Now i am run TOMCat …  |
| | Hi I’m new to PHP and MySQL and I’m trying to return a MySQL query using a PHP variable that has been passed to it. I currently get this error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\moodle\logicquiz\quiz.php on line 57 Error performing query: You … |
| | i did save image to mysql by creating a field type longblob and saving it by converting the image into byte(). my problem is the image cannot be to big else it fails. can anybody help me in this. i can send the sample code if requieres. thanks |
| | hello everyone , i would be very much pleased if anyone can show me a way to integrate apache webserver and PHP/PERL with mysql database on linux, and if possible can anyone let me know about any book which would be usefull in administering mysql commmand line on linux  |
| | [CODE=SQL] please help any one, how to write PHP, what is the use of PHP, syntex, advantages etc.... [/CODE] |
| | Hello basically i got a signup page and i want the user to be able to browse and upload a image and when the user clicks signup all his details and his picture will be saved to mysql database table, and when the user signs in the image appears is … |
| | Hi, When i add new product into "Products" table, a trigger will add a record into "stocks" table. Example; stock=10,productId=99 How can i do that? Thanks [code=sql]CREATE TABLE products( productId INT(10) NOT NULL AUTO_INCREMENT, productName VARCHAR(10), PRIMARY KEY (productId)); CREATE TABLE stocks( stock INT(10), productId INT(10), FOREIGN KEY (productId) REFERENCES … |
 | Hello :) I have a quick question with a script I'm making; It's a php script used to add data to pages (there are 5 in total and an index page), and I just restructured the database for more efficiency :o . It used to look like this: +-------+--------+--------+-------+--------+--------+ | … |
| | i'm trying to populate a select list from a mysql database. my line numbers on the code are 90 to 104. the error i'm getting is Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\wamp\www\capstone\admin\admin_curriculum.php on line 99 my code is: [code=php] $con = mysqli_connect("localhost","root",""); $sql … |
 | good afternoon,I am currently in the process of building a database that can expand over time (i think that is an oxymoron, but anyways) From what I have been reading ( I have a 1999 antique book called the complete reference SQL and from viewing websites on this subject) a … |
| | I am running mySQL Server 5.0.37 on a Windows 2003 Server. I have a table that I want sorted by three columns (column1, then column2, then column3). I can sort one column just fine. But, if the recordset is large, sorting by two (or more) columns crashes the mySQL Server … |
| | hello, everybody i have a problem , i have table , it contoin column ORDER ID, customer ID, amount, DATE. a problem when i type or create this table, i make a mistake i dont know where is my mistake when i type in mySQL database BY using ( MYSQL … |
| | Hey all, posting again here as got major headaches! Basically.. I have a series of quite complicated queries, but the main problem starts right at the beginning, other than that I reckon im fine. What I want to do, is display a list of Registrations from Student's for Modules. This … |
| | how to write nested queries ex: [code=sql]SELECT * FROM [table1] WHERE [column] IN (SELECT [column] FROM [table2])[/code] in a function. i tried this but MYSQL is getting stoped. is there any alternate. |
| | Hi all. I have posted on this before with no response. Let me try a different way. I have a db with a few tables :- ATHLETE, which contains fields ATHLETE (the record Id), FIRST, LAST, AGE and SEX; MEET, with fields MEET (the record Id), and MNAME; RESULT, with … |
| | Hi, I am a beginner in php mysql... I want to pass null values to integer from PHP file to mysql stored procedure. eg: $name = "John"; $age = $_POST['age']; // Which is a null value.. and i called the procedure like CALL InsertStudent('$name',$age); my procedure is not executing ... …  |
| | hello i am trying to display an image from a database which has just been uploaded by the user. when they go onto the next page the image should be displayed here. I have been able to get it to display the path for the image that haas been stored … |
| | I have this page which has to retrieve the information from a database and display using the list menu object can someone please let me know of how to do it. The idea is when the name is selected it will retrieve the information relating to that name from the … |
| | hello, everybody i have a problem , i have table , it contoin column ORDER ID, customer ID, amount, DATE. a problem when i type or create this table, i make a mistake i dont know where is my mistake when i type in mySQL database BY using ( MYSQL … |
| | hai i am write simple java code dataRetriving from Mysqldatabase to c:\ Commend fromt The out put desplay QUERY send me Plse |
| | hi to all the experts here, i am facing a minor problem..... i ady established the connection from VB6 via ODBC to MySQL and all the data needed has been passed to MySQL perfectly. But then how do i actualli retrieve the date from MySQL and show in VB 6.0? …  |
| | Guys i want to make a system that can access a mysql database through the internet. Does this mean that i going to assign the IP address of my database server to the IP given by the provider? like for example 110.92.221.70.. is this valid as the ip address that … |
| | hai i am nireekshan; i am using Mysql 5.0; it was instaling C:\Program Files\MySQL; i am write code Bellow see and --save c:\ "Mysqlcon.java " in this program run-in commend Fromt> javac Mysqlcon.java It was NOT Any Errer; >java Mysqlcon ERRER ACCERED.......CLASS NOT FOUND EXPATION //I AM COPY Mysql.jar file … |
| | how the image is upload and download in mysql databse using jsp. also how the downloading image can be show on the webpage.. as same in any profile (like in orkut) |
| | i am trying created a table on the server called images and when i text to see if the table has been created i get the message table already exists. as i did not develop the rest o the site i thought a table might have been created already called … |
| | Hi All, I am new to PHP, I have tried to look for similar error but could not find anwers that helped me. I am getting the following error: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\ ... register.php on line 109 Here is my … |
| | Hello i am having a problem with trying to create a table on the server every time a try to enter data into the database i get the message table already exists. I have moved the code to create the table on to its own page and only recall that … |
| | Hi, I can create all tables but order table. What is wrong, is it foreign key? [code=sql]CREATE TABLE customer( customerId INT(10) NOT NULL AUTO_INCREMENT, customerName VARCHAR(10), customerSurname VARCHAR(10), customerAddress VARCHAR(10), PRIMARY KEY (customerId)); CREATE TABLE order( orderId INT(10) NOT NULL AUTO_INCREMENT, customerId INT(10), PRIMARY KEY (orderId), FOREIGN KEY (customerId) REFERENCES … |
| | Hello, I am using a GeoLite Country ip csv and storing it in the db. it contains ip numbers which are normally huge. My problems comes when I search for some of these numbers. my query: [CODE] SELECT * FROM range WHERE range1 >= 1213099967 [/CODE] This query works fine … |
| | Hello this statement below works when the date is set as 02/02/2008 but when i enter it like this 2/2/2008 it dont search the date, in the database the date is set as 2/2/2008 because i need it in that format. i want to search dates from and to like … |
| | i want to generate a query example: if the english question s given ->list all the details from my_table where name='smith' and age <30 it shld generate a mysql query for the question ->SELECT * FROM my_table WHERE name = 'Smith AND age < 30;  |
| | Dear programers, i am new to mysql and webhosting. i have one website script,i want to instal the same script to my two domain names(for example: domain1.com and domain2.com) i dont want to add this two domain like addon domain. i have two different hosting for this two domains. for …  |
| | is this possible, i had to use the mysql class to connect to the database, but i would rather use oledb. the connection string i used is "Provider=MySQLProv;Data Source=mySQLDB;User Id=myUsername;Password=myPassword" when i try to connect a popup titled "MySql Data Source Name Setup" always comes up. even if i try … |
| |
The End.