10,938 Topics
 | |
| | Hi all, I'm trying to build a new search system for one of my sites. The idea is something like this: 1. Visitors choose something in dropdown1 (ex. seach staff, search students, seach grades) - all these choises should be extracted from mySQL db and could be updated from time … |
| | Hi there, Anyone to help me on sql code for SUM. I need a query that gets the SUM of one table column and subtract it from the sum from another table column: I tried this but it gave me wrong answer; [icode]SELECT SUM(i.amount-p.amount) FROM income i, payments p;[/icode] |
| | Hi all, I am trying to install MySQL++ on Windows XP and use it. I was able to install it in Linux because the website: [url]http://tangentsoft.net/mysql++/[/url] provided an RPM that built the libraries for you. As far as I can tell, no such thing is supplied for Windows. Supposedly, MySQL++ … |
| | Hi i am new here and I post this topic hoping that i will get some urgent help. I tried this code which should work to export customers emails according to their orders' status but the exported file contained an error. This is the error: PHP Code: [CODE=html]<br /> <b>Warning</b>: … |
| | I want to transfer a large text file (a database of over 1000 users) into phpmyadmin? How do you recommend I do this most efficiently? do I have to go through each user individually placing the appropriate quotations and punctuation? or is there an easier method? Thanks! |
| | Hi! I'm trying to learn PHP but as proceed with tutorials I encounter more and more problems. and I'm not sure if they are arising from my mistakes because I just rewrite very simple tutorial excerisies. I get this two errors when I load table1.php in my browser: Warning: mysql_num_rows(): … |
| | |
| | i forgot my username and password,.where could i find it?could it be possible that i could still retrieve it?i can access to the server and phpmyadmin,. but i simply forgot it... thank you!  |
 | Dear All, I am new to MySQL. Can i retrive the result of a query as the combination of different fields of a single record.. For example.. if the result record of a query is ... id(1), country(India), Location1(maharashtra), Location2(pune), Location3(Navi Mumbai)... My doubt is that can i retrive the …  |
| | Hi... when i use mysql queries with php, is there any way to load my page faster? Can certain divs or tables that use mysql query being executed last? after the page fully loads? |
 | In my last topic i quess i was asking to much so no one would help me, so this time ill take it one step at a time, heres my first problem. [CODE]<? include("dbinfo.inc.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM tutorials WHERE tut_program='Photoshop' AND tut_category='Text … |
| | hi guys... i have an urgent problem please give an idea about it.. Question#1: I want to know the correct date syntax in query database using MySQL... Question#2: I currenly using the MySQL connector/OBDC 3.51 is their any problem about it?? thxx in advance.... and ned asap reply... thxxxxxxxxxxxx guyzzzzz.. |
| | I'm having problems filtering the date for my reports with access and older versions of mysql i can do this my using this query format: Select * from transactions where xdate =#"& txtdate.text &"# or Select * from transactions where xdate =#"& format(txtdate.text,"mm/dd/yyyy") &"# but now that i'm using wamp …  |
| | 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 …  |
The End.