11,093 Topics
 | |
| | Hi there what i'm trying to do is: return a car manufacturer from a MySQL database and have the text returned a hyperlink to the car manufacturer website. The below just returns the manufacturer without a hyperlink: [B]$row['manufacturer'][/B] Would i make a row in the database called 'carmakeurl', store the … |
| | i got this error: [code]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\db.php on line 13[/code] my php code is this: [code=php] <?php //Database Info $dbhost="localhost"; $dbuser="root"; $dbpass="something"; $dbname="somedb"; $table="users"; //Connect to Database $con=mysql_connect($dbhost, $dbuser, $dbpass); mysql_select_db($dbname, $con); $user=$_POST['user']; $pass=$_POST['pass']; $query = "SELECT * FROM $table … |
| | Howdy, I am trying to write a simple program in java that creates a database with some tables and adds some data, but I keep gettin this error: [CODE]java.sql.SQLException: No database selected[/CODE] I am posting the code below, it's really easy to understand. Please HELP!!! I am new at mySQL … |
| | basically i want to be able to display an image from a mySQL database using PHP. I heard about this BLOB binary stuff & decided it was too complicated. How would i store a url so that i could access and display it directly in PHP. For example, would i … |
| | Hi to all I need some help to write a java program to parse 2 text file one containing the details of the database and the other the data that will be used to insert in the tables of the database A sample for the first file : schema : … |
 | Hi all ! I have been assigned a task to implement an insert query into table a [i] only if [/i] a record doesn't exist in table c. I have been scratching my head for past 2 days and even my best friend [i] google [/i] didn't help me much, … |
| | I have been trying to format a date that I receive from a value in a mysql database. The format in mysql is as follows. 1986-08-02 I want to convert that to Aug. 2, 1986 I tried the date function in php and it was not working for me. Anyone, … |
| | I apologize beforehand if this topic is in the wrong place. Quite honestly I am desperate for help. I have a project for school involving Firefox and making an extension that is a visual database. My professor suggested I use SQL Lite to make the database. I am so beyond …  |
| | hello i got this error while taking a backup in mysql usung mysql administrator Error Performing Backup: Could not open file for writing backup. what does it mean how can i get rid of it the error at last table to be backedup |
| | I'm trying to create a form that updates a MySQL record when the user clicks a LINK, not a button. I don't want to open another page for this. There really isn't a need for me to post my code right now, as I'm trying to figure out how to …  |
 | hi all i would like to create a registration and login and selection database, css, mysqladmin. need lots of help.. thanx something like this for example.. I am/We are a: Man Woman Couple (man and woman) *Interested in meeting: a Man a Woman a Couple (man and woman) a Group … |
