Database Php
id name
1 Dad
2 Mom
3 Brother
4 Sister
5 Brother
I want to use html form and php to access the database and alter it, basically delete and insert. I know how to make the html form. But I don't know how to create the php script. So far I've been using phpmadmin, it's great but I want something simple.
Sergewiz, helped me with the main php element that I wish to use.
update table_name set id = id + 1 where id > 3;
insert into table_name(id,name) values(4,'sister');
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Database Transfer Between Oracle 8 Database And MySQL Database
Is it somebody out there who has made a migration from an Oracle server to an MySQL server?? The scenario is as simply: I've got a Oracle 8 server with a database with content that I want to transfer to a MySQL database. No special data, constraints etc that MySQL not will handle. My solution is to reverse engineer the database from ERStudio and then produce a SQL script that will insert the data into the MySQL engine. But I can't do this, because the customer want me to do a PL/SQL script that does this, even if he never have worked with Oracle.. So the question is.. Do someone know a simplier way to do this or do I have to teach myself PL/SQL and make a script that produces a MySQL sql script ?
Script For Uploading Data From Local Database To Production Database
I am using MYSQL 4.0 for my local and production databases. I want to extract selected records from selected tables from local database and upload them to my production database on daily basis. In other words, I want to upload data which is entered in local database on daily basis to my production database.
How To Apply New Database Structure To An Existing Database, Without Overwriting Data?
I am writing a simple blog software application. We released a version of this software a while ago. It comes with a sql-tables.sql file, that you can just import into your mysql database and it will setup all the tables for you, for a fresh installation. We made the sql file by just doing an export I believe, without exporting the data that was in OUR database. Well, since then several people have downloaded and installed our software, and are using it. We are about to release a new version soon, however. Since it is all still under development, many things have changed in our database structure. We've added new tables, and modified or even removed fields from existing tables. So for the new release, we're going to include a new sql-tables.sql file obviously, so that for fresh installations they can still install it just like normal. However, the question is... how do you "upgrade" all the previous version's users's databases, without losing any of their data? Is there anyway to export just the structure of our current database... then somehow apply it so that it just goes through and changes another database to match the new structure? Or any ideas at all how to do this?
How To Convert MS Access Database To Mysql Database??
now i have more than ten thousand data in MS Access database and now i heed change it in to mysql database!So do you know how to that?I think i not time to key in back this all data because it is imposible la,because more than 10 thousand data la!
Converting Ms Access Database To Mysql 5 Database
I've imported a ms access database into a table in a mysql database. The access database contains a field that holds date/time values in 'general date' format. These all show up at 01/01/1970 in the mysql database. I believe the field in mysql is wanting UTC and shows numbers when looked at from the sql command line (i.e. March 13, 2006, 5:31 pm is shown as 1142289086). How do I get the access data into that format so it will import properly?
Cannot Select Database: No Database Selected
This is the error I get in multiple locations on my website. I am using postnuke for my website. I get this error when I try to access my PostCalendar, PNaddressbook, the modules area in the admin screen, the permissions area in the admin screen, and the blocks area in my admin screen. I had a backup of the entire postnuke folder when it was working. I replaced it with the functional postnuke backup and the problem still exists. I know it isn't Postnuke. The only possible problem could be in MySQL.
Database Error : No Database Selected
I am trying to install an application called weberp on my website. I have writen a script to test that the database name, user name, and password are all correct, and mysql is there and running okay. I entered a script into myphpadmin to establish the database. All the tables, and so forth, were created with no errors.
Database Error : No Database Selected
I am using myphpadmin to try and install weberp on a website. I keep getting this error, and I can't figure out why. The username, password, and database name; are all correct. The script to set up the database ran with no problems.
Extracting Data From Large SINGLE-table Database To MULT-table Relational Database
I have a very large single-table database of articles that I want to convert to a multi-table, relational database. The existing single-table database contains fields for article author, article source, and article category, where several 'author', 'source', and 'category' IDs repeat dozens of times for hundreds of different articles. I want to create seperate tables for author, source, and category and populate the new tables by extracting data from the original single-table database by unique ID field. I figured out how to use INSERT and SELECT to pull data in new tables, but can't figure out how to pull only a single instance of a unique author, source, and category to create master reference tables for author/source/category.
Convert Ver 4.0 Database To Ver 4.1 Database
I do not know if this is the correct forum to ask this in or not. We have changed hosts and the old hosting company was running MySQL version 4.0.27 standard and our new host is running MySQL version 4.1.22 Standard. We have a database from the old host that we need to convert to MySQL ver 4.1.22 so we can use it on the new host. We were running a older version of SugarCRM on the old host but we upgraded when we went to the new host and the new version of SugarCRM will not work with the copy of our old database file. It says that it needs MySQL version 4.1.2 or higher. Is there any way to convert the old data base.
Dropping Database Called "database"
I have finally managed to install and configure mysql on my pc for testing but need to import data from an Access Database. I first found out that I had to create a new user and grant priviledges to it - which means I could connect. My next stage was using the migration tool to import the data. This did not go so well... Firstly, many of the table names had spaces in them which means that they are effectively useless in mysql. So I thought I would start again, ensuring that the tables are first renamed in Access. I then went to show databases and, during the migration process, it has given the imported data the default name of "database". I now have a major problem deleting it as it thinks the name is an instruction! Anyone know how to get over this issue?
Move Table From A Database To Another Table In A Database
I am currently developing a project as I am only a web designer. I need to move a table from a database to another table in a database. I am using SQL Server 2005 Express. How is this done? I have been stuck for months trying to figure this out! I have even bought SQL Server Express 2005 for Dummies and cannot figure this out! I need someone to hold my hand and walk me through this literally! Or give me syntax code to do this.
Database
I'm working on a table which contains every member of our website. The table has 5 fields. Name Rank Joindate Picture Information The last one is the one that is bewildering me. You see, my goal is to have the information show up for each member's page. Now this information is several paragraphs long for each member. My question is how I should go about putting the information in the table. Should the information itself be in a .txt file and the url to it be in the table? What datatype should I use for the url, varchar? Is there a completely different way to do this?
Using One Or More Than One Database?
I am doing preliminary research for a future project and would like to ask your opinions on what you suggest is best for maximum database speed as well as stability and reliability. This project would be a web store with tables relating to product info, client info, community forums, financial data, etc. The product info tables would have the most querries, potentially up to tens of thousands of hits per second. I would like people to be able to login without any delays and to get search results back on products within a fraction of a second. Would it make sense to put the product tables into their own database separate from the community forums and client info tables even if they are hosted on the same server? Would there be performance difference and/or better stability, reliability? What about having these separate databases hosted on separate servers? Would that be better than having one all-embracing large database on one server or perhaps on a server cluster? Would there be scalability issues?
Specifying Database Name
I executed a sample jsp, connecting mysql using connectorJ with tomcat.It works fine but it i need to know where I can specify which Database it should use. where can i specify the name of database .
Same Database Name
We are running mysql 4.1.18 Is there a way to prevent users from creating the same database name? for example our name schema goes like: mysql_1234, mysql_32143, mysql_.... But we found out that some one could create MYSQL_1234 while mysql_1234 already exists. I guess what we need to know is that if there is away for mysql to not allow same names even though its different case characters.
Database
I was reading a post on PHPmyadmin here. It got me thinking about just what goes on in there as I never use it being a novice at such things. I had a reason to look for a tut on PHPmyadmin when my password would'nt work on WP and it would'nt accept. I learn here today I should have 'flush privileges' afterwards which I did'nt do, anyway I finally got a new password in the normal way. Today I thought I would look again at PHPmyadmin and see that SMF database is still there with all the members. In Fantastico no SMF how do I install that database to a new install of SMF is the question?
Database
I want to set up a database like IMDB.com but for my stample collecting club. Is there any open source databases like IMDB that I could use that would work like that?
100 MB For A Database
How much is 100 MB for a database? How about a Joomla driven site? Is it enough, a lot, tight...?
What Database To Use
ok, I've been using text based Databases for my website, and i'm wanting to move up in the world, i was thinking MySQL. what would be the best DB for a CGI script? and where and how would i start. any thoughts would help, i know a lot of you have been doing this for a long time, so i would like to get some experienced help.
Two Database
i want to select two tables from two different database. is it possible? i want to know the equivalent of this code in mysql. SQLString = "SELECT * FROM StaffTable INNER JOIN datalog.dbo.Employees ON StaffTable.PinProfile = datalog.dbo.Employees.Payroll_id WHERE PinProfile = '"&Session("user")&"'";
Old Database
I run a clan site and have had a problem with my web host going into liquidation. I have went with another webhost but because of this the prefix for the database is always eurozark_. The backup of my old site has a prefix of smf_. I tried to import the old database but none of the records registered on the new site. Is there a workaround for this or a way to rename the old database so that it will work in the new site. The iste is has SMF forum installed hence the smf_ prefix of the old backup.
Big Database
I will have to design a "big" database : - around 250 tables - between 3 and 4Gb of data - Mainly read-only access I search infos from people who have experiment that size of database with MySql. If you are in this case, I would like to know if you encountered problem due to limitation of MySql in that context.
1 Database Or 2
I am building a website with several scripts that use MySql, Links, Forums, Photo Galleries, News Articles etc. At this point I have no idea how popular the site is going to be and how much data will be inserted into the database. My questions are these: should I put all tables in just on database our should I split them up between 2 or more? I there a difference in performance when the site uses only 1 database or more?
Same Database Name
Is there a way to prevent users from creating the same database name? for example our name schema goes like: mysql_1234, mysql_32143, mysql_.... But we found out that some one could create MYSQL_1234 while mysql_1234 already exists. I guess what we need to know is that if there is away for mysql to not allow same names even though its different case characters.
My SQL Database
I want to install the SCommerce freeware on my localhost. While this installtion, I'm asked, where's my Database and about password and username. But I haven't been asked to make inputs for these subjects. But unfortunatelly I get the return: Access denied for user 'medienwerkstatt'@'localhost' (using password: YES).
Id From Database
I'm programming a photo database with perl and mysql where every user should be able to post some comments to each picture. so i've got two tables one with all the picture data and one with all the comments. my problem now is: How do i get this data together. My solution till now is: Each DB has a field called ID. an in the pictures database i got a field comments. there i'm saving alle comment-ids according to this picture separated by two semicolons so a pictures with 3 comments has a value like 1;;4;;283 in this comments-field. Like this i can read the field separate the ids an get the ids from the database. This doesn't look good to me. Is there any other easier possibility to do that.
Database Name
Is there an SQL command that i can perform which will return me the name of the Database i'm currently conected to.
CD In A Database
Let's say I have two tables Songs and AlbumSongs. Songs has SongTitle as a field and AlbumSongs has TrackLength and TrackNumber. Both have primary keys as in SongID and etc. Now I am asked to find the total length of all CDs in a database. I use the statement: SELECT SUM(TrackLength) FROM AlbumSongs;" And it gave me an answer like 20637(seconds). It seems reasonable since I know for sure that I have 6 bands in my database. Did I do this correctly? Also why is it that when I add Songs after the FROM statement, my answer is like 102356? Is it because of Cartesian whatever? Do I have to math the SongID with SongID with their respective tables?
Database Under Id
I want to be able to delete everything within my database under a certain ID. I know I have to use some sort of Cascading delete but not sure of the syntax.
Database
1)Once I enter a database using Code: use database , how do I exit this database so that if I want to create a database from my root (and not some sub-database, assuming this is what would happen) 2)what to I use to display the current database I'm in?
PMA Database
Whenever i try to install a chat prog on my server i get these stupid errors through MYSQL db through phpmyadmin. Error: The additional Features for working with linked Tables have been deactivated. To find out why click here. So i click here. Error: PMA Database ... not OK[ Documentation ] General relation features Disabled. I have looked all over google for hours tryin to find a solution for this. But i cant seem to find sumone.
Database For My Sql 4.1.14
i have an SQL database for mysql version 4.1.14 and my new shared hosting company provides mysql version 4.0.16 i asked them to upgrade the version they said that they can upgrade for shared hosting guys please help me i want to dump this database.is there anyway to convert my SQL database to mysql version 4.0.16 ? if there is how can i do that
Database
I own a website with free online games. I was thinking of putting all my game info (the description, URL, image URL, game name) into a MySql database. Should I really rely on a database to hold all the game info and everything Is this even a good idea to use a database for this
Database To Use
I'm about to start a huge project, what database software should I use if I want speed? There's going to be tons of data that's going to be indexed and recalled. What database do you guys reckon facebook.com and myspace.com uses? (no i'm not doing a social network site) my friend who works for www.twango.com (gonna kick flickrs ***!) says I should use sql server, but right now I don't have the money for it...I'd rather spend that money on programming talent. Say that I did it in mysql, how hard is it to convert everything to SQL server or oracle?
Database
i am working with this php/mysql program for my website which will allow me to update my "events" page. Basically with this I can easily add and update my events in seconds without messing with the code. anyway, i have installed it, created my database, but i'm having this problem. When i try to do anything that has to read from my database, i get this error message... showlister :: error Could not select database showlister_04b Check database to better understand this you might want to see for your self, go to http://flight409rock.com/tour/admin/add_artists.php and just fill in each form with unecessary info
Database
i have an "image.sql" that i want in my "mysql" database, i want to invoke it with a <?php code.. I have created a new database with the command promt in "mysql", and i see it when i command'show database'. Then i put the "image.sql" in the data floder in mysql by following: programfilesmysqldata. Anyway when i test my server (apache, wich i am running on my cpu for testing purposes) I should recieve a message from my image.sql that is invoked by my php code, but i get nothing, just a blank page, no errors. thanks in advance, if someone can help and needs more info i can post the php code or the image.sql
Database
I have an html form where I collect the user information. For the address section I am using 'varchar' type in mysql db. However the data after a 'space' is not being written to the database. For example 'abc def' has a space between c and d. Only the first part (abc) is being written to the db. Is there any suggestions how I can solve this issue?
Database
I have an insert query that just doesn't work. Here's the query" Code: $query = "Insert into Listings_images values ('".NULL."', '".$insertartist."' ,'".NULL."', '".$userfile_name."', '".NULL."', '".NULL."') "; My database is set up as: -id -listing_id -big_image -thumbnail -is_big_image I think I'm using "NULL" improperly
Database
I want to do is make a database of all of the CDs I have... I would love to organize them like so: Acacia Strain, the 3750 AFI Sing the Sorrow Alexisonfire "Watch Out!" and so on, in alphabetical order. How/where could I make this into a database, and then how could I display the database on a page?
Database
I'm using ver 5 with winXP. I can access the test database, but can't create a table. I can't create ANY database as I keep getting error 1044 (42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase
Database Pw
i've searched quite a bit, but cant find any post relating to sql command for setting database passwords. anyone know how?
New Database
I am quite new to working with databases and am currently having problems connecting to my new MySQL database. I have been working with dreamweaver and have been using a db on my localhost which worked fine, however now I have set up a db with an online host and I am having problems connecting to it. I go in to dreamweavers MySQL connection control panel and fill in all the details that I have been given, user name and password, and from the top of my db website which says “MySQL 4.1.15-standard running on 217.174.253.162 as stopticket@server217-174-253-162.live-servers.net” so I use the 217.174.253.162 as the server, however when I try to connect I get an error message saying “2003 cant connect to MySQL server on “217.174.253.162” (10060)”. Has any one got any idea of something I could be doing wrong
Same Database Name
Is there a way to prevent users from creating the same database name? for example our name schema goes like: mysql_1234, mysql_32143, mysql_.... But we found out that some one could create MYSQL_1234 while mysql_1234 already exists. I guess what we need to know is that if there is away for mysql to not allow same names even though its different case characters.
Database Getting Too Big
i have a mysql database which i think is getting too big! I have about a thousand records which came from a form on my webpage and I am worried that i may get complications in future if i dont do something! My question for today is how do I archive my database so that I can go back to it whenever I need to find old records? Do i just use the mysql admin console to do a backup and then delete the table contents or what?
|
TRACKER
