7,368 Topics
 | |
| | 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 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 …  |
| | 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 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 = … |
| | hi, i can connect thru ssh or phpMyAdmin but when my website or the application is trying to access to my database i get the below error (part of the error) i googled but i could not really understand how i need to fix this. (i dont know much about … |
| | How to clear the mysql query cache? RESET QUERY CACHE; is not working. Thanks in advance |
| | I made a classified site and am concerned that my database design amd sql queries may not be optimal. Need your suggestions. This is how the site works now: The user selects his colony, and my app shows posts made from the colony and posts made from nearby colonies. 2 … |
| | i think with this function users can add some amount to their account but what i would like to do is each day user login i want to add the some amount automatically. each day user login to the site i want to add 1000coins amount to their account and … |
| | What am I doing wrong? I've stored the date in american format (yyyy-mm-dd) and want to output it in european format (dd-mm-yyy). This is my code. [code=php] //ZENDING $result = mysql_query("select ID, Bestemming, Afkorting, Datum FROM Zendingen WHERE ID ='" . $znding . "' ORDER BY ID, Bestemming ASC") OR … |
| | I created a table in mySql named 'user' where fields are: UserID,UserFirstName,UserMidName,UserLastName,Username,UserType,AcctPassword,DateCreated, DatLastModified and IsDeleted. I create a separate form in vb.net to insert user record in database. My program can do insert command and bound this data from mySql to datagridview. And now, i wanted to update this by …  |
| | Hi All, Kindly note that I'm new to this forum. Hope that you can help me. I have a VB.Net application that must connect to online MySql database. I already have a MySql database and I connected to it from VB.net using the MySql connector (new instance and direct connect). … |
The End.