100Topics.net

Databases

           


Home > Computers & Tech > Databases

TOPICS

The Best Database

Ive been planning to create a online application which requires tons of stuff from database.Ive been using interbase, at first it was good but after a month i find it not user friendly at all... Its to hard to code in php..Can any of you guys give me a good database which is easy to use?

....know more

The Best Database

te best database for my is sql server yukonfor you?

....know more

Oracle 10g Install Issues

So I'm trying to install 10g on my XP Pro development box, and the install goes fine (I do the basic install of enterprise edition, I'm by no means an oracle expert) and when it gets to the part where it wants to create a database, the database creation assistant fails saying first that it cannot retrieve credentials, and then that it can't connect to ORACLE (I'm assuming this is the instance name).Anyone have *any* idea what's going on here?

....know more

MySQL, Multiple Tables

Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always learned ONE table... put EVERYTHING in one database table.I'm making a profile system so there needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two together? I could probably figure this out faster if someone explained and posted sample SQL code that shows how the two are linked together.Thanks!![N]F

....know more

What is MySQL?

This may sound pretty stupid, but what is MySQL? I am new to PHP and MySQL, and I was wondering if some body could give me a thorough explanation. I am working on getting 50 posts so I can open a forum myself on one of the servers. It might help if I know what I am doing. Thanks.Neil

....know more

Problems With A Database Table & PHP Syntax

Ok, because I am feeling dangerous and ready to move to the next level, I wrote a simple "page generator" script for my website for several reasons:1. I hate updating 20+ pages by hand just for ONE little template change2. I'm expanding my PHP & MySQL knowledge...Here is an error I get on the page that is supposed to submit contents to the database:Parse error: parse error, unexpected T_VARIABLE in /home/coco563/public_html/beta/make_page/make_page.php on line 11Now, on make_pa

....know more

An Installation Problem - Can Someone Help?

