10,946 Topics
 | |
| | hello , can any one tell me how can i update a password using procedure in mysql , if the oldpassword is same other wise get any mgs by the procedure . plssssssssss help me out |
| | Hello, My db table is this (semester result table) [B]sem1 regno(int) s1(enum) s2(enum), s3(enum), s4(enum) [/B] I want to find number of subjects in which the student with given id has gotten a particular grade. (ie no of subjects he/she has failed). Is it possible or shld i change the … |
| | I have the following problem: I have sample form with reportViewer on it & report type is rdlc report on c#. I added a new dataset then selected tableadpater on it then selected the database from mysql and I selected the Filldata method & provided a query to retrieve data … |
| | if somebody can help me please i want to write a store procedure in mysql to insert,update and delete but it should be dynamically because i have many tables and columns in my database the store procedure should be call than it should take the table and column dynamically ,can …  |
| | Hi... I have two site both have different login, now i want to merge database of 2 sites. need to merge both database and unique login for both. same user can use both site via one login. Thanks Hem |
| | Hello all . I am working on a small search for my website. It requires that i query the database and then display search results. In my database i have multiples. For example john on one row and john on the other. I want to display both of them. For … |
| | I have created an online form and am trying to post the info into a mysql database and I keep getting back a query error. Below is my PHP code. If anybody can help me, that would be great. Thanks a lot. [CODE] <?php $property_type = $_POST['property_type']; $number_of_bedrooms = $_POST['#_of_bedrooms']; … |
| | Hello, Am new to php and I have a question that is probably very easy. I have been watching tutorials online to learn how to work with databases, but none of them speak on how to upload to server. This is my problem: am using vertrigoserv but specifically using PHPMyAdmin … |
| | i am using mysql for the first time and following an online tutorial. i am using the command prompt to connect to the mysql server. the problem is that , i want to create a new database named bookstore. so, in the mysql> prompt i am writing [CODE] create database … |
| | I am trying to link fields between 2 of my tables but its not working. I have a table called assets, which consists of Asset_ID and AssetType and a table called t5_week3_shift3 which also consists of these 2 plus others. Im not sure whether to do away with the assets … |
| | hello :) i wanted to know that how can i move my database here and there..?? i'm working on Sql using some 'xamp' named software.. i have to create few tables, then i need to give this database to my friend..he'll add few more tables in it..then finally, we have … |
 | I am trying to write a program that can access my database from a remote computer and change it. How can I figure out the url of my database? according to my source it should be something like this [CODE] jdbc:mysql://host_name:port/dbname [/CODE] Thanks for your help. |
