10,946 Topics
 | |
 | Hey Im having this problem, im sure theres a simple solution, but i cant seem to see it :D The code bellow is part of a regestration form validation. Basicly when i ask the database if anyone else exists with the same username, password or email address - it works … |
| | Hello, First of all thanks for time reading this post and the problem is that: I'm Using Borland c++ builder 6 and i want to connect to my database through BDE components, i added Database, Table and Query components, filled query , added params to Database and tried to connect … |
| | Hi there, I'm new to web development and I have a question about MMS. I couldn't find a fitting forum to post in, but I hope it's alright in here :) How do you create a MMS-inbox on a server, what techniques do you use? We're running a Resin web …  |
| | hyy... i hv aproblem.. iwant to make aplication thabt need some field database from other database(pg-sql) and want to copy it to other database(mysql). can that skrip make this happen auto copying...?  |
| | Hello all, i get a problem: 1 have 1 database and want to move some field in tabel to other database automaticly, how to make this happen to auto copyning data everyday or every hour..? anyone can help me.. Thanks for read my thread, Ardy Satria. |
| | Hi.. I am new in php +ajax.....Now i am doing project in php+ajax+linux environment...i create a login page using php,ajax,mysql,, i have mysql tables are. register,slideshow,,,,,In register table having following field... 1.uid (autoincrement)2.first (firstname)3.last(surname)4.user(username),5.pass(password) In slide show table having following field,,, 1.uid 2.pid(presentation id,autoincrment) 3.slideno 4.description 5.location(this is what image … |
| | Hey. Right now in my game (online) I'm using std::vectors to store player info. Should I continue to use them (I hate having to loop thru them each time to find a player) or should I use MySQL to hold player information (like map their on, nickname, id, position, etc.)?  |
| | Hello, I am a PHP programmer, trying to transition to C++. I need C++ to communicate with MySQL, so I realize i need to have mysql++ libraries. I am using winXP. I have MinGW. I am just trying to install MySQL++, and I am having problems. I have been following … |
| | I need to get information from 2 tables in the same mysql database [code=php]$sql = mysql_query("SELECT * FROM notes, customers WHERE `to`='next' LIMIT 5"); while($a = mysql_fetch_array($sql)){ $row_color = ($row_count % 2) ? "#EFEFEF" : "#FFFFFF"; echo("<tr bgcolor=\"$row_color\"> <td height=\"25\">" . $a['custid'] . "</td> <td height=\"25\">" . $a['name'] . "</td> … |
| | Good day!! Hi...I having hard times in doing an online voting system using PHP and mySQL as database. It's like...student council election; once I login..i can then view my personal profile then view all the candidates in each position...I can then vote my desired candidate.Only one vote is allowed in … |
| | i am trying to send out an email which contains images from a database of images that have been uploaded. when i send the email out only the text and any images that have been hard codeing in using the img tag. i have done some research on this and … |
| | hello to every body, i have a problem in mysql database i dont know where i made mistake, i wrote a database this one dow, please show me where is my mistake or how i can use in simple way [code=php]<? trim($searchterm); if (!$searchtype || !$searchterm) { echo "You have … |
| | Hi, I have a project which requires me to use PL/SQL blocks, PL/SQL cursors, PL/SQL stored procedures, PL/SQL stored functions and PL/SQL triggers. I think(not sure) i can create PL/SQL stored procedures, PL/SQL stored functions and PL/SQL triggers in MySQL. Can i create PL/SQL blocks and PL/SQL cursors within MySQL … |
| | hi i have two tables,i want to display the details in startpost and based on the userid i want to display the username ie i want to print posttitle,date,name using single query please help [CODE] CREATE TABLE `creuser` ( `uid` int(11) NOT NULL auto_increment, `username` varchar(100) NOT NULL, UNIQUE KEY … |
| | hi, i need the code to connect mysql through python programming language  |
 | I've been away from sql for quite a well and need a little push to get restarted. Need to report out of a single table, with values coming out of only two columns. Need to group items from column 1 as the left column in the ouput table with totals … |
 | Having braved the task that is getting mySQL6.0 installed onto my machine, after listening to the preferences voiced by database users everywhere I was delighted when I finally got down to a bit of a play!!! The problem I found almost immediately, was that a lot of the returned results … |
| | 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.. |
| | 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 …  |
| | 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 |
The End.