10,940 Topics
| |
I want to connect to the database mysql . I am using Type IV driver Connector/J. How to connect to the database. When i load the driver class its working after that i get this error SQL Exception :Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** … | |
Hi. I'm currently trying my hands on PHP and MySQL. I understand how to retrieve results from SELECT statements in PHP? However, I'm not exactly sure of how to do it when a procedure call is made e.g. [code] [COLOR=green]$query[/COLOR][COLOR=green] = [/COLOR][COLOR=green]"CALL mach_validity([/COLOR][COLOR=green]$student_id[/COLOR][COLOR=green], @result)"[/COLOR][COLOR=green];[/COLOR] [COLOR=green][B][COLOR=green]if[/COLOR][/B] ([COLOR=green]$result[/COLOR] = [COLOR=green]$mysqli[/COLOR]->query([COLOR=green]$query[/COLOR]) { [B][COLOR=green]while[/COLOR][/B]([COLOR=green]$row[/COLOR] … | |
| Yes, I was wondering how do I set the password for mysql on opensuse? When I was setting it up [url]http://www.novell.com/coolsolutions/feature/595.html[/url] it never gave me an option to set the password. It would be useful for security measures. Thanx. |
Hello everyone! I have problem with the configuration of MySQL. I am using IIS, Php 4.3.11(CGI) and SQL Yog. All are working. I also installed and used MySQL Servers and Clients 4.0.15 for my database. If i connect to the database, i encounter this error: Can't connect to MySQL server … | |
Is it possible to retrieve one cell of data from a MySQL database? I need to put the ID from one row of a table into a php variable so that I can recall the correct row later on for editing purposes. If you know how to do this please … | |
Hello Im makineg a small cms for my purposes and my problem is updating adding dhe DATE, im getting 00.00.0000 can anybody help me making a drop down date with dd/mm/YYYY so I can add - edit ?? Thnx a lot Enjoy Life | |
I receive an error on system startup like the one in the attachment. But php_mysql.dll file actually is in C:\Prog\SERVER\PHP\ext folder in my computer. How can I change this incorrect setting? | |
I would like to move my forum database to a new server. However, the MySQL database is approximately 700 megs, and takes a great deal of time to import. Doing a [inlinecode]mysql> source backup.sql[/inlinecode] took well over 12 hours the last time I did it, and that was months ago. … | |
Hello, I am a newbie coder and I am trying to find a way to create a php mailing list. Ive tried looking around but have only succeeded in becoming more lost and confused. I would like the users to enter their email address into the text box and click … | |
Hi, I'm writing a program that parses a *lot* of log files into a database. It's completely O-O, and each object opens a database connection to mysql using [B]mysqli->connect()[/B]. Here's my problem - the program works great for a limited number of log files, but if I run it over … | |
hi everyone how to display mysql query results in a html or jsp page. using java script or any other if u have working code or sample code please send me please help me . its very urgent regards Manjunath | |
+----------+---------------------+------------+--------------------+ |wage_id | full_name | wage | date_added | +----------+---------------------+------------+--------------------+ | 1 | Unknown | 123 | 2001-12-22 | +----------+---------------------+------------+--------------------+ | 2 | Unknown2 | 321 | 2007-06-17 | +----------+---------------------+------------+--------------------+ how to count sum pf values in wage column? 123+321= 444 <---- that way :) | |
I'm having a devil of a time trying to insert a Windows UNC share into my MySQL database. The DBI quote function doesn't seem to be behaving as I would expect. Here's a little example: [code=perl] #!/usr/bin/perl -w use DBI; my $unc = '\\somebox.somehost.com\someshare'; my $dsn = "DBI:mysql:cmdb;localhost"; my $dbh … | |
hi ppl,i have a question.I have column which is a primary key.i have inserted a value also to it.Now again if i insert the same value it shouls not give a error.but instead continue.So how to go about it.like vb onerror is there any way that we can write the … | |
Hi all i new to MySQL and currenlty now is trying to do a database and upload it up to PHPMyadmin so that the page im am creating can use it but im facing a big problem here Error SQL query: # # Database structure for database 'database name' # … | |
hi can anybody help me i need to get the data from db through php script my code is : <?php $con=mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("poll",$con); echo "DB SELECTED<br>"; $result=mysql_query("select question from pollquestions",$con); echo "QUERY EXECUTED<br>"; echo $result ; echo "<br>DATA DISPLAYED<br>"; mysql_close($con); … | |
I currently run your typical city guide web page and for this entire post i am going to use my artsandculture page with in this page i have sub pages of museums,wine,galleries when a user clicks on museums there is a list of all the museums in html format and … | |
this is a program that i have, i dont know why it doesnt work. Could some one help me? thank you very much [code] #!c:\Python24\python.exe # Fig. 35.22: fig35_22.py # A program to illustrate Python's database connectivity. import MySQLdb print "Content-type: text/html" print print """ <html xmlns = "http://www.w3.org/1999/xhtml" xml:lang="en" … | |
I am looking for a set of buttons (CODE) for making a NAV set for php and mysql, I need next prev top bottom along with edit add delete reset, any one know of a good starting place to look at least? I would like for it to be working … | |
I need some advice from the pro's :) I am building an application that has data from several places. The structure is all the same but the data is specific to a user. 1 such a feed can consist of 50,000 rows but on average it's more between 500-2000 rows. … | |
hi im new to the field of datawarehouse, but im familiar with the database concepts so, can you please give me the guidance or scope of ddatawarehouse for my career, how it is helpful to my career growth, please give me those information. | |
Hi, I am new for PHP and MySQL, plz guide me for beginning, tnx Samad | |
yes, i know mysqls query language, but what i need to know is how to connect mysql database with php. i am designing a dynamic website using macromedia dreamweaver 8, mysql and php. how can i go about configuration in order to connect successfully? | |
I'm trying to create a libmysql.a file for my Dev-C++ project. Parameters for dlltool is as below : [IMG]http://img527.imageshack.us/img527/8911/beforeco4.jpg[/IMG] But the output libmysql.a file is not proper, it doesn't contain anything. [IMG]http://img72.imageshack.us/img72/1707/afterpj1.jpg[/IMG] What am I doing wrong? | |
hi i am trying to design a dynamic website using php and mysql, how can i make configuration so as to connect successfully? | |
Hi, I wish I could solve this on my own but I tried searching and googling but nothing doing. Althought worse comes to worse, I can use Perl to do what I want, but I would prefer having a SQL syntax that can handle it. Problem: 3 columns: username, daily … | |
Please help me on how to join 4 or more tables. I have an idea of joining tables but it is good only for two. I have joined 3 tables before but i worked that in access. For now, im using MySQL and Php. Hoping for your response. Thanks.... | |
Any recommendations for Barcode software that can be embedded into certain field in MySQL database to generate barcode? Thanks! | |
I've about given up on my previous problem. I [I]was[/I] beginning to think it'll be easier to do simply by dropping the user, then recreating it with the appropriate privileges next time around. Only, when I tried (as the superuser, no less) to drop the problem user, I got the … | |
I am trying to maintain a MySQL db which is required for business usage. I recently ran into a problem where one of our programs would blow up with an SQL error; taking a look at the error message, the program description, and the database in question reveals that the … |
The End.