10,946 Topics
 | |
| | 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 … |
| | |
 | Hi All, I am a Problem with Database. I Don't Know How Can i Import my Data in MySQL Database Using CSV Format. Can anyone Plz Help me. I am Using phpMyAdmin for Accessing my Database... Plz Help me. |
| | If you read an earlier thread i started i was having completely the opposite problem that i am having now. Before it kept telling me that the table already existed and now it tells me the table does not exist. I have created the table in the db.php page where … |
| | Hello everyone, I seem to be having a problem inserting some information into a MySQL table. Below is a copy of the MySQL table code I used and also the PHP code. I was wondering if anyone can help me find out why it wont insert the information. What I … |
| | Girlfriend would like to learn about MySQL. Can you recommend any book that purely deal with MySQL? No adds on as PHP or any other web developing technology? I know there are many sites with great tutorials but she insist on book so I have the "pleasure" to find the … |
| | Hello everyone, Im once having problems trying to retrieve information from one of my tables. I have a table with the following information: [code] CREATE TABLE `island2` ( `id` int(10) unsigned NOT NULL auto_increment, `user` int(11) NOT NULL default '0', `island` int(11) NOT NULL default '0', `town` int(11) NOT NULL … |
| | 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; using java as language |
 | Hello everyone! I am writing a music database, and I need to insert into album table the path to its cover. However, not every album has a cover in its directory, so I've made an algorithm that only gets the albumID that has a cover. My question is - how … |
| | i have once again been asked to fix some code on a website. this time the website is meant to have a content management system but once again the person who made the original website did not complete what he started. the content management system side of it is using … |
| | I am trying to set up a database on the server and keep getting the same error message. it say to me that it was successful in connecting to the db but access is denied for the user. what is causing this as the password and user name that is … |
| | Hi all The following query works and gives me the desired results. The only problem is that it is very slow, and I suspect it is because of the multiple sub-queries included in it. The table, RESULT, has multiple records per athlete, per stroke, per distance stored in the order … |
| | |
| | hello, basically ive got a while loop which brings up bookings dates but i want to send a selected row to a table within the sql table but depending on, one specific field for instance if the name = "tom" i want to send it to the table called tom, … |
| | Hello everyone, I was elected to be the company "IT guy" at a printing company aside from my day-to-day job here (lucky me), and have done a minimal amount of coding (HTML, ASP), but could definitely use some help on this project. We have some large clients who insist on … |
| | Hi, I have a question about how to select form a subquery. I'm attempting to count the number of times each m_id is returned after running this query: [code]SELECT m_id FROM taglink WHERE m_id <> '25' AND t_id IN ( SELECT t_id FROM taglink WHERE m_id = '25' )[/code] The … |
| | i have written a simple class for OOP in mysql and php and when i tested if even if the values that i used also in my normal connection process is the same the mysql won't connect me to it.. this is my class: [CODE] <?php class DBlink{ protected $link,$dbname,$uname,$passw,$db,$hname; … |
| | Hi everyone! :) I'm just starting out with php and mysql, and encountered the following problem: I have installed: Apache 2.2.8-1 PHP 5.2.5-7 MySQL 5.0.51-3 on an Arch-Linux system. Apache and PHP are working: I tested that. I can log in to mysql from the commandline; I made a small … |
| | As you know mysql is not compiled into php as of version 4, so you have to do some configuration for your php script to properly communicate with mysql server. I’m new to php/mysql development environment; at first everything was frustrating and you don’t get the help you require promptly. … |
| | What would I need to add so that I can return a count of the number of rows retrieved in the query? I am not sure where to include the COUNT (another query?) and then what syntax to use to print the result. thanks [CODE]$data = mysql_query('SELECT * FROM `bus_basic` … |
 | Hi, Am sort of in a fix at the moment. Am at the stage of creating my database from my ER diagram of which certain tables rely on the InnoDB storage engine for referential integrity, transactions etc. By shockingly enough my ISP doesnt offer InnoDB table types due to the … |
The End.