7,368 Topics
| |
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 … | |
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, … | |
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 … | |
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. | |
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 … | |
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 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] | |
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! | |
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 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 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 … | |
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 … | |
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 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 | |
[CODE=SQL] please help any one, how to write PHP, what is the use of PHP, syntex, advantages etc.... [/CODE] | |
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 … | |
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 … |
The End.