Mixing Different Address Formats In Access 2007
[left]I would like to set up an address database in Access 2007.[/left] This is normally a fairly straightforward job, however, things are never that black and white with me. The problem is, I need to add addresses from different countries (UK, Australia and Belgium), and they use slightly different formats. For example, in UK and Australian addresses, you write the house number first and then the street name, eg. 123 Somestreet, while, in addresses from Belgium, you do the opposite, the add
Creating A Php Login System Using Mysql
Hey everyone! I am helping someone make a login system using MySQL databases and a PHP login form. I have a fair bit of experiance in HTML and some javascript too. I have virtually no experiance in MySQL or PHP. Anybody know of any good PHP login systems that allow you to creat a personalised page for each user and when they login the system transfers the user to their page. Another thing that the system MUST have is a way of stopping unwanted users entering someones page. [code]For exa
Looking For Experienced Mysql Database Administrator
Hey all, figured this is where I should post this. More or less I run gaming sites (fansites) for MMORPG's and have been getting a lot of positive comments. I've decided to take my project(s) a step further and make game databases (items, quests, etc.). For a reference of what I'm talking about, refer to: [list] [*]Magelo.com [*]rift.zam.com (no www) [/list] These seem like they are pretty basic to anyone with database knowledge, but I have ideas on how to spice them up as well, ma
How To Restore Old Database In Second Mysql Db?
Hey Guys, I have IPB installed in one MYSQL database, now in second MYSQL database i want to restore the backup of old phpBB forum so that i can convert it to IPB. I have created a MYSQL database, but i don't know how to import the phpBB database into my second MYSQL database. In backup it just shows option to import in my no1 MYSQL D.B but i want to to restore in no2 MYSQL D.B Any help will be appreciated.
I have installed XAMPP on my computer. Everything works fine, but when I enter PHPMyAdmin I get this warning: "Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole." So I've changed the password to the root account, but then I couldn't access the mysql databases anymore with PHPMyAdmin (I receive
Resolving Can't Login To Sqlexpress Using Sa Account
When installing Visual Studio 2005 or Visual Studio 2008, the installer will automatically install for us one instance of SQL Server 2005 Express. But we can't actually connect the database without extra tools and we can't login except using Integrated Security. In this article I will explain how to download extra tools and how to login using sa account (not Windows Authentication Mode). 1. First download Management Studio Express for SQL Server Express 2005, [url="http://www.microsoft.
This might be a silly question, but since I am still in the process of learning, I feel I need to ask it anyway. I have set up a Table in Access 2007 to keep track of my private students, this particular table contains the personal details of the students. One of the fields, called "Course", shows which course the students follow (as there is a choice between a number of courses), and I have made a list box (drop-down list) which already contains the choice of courses on offer to mak
Need Help Developing A Database
I have been looking around if I can find a template or other model for a database (table), I tried Microsoft Office to see if there was a suitable Access template, but I didn't really see what I was after. Are there any places on the Internet where you can find database templates? Or, if anyone can give me some advice,what I want to achieve is the following: I have a database table (have both an Access and MySQL one) with the personal details of my private students in it. It obviously con
I use a great piece of software (it is even free) called QIOS Pelican to send out newsletters. It is compatible with a number of different datasources (MySQL, Access, Oracle, Excel, Outlook address book etc.), and then sends out your email (which you can also edit in the program) to the recipients it finds in your datasource. My problem is: I (obviously) have a (MySQL) database with subscribers, which QIOS Pelican uses to send out the newsletter to, and people can subscribe to that newsletter
Hosting Mysql Locally With A Remote Webhost For A Web Application
We have a website running just fine. There is a database intensive application on the website, which does a couple of joins across various tables with around a million tuples. After this heavy processing initiated by the script, the output is only a few kilobytes. Since, getting a dedicated server for the database would be expensive, I am considering hosting it locally in-house on AMD quad core's. The basic amenities are well and good except for the bandwidth. The maximum data outbound is a
Php Unable To Connect To Mysql Using Localhost
I'm running local sandbox on OS X 10.6. Been doing so for quite sometime. Ran an software update and now everything seems to be jacked up. Here's the basic problem: I'm unable to connect to MySQL using PHP when defining the host as "localhost", which I need in order to keep in sync with the rest of the team. First, the relavant code. Here's my test php script: [code]<?php $usr = "root"; $pass = ""; $host = $_SERVER['HTT
Hello, I am writing web site using java (jsp) and mysql as database. I need functionality that can be seen in certain online games. For example in Travian when I send soldiers there is time they will arrive in enemy settlement. Now I am interested in this time. How can I fire certain even when time reaches zero. Thing is I studied triggers but problem is that triggers only fire at update and similar events. And I would require something time based. Thanks for your answers.
After numerous attempts to open my old pups on hand file that I lost with my old computer, I have given up and decided to just try to make a new one. But now I find I don't know how to work excell, and I'm not even sure how I made the old one to start with either. Anyway, I need to figure out in excell how to make one. I can't figure out how to loose the A B C's across the top and turn them into the right headers, and I can't figure out how to loose the extra colums I don
i want study the connection database and security user lever. but failer any body help me, where the problem is. here the code [codebox] <?php /********************************************************************************* * Filename: common.php * PHP 4.0 *********************************************************************************/ error_reporting (E_ALL ^ E_NOTICE); //=============================== // Database Connection Definition //------------------------------
Oracle Is The Best Database Application
I think Oracle is one of the best Database Application Package... MySql is also good. Microsoft SQl Server Consumes physical memory a lot.It slow downs your computer very much.. Oracle database is more secure than Ms SQLServer.. MySQL is Opensource.I don't have much Experiance with mySQL.If anybody have proper idea about mySQL please reply......
Oracle Pl/sql No Type Checking Inside The Declaration Section
[font="Times New Roman"][size=3]I always have wondered why Oracle doesn’t checks for the type casting inside the declaration section of a pl/sql block and it also ignores the checking of size mismatch inside the declaration section. When you do one of the above mistake in side pl/sql stored procedure it compiles the code successfully but it gives the runtime error. Ideally it should go inside the exception block but it doesn’t .Can Any one tell me why. I didn’t find any proper ans. on any forum
Looking For A Data Output Program
I was wondering if anyone could put me into the right direction: I use a great program called [b][i]Simfatic Forms[/i][/b] to create web forms. The program is quite flexible and allows you to create forms which can then email the submitted data to you, and.or save them in a MySQL database or a file and it also has some possibilities of generating a Thank you page and a page with the submitted data, but then you have to click through to confirm the entry. It is excellent for creating a wide ran
Hi there, I recently uploaded a copy of phpMyAdmin to my site, and everything works fine, except for one problem. I logged in as one user (I'll call him hostacct_dbuser), got through to the good stuff, and now I have a problem. When I log out, it automatically enters that DB username into the username field. Whenever I try to login as a different user, it will assume hostacct_dbuser and will give me the "Password incorrect". But the strange thing is, it only happens on one comput
Displaying Rows & Columns Horizontaly
I'm experimenting with php and mysql. I have table in mySQL database something like: | sr.no| name | | 1 | abc | | 2 | xyz | | 3 | zxc | Now i see the table in vertical for serial number and name. But if i have to display them in horizontal way. How to do that ? like |sr no| 1 |2 |3 | 4| |name| abc| how to do this using php and mysql ?
Mannual Creation Of Oracle Database
Manual Creation of database in windows with oracle 9i (Step-by-Step) (Name of the database=db18) (Note: all commands are in bold letters) 1. Open the command prompt and execute the command sqlplus/nolog 2. Connect to the default database as sysdba in sql prompt SQL>conn sys/oracle as sysdba you can see the name of that database by executing select name from v$database; 3. Now open another command prompt and set oracle SID as set oracle_sid=db18 4. Start a windows service with internal pa
Mysql Database Restore Problem
[quote][b]Error[/b] SQL query: -- -- Database: `gtasforums` -- CREATE DATABASE `gtasforums` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; MySQL said: Documentation #1044 - Access denied for user 'tgtasect'@'localhost' to database 'gtasforums'[/quote] I don't know what's wrong, but this is the exact error I keep getting. Please help.
Ok here's my problem, since my old forum had bugs from wrong turns (bad mods installed) I installed a fresh copy on my new server and set up the mySQL and everything with no problem. but I wanted to restore my old site somewhere because I needed some stuff from it (like codes) I have a backup of the site and the sql, I made a sub domain on my account and uploaded my old forum there and when i tried to restore the old sql it didn't go over too well so I did as suggested by another topic t
What Is The Meaning Of Sql Vulnerability?
[font="Calibri"][size=3]Recently dear friends I encountered this term that is SQL vulnerability. But unfortunately I don’t know the meaning of this term. Any one there to help me with the detailed meaning of this term. Moreover I would like to know that is it dangerous for any site to be SQL vulnerable. If so how could we rectify this negative factor of any website? One more thing which I want to know is how I could find whether my site is comes under this category or not. [/size][/font]
Phpmyadmin Don't Let Me Create A New Database?
Hiya people... after installing my drupal (not fully) onto my hosting account and getting my domain name to point correctly to the drupal's index.php file, I have received the next problem. I don't think that it can be solved because this is on another hosting account, but I just want your opinions so I can make up my mind... People here are nicer and are quicker to reply to my problems... Thanks... OK, so the problem is that I can not seem to create a new database for my website on
How Do I Shift My Wp Database From A Sub-domain To The Main Domain?
I've had some bad experiences trying to tinker with databases, that's why I decided to ask for some help before going off on my own this time! I'm running a wordpress blog on a sub-domain of my personal site (like www.blog.mysite.com) and I put it there because I wasn't expecting any traffic at all and wanted the main domain (mysite.com) to hold a little info about myself. But to my surprise, my blog has begun to get some traffic and even quite a few comments, all thanks to
Hello all! Would like to know the difference between SQLite and mySQL. Which is better to use? Honestly would like to know if server load will be lower with SQLite.. Thanks a lot!
Mysql Problem Not Letting Me Open Any Localwebserver?
Hiya people... I seem to need help again. Recently, I tried to re download the MAMP local webserver for my computer, and due to different browser only allowing me to download different types of local webservers (MAMP can only be downloaded from Safari and Xampp can only be downloaded on Firefox), that I ended up with both local webservers... I am deciding to work on my site so that I can upload it to my proper site, but however, I cannot start any servers on MAMP at all, and I cannot start the
Freeware Program For Displaying Mysql Data
Hello, I was wondering if anyone could point me into the right direction. I have a very good program to make web forms (Called Simfatic Forms), however, I have now developed a form, and I would like to display the data visitors have entered into the form nicely formatted (probably in a table) on my website. Since I am not very fluent in PHP programming I am looking for a program (preferably freeware) which would help me achieve that. It does not have to be anything very complicated, as the dat
Problem With Order By Sql Statement
How can i order them by the most number of attractions or most number of rewards? Tables member table - the main table [code]member_id | name 1 dolrich 2 test 3 sample attraction table attraction_id | member_id 1 1 2 2 3 2 4 3 5 3 6 3 7 3[/code] What i want is that i can order by them by their number of attractions Here is the result expected. [code]member_id attractions count 3 4 2 2 1 1[/code] Here is the query for
Hello, I was wondering if there is a way to access each of my subdomains individual phpmyadmin database without having to access cpanel. Something like the following: www.mysubdomain.com/phpmyadmin, and that would take me to that subdomains database? Is it possible? I have seen it before in another webserver and I was wondering if this was possible here. Thanks
I am learning MS SQL can anyone recommend any good sites where i can watch videos or where the information is good but not boring. I have to take an exam at the end of September
Installing Phpmyadmin On Local Machine (windows)
I am going to show to all members (beginning developers ) how to install phpMyAdmin on Windows local machine. First of all.. For those who doesn't know what is phpMyAdmin I'll try to explain it. phpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL databases. You can read more to learn it [url="http://en.wikipedia.org/wiki/PhpMyAdmin"]here[/url]. Here are the requirements for the installation: PHP Installed MySQL Installed Apache Web server 2.x.
Remote Datbase Access From Desktop
I was wondering,in C-Panel there is a section that apparently allows remote access to the Trap17 mysql database from a remote site. You simply enter in the web address of where the code would be coming from. Would anybody know if you can do this from a desktop?By just entering your ip address?Also.wouldn't the php.ini file remote access feature("Which should be set to "off" by default) effect this and disallow it? I was just wondering if anybody knew anything about this.
The Only Reason I Choose Ms Sql Server Rather Than Mysql
The only reason i choose ms sql server rather than mysql is, MS SQL has more security features!! MySQL is lacking a lot in my opinions - Lack in wide char, like nvarchar, I developed some application to support chinese letter, and dont know how to build one in mysql - Lack in t-sql syntax, like query in query is not fully supported - Does not have today SQL features like BI support (today really required) And compare MS SQL to MySQL, the only reason why mysql is favourable is - it is f
I Need Help Choosing A Database
Im in process of a new website. I believe the best way for it to be setup is so minimal entry is needed for it to continue running. Its a sport website which will hopefully automaticly desplay, main results and user selected results. A great example of what Im describing is xscores. The info displayed is much the same except graphics will be more appealing. Ill start with an example: Lets say we deal with a Football League. One of the pages will have the league table. I want to have detailed
Remote Access For Mysql On Vista Panel?
I know one is able to set the host to remotely access mysql in CPanel, but what about Vista Panel? I had tried locating for the function but is unable to do so. Can anyone guide me?
Hey all. I have an xp computer but love vista desktop icons. I have all the icons to the start-menu and the desktop, but which files do I need to replace before they appear on my computer? I hope you can help me. - Fille
Any Advice On Starting A Database?
I want to use a Database to keep track of members through a registration/login process. I also later down the road will need a larger database to hold information about actors. My question is, how do I go about making a database first for the registration/login page? I must let you know I don't know much about MySQL but am willing to learn. Any help will be greatly appreciated.
How Do You Save The Query Results From Ms Sql?
I know that it is possible to save the query results from a database to an external file. Though it is not a straight forward process in many of the database, some of them do allow it and others do not. You might have to use an external tool to achieve this functionality. Say for example you cannot do an export to an external file in Oracle directly. You might have to use some kind of front end software to achive this. I have used TOAD and it has an option to do it... There is an option inbuilt
There are MySQL hacks out there, They can travel from your website to your computers. One of these are the MySQL injectors. The injection drops your tables and shuts down the program permanently. Be careful of these hacks, as they can destroy your MySQL related websites, programs, etc.
okay problem is this. Today I was trying to set up an AEF forum on my site. upladed everything as told and I got this error. The universal.php file is not writable and the setup could not CHMOD. Please CHMOD it to 0777 for the setup of your AEF board. You may later revert it back to 0655. After CHMOD just access this page again to start the setup. Totally lost now. What have I done wrong? [url="http://echoofthunder.com/AEF/setup/index.php"]My AEF Forum[/url]
Phpmyadmin User Problem On Trap17
Hey everyone, I just want to point out a problem I have found with our current hosting setup with cpanel and phpmyadmin. The problem occurs when you try to run some sql in particular a query that imports csv files into a table you have already created. The query will try and execute using your default user name which is 'sonesayi@localhost' for me. I cannot add this user name 'sonesayi@localhost' to that database so what is another way to solve this problem? Additional users i cr
As far as I can remember OS X comes with apache but does not come with MySql so I had to download and install MySql from their website (dmg file). This worked fine but as I also installed xampp later which comes with MySQL as well I think it conflicts with the original one installed. Some symptoms of this are: 1. when I start xampp it starts the original mysql install instead of its own. 2. I cannot determine where should I go to configure the xampp mysql users + passwords 3. scripts wont work
How To Connect Mysql With Jsp ?
after many i tried to connect to mysql with jsp, its was now successful. but i can connect at localhost. i wonder why that. can anybody help me ? it was so good if can post complete system. e.g (login).
Need Advice On Setting Up Mysql Database.
[center][img]http://i37.tinypic.com/rbdv0l.jpg[/img][/center] First of all, to get the idea of what I am trying to achieve here, please have a look at my idea thread, entitled [url="http://www.trap17.com/forums/idea-using-cron-job-grab-daily-travian-map-sql-updates-t60325.html"]Idea For Using A Cron Job To Grab Daily Travian Map.sql Updates[/url]. This gives a prelude to the project, what it is for, what it is supposed to do, etc. Now, what I need is specific advice on setting up the mySQL dat
Hi, I am learning advanced databases. I need to know , If i can install more than one database software on a single machine ? I have to work on PostGRE, MySQL, Oracle and DB2/SQLite/MS SQL for an assignment. Secondly. Where Can i get the internal working of these databases from. I need to know how a query is executed and what all steps are performed under each of the above. Thirdly. I need an open source alternate to Oracle , if its there or a developer edition for Oracle. Is it avail
For those of you... who really reall Ok... I am sharing to trap17 an easy to use image file to brush up your understanding of database normalization. Everytime I have to understand the concepts, I have to go through the complete text and its a little hard to do that... Had some requirement recently, and I thought I will prepare something like this and refer to, when there are future requirements. This is not exhaustive and very detailed. Helps to get some basic understanding. Prior knowledge ab
Alright, for a few weeks I've been wondering about this. I'm a newbie when it comes to database languages. What's so special about the SQL family of languages that most people use it? Would there be any real difference if I made an SQL database with entries or if I setup a perl script - or any other web language - to do the same thing using plain text/binary files?
Select All Rows With Same Name
I have a table called albums it contains the following: [quote]albumid bandname albumname[/quote] the following data is in it [code]albumid bandname albumname 0 Grendel test album 1 1 Grendel test album 2 2 VNV test album 1 3 VNV test album 2[/code] Now I want to display the albumname from only grendel or vnv or anyother band who comes in the table. How can I do this ??? thanks in advance
Hi all, I am not sure if this is the right place to post but I'm sure you'll tell me if it's not. My problem is this: I have a website where I sell books and it's one of those simpleton sites where I don't need to know code, I just click icons etc Anyway, I can upload images to the server and need to have them in different resolutions and link from a thumbnail to the larger picture. What I am trying to say is I have about 6000 books to display on my website wh
Informix To Sql Server (or How To Open .unl Files)
Does anyone know how to import .unl files into SQLServer 2000? My boss gave me this task to migrate an old database into SQLServer. I don't have informix installed since the files were sent to me via email. All files have .unl extension and I don't have a clue how to view them. I've tried opening them using excel but it can't be read. Does anyone know how to do this? Or at least know how to open/view the file using excel or any other program that could be easily migrated to
Hi, I'm trying to build an online game and figured the easiest way to do the server list would be to make a mySQL database for it; however, I use the con() command on the IP i get from pinging my website and I always get an abnormal program termination; however, it will work with the mySQL on my own machine. The code is below: [code]#include <iostream> #include <iomanip> #include <mysql++> #include "pass.h"//holds my password (i program at school)
Question Regarding File Transfer!
Hi friends, I am looking for a secure and robust file transfer web service. I am handling a sales force which is stationed at different locations and is frequently moving. They need to upload there activity reports frequently to our servers. So I am looking for an easy to use secure and robust file transfer web service which can be used by my sales force for their needs. Thanks & Warm Regards.
Mysql-essential-5.0.51 Installion Problem
Dear friend, please help me. Iam working on php project (matchmaking site). I have downloaded mysql essensial 5.0.51. When i was installing mysql 5.0.51, i got following error - Error 1901: Error attempting to read from the source installation database: c:\windows\installer\527ec6.msi [retry] [cancel] What is solution of this problem ? Iam using windows xp professional version 2002 (service pack 2). Please post your reply. Iam waiting for your answer.
Hello, I want to install [url="http://sourceforge.net/projects/rpgwebprofiler/"]RPG Web Profiler[/url] on my web site. It seems easy with a very few steps but I have never worked with Apache before. The [url="http://sheets.frp.trap17.com/INSTALL"]readme[/url] of setup. This is the step I couldnt understand, the last step. [quote]5. Create the following entry in my Apache configuration. Alias /profiler "/home/tarlen/profiler/public_profiler" <Directory "/home/tarlen/p
[url="http://www.firebirdsql.org/index.php"][img]http://www.firebirdsql.org/images/firebird-logo/firebird-logo-90.png[/img][/url]<-- Click Here to Go to the Web site. [quote] [size=2]Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a varie
A simple BBcode class [code]<?php // Filename: bbcode.php // Version: 0.1 // class bbcode { function code_box($text) { $output = "<div class=\"code\"><h6>Code</h6>\\1</div>"; return $output; } function quote($text) { $output = "<blockquote><h6>Quote:</h6>\\1</blockquote>"; return $output; }
Hi everyone Recently i tried to upload a personal blog. as I know a bit of PHP programming I was looking for a free open source PHP blog. first I tried [b]Wordpress [/b]out but there was few problems that i needed to change php.ini or .htaccess file and also some other PHP settings. as i was trying it out on a free web host i didn't have access to php.ini. so i have changed it from Wordpress to [b]bblog [/b], i have installed it successfully and i followed it's safety instruction (dele
Hi... One of my hosts hasn´t MySQL but i need to develop a login system so I need to know if it´s possible to use a MySQL database intalled in another host... If it´s possible can you explain me how to do it? Thanks in advance
Alright... so this is really my first time using databases at all. Anyways, I need some help. [url="http://2kart.trap17.com/shoutbox.php"]http://2kart.trap17.com/shoutbox.php[/url] I used a tutorial from spoono.com (http://www.spoono.com/php/tutorials/tutorial.php?id=19) to create this... everything seems to work, except that it won't show what is posted in the shoutbox..... my code is below.... and since I hardly know anything about databases, I'm sure you'll find an error quickl
What Value Would I Use To Insert This Data?
I am learning slowly but surely and I know some of you probably getting tired of my questions. ^^;; However, I believe one can not learn without asking questions. So.. if I get too bothersome.. just point me to some books or something. lol XD [codebox]<?php // Make a MySQL Connection mysql_connect("localhost", "name", "password") or die(mysql_error()); mysql_select_db("at2927_abq") or die(mysql_error()); // Insert a row of information into the table &
I seem to be having trouble with getting my Query to post my user's ID numbers. [code]// Make a MySQL Connection mysql_connect("localhost", "user", "password") or die(mysql_error()); mysql_select_db("databasename") or die(mysql_error()); // Retrieve all the data from the members table $result = mysql_query("SELECT * FROM members WHERE id='$id'") or die(mysql_error()
Hey, any one can give me a sight to get databases for war games, a database that could include units hp,speed,power and similar things. And if you can how can i put the numbers I want as hp,speed and other things as i want.
Okay, I have a forum which is growing daily. Even though members aren't that many, I'm still concerned over my database space and its capacity to hold the forum's content. Since post counts take up database space, the remaining space will decrease daily, albeit by little amounts. Still, it will decrease anyway and eventually my database for that forum will run out of space. My question is: 1. Is there any way to possibly create a new database to continue holding the old database
Php With Simple Csv List As Database, What Do U Think?
I've designed a php website and i used simple CSV file as my database because of few reasons [list=1] [*]my client had to pay more to active MySQL [*]database was a simple product list [*]it was easy to convert product list from existing Excel file to CSV [*]it is easy to make any changes [/list] so i have few files to convert to CSV if i wanna update the website. I know it's less secure specially if it's an online business (which is not). question is : what are disadvantages? is t
Importing Cvs Files In Phpmyadmin
More Database problems...I need to know how to import CSV files into existing tables, in PhpMyAdmin. For example, I have a members table, which contains 220 members. Now, I have a CSV file which contains another 50 members, obtained after I last backed up my database(With 220 members). The data for the extra members have been exported in CSV form, so I need to import this data into the members table, to get the rest of the members. I also need to do this for a few other tables. I hope I can
Loading File Into Blob Fields To Mysql
Hi all! does any know how to load file into blob filed by sql script?
Database Migration - Seditio To Joomla
Hi guys! I was desperately looking on internet for any help with migrating Seditio database to Joomla.. I`m admin on site which has more than 2500 members and day by day I get annoyed by pretty dumb solutions in Seditio.. can anyone tell me how to migrate the seditio site to joomla? any tutorials on internet on database migration? thanks
Ok I did poorly in my database class so Im very bad at normalizing forms. I started creating my database and eventually ran into a problem with how I've set it up. Im not 100% sure how I'm going to fix it at this stage but heres the problem. I have 2 tables MONSTER and ITEMS. Basically its layed out like this. [codebox] MONSTER TABLE -------------------- m_id int (PK) m_name varchar m_level int ...etc ITEMS TABLE -------------------- i_id int (PK) i_name varchar i_nm int [/codebox]
Can anyone clarify what the value in int() actually does? [codebox]CREATE TABLE job_class ( jc_id int(1) NOT NULL AUTO_INCREMENT PRIMARY KEY, jc_index int(2) NOT NULL, jc_name varchar(20) NOT NULL, jc_type varchar(20) NOT NULL ); [/codebox] I was under the impression that any integer value used inside a () was the limit that data-type would have. In the PRIMARY KEY column I was able to add integer values 1-18. I'm kinda confused now If I can add 2 digit integers there then what is the poi
I'm quite new to creating and managing databases - yesterday I installed Filemaker Pro 9 and my initial thoughts are that it's amazing! Only just starting to get to grips with it - think it'll take some time to master it. What Database software do others use and what do people think of Filemaker Pro? Advantages/Disadvantages?
Ffxi Merit System Eer - Need Assistance
Hey all. I'm in the process of building an EER model of a merit system for my custom player management system which will be a php/mysql website when its done. The problem I have been having is that this is a very complex system. It started off being very simple but when I identified all the features I wanted to include into the website it turns out to be alot and complex. This is why its very important that I acurrately describe EER model so it can be used to build a database to supoort my w
I just want to find out how many use it and how much help its been for them. I've started a project a while back and I find I've not planned it fully in the early stages i.e. requirements wasnt fully identified so I'm constantly having to go back and recode many parts as I discover its missing something. At this stage I've stop completely in my development and going back to the drawing board to try and plan it out as best as possible so I wont have to redo alot of it because of p
Hi, I am tring to get one single cell from a database. The primary key is username. I want to store the single cell in a variable called $charity. The code below seems to work. However, this outputs to the screen the answer. I want to store the answer in a variable. [code]$query="SELECT charity FROM `users` WHERE username='$username'"; $result=mysql_query($query); $row = mysql_fetch_assoc($result); echo $row[
Hi, i need to know how to transfer a MySQL database from one domain to another ... i understand that i can use phpmyadmin to do this using the export and import functions however, when i tried to import the datafile generated by the export function, i got an error saying that i do not have permission to access the database do i need to create an empty database + admin user before i can use the import function at the new domain? or am i missing something else i need to do?
[quote]Hello All. I'm looking for some advise or assistance with getting a web page/access page running so that i can have the page online and collect the data live into my database for Project Management... Currently I'm developing a database using M$ Access, and need to have staff data enter sales information directly into a web form that can be linked to a database? I've looked at using a M$ Front page web form with data collected into a .CSV text file and extracting
OK so i have Cpannel (11) and i have Email address that i want to give away, how do i make a form where users can automatically sign up?
Problem With Where Clause And Max Function
i have a column in a table which is varchar format but contains timedate type data eg. '24/7/07 05:32 PM'. I'm trying to run a query which uses a where clause to only return the rows where this column is equal to the most recent date. I've tried using the MAX() function which returns a valid result but not the most recent date.
Connecting Php With Oracle Database
i need to connect oracle with php ..now me using oracle 10g can any one give me the solution thanks.
I was wondering what is the difference between MySQL and SQL. I was really confused when i planned to do a project recently. This question has haunted me for a long time. Is it both same?
im trying to open up a sql to modify a database but my computer im using is kinda slow and everytime i open it up in wordpad it freezes lol does anybody know a good program or text editor i can use to view sql files?..
You Can Inport Big File Sql With Bigdump
You Can Inport Big File SQL With Bigdump And You Can Find This File With Google !!!!! If You Can Get It Please PM :tranvantrung_thao >>>>>OK
Installing Mysql On Unix, Linux
Download the latest version of MySQL.Choose the latest stable release and, from the stable release page, choose the option under "Source Downloads" marked "tarball (.tar.gz)". Download the file into a directory where files can be created and there is sufficient disk space. A good location is /tmp. Change directory to this location using: 1. % cd /tmp Note that the % character should not be typed in; this represents the Linux shell prompt and indicates that t
Questioning My Database Structure...
Okay, I posted a brief description of this in the PHP section, but I'll summarize myself again. I'm creating a PHP based game that is an economy game, where you start out with so many resources and a building, and you expand your business empire by building more buildings, which puts out more resources, and you can buy and sell on the market and whatnot. In the end, you try and become the wealthiest player in the game. Now I already have most of my database in MySQL set-up. But I'v
Is there anyway to merge 2 databases? I have an XOOPS and SMF both installed with Fantastico, and the bridge is not working like the Joomla! one does. (with the seperate db capability) i know how to transfer all the tables by hand but depending on how much data you have stored in mysql could take a long time. Take short time!? Help me!
I just downloaded php, mySQL, and apache web server. I plan on running and testing a website on my local computer for now. I would like to know how to install php MyAdmin on my machine and how to configure it. thx:)
Fastest Way To Import Backup Db [resolved]
I have exported mysql database file which is over 100mb and wants to import back. I've tried BIG DUMP and it takes forever. I've also tried import command of phymyadmin but got this error - "Fatal Error: Maxiumum execution time of 300 seconds exceeded". Can anyone tell me the fastest way to import back.
Text Rpg, Don't Know Where To Begin.
Ok, well I really want to create a text rpg for my website. If you don't know what this is, basically its a thing that you can register, etc, and then after you register, you play with the community, sort of like a regular online game, but no animations, just pictures, and text. Pretty complicated I guess. I just want to know if anybody has any, experience, and could help guide me through it as I don't know where to begin. Probably with the login/register system, but idk what to do. Does
How To Connect Site To Database? [resolved]
I created a table in phpmyadmin, i copied the code in a file and uploaded this file onto the host. Now it says that it cannot connect to the database. The error lies within "mysql_select_db($db)" => so i think this means that it cant find the database? If anyone knows how to let my login and register forms connect to the database, please help me. I used a login system from this site, ill post the link later.
On the host I moved here from, I have a database that I would like to transfer. On this host I am unable to use PHPMyAdmin, but I have MySQL-Admin 3.3 that works fine. But the main problem is the host. Recently they made it so you there is only a 1mb upload limit, and also that MySQL temporarily will not operate properly. Which is basically why I want to get off that host. Anyway, I can export each of the small tables easily. But I have tables that are over 2mb, and I do not know how I can get
Joomla Sql Error: Connection To Database Server Failed.
Hi Today I got this error-message in back-end on my Joomlasite [url="http://hewwelub.trap17.com/d-lan/"]hewwelub.trap17.com/d-lan/[/url] [quote]This site is temporarily unavailable. Please notify the System Administrator Connection to database server failed.[/quote] This is the first time I get this error, and I don't want or have the time to reinstall the site with all its features... The only time I have seen this problem yet is when I tried to unpublish a menu item. Any answer would
Sqlserver 2005 - Login Problems
Hi guys, I just installed sqlserver2005 and when i open server management studio and try to connect I chose SQL server authentication mode it then asks me for a login and password. I have no idea what this is. Is there a default? or do i need to add a login somewhere. I may have not specified one when installing. Any ideas? Cheers, Paul
I have a book, PHP and MySQL for Dummies, and i guess i am more then a dummy. It is my first time setting up my own database from scratch. In the book it says to set up the table, but it doesnt tell you what to use or anything. Just to set one up and explains what you put and where. Here is where i am: I made a Database called "boozker_aah" (not going to say what aah stands for yet. Its for my new site) Then i want to make a table for the users (right?) I called it "aah_users&qu
Setup And Run A Php Nuke Portal
I will teach you how to setup and run a PHP Nuke Portal 1. Download the free version from phpnuke.org 2. unpack and open the config.php 3. Modify the data to match your MySQL Database [code]db=dbnamehere user=userhere pass=passhere dbhost=localhost[/code] That above is an example 4. upload all files including the edited config.php 5.after the files are uploaded, open either Phpminiadmin or phpadmin 6a. For phpminiadmin: click the link to "import database" find the sql file in your sq
You can download mysql query web browser on [url="http://www.mysql.com"]http://www.mysql.com[/url] you also can download plugin there...like conector mysql from visual basic ,java,etc with my sql query tool browser you can make and maintance youre database sql easily because use gUI interface..!!
©100Topics.net. All right reserved.
