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_connect("host name", "admin", "1admin") or die(mysql_error());
echo "Connected to MySQL
";
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
mysql_connect ("localhost","solo"," ");
?>
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 .
...






