I'm not sure if I'm in the right sub-forum or not ... but if this should be somewhere else please feel free to relocate!I have uploaded this PHP app to my server with plans to install it (It's a program like aweber.com)I made the database and started following the installation instructions.The instructions say to run the SQL file (autoresponder.sql). I haven't done this before in phpmyadmin as most php apps I have installed also have an installation script.Needless to say, I

....know more

MySQL Output Database Question

I am new to MySql and have just created a database after using a script. My problem is not the script, but what it says about putting it into the output file. I cant figure out the right terms to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE 'location' but it isnt working. I'm lost with this stuff, I really am. Can someone please help me out?

....know more

Do You Know Of Any Good Free WAP Enabled Forum

I'm not sure if this is the right section for this so please alert me or redirect this post to the right section. I own a wap site that is visited my nearly everyone in my country on a daily basis. What I would like to know is if its posible to put up a FORUM section on it and host it on ASTAHOST, also is the WAP forum a Sql type? i'm kinda new to this stuff, btw, the wap site is in php3 but i'm gonna use wml and upload it to ASTA for hosting because my other(use to be) server is ad

....know more

What Database Do You Prefer?

So, what database do you prefer, which is better? What`s your favourite? Actually i need some tips about that, because i just need to know as much as i can about it So please, couldn`t you tell me what`s the best one, it`s advantages and diadvanteges, wich is easier to use and so on

....know more

Mail Sever In PHP Script

While testing an an autoresponder script I am geting am eoor message like this.Warning: mail() [function.mail]: Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in D:\Program Files\xampp\htdocs\responder\do_signup1.php on line 23any kind of help would be apreciatedthanks sherif

....know more

Learning Php/sql Basics

Hello,I've been wanting to learn to create websites for a long time. I'm not sure how hard it will be and how long it will take to learn enough to make my own database-driven website. I studied SQL, basic programming, worked with databases and am familiar with HTML tags, but this all was for work, university and I never paid a lot of attention to details.In the past few days I read beginner's tutorials on PHP/SQL, CSS and even HTML.Now I want to create a simple database with some tab

....know more

Access

I was looking to make a site where people need to create an account, and log in to view the main pages.Is it easy, or do-able, to use msoft access to make a database where people are able to sign up with a username and password via my website?

....know more

Installing Mysql?

Well i have the codes for my game i got them from a friend of mine. He bought them from MCcodes.com and now i am tring to install MySQL to it.. but no luck with all other web host. I don't yet have a account for Astahost but "localhost" will not work no matter what host it is.. the last host that worked was from freehostia but it doesn't support cron jobs. mysql4.freehostia.com was the hostname but the rest of the web host i tried did not tell me the host name they just said to

....know more

How to Backup MySQL Database

in mysql install directory:\mysql\bin>mysqldump -u root -p root your_DB_name > back.sql

....know more

Any One Know How To Create A Database?

Hi i would like to create a database but i do not know how. Could some one please show me how.

....know more

Mysql And Php

I don't know if this is the correct forum, but here is my question:I'm trying to test Joomla and some forums in my computer, I have already installed MySQL with the GUI tools, Apache, and PHP with the MySQL and MySQLi extensions, but when I'm trying to install Joomla I get this error: Required Settings Check:------------------------------------- PHP version >= 4.1.0 Yes - zlib compression support Available - XML support Available - MySQL support Unavailableconfiguration.p

....know more

Best Database

What is the best free database if some one trying built a social networking website? And how to operate it with dreamweaver 8?

....know more

Free MySQL Server

Does anyone know of a free mysql server? If you do, that would be great. Thanks---------------------------The post simply deals with mysql server and has got nothing to do with phpbb. Next time onwards please phrase your topic titles a little more carefully. Topic edited.

....know more

Creating MySQL DB

Hi, everyoneI've host and I want to upload phpbb2 but there isn't a cpanel and I know I must create a mysql db how can I do?Did you realy read my post?

....know more

Access 97 To Access 2003

I need to convert a database that is in Access 97 to Access 2003 but every time i do it using the Convert tools of Access 2003 i got some errors and can't change or add any of the objects -tables, querys, etc- of the converted database.All the errors i got are related to the user priviligies and permissions of the database, is there exists a way or procedure that allows me to reset this permissions???Best regards,

....know more

Stop AUTO_INCREMENT From Jumping

One of my MySQL tables has an ID column - it's a primary key with auto_increment. And it works. If I add six rows they number 1 to 6 nicely. But if I delete rows 4 to 6 then add a new row, it becomes row 7. And if I delete that it becomes row 8. How can I make it so the next auto_increment is the smallest possible? (i.e. 1,2,3,4,5,6 - I delete 4-6 and the next row inserted becomes 4)

....know more

Free Databases

this website offers Database hosting for free. Jus signup and u get u r own database .. it supports mysql, postgresql, sapdb, sybase, db2CODEhttp://freesql.orgfrom the webpageQUOTE This service is, and will remain, totally free. I have receive hundreds of Thank you emails from all over the world telling me that having this service available has allowed them to practice and learn without the burden of having to run their own server.

....know more

Database Program With GUI

I am looking for a program to create SQL databases through a GUI to simplify it, the only things i can seem to find are command prompt things and i can't work with them. I like MS access and would like something similar to that if possible. I am working with windows at the moment can anyone recommend a program i can use (preferably free)Many thanks

....know more

How Do You Make Large Databases?

In a game I'm working on, I would like to have a database of actors/actresses. I'm not sure exactly how to do this. I'm pretty sure with the hosting here, I can only have 99 databases. I'm a little lost as to how to make it. Can all the actors/actresses be put on one database with the specific things I want to include (i.e. how well the do in each genre)? I'm new to Mysql and just need some help as to where to start.

....know more

What Is MySQL ?

What is MySQL actualy???

....know more

Mysql - So Hard

Doesn't anybody think MySQL is so hard to code? I mean think about it, you need loads of databases just for one little script and you have to type things in like<MySQL> ;Host-Username: (blahblah) ;Host-Password: (blahblah) ;Host-DatabaseName: (blahblah)</MySQL>Ok, that MySQL code was random, and it is alot harder than that.If you have expierenced it being hard, you are free to post right in here, mate.

....know more

What is MySQL ? Can Anyone Explain

Hey. I have a few questions about mySQL. I'm just starting out on using it and am curious to know: 1) What exactly is it? 2) Where is it stored? 3) Does my computer have to be on all the time for other people to use my site? 4) Where can I get one? 5) How can I access it? 6) What does mySQL stand for? 7) Is there anything else I should know about using it?Any help with this would be appriciated. Thanks!

....know more

What Is A Good Gui For MySQL ?

May I know what is a good GUI for manipulating mysql? Perhaps in the league of mysqlcc will be a good one Thanks for the help.And btw, who uses GUI for their Mysql here? I know that some people like to use console to type

....know more

Best Database Software For Dental Office Menagement?

I'm a dental surgeon and work in a dental office in Israel. We have in Israel three major dental office menagement softwares. None of them is suficiant enough and some of them realy suck. The price of the softwares is very high and you get almost nothing for this price. Two of the programs are ACESS based and the other is FIREBIRD DB based. I've decided to create my own program. When it is perfect, I'll maybe sell it. I have no knowledge with databases and never even seen one. I'

....know more

Linking Two Tables

I have two tables in a database. userid and usercreditsIn userid I have all the fields that identify the user (name, address etc.)In my usercredits table I have the following fields:IDNUMProgramNameCamp#CompletionDateAmountDatePmtSentPmtMethodCommentscreditIDWhat I would like to understand about my table structure, is how do I associate my credits tothe correct user. If I have done this correctly, there is also a field in the first table that is called IDNUM where each user has a unique number

....know more

Best database

When it comes to the best Database, a lot of stuff needs to be considered1) Size2) Ease of use3) Embedded Nature4) Licensing5) Enterprise Orientedness6) Features1) Size: Oracle is synonymous with databases in companies where there are a huge number of records in the database. Nothing can come close to it.2) Ease of Use: Well, this stands for the interface. There is quite some competition here. Oracle is good. MySQL has some third party GUI and cli interfaces that can ease out the job. Sqlite3 is

