10,946 Topics
 | |
| | So... what is better, SQL, MYSQL, MSQL, POSTRESQL, and etc for a fast database that must be used in conjunction with asp and php. For now, i'm looking for the easiest database to be used in conjunction with ASP. Any suggestions? [flash]http://www.geocities.com/cyberpitstop/footer.swf[/flash] |
| | Hi, I just built mysql from source on Solaris. It's installed in my own space since I have no root access on that solaris server. The problem is I always get following error when trying to run mysql. sand:163% ./mysql ERROR 2002: Can't connect to local MySQL server through socket … |
| | I just feel like posting this today because I had several people asking me on how to use this Desktop Applicaiton called MySQL Maestro. Below is a self tip to help get you started and squared away for the most part. The rest once you get into it, youll pretty … |
| | Here is the error I am getting: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/movethem/.panel/web/portal/73/includes/sql_layer.php on line 286 This is in correlation to a calendar that I installed. Would anyone have any idea how I can fix this? My main config file is working as … |
| | We've recently developed a complicated relational MYSQL database which, on a data storage level, is working really well. Unfortunately, in terms of being able to sort and edit sometimes very large data reports, our front end interface (a custom built work in progress) often scores a relatively unimpressive "C-". Complicating … |
| | is there a way to check the exsistance of a table? I want something similar to this: SELECT COUNT(*) FROM table1 but for a table (in a given database), not rows within a table I know of another line command: check table table1 quick but this gives back too much … |
| | I am getting a syntax error report from an UPDATE using two tables in a MYSQL db. :cry: This must be my mistake but I can't see it and have changed around many times now. Any ideas to help me resolve this welcome. Statement: UPDATE hole,tee SET hole.hx=tee.tnx where hole.hid=tee.hid; … |
 | has anyone used embedded mysql in their app? please share your experiences. i'm contemplating whether or not to do it. i may just use XML. i know it's improper, but a lot of commercial apps do it! |
| | I'm new to SQL and was wondering how exactly do i use the join in a query. i have 3 tables, with the primary keys from the first two tables acting as keys for the third table. I have to get information from the first and third tables but need … |
| | Hello, I am very new to the world of Linux. Could someone tell me if I were to setup one machine with Linux, Apache, MySQL and PHP and dual boot it with Windows 2000 Professional, what would the ideal hardware requirements be. Also, what is the ideal size of a …  |
| | Well first some background, this hasn't happened before but last night I had some trouble installing a shoutbox mod so I undid all the steps I had performed I have also installed a search engine friendly mod successfuly which makes php links html links even though I know ipb supposedly … |
| | hey I've been getting this error: [COLOR=Red]Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource [/COLOR] This is what it said that is causing the problem: [B]$stafflist=mysql_query("SELECT id,name,sn,email,title FROM staff WHERE man='Yes' ORDER BY id");[/B] Can you please tell me what is worng ASAP. Thank you |
| | HI all (Battled with the WORD – (probably wrong in these terms)) I have a field in an access database (DateInserted) and want to get a (DateID) field out of it. To get the DateID field I use – [B]Day(DateInserted)&Month(DateInserted)&Year(DateInserted)[/B] - (Unique key for date outputs as 21102004) my problem … |
| | Hi, I've run into absolute brickwall and am really desprate for your help please. I have a MYSQL Database with two Tables called user_comment and the second user_table. When a user register with the site, their details are kept in the user_table. the second table user_comment is so that users … |
| | [B]How many clients can access a PHP script at a time from a MySQL server?[/B] thanks in detail. |
| | Hi, im new to the forums and i hope you wont mind me launching in with a big question! Ii am currently prototyping a multimedia information system which holds wakeboarding images and videos, along with a comprehensive set of meta-data about the multimedia data. Users can query the metadata in … |
| | I have a portal site [url]www.localmiamiguide.com[/url] that needs to be transfered to mysql. Anyone have any idea how much that would run me? :cry: Please advise. Jcolome [QUOTE=fsn812]I have worked on large scale projects using Oracle, medium sized projects using MySQL, and some small projects using Access. All have worked …  |
| | I have created a small application in PHP and MySQL. Could someone tell me what I need to do to add the appln. on an Apache Web server? Is there anything I need to take care of in the application to be a web app? |
 | :cry: I downloaded MySQL 4.0 then clicked on Setup file but ... (oops!)The followin' message appear [IMG]http://img94.exs.cx/img94/8826/error2.jpg[/IMG] Just tell me how could i solve this pro??? Thank u a lot!!! |
| | hi, i am thinking of designing a customised GUI frontend for mysql. i would like to know which of the programming languages Perl or Python can be used. my preference would ease of use and cross platform compatibility. i have already used off the shelf GUI's for mysql and i … |
| | A project that I've been working on (and getting help on [URL=http://www.daniweb.com/techtalkforums/thread10421.html]here[/URL]) is just about complete, but I've had to develop it locally on MySQL 4.1 for it's support of nested queries - I'm [B]rubbish[/B] with joined queries. However, the project is going to be running on my host, who … |
| | |
| | hey ya , i get some problems and hope u can help me to solve it first, i'm using Window XP , Laptop - service pack1 , uhm .... i tried to install mySQL on my computer but it didnt work ... some1 can help me to install MySQL , …  |
| | Hi, I have apache, php, phpmyadmin, and mysql in my computer. I could connect to mysql and manipulate database well before. But for an unknown reason, I can't do it now. Each time when I tried to do this, it gave an error message as "Can't create TCP/IP socket (10091)". … |
| | I'm trying to get started in ASP.NET, but I just don't understand the errors being returned to me. I'm trying to connect to my MySQL database. I have followed several examples from books and the internet with no success. Could someone look at my code and see if I'm screwing … |
 | I am trying to create an INNODB table with a foreign key, and it doesnt seem to be working. Can someone give me an example on how to use a foreign key. Here is an example of what i have: FOREIGN KEY (client_id) REFERENCES CLIENT (client_id) This line is preventing … |
