10,938 Topics
 | |
| | 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 |
| | 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;  |
The End.