....know more

Login System

I want to make a login system using Mysql. I am amateur in these things so please explain in detail like spoon feeding. I have already made a database in http://www.sitebooth.com now what type of table I should make and and the website or PHP for it . If you think i hav chosen wrong site please give any better database hosting site. Please help meBest RegardsPritesh Gupta

....know more

Can't Import Backup Sql File To Localhost

Hi, I downloaded a backup of my forum database and wanted to import it on my computer locally for testing purposes. This has always worked for me in the past, but I'm having some problems with it lately.I'm backing up my database via phpMyAdmin->Database->Export->Select All and downloaded as a .gz file.I'm using Windows XP Home with WAMP installed, so it has MySQL built in. It's version 5.0.27.I ran all the services and at the prompt typed in:mysql -u root -p backup.sql

....know more

MySQL Query

i dunno why this query doesn't function..CODE$sql="SELECT count(*) FROM participantes,sancionados WHERE participantes.No_Ficha = '$no_ficha' or sancionados.No_Ficha='$no_ficha'";$query=($sql);any suggestion???

....know more

Is MySQL Hard To Learn & Is It The Best Database?

mysql is really hard to me , i cant understand it all i know is a very very little bit of php and asp and quiet a lot of html as we learning web design at my school, which is pretty good. But databasing pretty hard, iv only used it once in my life and still had to get my friend to do it for me.but what do you think of mysql?and do you think its the best databasing ever?

....know more

phpBB - MySQL Help Needed

