11,093 Topics
 | |
 | hi, dont usually ask for help since i believe in google. But im in a serious fix. intro: currently working on a table that has three fields, 'id' 'current' 'previous'. problem: i want to insert another field (or two - no too sure how to go about it) but with … |
| | Hey Guys, I am still in a thinking stage and will like to learn from your experience, and was wondering if any of you folks have a hybrid environment i.e. Linux and Proprietary systems and what kind of issues do you run into. And also, what pieces of technology you … |
| | Help me out guys. I am probably being such a bonehead but I can't figure out where I've gone wrong with this code for adding Next/Prev buttons to my pages: $ ID = $_GET; $limit=2; // rows to return $numresults=mysql_query("SELECT * from fragrances WHERE ID=$ID ORDER BY title"); $numrows=mysql_num_rows($numresults); // … |
| | I m beginner in Php-Mysql. I have installed apache PHP-Mysql but still it is showing problem in running the script. I really need a help to learn it. Anyone is there who can solve my problem.  |
| | Pls help me to find out free STEP Y STEP MYSQL TUTORIALS with php  |
 | I am trying to create a calss with a constructior that creates connection with MYSql database , i am using database name as dbetch . I have set the path varable but still it id throwing error package login; import java.sql.*; import java.sql.DriverManager; import com.mysql.jdbc.Connection; public class conn { Connection … |
| | Hi Does anyone know what is the simplest way to backup a database using the [b]mysqldump[/b] function in php? I have googled a lot and the codes i have found are very hard to understand and most of them does not work. Thanx in advance for your help.  |
 | ok, so i need to insert something to my mysql database. I have seperately tested the connection, and it's good. It's just something wrong with my code. Look at it. [code=php] <?php include("db.php"); $link2=mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); if(!$link2){ echo "could not connect.";} $myusername="test"; $mypassword="test"; $sql="insert … |
| | Hello, I'm developing a small, web-based music sharing application. I used to create static HTML contents. But now, I need a dynamic site that retrieve information from databases (also write data to database). As a beginner in PHP and MySQL, I hope someone from here can help me out.. Here … |
| | Hi folks. I Have a question : I'm interested how you generate query string to search DB with more than 1 form with LIKE. For example : We have $_POST['name'], $_POST['title'], $_POST['phone'], $_POST['email']. How do you generate sql query to search with two criteria ( name and phone ) ? … |
| | I am trying to get this function to work and having a few problems. [CODE] if(function_exists("mysql_real_escape_string")) { $value = mysql_real_escape_string( $value ); } [/CODE] and i get an error: [B]Warning[/B]: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in w:\[B]pathname[/B] on line [B]11 [/B] Does anyone know how … |
 | hi , I have four different tables, all are linked together using foreign key relationships. Now i need to insert data in to the tables.How can i use nested insert queries to insert data by a single query?  |
| | Hello all, I will be creating a mySQL database to store telemetry that will be grabbed from an instrument at a rate of once per second. Are there design considerations that I should take into account in order to achieve this insertion rate? The database will eventually grow to about … |
| | 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 … |
| | Hey all, So here's the deal. I have a list of comments, and each comment gets an automatically generated commentid when it gets added to my mysql table. I just added the functionality to allow users to reply to other ppl's comments ... So I added another field to my … |
| | |
| | Hi I am tring to populate a drop down by selecting another drop down. The first drop dwon populates from eventdata table and i want the second drop down to populate from a race table. I have tried to find the row which contains the same event id as the …  |
| | hey there, i recently installed php5.0.2, apache2.0 and mysql4.1 independently but got them to work together. however i can only access a database when i type: [code]$db = new mysqli('localhost','username','password','database');[/code] and yet when i try: [code]$db = mysql_connect('localhost','username','password');[/code] it does not work, i have uncommented the extension in my php.ini … |
| | [B]Description:[/B] The problem is with the SQL. In tbl_comment.comment_mreference, I have made this column varchar(60). It can either contain an integer value, or an alphanumeric value. If it's an integer value, an admin would be logged in and it would have inserted there auto_increment member number into tbl_comment.comment_mreference. If it's … |
| | Hi, I have been trying to see how it is possible to get the name of the primary key column from the database by checking the constraint name. I have, up until now been unsuccessful. I have tried the below and I get nothing returned and no errors as well. … |
| | Hi all......another question for ya all :S Does anyone know of a way to monitor a change to a database, Basically I need to write some code for my app that can detect a change i.e. table x has been modified in someway or table y has been created etc? … |
The End.