10,940 Topics
 | |
| | I came again across "http://www.mysqludf.org/lib_mysqludf_str/index.php" and found the library useful but I could not figured out how to install and use them on WAMP Server version 2.0 with MySQL version 5.1.36 on Windows 7. I did followings steps but did not get the work done: 1. Created a directory named … |
| | i have a combobox and few textboxes in Form1. i inserted new item into combobox by entering new item in one of the textbox. i manage to add item into combobox in Form 1. But how can i achieve if the item i added in Form1 to be inserted automatically …  |
| | Hi, Guys Could anyone tell me how to import MsExcel data into MySQL using PHPExcel. I want to make an upload system for my users. They want to upload their data which is in Ms Excel format into MySQL databases...Please teach me how to do that... And I appreciate your … |
| | [CODE]----------------------------------------------------------- chan1 |chan2 |chan3 | captureTime |id ----------------------------------------------------------- 20 |21 |25 | 2011-10-11 00:00:00 |1 ----------------------------------------------------------- 21 |18 |19 | 2011-10-11 00:01:00 |1 ----------------------------------------------------------- .... .... .... ----------------------------------------------------------- 20 |25 |21 | 2011-10-11 00:15:00 |1 ----------------------------------------------------------- 21 |18 |14 | 2011-10-11 00:16:00 |1 .... .... .... ----------------------------------------------------------- 15 |26 |23 … |
| | very new to database and mysql, i would like to know if it is possible to create a drop down box using just mysql within the database and if so how is it down. |
 | Guys i have a small question.That is i have already developed a Java Desktop Application with interacts with the MySql Database.But i'm using MySql commandline client.Some youtube tutorials,i saw they are using MySql workbench to configure the Dtabase.So i want to know is there any issue if i use commandline … |