Ok, well I origanaly installed phbb on my webspace but then switched to invision 2.0. After about 4 days of skinning, configuring, ect I opened up the forum. With this done I didnt need the phbb forum so I went to the cpanel and removed it. After I did this My Invision forum no longer works. Here is the error I get.CODEmySQL query error: SELECT * FROM astahost_cache_store WHERE cs_key IN ( 'attachtypes','bbcode', 'multimod','ranks','profilefields'

....know more

Backing Up MySQL?

Could someone please tell me how I would back up my MySQL database? I'm using phpMyAdmin by the way. Thanks for your time.

....know more

MySQL Problem! Can't Connect To Server

Hi, not sure if this is the correct spot but it is on MySQL which is database software! Ok, I am configuring a server for practice and I have run into problems with MySQL... I can't start it!!I'm running SUSE Linux Enterprise Server 9, and in the shell - konsole window, I typed:mysqld startand that brings up the following: mysqld: Too many parametersmysqld Ver 3.23.49 for pc-linux-gnu on i686Use '--help' or '--no-defaults --help' for a list of available optio

....know more

Accessing Ms Access Database From A Centralized Location?

HiI am a manager at a trading/wholesaling company (and have no programming background). I customized the Northwind sample access database to make invoices and keep accounts for my company. We now opening another office at a distant location. So, the order entry will be done at two points(we plan to use the same Access database).I am not able to figure out how to access the same MS Access database from two different location(as LAN can't be used). Moreover, we can't afford to pay huge sum

....know more

Can I Remotely Access Astahost MySQL DBs?

I can Access This MySQL Server using a Software like MySQL-Front?

....know more

How To Use MySQL ?

I was wondering how you use MYSQL? It seems a hard database to create, any help on this?

....know more

Updating A Database's Tables

Is there an "easy" way to update a database's tables? Like for instance, I have my own custom-coded member login system. Whenever I add a new feature that needs a database, I manually have to download, update and upload the database. Is there an easy way I can do this?THANKS!!![N]F

....know more

What Is Maximum Capacity Of Astahost MySQL Database?

I'm sorry about this topic. I'm a new user and my english is not very good. I want to learn the max capacity of mysql db.

....know more

PHP And SQL Databases: Please Help!

iam new to PHP and SQL and i have recently been learning them on my IIS using easyphp and till now i only got the basics ...not all of them coz most of the sites i have been theough was either:1.not making any sence at all (i always get erorrs) especial in the last line i always seem to get something wrong in the php code which i cant find any explaination in any tut i have read till now.CODEmost bugging serror was in this line </html> so please if you know any site that explain in a

....know more

How To Learn Mysql?

I want to learn MYSQL but I don't know where to start.Any suggestions of where to start in learning MYSQL?

....know more

phpBB Database Transfer

Hello, i'm a newbie in using phpBB and I still lack knowledge in mySQL database. How do I transfer the datas(users,configs, all of them) contained in my current forum to another one in phpBB? I hope someone can help, a short but detailed tutorial would be good. Example is, if I want to move to a new host and I want to transfer all the accounts on my old forum to the new one. Thanks in advance, hope anyone here knows how to.

....know more

Please Help! SQL Problem - Thanks For Reading

I seem to be getting this problem on my website more and more often. I am the biggest computer newbie ever, so sorry if this is a bit of a stupid question , but is there any way to configure it so it avoids this mesasge?

....know more

Paid To Read

I want to install a paid to read script ,are you accept like these scripts? if yes ,could you tell me how to install it .( the script contain CGI and PHP scripts.thank you.

....know more

Difference MySQL And PostGRE-SQL

Can somebody explain me the differences between mysql databases and postsql databases. I have no idea what they make different.One thing I heard is that postsql should be better than mysql databases...but I have no What would you recommend me to use for a forum or so?

....know more

Need Help With phpBB

Erm does anyone know how i can increase or decrease the number of posts a person has in phpBB forums? I'm having trouble with that, can't find the link or something. I would gladly appreciate any help! Thanks

....know more

Error In Installing MySQL Server

I try to upgrade my MySQL server from 4.018 to 4.1.10a.Firstly, I downloaded mysql-4.1.10a (not the essential one) for win XPThen I install the new version after the old version was uninstalled.After the installation process, Instance Configurator comes up to help for the configuration.But an error occured when it try to start the MySQL service.Error messageis "cannot create windows service for MySQL. Error:0"So my MySQL server cannot be started. It is running win XP on my computer.Do

....know more

MySQL Database Problems

My friends have a little forum running here. The problem is that quite often we get the following message when we try to open the page:QUOTE Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 48Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 330Warning: mysql_errno(): supplied

....know more

Space Needed For Database

Iam assuming the information in the databases i will create will be stored in the 500 MB space i get, but since 500MB isn't enough iam wondering if you guys can tell me how much bytes the following take: Varchar(x),Tinyint,Text,date,smallint,mediumint,bigint,float.... And the rest present when you add/edit a row in a table.Also what are the ranges of tinyint,smallint,mediumint and big int

....know more

~* Backing Up Forum & Database *~

Hello folks ..I started using IPB forums .. and i have a few queries i would like to ask .. Assume i have installed the forums with the database and its working now .. I have 50 users that have signed up .. now sumthing just comes up like reg problem ( happend recently with me and my previous installations got deleted ) well in that case the forum tables and catagories i have made plus the users that have signed up .. all these things i would like to back up .. Its like sumthing similar to a Nor

....know more

Where Can I Find Free Host For MySQL ?

hellowhere could I find a free and stable SQL host?I have serwer without MySQL and I need databse...

....know more

Recommendations For An Image Database ?

I was toying around with the idea of creating a MySQL database for my comic strips. But while reading about image databases, I found that there are (at least) two fundamentally different ways to set up such a database.Option one is to upload the images into the database using BLOB. This is straight-forward enough.Option two is to load into the database the locations of the images, elsewhere on the server. Then the database just directs the browser to the images.I'm sure there are some databa

....know more

Creating A Online Community With Php And Mysql

hello, I am trying to find out how I can create a online community like Myspace? Does anyone know the requirements/How i would be able to go by doing this type of thing?

....know more

Wondering If I'm Having A Code Problem Or If Its My Database

I'm still trying to figure out my login/registration page. It's probably a problem with my database itself. I have come up with this error on my webpage:QUOTEWarning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lonebyrd/public_html/registration.php on line 93This is the code for that line:CODEif(mysql_num_rows(mysql_query($nameq)) > 0)Before that is probably what matters so I will give that too. Here it is:CODEelse

....know more

Help With Registration Page, Access Denied.

I'm coming up with an error that I can't figure out in my registration page. Below I've given the error message and the code.QUOTEWarning: mysql_connect(): Access denied for user: 'nobody@localhost' (Using password: NO) in /home/lonebyrd/public_html/db_connect.php on line 33Access denied for user: 'nobody@localhost' (Using password: NO)CODE$Host = "localhost"; // define host name (default: localhost)$User = "$lonebyrd_razmo"

....know more

PHP + (Access OR MySQL): Which Is Better To Use?

Well I'm just starting to get back into web design and I need to create some pages that use databases, I know I used to have two different ways of accessing databases through pages. One was using PHP to use a microsoft access database and then I also used mysql.My question is before I go back and relearn everything, which method is best to use?

....know more

Mysql--how Do I Order By..

well i would like to recieve the results in the same order a supplied in the IN Argument, ho would i do itPlease help[codebox]SELECT DISTINCT data.id, data.name FROM `data` WHERE category = 2 AND id IN(1957,1923,1921,6628,6377,6360,1942) [/codebox]

....know more

Database Size?

Well I know that MySQL databases can get rather big, so I was just wondering how big everybodies databases were? Do you have really big ones, or are they relatively small? Also what do you store in them? (just text, or binary data as well)

....know more

Connecting To A Remote Database

I wondered if anyone here can help.I have a database on a remote server (A). I want to access it through a php script on a different server C.I have allowed access on (A) in Cpanel - mysql dbases - Remote Access by putting the IP address of server CThe host of server (A) has also whitelisted the IP of server C.Though I am having trouble connecting from server C which is with a different webhost.any ideas how to get round this?I have though of SSH forwarding, but I think this can only be used to

....know more

How To Use MySQL, PHP And Recordsets ?

I am just beginning to use PHP and MySQL together. I was wondering, in PHP, how do you access information you have retrieved from a MySQL database? I've used ASP with an MS Access database before, and in that scenario the information returned through an SQL query can be stored in a recordset. Basically, I am wanting to know how to do this in PHP.

....know more

help me!!!!!

i used below to display my banner<?$db=mysql_connect("localhost","root","");mysql_select_db("ad",$db);$result=mysql_query("select * from ad");$row=mysql_num_rows($result);$imagenum=mysql_query("select * from ad where ID=1");while ($image=mysql_fetch_array($imagenum)) {printf("<a href='$image[1]'><img src='$image[0]' border=0 alt=wallpaper></a>&q

....know more

Steps in using the database at astahost.com

I'm building my website now and I'm anxious to know how to use the mysql.I have the development experience with Oracle and C++. But is new to mysql and html or asp.Would the experts here state the steps how to use the mysql here? Thanks in advance.

....know more

Learning MySQL

HelloI want to learn about MySql Database.Do any one know about free rescorces for learning it.Also a tutor for DreamWeaver MXI will be very thanful.Sohail Ahmedsohail4@msn.com

....know more

How To Learn MySQL ?

Hi Guys,I want to learn to use MySQL in my site. I'm told that it is already installed. But I don't know how to use it.I've installed PHP Triad in my machine and with MySQL.Please hyperlink to a website containg articles on these.Bye,Bigyan

....know more

Need Help In Database Auto_increment

i am creating a game and i set when someone registers than he gets id...in "extra" i have set it to be "auto_increment" but whenever new player signs up he gets number bigger than 210...(my first id was 211,next was 212,third was 213,fourth got 214) how to set it to go from 1 to infinite? thnx

....know more

Help To Build A Forum Site Without Ads

can anyone help me... cauz i am building a forum without ads for my class... and i wan them to have good communications with teachers... can anyone teach me how to make it?...

....know more

Oracle 10g - Dba Less?

Today Oracle is pushing the idea that if you have an Oracle 10grunning in your company then you could survice without a DBA inyour payrollNow I want your opinion on this thing

....know more

Recover Tables From A MySQL .frm File

I have a couple of .frm files with no corresponding data or index files. Is it possible to recover the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is innodb

....know more

Apache Php With Mysql On Windows [solved]

I have problems running PHP MySQL function in a windows set web environment. PhP scripts are executed but if I try to use mysql connect and other like functions I get a blank window (while using the browser).The command line client is working...I've added the path to libmysql.dll and the extension=php_mysql.dll in the php.ini.

....know more

Oracle "lite" Alternative?

for college, we run oracle on a win2k3 server that's run on a virtual system like VMware and/or Virtual PC. VMware has it bells and whistles, and makes a nifty gadget, but eats my laptop's resources like there's no tomorrow. So I got rid of the VMware image and VMware itself, and wanted to switch to VPC. Another problem I have, is that I barely have any diskspace left to work with, and those images are at least 4 GB. So I wondered if anyone knew a program that would act as Oracle, bu

....know more

Whats The MySQL Version At Astahost

Anybody know what version of MySQL Astahost uses? 3.x? 4.x?

....know more

Auto-backup Your MySQL DBs Daily/weekly/monthly

Hi folks,[tab][/tab]I just came across this cool shell script called automysqlbackup which takes on certain parameters such as your user/pass/host address/database names and performs automatic daily/weekly/monthly backups of your databases as configured. The script is ready to run and need very little configuration - only in the top part:QUOTE#=====================================================================#=====================================================================# Set the follo

....know more

Oracle Vs. Mysql Vs. Postgresql

Hey Everyone!,Please choose your preferred database s/w!Regards,Avell

....know more

What Are Your Opinions / Views About Oracle ?

What can you say about Oracle. I never used it so i want to hear from experts what is Oracle like :-)[note=miCRoSCoPiC^eaRthLinG] Topic title edited to suit the nature of content better. In future try to make your topic title more descriptive. [/note]

....know more

[help] Student DB Script In PHP & MySQL

Since my earlier try with using access went wild .. i decided to choose MySQL as my DB and PHP as the code .. so just changing a few things in my earlier post .. for the new people .. QUOTEok .. i have this little problem i am going through ... Leme explain this project of mine first .I have a MySQL DB of student fields like ID no, Name, Marks .. etc .. This one MySQL DB would be updated by just adding more rows and would be done on the server.Now .. I have a HTML page that shows this :I would e

....know more

Navcat For MySQL

Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just played around with the demo. Has any one used it beore, if so please let me know if its worth buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility and functionality.Regards

....know more

Mysql On Computer

I posted PHP on computer? , but for some reason it doesn't show :/. Anyways I am wondering if there is MYSQL on my computer, meaning can i make a data base on my computer? that way i make what i want and upload it when i get hosted =)

....know more

How To Understand A Database Schema

Yesterday while i'm seaching for a data model and database schema at the Library of Free Data Models for a new project of a friend of mine i found there this nice and simple tutorial on How to Understand a Database Schema.As its name says, this tutorial will help you to better understand a Database Schema and covers the following basics topics that every Database Schema must define:QUOTEPrimary and Foreign Keys.One-to-Many and Many-to-Many Relationships.Inheritance."Rabbit's Ears&qu

....know more

MySQL

Hi all how are you? I am just having a bit of an issue with my form script and mysql, inserting records from this form of mine into my table in my database.it looks like all my others and they work, so what could be so wrong with this. Herelet me show you the codeCODE<?php$host="xxxxxxxxx";$username="xxxxxxx";$password="xxxxxx";$db="xxxxx";$link=mysql_connect($host,$username,$password);if (!$link)die(&quo

....know more

How To Create Database...

OK I got the script and hopefully I'll get my account back at astahost.. I just wana know how can I make the database for this forum.. I have ipb 2.0.4 script..and how can I creat tables etc etcwwaiting for reply ..-----I changed your topic to a more descriptive title. You should never use undescriptive titles like the one you used, "How To..."-----szupie

....know more

How To Connect MySQL With Flash?

I know Flash and mysql but could not figure out if I could ever connect these? I want to have a dynamic content in my flash object that could be retrieved from the database directly without myself needing to update it again and again. How can I achieve this ? Do I have to install any additional controls or connectors to do that ? If yes any one tell me

....know more

MySQL Data Replication, How?

How can I make data Replication in MySQL??, I'm making a web based software that's going to be used in 5 different drugstores of the same company, how can I make it so all 5 stablishments see the same data in real time?? is that possible? all 5 drugstores are in the same city but not so near one of each other, what kind of hardware should I use? where can I find a guide to it? what is the first step? can anyone help me please?

....know more

Help Neede:which Software To Use

Can any one suggest how can i make a program likecheatbook databaseis there any easy options

....know more

Database Not Storing Data?

This is puzzling me... I have a database for a global template system I'm coding... I get all the kinks worked out of the PHP portion of it, make a test page, and this is what I'm greeted with:QUOTEThat's what I get in Firefox when I access the page. Actually, it doesn't matter what ID I give it, that is all that appears.I'm trying something new but I'd like a PHP script to setup a table in an existing database.ID -> This should be set to auto-inc so first ID is 1,

....know more

Creating Tables In MySQL On Home Comp

Hi, I've tried seraching for a bit, but I couldn't find an answer to my questions. Recently I've succesfully installed Apache on my Windows XP Machine, along with PHP and mySQL. I need a database on my computer for testing purposes. I've enables mySQL in PHP, and both seems to be working fine. I can connect to the database, but how do I edit the database? E.g., edit rows or modify columns. I would much rather stay away from using the command-line stuff. I'm looking for a GUI

....know more

Database Design Help

I've been lucky to be the one to build my school's Intranet and want to make it as dynamic as possible, but not too dynamic as the server needs to also process a million other tasks as well (it is being hosted on my school's Novell NetWare server to easily control access).The technology department usually loans out school copies of software directly out of the software library. The problem is, no one knows EXACTLY how many copies of Windows XP, Photoshop, Office, etc. there are and t

....know more

Need Syntax Help With MySQL And PHP

I've been working on this for hours now which is really embarrasing really considering I've got it to work perfectly in the past but I cant find the script I used then Here is the script im working on:QUOTE1] mysql_connect("localhost", "root") or die( "Unable to connect to database");2] echo "connected \n ";3] mysql_select_db("users") or die("Unable to select database");4] echo "selected ";5] $query =

....know more

Access -> Mysql

I have a problem. Is any program wchich converts database Access to Mysql ??

....know more

MySQL Server Wont Start

Well I finally found a linux distro I like, I got the mysql server rpm installed on Fedora core 6 just last night... Now I am trying to start up the server and all i get is it saying its starting then saying its stopping from PID file /var/run/mysqld/mysqld.pidI am new to linux and farily new to running the mysql server, what should I be checking to fix this

....know more

Permission Problem With Mysql Database Creation

I seem to have a problem with accessing my database with proper permissions. I have set the my database correctly giving my db username all priviliges yet i seem to be unable to even log on with this username with a denied access error. Any ideas on resolving this?

....know more

MySQL

What exactly is mySQL? Is it a programming languauge like HTML, etc? I know that tables are very important in mySQL, and that the tables store all the data. But can you actually go about writing the code for a mySQL database?Thanks

....know more

Examining Databases At A Whole Glance

Most of us using databases or doing data minings are not aware of SQL-92 specification seemingly these days.SQL-92 specifiaction is the SQL database query language standard.Oracle,mysql postgresql,mssql and DB2 - most widely recognized SQL database programs - are all closely related to SQL-92 specification for the use of query nevertheless how they implemented SQL-92 specification features inside in the program.Implementation of SQL-92 specification features are applied in the order of Oracle, p

....know more

The difference between MySQL and other DBMS

Maybe Mysql is the most popular DBMS used in Web programming, but what about the others such as Oracle, DB2?How to choose the better one in website planning?

....know more

Is php supports MS Access

I want to know that is php supports MS Access databases. And could anyone told me the complete php installation.I have little bit problem during installation.

....know more

How Can I Import Csv Files To My MySQL Database?

I am having hard times finding that import csv in the mysql phpmyadmin. I once worked on some csv files and someone imported it on the mysql server. I was not able to ask him. Does someone know how can I import csv files in mysql server?

....know more

Low cost web hosting