10,940 Topics
 | |
| | <?php $con = mysql_connect("localhost", "root", ""); if (!$con) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db("kar",$con); $sql = "SELECT * from valid"; $result = mysql_query($sql,$con); print_r(mysql_fetch_assoc($result)); echo "<br>"; mysql_close($con); ?> |
| | Hi, I am about to blow my brains out. Im sure you've been there! I am trying to create a table in my MySQL database and getting this error -> SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds … |
| | Can anyone help me? Can i know what is the difference between superkey and primary key? what is actually candidatekey? |
| | The script is supposed to receive data from a HTML form and update the table based on the supplied information. This is what I get: "Connected successfully Selected successfully Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in on line 39 Query was empty" [code=php] <? $name = …  |
| | I need help in deciding which DBMS is best suited to fit my system, would it be MySQL or SQL Server Express. The system is a TPS,it stores and manages job applicants data (name, address, gender, educational level, skills, etc). Since I am only a student and this is just … |
| | Hi I am using Navicat and have two tables that have a one to many relationship. I have a table called rlbbulbs and a table called rlbbrand. brandID is the primary key in rlbbrand and is supposed to be the foreign key in rlbbulbs. Navicat has a way of creating … |
| | Briefcase application Access 2003 two way replication Are there any open source databases that allow two way replication exactly the way Access 2003 handles it? I have a desktop app that I would also like to have live on the web but I have to use Open Source software like … |
| | Hi i am trying to design a social networking site for my project. i have to design the database for the social networking with user profile and friends contact list as like facebook and orkut. can anyone help me to implement the database design with fast and accuracy retrieval of … |
| | Hi I want to create a database that can store the friends contact list as like social networking what is the best way to design the database structure and easy to retrieve the contacts of friends using mysql. i need solution for this, HELP ME regards ~Deepu~ |
| | Hello all, I need to find all the records of one table that relate to ALL records of another table. I was thinking that I can check to see if a two tables are equal (via sub-selects). Is there a way to compare tables in SQL or is there an …  |
| | I am using the code below to insert the username and password to keep thi id and password record i want the change that if the id and password exist it replace the id and password in the database [CODE]$username=$_POST['login']; $password=$_POST['passwd']; $con=mysql_connect('localhost','root',''); //establishing connection with server mysql_select_db("sql", $con); //selecting DataBase … |
| | Hi all, I try to view latest date and amount from history table for each branch (branch table :viscawangan). But accouter problem to view [B]amount [/B]value. [CODE] SELECT b.kod_cawangan,b.nama_cawangan, MAX( a.tkh_data ) AS tarikh_data,[B]a.amount[/B] FROM history a, viscawangan b WHERE a.kod_caw = b.kod_cawangan GROUP BY kod_caw [/CODE] Here i give … |
 | Hi all I'd just like to know if it's possible to specify two different values for the same column in a WHERE in MySQL. For example [CODE=mysql]...WHERE column1 = 0 OR WHERE column1 = 20[/CODE] That's what I'm using at the moment but it only returns a result where column1 … |
| | Does anyone know why the following subquery is using filesort and scanning all rows in the table according to EXPLAIN? I am trying to get the total of the top ten scores and the result is fine. [CODE]EXPLAIN SELECT SUM( score ) AS top10_total FROM ( SELECT score FROM answers … |
| | I'm coding my own blog which is almost completing. I'm facing a problem on one thing. How can I insert comma separated tags in mysql table? I want to insert every comma separated tag as the new entry in the table. I would be thankful if anyone will help me … |
| | Hi, I have two databases (live and staging). Extra columns have been added to various tables within the staging database by another developer while they were extending the websites functionality. Now has come the time to put the new functionality live, which means taking the staging database schema, creating a … |
| | Hi all, User table has an ipAddress column, & userid column as pk...maybe more than one user has the same ip! UserActivity table has userid as fk, and activityid which is fk to activity table So, I'm trying to get a count of how many rows in the user activity … |
| | I don't know what I'm doing wrong, but it won't update ever. I know all the variables work because I've posted them in several places, I've echoed them out, copied that and put it into the query and it's worked, and I've copied it to an entirely different page and … |
| | Hi there, most interesting forum and I hope I can get some help here. I have 2 record sets, one which looks up a product by SKU and the table contains a field with "related SKU's" in a comma separated text field. I have created a Var with the "related … |
| | If I am violating a rule please delete this thread. I posted this question in the Linux forms. [url]http://www.daniweb.com/forums/thread298067.html[/url] I have a screwed MySql install in Linux, I assume someone will have the answer to this over here as the Linux forums seem dry.  |
| | Hi everyone. I want to add a advanced search function to a demo site I'm doing but have no idea where to begin on this. I'm using a MySQL Db for all the site and PHP to pull data from DB. Any suggestions are welcome. Regards |
| | On average, I Have been doing quite well on my "TAXA" Wood Wood Knowledge Base website in getting many of the features coded and working --- more than this slow and amateur PHP coder that he could. I even got a search engine working yesterday, something I was not sure … |
 | hi guys i need youre help i have a problem. im retrieving a records (20000+)from my database, $result = mysql_query("SELECT * FROM banco order by counterindex asc"); but it only display 200+ how can i display all my record by page? any help and suggestion is greatly appreciated. |
| | Hi - I've got two (2) Tables: Old and New There are two Fields: ID and Status What I want to do is compare the ID fields between New and Old; if a specific ID is in the New table BUT NOT in the Old table, the I want to … |
| | Hi i have data in a mysql table which is about 70000 rows. In one column there is information that I would like to split into 2 rows. The information I want to send over to the other named row is nicely sat in brackets eg (18) . It is … |
| | Hi I'd like to run a flashMovie in a .php page to the norm html. Fla's run ok, except they don't handle 3D object key command .swfs. [url]http://www.flashsandy.org/demos[/url] Click on 2nd image of a type of jet_copter Gavia AT-1008 as the best example of what is possible. Use keyboard arrows … |
| | Hi, Trying to run this script via MySQL workbench. Can anyone see anything wrong with it? I suspect the foreign keys are not defined properly? Thanks [CODE]USE streamlibrary; DROP TABLE IF EXISTS streamlibrary.FileProperties ; CREATE TABLE IF NOT EXISTS streamlibrary.FileProperties( PK_fileName VARCHAR(50) NOT NULL, extension VARCHAR(4) NOT NULL , sizeMB … |
| | I am trying to convert my CMS to SQLite for easy and quicker deploy-ability. Performance wise, I heard that SQLite might be the way to go. At any rate, I am having the hardest time with trying to convert my mysql database to a SQLite database. Having reviewed and downloaded … |
| | hey guys, my simple program flows like this: a textbox where in you will input a keyword then when you press the 'go' button the data in the mysql database will be shown in the listview. im using mysql and vb .net. i've made the table with sample records in …  |
| | Hi to all, i am building a site with movie reviews.. due to the fact that a movie may have more than one category ex action, adventure, sci fi etc i ended up using a sinlge column to add all tha categories in comma delimited form.. 1st question. is the …  |
The End.