| | i want to display the auto increment field in mysql database no using php. using the code the output that am getting is zero in the $id field , what could i be missing echo"<table bordercolor='#CCFF99' bgcolor='#FFFFCC'>"; echo "<tr bgcolor='#CCFF99'><td>Order No:</td>"; echo"<td bgcolor='#FFCC66'>$id</td>"; echo "<tr bgcolor='#CCFF99'><td>Topic:</td>"; echo"<td bgcolor='#FFCC66'>$topic</td>"; echo "<tr … |
| | I get this error in my Java programme which coded by me according to a tutorial.I coded it to connect my Java App with MySql database.This is the code.[CODE]package Gui; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.sql.SQLException; /** * * */ public class connectionconfig { private connectionconfig() … |
| | Guys i'm using MySql commandline client.When i log it just asks the password and it doesn't show username.Please tell me is there any command or any other way to check my username.Plzzzz...... |
| | Hi, I have build my website with PHP and MySQL and when I was debugging I noticed a problem which I cannot find a way around it. Basically I have a search box on my website, which will search from a column that I have on MySQL database. Now I … |
| | can u please provide me with a c/c++ program to add a user to MySQL and allow him to only insert into the database |
| | hi, my table has following fields ForumPostsId(primary key),ForumPost,ParentPost parentpost can have 0(which means its parentpost) or ForumPostsId(which means its a chlid post related to parentpost) i need to generate a list which will the show parentpost and count of child post related to parent post Any suggestion!!!!!!!!! regards rajan  |
| | Hi all, I'm a java programmer but currently have a task to compare different list and output their common element in PL/SQL. In java this is very simple but i'm not sure how i would handle this in sql since I'm fairly new to it. ex l1='A,B,C,D' l2='B,C,D' l3 ='A' … |
| | can someone help me with this pls.. [CODE]DELETE FROM site_post, site_comments WHERE site_post.id=$id AND site_comments.matchid=$id[/CODE] needing to delete two rows one from each table.  |
| | may peace on you !guys i am new to MySQL query. i am developing a student information management system and the way on to which i am stuck is i wanted to add fine on student fee if the remaining is not zero of previous month and next month arrives.the …  |
| | [CODE] <?php $tags = $_POST["search-tags"]; $age = $_POST["search-age"]; $rating = $_POST["search-rating"]; $city = $_POST["search-city"]; $state = $_POST["search-state"]; if (!$tags = "") { $tags = " WHERE `tags`='$tags'"; } if (!$age = "") { $age = " WHERE `age`='$age'"; } if (!$rating = "") { $rating = " WHERE `rating`='$rating'"; } … |
| | Hello, I have done a PHP project and on my localhost it is working perfectly but when I uploaded it on my webspace the CMS part of my website did not work as it is supposed to. The strange thing is that the client side of the website is working …  |
| | Hi Guys, Another puzzle for someone to try and crack... I have two divs inside the <body> that basically act as two versions of the same page. I need PHP to call one based on a variable retrieved from a database. As it stands, this is what I have... [CODE] … |
| | I have 2 query which I want to make it as 1 query. Could anyone help me. Because the query is just the same. The difference is they have 2 condition which 1 query for same year and another query for different year. [CODE]If (bboard = "All") Then If (qter1 …  |
| | Hello, I am a computer science student working as a bartender in a restaurant. My boss was complaining that his monthly inventory audit was taking too much time (as he has about 2000 unique items to count) and I suggested I could build a mysql database to help him (and … |
| | Hi guys, I'm wondering if there is a way to solve this problem. Currently, I have an SQL statement that goes this way: [CODE]SELECT distinct name,id from list [/CODE] My understanding is that it selects the things that are distinct on both tables. Example: id name 1 Joe 2 Joe … |
| | how to lookup datasource which is created in glassfish with some jndi/dbname name. I am trying to get datasource writing code in a servlet like this Datasource datasource = (Datasource)initialContext.lookup("jdbc/customer"); Connection con = datasource.getConnection(); but it is throwing NameNotFoudExcepion for this context . how can access datasource created outside of … |
| | Hi . I am building a live chat using mysql and the database is updated because of users entries . So the number ow rows in the table changes constantly . And need to use a query which will select the rows that hasnt been selected. SO how do I … |
| | Hi everyone, I'm a beginner in working with PHP and I'm stuck with an annoying problem. With the help of a tutorial I've made a pagination for database results that works great. Now I'm trying to adapt the code and use the same pagination for a search-page on my website, … |
| | Hey. I am fairly new to VB.NET so I research alot when I run into bugs. Problem is I cannot find a solution to this, or anything remotely dealing with it. I am developing software to connect to a remote mysql server, run a query, and come back with a … |
| | Hey Everyone, hope all good. i have a problem with some php that is not randomly selecting an ip. I will try to explain my problem below. I have a state form [CODE] <select name="State"> <option value="0" selected="selected">Select a State</option> <option value="AL">Alabama</option> <option value="AK">Alaska</option> <option value="AZ">Arizona</option> <option value="AR">Arkansas</option> etc..... </select>[/CODE] … |
| | help me update my database.. when i click edit it will add a new record.. i want to update a record.. to edit a new record it will be base on the cutsomer's nameu [CODE]Dim conn As ADODB.Connection Dim RS As New ADODB.Recordset Set conn = New ADODB.Connection conn.ConnectionString = … |
 | Hye , I am having this kind of problem. Could anyone please help me why I am getting this error? [CODE]UPDATE company_alert SET company_alert.alert_value = company_financial.receivable FROM company_alert INNER JOIN company_financial ON company_alert.stock_code=company_financial.stock_code WHERE company_financial.year_id=company_alert.year_id[/CODE] You have an error in your SQL syntax; check the manual that corresponds to your … |
| | Ok I am stumped so bad. I am using a form to insert a topic and comment into a table and if the topic is new it creates a new table specific to that topic. So I pass the topic name through the url and Im trying to retrieve it … |
| | pls help i am beginner and i am trying to create a simple Guestbook but i got error "Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /index.php on line 43" here is the code i use : <?php require ($_SERVER["DOCUMENT_ROOT"]."/komara/config/db_config.php"); $connection = @mysql_connect($db_host, $db_user, $db_password) or die … |
The End.