11,093 Topics
 | |
| | All right. So i have child, parent, activity and register table and i want know how much money a parent will pay for his child if the child have 1 or more activities. So i came out with this code: [CODE]SELECT CONCAT_WS (' ', parent_title, parent_fname, parent_sname) AS 'Parent/Carer Name', … |
| | Hello everyone, I haven been trying to connect to my database but i have been getting this error: Error message: SQLSTATE[28000] [1045] Access denied for user 'mgs_user'@'localhost' (using password: YES) Does anyone know what is causing this error? please advice thanks  |
| | WELL I AM TRYING TO DO THIS BUT NOT GETTING ANY RESPONSE FORM SERVER DELIMITER // CREATE PROCEDURE getchgp(in ol varchar(100),in nw varchar(100),in sch varchar(100),out res varchar(100)) BEGIN SELECT pass INTO res FROM registration WHERE pass=ol AND schno=sch; UPDATE registration SET pass=nw WHERE schno=sch AND pass=ol; END // DELIMITER ; … |
| | Am trying to restore a MySQL database using the 'mysql -u root db < my_db' command. In vb's process.start. it gives me the default output you get when you type MySQL - help. Can someone tell me what's up. I guess it cannot see the < symbol. Regards. |
| | I have a database full of user. This is roughly how the database looks: [CODE]| username | sex | birthdate | zip_code | |----------+-----+------------+----------| | coolUser | M | 02-14-1987 | 90210 | | blueUser | F | 06-16-1982 | 10011 | | . | . | . | . …  |
| | please help me..!! i urgently need a php script which would send email to a recipient if changes/insert occur in database. Details: suppose i have table name employee with fields: emp_id name email status 1 abc abc@xyz Yes 2 xyz xyz@acb NO now, say if status of emp id changes … |
| | I have a database full of user. This is roughly how the database looks: [CODE]| username | sex | birthdate | zip_code | |----------+-----+------------+----------| | coolUser | M | 02-14-1987 | 90210 | | blueUser | F | 06-16-1982 | 10011 | | . | . | . | . … |
| | how i solve the problem mysql_num_rows() expects parameter 1 to b...  |
| | I know this sounds strange, but I messed up in a 'Manual' change to a DB table, and need to find a couple of records that I have no pathway to find... Explanation We have a member table called 'members' several different position tables, one for each level called position_1, … |
| | if column name is course and check this column to db mysql that if course is match with text field name course so not enter this record in mysql db for exmple i m entering already csc1 course and im type csc 1 again then show message "you are already … |
| | Is there anyway i can link a session to a particular table within my database, well i think this is how i need to do it. I have different tables which hold information for different shifts. The user selects the Site from one page, then selects the shift from another … |
| | 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 … |
The End.