watch


Comments: mysql YouTube video.

 adm-in wrote:
Video Plugin - Search Turtilla Videos right from your browser. Install now!

 i made a project using c on linux known as online examination system but it has bugs i need help to remove the following errors:- 1)Function does not call itself, 2)segmentation error, i have alre3ady used the following header files:- ,,,, ...


 I am trying to install MySQL v5.1 on Windows XP. I know nothing about MySQL and am going insane trying to set it up. I downloaded the package that has to be manually set up since I could not find one with an automatic installer. I went step by step through the manual and have installed it, but I'm having trouble actually starting the server. When trying to start it, I get the following error: C:\MYSQL\BIN>mysql ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) My my.inf is in the C:\ directory and is as follows: [client] #password= your_password port= 3306 socket= /tmp/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port= 3306 socket= /tmp/mysql.sock skip-locking key_buffer = 16K max_allowed_packet = 1M table_cache = 4 sort_buffer_size = 64K read_buffer_size = 256K read_rnd_buffer_size = 256K net_buffer_length = 2K thread_stack = 64K Thank you very much. :) ...


 I am trying to retrieve some data from a my host's database (using MySQL 4.0.24 and PHP 4.4.1), and so far I can already connect and insert data into it and pretty much do the basics, except i keep getting this error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/xxxxxx.com/xxx.php on line 34 I already checked for spelling errors and syntax errors, but here is the clip of code anyway: $xxx = mysql_query("SELECT * FROM forum"); $row = mysql_fetch_array($xxx); while ($row) {..*code*...} The database table is named correctly, and the data is in the database and everything. But for some reason I still get that "mysql_fetch_array()" error. The code works when I use my own sql server and localhost, but I need it to work on my host's server, and I don't have access to the host server's settings. Again, I already can connect and do most of the stuff on the database; just can't get mysql_fetch_array to work. please help? ...


 Please let me know whether is it possible to connect a MYSQL db which is located in Windows Server 2003 Microsoft-IIS/6.0 from a Linux Apache/1.3.37 (Unix) server. FYI, the mysql db connection file is in LINUX Apache server and the mysql database is in windows 2003 server. i have just replaced the necessary variables and tried to connect but it showed the below error. ======================================= "; mysql_select_db("test") or die(mysql_error()); echo "Connected to Database"; ?> ======================================= ================================================ Can't connect to MySQL server on 'host name' (4) ================================================ FYI, It does not work even after adding the linux server ip address in trusted websites in windows server to enable access. Let me know is it possible to connect or not? ...


 I need to totally remove the MySQL database and MySQL Server components from my server. I have tried the add/remove programs but that does not work. I have a site that I need to access the MySQL database, but I have to totally remove the corrupted versions first. I believe the first/main database came with a copy of XAMPP. But the MySQL Server came straight off their site. For some reason they are both corrupted and can not be used or accessed. When I try root / localhost / password I am told that the database can not be connected to. I have tried nearly every means I know of to get rid of it, and I am at a loss. For a Computer Technician this is making me feel totally stupid. BTW reformatting the hard drive is out of the question. I did mention this is running on my server, right? If you know how to help great. If not please keep your shallow opinions to yourself. I am a level 4 answerer with a 42+% acceptance for best answers! Thank you ...


 first, i'm using PHP + MySQL second, i'm trying to query answers from ans table base on member_id in a single statement. using this statement on the phpmyadmin SQL windows, gives me the correct results but it doesnt work on a PHP page: SELECT ans FROM ans a, members m, link l , questions q WHERE m.member_id = l.member_id AND l.question_id =q.question_id AND l.answer_id = a.answer_id AND m.member_id = 4 MySQL statement in PHP file: $member_query = mysql_query("SELECT answer FROM answers, members, link, questions WHERE members.member_id = link.member_id AND link.question_id =questions.question_id AND link.answer_id = answers.answer_id AND members.member_id = $member_row[member_id]"); $member_row = mysql_fetch_array( $member_query ); error: mysql_fetch_array(): supplied argument is not a valid MySQL result resource HELP PLEASE members table: type_id, member_id, f_name, l_name link table: m_id, q_id, a _id qn table: q_id, type_id, qn ans table: a_id, ans ...


 I'm writing a database application for the web using php and mysql. Right now I'm working on the portion of the code that will allow the administrator to authorize someone who is attempting to register to use the database. Here's the mysql query that is giving me fits: mysql_query("replace(authorized, '0', '1') from members where id = $_POST[sel_id]") or die(mysql_error()); What the code is attempting to do is changed the boolean field authorized from 0 to 1 for any records in the members table where their id matches the one passed in from the submission form as sel_id. But, when I attempt to authorize, I get the following mysql_error: You have an error in your SQL syntax near '(authorized, '0', '1') from members where id = 10' at line 1 Can anyone give me a hand in figuring out what I'm doing wrong? This is my first attempt at using the "replace" function so I've probably got the syntax wrong or something but I can't seem to find help on it anywhere. Thanks. ...


 im getting an error on my forums saying this... "Warning: mysql_connect(): Too many connections in /home/c332147/public_html/forum/db/mysql4.php on line 48 Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/c332147/public_html/forum/db/mysql4.php on line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/c332147/public_html/forum/db/mysql4.php on line 331 phpBB : Critical Error Could not connect to the database" if its anything like validating html.. fix the first problem.. it should fix the rest. resolved on its own somehow ...


 For dynamic websites like Auction sites. Whats the best thing to do for the back-end? I see "packeged" turnkey websites being sold in MySQL. The problem is, i have a large marketing budget, for offline and online marketing. If user traffic increases so fast, will MySQL be able to handle it? Ive Seen the licensed version of MySQL, which is called MySQL Clustering. Is this any good for this? Problem is, oracle standard edition costs about £10,000. This is way over budget for a start up website. I mean we can get it, but what if things go wrong? I just dont know where to start. I have heard contradicting things. Some peopel said MySQL, if organised very well, can show performance like Oracle!!!! (As far as transactions per second is concerned). If i go with MySQL, what range of users can it support without slowing down anything? ...


 We own a site that is projected to have over 50,000 users within the next few months. Our site offers photo sharing, e-mails, chatting, games, and news. Were afraid to have all these programs running on a single mysql server and overloading it. So we want to install 3 mysql servers on our raid drive. The 3 mysql servers will be running on 3 seperate hard drives. Here's our questions 1. Is it nescissary to have 3 mysql servers or is 1 enough? 2. Can 3 mysql work togehter? ( Example: One server handles the members photos, The other server handles the members emails, the other mysql server handles the Chat Rooms and Games ) ...


 I have a database connection problem.Actually I got mysql server, php 4.4 (application server) and IIs server installed.when I try to connect to the database by the php script of I am getting the following error Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in c:\inetpub\wwwroot\mypersonal\registerspage.php on line 10 Can any one help me to connect mysql database. Advance thanks for every one who helps me . ...





Home   Rss   Webmaster   Privacy   Contact
2006-2009 Turtilla.com All rights reserved.