phpMyAdmin-MySQL Error #1251:client Authentication
After I installed phpMyAdmin and tried logging in with the root password, I get this :#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL clientI already installed mySQL administrator and enabled old passwords. Any help would be appreciated.Oh yeah I have :mySQL version 4.1.11-ntmySQL client 5.04Apache 2.0.54PHP 4.3.11phpMyAdmin 2.6.1-pl3
Lost Connection To Mysql ,..., System Error: 111 In
While I was trying to connect to my database or even create one using PhP mySQL I was given the followoing error:Lost connection to MySQL server at 'reading initial communication packet', system error: 111 inHas somebody encontered a similar report? I have my database created using the cpanel together with a user name and password.I wonder if it is a server issue? What can you do if you have not access to the configuration files?
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?
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
Mirror My MySQL Database To Another Mysql Server
Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql server?or create a small php script to do this?The reason is because, we all know that database is very improtant if we have dynamic website.I have my forum hosted and i want to automatically mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid that i forgot to backup my database..also i have one central backup database.Thanks for the help..Im looking forwa
How Many Concurrent Users For Oracle Database?
Hi friends, How many concurrent users can practically access the oracle database? they say tht the figure is hundreds of thousands users...is there any exact figure?or does the number of concurrent users depend on any other factors as wel? I think depend on parameter 1.session2.processessession Specific connection of a user to an Oracle instance through a user process. A session lasts from the time the user connects until the time the user disconnects or exits the database applicati
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
Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database
Hello to all of you beautifull people out there, I am new to MySQL, i just wanted to know if its a good practice to directly store images and other binary files in a MySQL database. Any one with help? Thanks
MySQL Datetime --> VB.NET Datetime Conversion Prob
Hi,Can anyone provide me with a quick example of fetching a MySQL Datetime Field and converting it into native VB.NET DateTime format ?? Say for example my db contains a couple of fields: Field1, Field2, DateField... one of which is the default MySQL DateTime.Say I'm using the following code to connect...CODEConnectionString = "....."QueryString = "SELECT * FROM SomeTable"Dim myConnection As New MySql.Data.MySqlClient.MySqlConnection(ConnectionString)Dim myCommand As
te best database for my is sql server yukonfor you?
Phpmyadmin Export And Collation Problems
I have a very strange problem with the Exported sql file generated by phpMyAdmin that never happen to me before, the problem is that my data contains some strange characters but when i see them on screen it shows correctly, instead of showing the spanish characters á, é, í, ó, ú and ñ it shows others, for example instead of á shows á, instead of ó shows ó, etc.The other problem i have is that when i use Internet Explorer and want to download the generated sql file to my machine nothing happens
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
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?
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
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.
i have just got hosting here on astahost and i have to copy my databases from my old server...is there an easy way of doing this? in phpmyadmin?thanx in advance you know lol
[mysql]how Can I Get The Newest Record?
I am currently developing a website which need to show the newest record in index page.The newest record should retrieve from mysql database.now, the question is....how can i get the newest inserted record from a particular table in myssql database???
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
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
do know anything about SQLight ?i am using "Auto Play Media Studio 6.0" and need to use database and this program use SQLight nd i dont know how?
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
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
MySQL - Trouble With Bulk Insert Statements
I'm trying to insert about 500 rows into mysql, but I keep getting errors. If I copy and paste too many (about 50) insert statements at a time I get errors sometimes. I sometimes even get errors but then the row is skipped so I don't know there was an error (I'm using linux and SSH). What's the best way to get my insert statements to put the data in MySQL? Is there anyway that I can have it tell me if there where any errors all the statements are executed?Thanks for your help.
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,
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
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?
Oracle Vs. Mysql Vs. Postgresql
Hey Everyone!,Please choose your preferred database s/w!Regards,Avell
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.
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
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
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?
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
Sample My.cnf - MySQL Configuration File
Hi all, Recently there has been lots of questions about configuring MySQL. Usually the rpm comes with a few sample MySQL config files, but here I'm providing you with a fully working one for your reference. Feel free to modify it to suit your needs. One word: My MySQL is configured to use only large InnoDB Databases, because of the large volume of transactions it handles. You'll find a reflection of that in the my.cnf... Most home users would use ISAM DB instead. So make the suitable
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.
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.
ADODB Class - Database Wrapper Class
Do check out this award winning class ADODB. Its really easy to use and has many features which really help a lot in the development of an application. The best part is that you just have to specify which database system you want to use in the beginning. If you want to change the database server, just change it where you create a connection. It supports MySQL,MSSQL, Oracle etc. It has an inbuilt pagination script to display your results in pages.-----This is not a tutorial. Moved from [How-To
Read/Write Issues After Copying An Access .mdb File
Alright, I'm currently creating an interface program for a MS Access database. I've only used Access once in the past but used other DB's a handful of times so I didn't have any trouble getting the general program created. My issue arose when I tried to make it so that the users needing to use the program can just copy the .exe and the .mdb files and use it.The program doesn't require users to share the database but to store their OWN programs information in their OWN databas
I have to create a whole project using Microfost Access. I have a field which will eventaually contain details of a a list of people's DOBs. I have added an input mask, so that it it displays the place holder __/__/____However, how can I validate this field. For example, not it is possible to type 30/10/1991 [dd/mm/yyyy]. How can this be changed so that it validates it correctly?
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
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.
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
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?
Ok. So I signed up for this college course called "Oracle."All they told me was the that course is supposed to teach me professional internet databasing.Am I right? And what exactly IS "Oracle"? What am I gonna learn? Thanks for your help!
Problems With Php Saving Data Into Mysql
i have a server that says it allows php and mysql and in the control panel i can access mysqladmin and phpmyadmin but i cant get the php to save data into the mysql, i am trying to make a text-based MMOG so i need to save my users/passwords into a database(i thought) and it won't do it, can anyone help me
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"
in mysql install directory:\mysql\bin>mysqldump -u root -p root your_DB_name > back.sql
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!
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
Itunes - Cannot Connect To Store
When I downloaded the Itunes update (7.6) I installed it, and now I can't use the store. I get a message something like Itunes cannot connect to store, as it was unable to establish a connection to a network. I have been told it might be something to do with norton protection center / norton antivirus, but I am not sure what settings I have to change.
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
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
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
How do i restore a sql.gz file? Im confused
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
It is good practice to use multiple tables to sort out big amounts of data. But once you do that it becomes increasingly hard to cross reference the tables. Mysql has a little beautiful command structure that they have added. You can select multiple tables within one sql query. Example of a basic sql queryCODE$sql = "SELECT * FROM table WHERE row=1";If you noticed that I selected all of the rows in the table. Normally you will try to not select the entire table from the database unl
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?
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
Can we use PHPBB2? If we start hosting are we allowed to use PHPBB2. I mean I know that if we are allowed to use PHP but Wil the file manger be that of Cpanels
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?
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?
How To Dump .SQL File to MS-Access
Is there any way to convert a mySQL dump (.sql file) to an access file? Problem is, I downloaded and installed the mySQL server and ran it. But I couldn't restore the dump - it kept complaining about charsets and even the guy who created the dump didn't know what was up.So I'm looking for another way to access the contents of the database. Help anyone?
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)
i dont know if this might be useful to ppl here, but this is a very good knowledge for serious siteadmins.while i was digging for mysql backup techniques, i've found that mysql is able to do realtime replication. the idea is that there are master server and slave server. both are having the same version of mysql installed. the data flows;Master >copy> Slave ( in realtime!)you'll never have to manually copy the database file of wasting your time to manually use the mysqldump com
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'
Help Needed With MySQL_fetch-array() Error
databasing is quiet hard to learn but im starting to get the hang of it. on my home page i have a few errors like this Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mrogers/public_html/html/nav.php on line 80 i have checked whats on line 80 and this is what i ended up with$row = mysql_fetch_array($sql);but it does not look like anything is wrong and i kind of do not under stand the mysql witch i am learning at the moment, but any one know
Hi!, what is MySQL with MySQLi because i am hosting phpbb3 site and i got a database types of MySQLMySQL with MySQLiPrestigeSQLI have choosed MySQL now but i am willing to reinstall.xxxx-jozh-xxxx
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'
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
How To Use MySQL Monitor With XAMMP
I am taking the suggestions of other Astahost members, and trying my scripts out through Xammp before putting them on my website. Right now, I am reading the online book 'Practical PHP Programming' and learning some more about MySql, and trying to figure out how to use it without the PHPAdmin in Astahosts Cpanel. The book talks about a MySql Monitor, but I have no clue how to access that. I am using Xammp, and I have all my services running, but I'm just not sure how to use the My
Restore Database Backup Locally?
I wanted to use my live forum database (in another webhost) on Astahost for testing purposes. But I guess the free accounts we have do not support that restore backup option...tried it and got a message saying that.Is there any way we can do this locally? I will probably install XAMPP or one of the variants of those packages. I don't assume cPanel can be included also locally? If not, I just want to know how I can use the database from my live forum in my own computer.Thanks.
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.
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???
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?
What is MySQL actualy???
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?
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
One of my users wants to transfer the data and so on from his phpBB2 to his PHP-Nuke CMS. I offered a link to Nuke Code that had 8 programs that deal with such matters. He replys that that is not really what he wants, to that the only response I could give was that since all he wanted to do was to export his phpbb_users table to his nuke_users table. To this reply he seemed to get the result he wanted but then stated that some of hid files as imported caused errors and I am sure this is the wa
I was wondering how you use MYSQL? It seems a hard database to create, any help on this?
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.
I know you can connect to data base and select a table, can you select a table get what you want from it then select another table with the same command, or do you have to close the first table (is their a command for closing a table)
Need Advice On Creating Online Music Database
I need to create a database of around 1000 music albums that I can put on my site, with the ability to search the database according to several different criteria. Being a complete and total NOOB to the world of databases, can anyone point me in the direction of some software that will let me create a good-looking and functional database, but that isn't too complicated for me to use?! Sounds like a tall order I know, be grateful if anyone can help though. Thanks! Notice
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
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
Count The Number Of Records Of A Table Group By A Foreign Key
how do i count the number of records of a table group by a foreign key??? Here are my tables:a. table situation:CREATE TABLE `situation` ( `id_situation` tinyint(3) NOT NULL auto_increment, `situation` varchar(20) NOT NULL default '', PRIMARY KEY (`id_situation`)) TYPE=MyISAM ;b. table documents:CREATE TABLE `document` ( `id_document` int(8) unsigned NOT NULL auto_increment, `id_situation` tinyint(3) unsigned NOT NULL default
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?
How To Use MySQL/phpMyAdmin Under Linux
Can any anybody help me by guiding me on how to use mysql database, creating tables and showing database results using Phpmyadmin in a Linux Web Hosting ?
does anyone know how to set up a database for a SMF forum.
Hi guys, ive got a registration system that looks something like the one below:[codebox]<html><body><form action="insert.php" method="post">Firstname: <input type="text" name="username" />Lastname: <input type="text" name="password" /><input type="submit" /></form></body></html> [/codebox]Then i have inset.php, which looks like the following:[codebox]<?php$con = mys
I exported an Access database to csv file, and then imported the csv file to mysql.Now I'm trying to use COUNT() on a field, but its returning the total number of records, which is not what I want. I know that COUNT() is supposed to count all records that arent Null, so I checked out my table in phpmyadmin and I realized that even though there are no values for some records they are not showing up as Null.What is the difference between a Null and a field that is just empty? Shouldn't it
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
Help In Storing Encrypted Passwords In MySQL
Hi,I need some help with storing password in mysql database or something similar.i used to store the password in database using md5() function but there is no way to retrieve thepassword back.Now i want to know that -is it standard and secure way to store password?is there any other technique to store password so i can retrive it back?Any advice on this would be highly appreciated.you can my quwstion in other websitesThanks
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
~* 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
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...
T-Mobile Sidekick/Danger Hiptop Friendly phpBB Theme
In order to make more sites sidekick accessable/sidekick friendly, a theme has been designed for phpBB. All it takes is a simple download from www.hiptools.net (not .com) and it needs to be uploaded to the board theme folder. The sk friendly theme is almost completely text based, so there aren't as many pics to load and it makes loading faster on the sk's. I'm planning on uploading it within the next few days. PeaceAaron
Getting Form Information To Database Query
I have a form written in html with the input box labeled:AttackBonusI have a query:SQL$query = "Select * From i bf_farmlist Where '%".$AttackBonus."%' >= i bf_farmlist.Defense_Bonus Order By i bf_farmlist.Name Asc"; I have no idea how to get the form variable to the query, as the variable always changes.Here is the form:http://army.klass-world.org/farm/index.htm
How Do I Learn Oracle In Arabic?
how i learn the system of database oracle in arabic ??
Any Website Provide Free Host Mysql Host?
any website provide free host mysql host?i need it because i am using 000webhost.com now but it only provide 2 mysql database... can i know where or how can i get more databasesregards
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
Need To Transfer Data From One Server To Another!
I am running a PHP-Nuke site on a web host that only allows one database so if I wanted to use a forum also in addition to PHP-Nuke I must use different prefixes. My PHP-Nuke has 112 tables and I am setting up an almost identical site minus any other forums, just PHP-Nuke 7.7 on Astahost which allows many databases, so I sucessfully exported my users, and my categories, and the posts, and I even exprted the posts text as well as the download categories and download text tables. The problem I am
©100Topics.net. All right reserved.