| | i have got a project where i have to connect c program to mysql database. but, i have zero knowledge of mysql. so, iwas looking for a mysql tutorial with c language . but. most of the tutorials online are mysql with php. so, could you please provide me some …  |
| | Hi there, I was wondering if someone could tell me how to store multiple checkbox values into a MySQL table? I know how to work it with Python on its own but I need to store into a database. Any ideas? |
| | hello, I have a situation that i'm wondering if there's a solution. I have specific databases for different cities in texas. I plan on adding more but i do not nkow how many more or what their names will be. Every city is going to have the same tables in …  |
| | Hi! Im new to MySQL RDMBS. I know the basic CRUD if you know what i mean. Create Read Update Delete. I have 2 tables: Category table and Product Table Products should be categorized. Product table has PK as an ID and FK to Category Table How to INSERT INTO … |
| | [CODE]<?php $conn = mysql_connect("localhost","rentwall_rentwall",")X7zlBx)XgZ5") or die ("Could not connect MySQL"); mysql_select_db('rentwall_rentwall',$conn) or die ("Could not open database"); function post($postname) { $posted = mysql_real_escape_string($postname); return $posted; } ?>[/CODE] Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'rentwall_rentwall'@'localhost' (using password: YES) in C:\wamp\www\site2\db.php on line 3 Could not connect MySQL please someone help … |
| | My codes work in localhost but this error happens when I upload to a web site. [code]<?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_conn = "mysql4.000webhost.com"; $database_conn = "a3027257_ccbc"; $username_conn = "a3027257_ccbc"; $password_conn = "a123456"; $conn = mysql_pconnect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(),E_USER_ERROR); mysql_select_db($database_conn, $conn) or die("cannot select Database"); mysql_query("SET NAMES … |
| | Hi everyone! I've been looking for a solution, but i just can't find it anywhere... Ok, so the problem is: i have a database which looks something like this: user_id product_id score 14 . 235 . 79 23 . 235 . 32 53 . 665 . 21 14 . 235 … |
| | for experiment i pull data from mysql to xml to use in flash how can i add ahref to id in xml to achieve like this [url]http://www.kalitekolik.x10.mx/product.php?id=1[/url] [url]http://www.kalitekolik.x10.mx/PHP_MySQL_Flash_FINISHED.swf[/url] my database like this id/ product_name/ price/ details [CODE] <?PHP $link = mysql_connect("localhost","lafamosa_kermis","lafamosa1000"); mysql_select_db("lafamosa"); $query = 'SELECT * FROM products'; $results = … |
| | i got 4 table which call addproduct, sellproduct, reportfoundproduct, productbalance i want to make a trigger to update the balance quantity of stock in productbalance table after insert data to those three table (addproduct, sellproduct, reportfoundproduct) below is my trigger : CREATE DEFINER=`root`@`localhost` TRIGGER `user`.`addtotal2` AFTER INSERT ON `user`.`addproduct` FOR … |
| | hi, when i insert date time into my database it insert server time not local time how can i change this? even i tried ; [CODE]$currntdate = date("F j, Y, g:i a");[/CODE] which didn't work either.. thanx in advance. |
| | Hi everyone, I'm trying to write a Python script, where it counts the specific results from a database. Running the following line in MySQL Client works: SELECT name, COUNT(*) FROM results WHERE name="bla bla"; And it returns all of the results fine. But I'm trying to put it into a … |
 | can anybody tell me what format of date 1311048886 is? how we insert and select in database.  |
| | Please someone should help me before I faint. I have been working with this login script and am getting this error on a server: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/utimate/public_html/PhpPractice1/index.php on line 32. When I test it with wampserver, I will get this … |
| | I am using MySQL to store the RSS feed contents that are updated every few hours. I truncate the database once a day. But during the day, whenever same feeds are updated every few hours I get duplicate entries piled up. Is there any PHP script that I can run … |
| | Does anyone know the SQL statement for replacing a string in the whole of a database. My database is called DB1 and I want to remove any instance of "Table/". Many Thanks, |
| | I am currently using a script to run RSS feeds and dump all data into a MySQL. Every time I run it, it creates a duplicate entry into a database. Is there any way, I can just program a script to only get new feeds? I have some feeds subscribed … |
 | Due to the compability between PHP and MYSQL I am hoping someone has a solution to my problem :( I wish to reset the auto increment field and get them "redone" as such. Problem being: When I delete a row it leaves an incorrect auto increment, as a total as … |
| | Hi everubody! I have a huge issue with dates and encoding in my database. Two weeks ago I restored a database from an Xcloner copy to my site, since then all problems are there. My site language is Spanish, and I was using in Wordpress define('DB_CHARSET', 'UTF8'); Since then if …  |
| | I made a test database to store items in a database, but I keep getting an error when trying to import from a txt file. Here is my txt file [CODE] 1,Lánc 2,Fa 3,Csavar 4,Lakat [/CODE] How could I fix this problem? Also is there a reason I need to … |
| | hi, i have two databases and each one have diferent fields names and tables and i want a creat a map for each field and each table and export to a database to the other i have tested the mysql migration but i can´t choose a diferent table in the … |
| | Hello.. i have a table named Tuition with fields: TuitionNum,TotalFee,Fine,levelNum,SchoolYear,DateCreated,Removed,DateLastModified,UserID I inserted record successfully but when i'm trying to display TotalFee using this code, [CODE] myConnString = "server=localhost;" _ & "user id=root;" _ & "password=fiancee;" _ & "database=anneclaire" SQL = "SELECT TotalFee FROM Tuition WHERE levelNum='" & TextBox1.Text & "' … |
| | i need help, i want to pass a value to javascript from php and it keeps giving me "null". i want to get what picture the user selected. [CODE] <?php mysql_connect('localhost','root',''); mysql_select_db("ajax"); $query="SELECT * FROM xxxx"; $result= mysql_query($query); while($row= mysql_fetch_array($result)){ $rating=$row['ID']; echo "<img src =\"" .$row['filepath']."\" /><br/><a id=".$row['ID']." value='rating' onclick='getrating();'> … |
| | Hi, I'm not familiar with the AJAX way of doing this, hence why I'm posting this. I've got this form that needs to check if the user input is already in the database, if this isn't the case it should disable the submit button and display an error depending on … |
| | Hey guys, i have a javascript code for the "state-city" selection dropdown in my form. Now i have to provide an option for the user to add a state or add a city if it is not already present in the dropdown. I'm using php and mysql. Please help. Thanks …  |
| | Dear, I am making an ordering form and all of the products' data are stored in a MySQL database. The menu form to select products are all [B]working with plain HTML[/B] not php echo's. But now I can change products' info via a separate web page by updating the MySQL … |
| | |
| | HI , CAN ANY ONE TELL ME HOW CAN I UPLOAD A FILE TO MY WEB SERVER WITH OUT USING <INPUT TYPE="FILE"/> , I JUST WANNA USE I BUTTON TO UPLOAD A FILE , AND WHENEVER I CLICKED ON THAT BUTTON I WANNA A FILE WHICH IS ON MY SYSTEM … |
| | hi, i looked all the codes but i could not really see it - i dont really understand coding-. after registration this website send an activation code but i want to make the user active when they actually register. when they register their status is set to A but for … |
 | hi all, I have doubt on Index,I know Index are used to increase the performance of table but my question is where to create Index whether primary key table or foreign key tables ? |
| | Hi, I want to create a database like Dmoz(dmoz.org). I have a problem with creating parent child relation. I want to create parent child relation. This parent child relation will be assigned to a 'links' table. In the links table I will insert data whether in root category or subcategory …  |
| | what would cause this error, it seems that database can be connected but i cannot do it with the below code to this specific database on this server but i can connect to some other host database with below code, can you please help? [ICODE]Warning: mysql_query() [function.mysql-query]: Can't connect to … |
| | hi, my client side files are in one server and server side codes and the mysql in one on my client side files config i see the below [ICODE]$config["db_host"] = "mysevercodessideIP"; $config["db_user"] = "myuser"; $config["db_pass"] = "mypassword"; $config["db_name"] = "myDBName";[/ICODE] i get the error [ICODE]MySQL Error:Can't connect to local MySQL … |
| | Hey, I'm currently using mysql_real_escape_string() to protect against SQL injection. Is there a way to exploit this? I have already tried \ to try to make the query \', thus making it just a regular backslash. I have heard of the Big5 exploit, but I don't know how to use … |
| | hi i have below structure in my database table id eve_id cat_id member add_date 1 Tel1 5 1,2,3,4,5 0000-00-00 2 Acc2 2 3 0000-00-00 3 For3 3 1 0000-00-00 4 Acc4 2 5 0000-00-00 5 Acc5 2 6 0000-00-00 now my query is as below [CODE]$memque="select * from tblevent where … |
| | Hi i am looking for simple intranet project in java with mysql.Can anyone post this kind of project or suggest some sites. Appreciated if u replay on this. Cheers!  |
 | hi mysql athlets!)) Guys, please tell me - how to solve problem like this = I have sql-query like this one (imagine that all this tables and fileds exists - and error can't be in its adsence) = [CODE] select NAME from (TAB1 left join TAB2 on TAB1.ID = TAB2.ID) … |
 | I want to write a wrapper around MySQL but I will in future extend it to support other databases. I will cover only nasic useful features (commons) but it should be extensible in future with minimal change. I want to write an interface but I cannot get good tutorial to … |
| | hi, i finally learned how to install mysql and phpmyadmin but now i need to find out the ip adress for the specific datebese i can login IP/phpMyAdmin but i need an ip adress instead of "IP/phpMyAdmin" can you please help me? $dbH = "ip"; $dbU = "user"; $dbP = … |
The End.