| | Hello I have just bought a book on php, MySQL and Apache server which came with an installation disk. I have installed all three on my laptop computer running MS XP Professional. All three seem to work ok independantly but when I try to run any code examples through IT … |
| | |
| | I am extremely new to MySQL and web databse programming. I am runnning an Invision Board forum and have had numerous problems when installing mods (I know, install at my own risk, blah blah blah). My question is this: I am restoring the SQL database (I did make a backup; … |
| | I am having difficulty uploading text files to mysql database through phpmyadmin. Here is the feedback from the hosting company: The problem is in the inappropriate input file format (the txt file) - there are spaces before and after the comas. To solve the problem - strip the spaces arround … |
| | does anyone know where i can find a complete list of mysql commands. Im in the proccess of writing a live mysql database interaction for web use. and right now i need to store all mysql commands to an array and have the php script read the array and modify … |
| | i need to know the format to search for a user name in the database, im using PHP to submit the data so far this is what ive got [php] @mysql_select_db("$DBName") or die("Unable to select database $DBName"); $sqlquery = "INSERT INTO $table VALUES('$id','$name','$email','$opinion')"; $results = mysql_query($sqlquery); mysql_close(); [/php] im using …  |
| | Finally, there's a book that will help you prepare for the MySQL certification exams. Learn more about it here: [url="http://www.amazon.com/exec/obidos/tg/detail/-/0672326329/qid=1087361084/sr=1-1/ref=sr_1_1/002-7750886-2407247?v=glance&s=books"]http://www.amazon.com/exec/obidos/tg/detail/-/0672326329/qid=1087361084/sr=1-1/ref=sr_1_1/002-7750886-2407247?v=glance&s=books[/url] |
| | Hello. I have installed PHP4 and MySQL (.dmg) on Mac OSX v3 client. Everything is up and running. I have created tables in my DB, established user privileges, etc through the 'terminal' app. I have turned on web sharing through the 'preferences' panel and dragged my .php files to the … |
| | Hy, I have a PHP raport and I'm using a MySQL database. That raport have to show me information from database. These information from database I only can see them with Internet Explorer (I'm using it to show me the output from my PHP program). If I want to see …  |
| | Hi, I'm new to this forum. I am a consultant looking to extend an application's platform dependance. To this I need make specific DB design changes for my normalised database (ie. PK-fields that were autonumber/identity are being changed to integer). Does anyone know if MySQL, Oracle and SQL Server support … |
| | Hi, i'm making a database on mysql for a uni assignment. In the write up of the report i've been told to put in a logical model which can be done by identifying the relationships from a conceptual model. I know what a conceptual model is and have identified the …  |
| | Hy, I have a PHP raport and I'm using a MySQL database. That raport have to show me information from database. These information from database I only can see them with Internet Explorer (I'm using it to show me the output from my PHP program). If I want to see … |
| | [size=2]By: Jeff Johnston MySQL is set to announce some exciting new features at its User Conference in Orlando April 14-16 ([url]http://www.mysql.com/[/url]). The wildly popular free database server is expanding its functionality in attempts to keep up with the competition, PostgreSQL, and Firebird. The two new features are MySQL Cluster and … |
 | What Is MySQL? A friend told me it was free as long as i didn't sell it. is this true? if so where can I get it and what does it do exactly? thanks |
| | does anyone know a good FREE company who does MySQL and PHP hosting? |
| | Hi, I'm having a problem of starting mySQL.. well I'm actually forgot what did I do a long time ago that mess the mySQL up in my server. Well now when I'm trying to execute this command from the terminal such as: /etc/init.d/mysql start .. instead of starting the terminal …  |
| | [url]http://staging.infoworld.com/articles/hn/xml/02/10/21/021021hnnovellmysql.xml?Template=/storypages/printfriendly.html[/url] |
| | Okay, so this forum uses PHP with MySQL... I have access to PHPMyAdmin on a remote server. I have been making periodic back-ups (dumps of the tables) but I'm always afraid that when I need them most, they'll fail on me. There isn't by any chance an easier way to … |
| | [url]http://builder.com.com/article.jhtml?id=u00320020624gcn01.htm[/url] From article: [ When to use MySQL] Why would you use MySQL over PostgreSQL? First, we need to consider the needs of the applications in terms of database requirements. If I want to create a Web application and performance is an issue, MySQL will be my choice because it |
| | This is a great tool to use when creating DBs in MySQL. Better than the one it comes with. If you're about to embark on an app using MySQL, I recommend it. [url]http://www.anse.de/mysqlfront/[/url] |
The End.