10,940 Topics

Member Avatar for
Member Avatar for kalaiselvi.v

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 ** …

Member Avatar for masijade
0
109
Member Avatar for tunday

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] …

Member Avatar for tunday
0
90
Member Avatar for iamthwee

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.

Member Avatar for Infarction
0
130
Member Avatar for dudegio

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 …

Member Avatar for Puckdropper
0
480
Member Avatar for sickly_man

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 …

Member Avatar for sickly_man
-1
2K
Member Avatar for gllanci

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

Member Avatar for iamthwee
0
105
Member Avatar for hkBattousai

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?

Member Avatar for Puckdropper
0
67
Member Avatar for Dani

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. …

Member Avatar for pritaeas
0
153
Member Avatar for Slavis81

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 …

Member Avatar for elderp
0
256
Member Avatar for smac

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 …

Member Avatar for Puckdropper
0
193
Member Avatar for akash_msrit

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

Member Avatar for ~s.o.s~
0
109
Member Avatar for Dorio

+----------+---------------------+------------+--------------------+ |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 :)

Member Avatar for iamthwee
0
219
Member Avatar for roswell1329

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 …

Member Avatar for roswell1329
0
164
Member Avatar for krthk_sg

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 …

Member Avatar for tinamary
0
102
Member Avatar for lzmiy

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' # …

Member Avatar for leelee
0
72
Member Avatar for mithesh

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); …

Member Avatar for Rhyan
0
79
Member Avatar for shortybookit

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 …

Member Avatar for Rhyan
0
132
Member Avatar for dummies2

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" …

Member Avatar for BearofNH
0
149
Member Avatar for krisfr

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 …

Member Avatar for jbennet
0
178
Member Avatar for edynas

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. …

Member Avatar for pty
0
172
Member Avatar for tinamary

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.

0
101
Member Avatar for alamati
Member Avatar for jbennet
0
118
Member Avatar for nyadimo

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?

Member Avatar for Puckdropper
0
81
Member Avatar for hkBattousai

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?

0
86
Member Avatar for nyadimo

hi i am trying to design a dynamic website using php and mysql, how can i make configuration so as to connect successfully?

Member Avatar for shashi28
0
101
Member Avatar for bobby08

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 …

Member Avatar for fasttoshiba
0
711
Member Avatar for dudegio

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....

Member Avatar for SkinHead
0
70
Member Avatar for carmaniac

Any recommendations for Barcode software that can be embedded into certain field in MySQL database to generate barcode? Thanks!

Member Avatar for SkinHead
0
85
Member Avatar for EnderX

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 …

Member Avatar for kaung
0
206
Member Avatar for EnderX

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 …

Member Avatar for jbennet
0
107

The End.