11,093 Topics
 | |
| | |
| | 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, … |
 | 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 …  |
The End.