| | I am new to PHP. I have a MySQL database with a column of URL's. I have a PHP script that randomizes the URL's and echoes the result to the browser. I just need a need a way to turn the randomized URL into a clickable link. I would imagine … |
| | Dear Masters, I have a problem on comparing data. I have two databases that have a similar (if not same) tables, but holds different data, and I want to merge the two tables. But can't seem to figure the easy way to do that, again and again I use script …  |
| | Hi i'm trying to write a simple SQL command to use within PHP. I want to select the whole table, sort by one of the columns, then only display the top 100 rows. Without the[B] WHERE rownum <=10[/B] it works fine. But it displays the whole contents of the table … |
| | i am having an issuse not sure how to approach this i have setup a area that grabs user's / user data by a search now i dont get the same results when i do lower case and uppser case any ideas ? [code]$query = "SELECT * FROM `users` WHERE … |
| | how can i find size of my database what is the max table size in mysql is table size shown is in terms of kb or mb in mysql by default actually dis is the max_data length shown using "show table status" 281474976710655. means data size is shown in kb … |
| | hi im a newbie at this but im getting a error message that says: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pickurau/public_html/classes/Lib/Query.php on line 27 and line 27 starts with the if(!mysql_affected_rows() || mysql_num_rows($this->rs) < 1) return false; does anyone know how can i fix … |
| | how to implement a java class making dynamic queries in java that access mySql tables query,insert & delete taking changing conditions & parameters every time like : SELECT field_names FROM tablename WHERE condition every time it takes different field_names , tablename and conditions  |
| | Hello, I am trying to store a single MYSQL result into a 2 dimensional array, for example I would like to end up with something like this: array[0][0] = result[0] , array[0][1] = result[1] , array[0][2] = result[2] ..... Here is my code: [code] $tempCat = array(); for ($i=0;$i<$numcat;$i++) { … |
| | i want to insert into table some dummy data so as to large my database is there any script or procedure in mysql to execute a insert statement about some thousands times |
| | |
| | Hi, I want to send a XML file to my website where the XML is read and information passed to MySQL database. I know this is done but i don't know how to do it. Something related to header etc? Any idea? Thanks |
| | Hi, I have been building a shopping cart for a website that I am building. What I am trying to do is created a purchase history so when an item is purchased it is stored in the customers purchase history (in the customers MySQL table). I have three tables Cart … |
| | attached is a screenshot of what my table already has for the URL micorosft.com. The column headings are the same as column names. Now, if I do the following statement: [CODE=MYSQL]select * from assign2 where UPPER(keyword1) LIKE '%MICROSOFT%';[/CODE] OR [CODE=MYSQL] select * from assign2 where keyword1 LIKE '%microsoft%'; [/CODE] I … |
| | Hi, I am attempting to write a query to return whether or not a particular items value entered is the lowest value and also unique. For example, if an item as 6 values against it e.g. user_id item_id value 1 101 3 2 101 3 2 101 4 3 101 … |
| | i want to insert dummy data for testing my database.so i want to execute a single insert statement 1000 times. is there any function to do so or is there any script todo. if so plz help me |
| | hi all could someone plz help me out in validating csv file(excel sheet) before i can insert it into the database?:?: i hv the code for uploading but not validating reply ASAP. cheers coder |
 | I can handle errors just fine on MySQL, but what about warnings? If I use the following code I still get to see the warning, while that is not what I want: [code=php] if(mysql_connect($host, $user, $pass)) { $conn_server = true; } else { $msg = "Fout bij verbinden naar de … |
| | Hi, I am new to PHP and Mysql development . I had installed RHEL5 Server, Apache, PHP5 and MYSQL5.1. I got below script which actually give status of the Apache, PHP and MYSQL. [code] <?php session_start(); ?> <!-- INSTRUCTIONS: 1. Please copy this file anywhere in the DocumentRoot of your … |
| | I am using Wamp server, I reinstalled Wamp after uninstalling it to try Xaamp.I have completely removed all of the Xaamp files.Recently,I opened my phpmyadmin directory and discovered an error message which hinted to me that there were two MY SQL servers installed on my computer(please refer to [url]http://i89.servimg.com/u/f89/13/69/31/58/sql_mi10.jpg[/url] ). … |
| | Hi everyone, I am creating a student timetable. I have the table done in html and I now need to input the values in the database. I was trying to use something along the lines of [code]if(day = 'Monday' && time = '9') { echo(subject); }[/code] i keep getting an … |
| | Hi Everyone, I am facing one problem in inserting query when i am inserting value of textarea in database. Let me explain whole of this. i am working as a empoyee form in which form when we insert value of all information regarding leave of that employee . In this … |
| | HI there [QUOTE]Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`database/t1`, CONSTRAINT `t1_ibfk_1` FOREIGN KEY (`ID`) REFERENCES `t1` (`ID`))[/QUOTE] The field ID is an auto-increment field and I altered the field to a lower number and now I can't insert any … |
| | how can we check whether the primary and foreign key are working in the database in mysql |
| | Hi, I need to retrieve the max and min values of the price field in my db. I have a item table and a category table. I am using $_GET['category'] to get the category name and then I need to retrieve the min and maxvalues only for the items in … |
| | I have a small database, at the present time, built for basic tracking and it has 5 rows ... trackid datetime uid emailaddress orgcodetrack It's populate with 10 records test data from 3 users (uid)... I need to return the total visits from each uid... Here's what I have so … |
| | hey, I am having some trouble with this one. I am doing a student web organiser.The user registers details which goes into userinfo and sem1week1. My three tables are: 1.userinfo: firstname, lastname, e-mail, username, password, coursecode, courseyear. 2.courseinfo: subject, time, day, semester, coursecode, courseyear. 3.sem1week1: username, coursecode, courseyear, day, time, …  |
| | hai i want a shell script to load data from a csv file into mysql table plz reply me soon urgent |
| | Hi Ive reached my own limit with this one... hopefully its not that tricky. I have a products table, each with a unique id. I then have a complimentary_items table which links two products as 'matches'. The complimentary items table has three columns: id, prod_id1, prod_id2. Can I write 1 … |
| | i had a table categories(cid int primekey,name varchar,description text,parent_id,created date,updated date) i want a script for insertion like this insert into categories(...) values(cid value,name value,..desc, parent_Id..); can i write the statement as insert into categories(....) values (1,'aaa','some text',[U]select parent_id from categories where parent_id=id[/U],date,date); just i wana know how can i … |
| | hi all, am still new in developing J2ME applications.I have a mobile application that needs to connect to mysql database using JSP as the middleware..can anyone please sort me out am stuck on the how to go about it. |
| | I use MySQL-Front tool create and call Stored Procedure successfully, but in my PHP code and phpMyAdmin it fails. How can i figure out this problem when i run on phpMyAdmin the error show #1305 - PROCEDURE joomla1.5.9.save_orders does not exist this is my code of procedure [code=sql]DROP PROCEDURE `save_orders`// …  |
| | I have a query [code=language] SELECT radcheck.id, radcheck.UserName, radcheck.epost, radcheck.fylke, MAX( radacct.AcctStopTime ) AS AcctStopTime FROM radcheck LEFT JOIN radacct ON radcheck.UserName LIKE radacct.UserName WHERE AcctStopTime LIKE '%2009-03-19%' GROUP BY radcheck.id[/code] I'm looking for a way to use wilcards, > <, NOT LIKE etc on only the highest date value … |
| | i have a database and it has a column thats id its auto incrementing and one called download_link i want to have that autofill with a url thats concatinated with my id so localhost/upload/downloadtest.php?id= adds the id and becomes localhost/upload/downloadtest.php?id=1 localhost/upload/downloadtest.php?id=2 localhost/upload/downloadtest.php?id=3 etc how could i do that be done |
| | [CODE]$realUser = mysql_query("SELECT Username FROM my_db WHERE Username = $user ");[/CODE] This is not storing the $user value to $realUser. I am correctly using $_REQUEST['user'] to retrieve the value for $user from a form, and I am connected to my database. I understand there is an issue with PHP variables … |
| | i have a table holding files and each has a unique id eg. 1, 2, 3 etc. i have a column in the table i want to contan the link that should be <a href=\"localhost/upload/dltest.php?id=(number) eg. <a href=\"localhost/upload/dltest.php?id=2 i want that link to be auto created from the other information … |
| | I have two tables, question_table and answer_table. i want to be able to select a certain number of questions in a random order and have the answers that relate to the selected questions also display. IE: question_Table: ID: Question_Text 1 Who are you? Answer_Table: ID: Question_ID: Question_Answer 1 1 Me. … |
| | Hi guys.! Good day! I have a one windows xp computer which ive installed wamp(windows apache mysql) package. I want to connect to this computer using one computer on a network. The code works fine when i run the program on this server computer because i will just specify the … |
| | I would like to create a table in mysql, with one of the fields being images. Can any one tell me what type i should call the field, and also if i have to put in any special commands. thank you |
| | i had a table categories category_id parent_id industrial null automotive null petrol industrial bikes automotive diesel industrial tankers automotive ....so on ihad another table CATEGORY_PRODUCT with fields(category_id) in this table i want to insert the category_id from category table as if parent_id=null then insert category_id as parent_id if parent_id !=null … |
The End.